Warehouse reservations can accumulate over time. Let's look at cleaning them up.

Warehouse management on-hand entries cleanup

Similar to On-hand clean up, if your organization is utilizing warehousing functionality with inventory reservations, there is functionality to clean up your inventory reservations and on-hand related entries. If you are not using WHS functionality, this functionality will not make any changes.

Where is this in AX 2012

In Inventory Management > Periodic > Clean up, look for Warehouse management on-hand entries cleanup. This is similar to (link to on hand entry cleanup) but will clean on-hand entries for item in the reservation hierarchy. You can filter based on item, product and site as standard plus whatever else you can get into the query. You also have the option to add X number of days since update for delete. This allows you to specify that if something has not updated in something like 90 days, it OK to cleanup. This can help clean up items that are either cyclical, seasonal or exist for a short time never to be seen again. This will iterate through all records in inventory reservations (whsInventReserve), check that all values are zero and if so, delete that record. This is also aware of the reservation hierarchy so depending on how a specific item is setup, it will delete and/or rebuild values for the items given reservation hierarchy. Also, you may run into some performance issues so plan ahead ΓÇô do this off hours or on a weekend.

Where is this in Dynamics 365 for Finance and Supply Chain

This can be found in the same place as in AX 2012 and is functionally the same. This does, however, have a few performance enhancements and tweak in code that the AX 2012 version, as of CU12, does not have.

Other Versions

This is available for AX 2012 R3 CU11 and later or by specific KB. See https://cloudblogs.microsoft.com/dynamics365/no-audience/2015/12/28/impr... for more details.