Clean Up Cost calculation details

Submitted by Nathan Clouse on 02/09/20.

Last modified:

05/09/21

Tags:

Calculating costs can create lots of records. Over time, those can take up a fair amount of space. Let's clean them up!

Cost Calculation Details

Much like lots of other data in AX 2012 and Dynamics 365 for Finance and Supply Chain, as time progresses, it can lose its value and eventually just starts to slow things down. Cost calculations can be no different. There is functionality in the system to clean up lots of different BOM costing related info that is older than a specific date. This can help clean up old BOM rolls from years ago where we donΓÇÖt need the costing detail anymore. Removing these old records could impact some historical reporting specifically looking at older cost rolls.

Where Is This In AX 2012?

In Inventory Management > Periodic > Clean up, look for Clean up cost calculation details. This screen has a few options on it to help you clean things up. First is the option to ΓÇ£Apply to sales lineΓÇ¥ with a date. With this enabled, this will delete all records in the Calculation table (BomCalcTable) where the calculation type is order and the transaction date is less than the date provided. Next is ΓÇ£Apply to planned cost calculationΓÇ¥ and a date. If you select ΓÇ£pendingΓÇ¥, this will delete pending item prices (InventItemPriceSim) records where the costing type is ΓÇ£normalΓÇ¥ and the from date is less than or equal to the date entered. If you select ΓÇ£Pending and ActiveΓÇ¥, this will also delete active prices (InventItemPrice) of type ΓÇ£normalΓÇ¥ leaving at least 1 active price for an item regardless of date selected. The next option is ΓÇ£Clean up standard cost calculationΓÇ¥ with a date. If you select ΓÇ£pendingΓÇ¥, it will delete pending item prices (InventItemPriceSim) records where the costing type is ΓÇ£StandardΓÇ¥ and the from date is less than or equal to the date entered. If you select ΓÇ£Pending and ActiveΓÇ¥, this will also delete active prices (InventItemPrice) of type ΓÇ£standardΓÇ¥ and ΓÇ£conversionΓÇ¥, leaving at least 1 active price for an item regardless of date selected. Lastly, always run this in batch as it could take a long time to run if you have lots of costing history.

Where is this in Dynamics 365 for Finance and Supply Chain?

This can be found in the same place as in AX 2012 and works functionally similar. The first option to clean up cross costing versions is new to D365 and is also a feature in feature management. This option will make it so all of the options selected for the cleanup operation are across all companies rather than just the company you are currently in. depending on your specific version and configuration, you may not see this option.