Applies to Product - Dynamics 365 Supply Chain Management
What’s happening?
The customer inquired about the functionality of aggregating on-hand inventory entries by financial analysis code.
What’s happening?
The customer inquired about the functionality of aggregating on-hand inventory entries by financial analysis code.
Reason:
The query for the InventSum table was reported to be very slow, with many records having closedqty = 1 but closed = 0. The specific issue involved searching for all valid financial analysis codes where closed = 0 and aggregating amounts for matching records.
Resolution:
To resolve this, the following steps were confirmed: - Search for all valid financial analysis codes where closed = 0 for a specific item. - From the search results, identify records that match the financial analysis code. - Consolidate the amounts into one record for the matching financial analysis code and set the amounts of the other records to 0, changing their status to closed = 1. - This process resulted in a significant reduction in the number of records with closedqty = 1 and closed = 0.