Remove item standard costing data

The item standard costing data is part of the cost price 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 cost prices and the cost price 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 Price History (ticpr2230m000) session to remove the data.

To remove cost price data while actualizing cost prices, select the Delete Cost Price History Data check box in the Actualize Standard Cost and Valuation Prices (ticpr2220m000) session.

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

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