Remove item standard costing data

The item standard costing data is part of the standard cost data, and contains all standard costs (FTP) by item, cost component, and warehouse. The data is date effective, and every update of the costs results in new data.

The underlying tables contain the actual standard costs and the standard cost history. Therefore, the underlying tables can grow significantly. Usually, the data is stored for a while, but when the data is no longer required, use the Archive/Delete Cost History (ticpr2230m000) session to remove the data.

To remove standard cost data while actualizing standard costs, select the Delete Standard Cost History Data check box in the Actualize Standard Cost and Revalue Inventory (ticpr2220m000) session.

Old standard cost data is removed, and takes into account the number of years defined in the Number of Years to Retain Standard Cost History field in the Standard Cost Calculation Parameters (ticpr0100m000) session.

Performance aspects
  • Effect on CPU: Not applicable
  • Effect on database growth: Yes