Archive/Delete Cost History (ticpr2230m000)

Session objective

Use this session to delete, archive, or archive and delete the standard cost history data by standard item(s) or item group(s).

This data determines which Cost History data can be deleted:
  • The value specified in the Retain Standard Cost History field in the Standard Cost Calculation Parameters (ticpr0100m000)session.

    This parameter reflects the number of years that the Standard Cost Price must be retained in LN. The Archive/Delete Cost History (ticpr2230m000) session considers this number of years when removing the standard cost history data.

    For example, if the parameter is set to 9 years and the item has historical cost prices of 1, 8 , 11 and 20 years back, then Archive/Delete Cost History (ticpr2230m000) will remove the cost price records that were created 20 years ago.

    The cost price record that was created 11 years ago is not removed because removing it would imply that it will not be possible to retrieve the cost price of 9 years ago.

  • Transactions Date specified for the first item in the Planned Inventory Transactions (whinp1500m000) session.

    The date of the first Planned Inventory Transaction of the Item is considered when this date is earlier than the date of the Cost Price record determined by the previous condition using the Retain Standard Cost History field in the Standard Cost Calculation Parameters (ticpr0100m000)session.

    If applicable, one Cost Price record with a date earlier than the date of the first Planned Inventory Transaction of the Item will be retained and any existing earlier Cost Price records will be removed.

Note: 
  • Archive/Delete Cost Price History session does not check for open planned orders on deletion of Cost Price history. The session is not designed to check all open orders (nor closed orders that can be reactivated) to see if cost price data for a specific date may be required.
  • For direct delivery, no planned inventory transaction is created and therefore the situation can occur that no cost price data is present on the actual receipt date.
  • If the Archive General Data only via Session Archive General Data check box is disabled in the COM Parameters (tccom5000m000) session, the option to archive general data is displayed in the Archive/Delete Cost History (ticpr2230m000)session.

    In such case, parallel processing must be configured in the Parallel Processing Configuration (ttaad7520m000) session for the Archive/Delete Cost History (ticpr2230m000) session.

Invoked tables

This table shows the data that is archived, deleted, or both.:

Standard Costs by Item ticpr300
Item Costing Data by Effective Date ticpr301
Standard Cost Details by Item ticpr305
Effective Item Surcharges ticpr320
Effective Item Surcharge Bases ticpr330
Effective Valuation Prices by Item and Warehouse ticpr340