Microsoft Dynamics 365 Blog

Intermittent Inventory On Hand Performance Issues 

5 min read

A few customers have reported intermittent performance issues involving inventory on hand related queries on the InventSum, InventDim and/or WHSInventReserve tables, due to bad query plans regarding the table joins. This not only applies to on hand inquiries necessarily, but anything else dependent on it, e.g. inventory related posting processes, e.g. purchase invoicing. So based…Read more


Improve performance by running the Warehouse management on-hand entries cleanup job – for New AX and for AX2012 R3 CU10 

3 min read

  Introduction Calculation of the on-hand are used from many forms but also during many business processes, the latter being less obvious to end-users. Therefore, it is always of interest to us to improve the performance of these operations since the overall impact on many processes can be quite significant. The nature of the queries…Read more