Warehouse churn can create lots of data in location load table. Let's clean it up.

Location Load Cleanup

Depending on the amount of inventory churn in your warehouses, it may be a good idea to clean up your Location Load every once and a while. The location load table contains info about the load on a given location in the warehouse. This functionality predominantly related to the use of Warehouse Management 1 or WHS. If you are using WMS 2, you may not need to clean this table up. You can inspect this in SQL to see what the data are shaped like and make a determination from that.

Where Is This In AX 2012?

In Inventory Management > Periodic > Clean up, look for Summation of Load adjustments. This will sum all Location Load (WMSLocationLoad) records up to a certain point in time. First it will loop through all records that meet the filter criteria. Next, it will mark those for deletion and tally up all values for that location (WMSLocation). If the result for that WMSLocation is anything other than zero for all values like counts, volumes and weights, then a summary entry will be created. The default date and time for the summation is the moment that the clean up runs.

Where Is This In Dynamics 365 for Finance and Supply Chain?

This works just like the AX 2012 version and can be found in the same place.

Other Versions

This was added as part of AX 2012 and should be available in all versions of AX 2012; RTM, R2 and R3. However, this isn't available for earlier versions. To find out more go to https://cloudblogs.microsoft.com/dynamics365/no-audience/2011/05/26/wms-....