Let's walk through creating a standard Build VM
You are here
On-hand entries cleanup
Can we save space and improve performance by cleaning up our on hand tallies? Let's review.
On hand entries in AX / Dynamics 365 For Finance and Supply Chain accumulate over time. Typically they dynamically get adjusted as transactions occur to reflect current levels. However, as the inventory levels for some items go to and stay at zero, a record will remain with all zero values. we don’t need a record to let us know we don’t have on hand of a particular item. Furthermore, some products may have reached the end of their life cycle and are no longer available for purchase from any vendor and have been stopped. Just like the other clean up routines, there is functionality to clean up records that are no longer relevant. There is functionality to identify and clean up on hand entries where the quantities and value for a specific item and inventory dimension are all zero and open.
Where is this in AX 2012
In Inventory Management > Periodic > Clean up, look for Inventory Dimension Clean up. This will let you specify some inventory dimensions and product(s) that you want to clean up the inventory summation (InventSum) records for. You should run this in batch. It will loop through all Inventory Dimension and inventory summation records. First, it verifies if the given Inventory summation record can be deleted by confirmed it has zero quantities and values for the on hand record and also confirms it has no open transactions ( Inventory Transactions where the status issue is not sold and the status receipt is not purchased ). If that validation is passed, it will check if a closed inventory summation exists and, if not, create one. Lastly, it will delete the inventory summation record for the specific set of inventory dimensions being checked like site, warehouse, config, style, color, and size.
Where is this in Dynamics 365 for Finance and Supply Chain
This can be found in the same place and is functionally the same.
This functionality is only available in AX 2012 R3 CU10 or later. It is not available in R2 or any earlier versions. Please see https://fix.lcs.dynamics.com/Home/Index/0/kb/3063513?bugId=3601375&permi... and https://cloudblogs.microsoft.com/dynamics365/no-audience/2015/12/28/impr... for more details.