View periodic cost lines

Trade Management  •  Article  •  7/30/2025  • 

The system processes item ledger entries and generates periodic cost lines for trade plans with the Trade Plan Type field value set to Periodic. For more information, see Calculate periodic costs.

To view periodic cost lines, follow these steps:

  1. Select the Search icon , enter Periodic Cost Lines, and then choose the related link.
    Alternatively, on the Trade Plan Card page, on the action bar, select Related > Periodic Cost Lines to view the periodic cost lines calculated for a specific trade plan.
    The Periodic Cost Lines page opens.

  2. You can view the information about the periodic cost lines in the following fields:

    FieldDescription
    Entry No.Specifies the periodic cost line number.
    Item No.Specifies the item number.
    Variant CodeSpecifies the variant code of the item.
    Receipt Item Ledger Entry No.Specifies the item ledger entry number to which the periodic cost applies. The system will create a new periodic cost line for each receipt on a location.
    Receipt Entry TypeSpecifies the type of transaction associated with the item ledger entry.
    Receipt Document TypeSpecifies the type of document associated with the item ledger entry.
    Receipt Document No.Specifies the document number associated with the item ledger entry.
    Receipt Document Line No.Specifies the document line number associated with the item ledger entry.
    Receipt Lot No.Specifies the lot number associated with the item leger entry.
    Location Receipt Item Ledger Entry No.Specifies the location code associated with the item ledger entry.
    Location Receipt Entry TypeSpecifies the type of transaction associated with the location.
    Location Receipt Document No.Specifies the document number associated with the location.
    Location Receipt Document Line No.Specifies the document line number associated with the location.
    LocationSpecifies the location code associated with the item ledger entry.
    Receipt Date LocationSpecifies the receipt date of the item at the location.
    Location Receipt Lot No.Specifies the lot number associated with the location.
    Trade PlanSpecifies the trade plan from which this periodic cost is calculated.
    Last Calculation DateSpecifies the date when the periodic cost calculation was last run.
    You can select the value to view the periodic cost line entries.
    Remaining QuantitySpecifies the calculated remaining quantity.
    You can select the value to view the periodic cost line entries.
    AmountSpecifies the calculated amount of periodic costs. This value is calculated as the sum of Amount field values of all the periodic cost line entries.
    You can select the value to view the periodic cost line entries.
    Posted AmountSpecifies the amount of periodic costs that has been posted.
    You can select the value to view the periodic cost line entries.
    OpenSpecifies whether all the periodic costs have been posted. The available options are:
    • No: All the periodic costs have been invoiced.
    • Yes: All the periodic costs have not been invoiced.
    You can select the value to view the periodic cost line entries.
  3. Select a periodic cost line and then on the action bar, select Show Entries to view the periodic cost line entries for the selected periodic cost line.
    The Periodic Cost Line Entries page opens. You can view details of the periodic cost line entries in the following fields:

    FieldDescription
    Entry No.Specifies the item ledger entry number that relates to this periodic cost line entry.
    Periodic Cost Line Entry No.Specifies the number of the periodic cost line entry.
    Calculation DateSpecifies the date the periodic cost line entry was calculated.
    Rate TypeSpecifies the type of rate applied to the periodic cost line entry. The available options are: Amount per Unit, Amount per Net Weight, and Amount per Gross Weight.
    Trade Partner No.Specifies the trade partner selected on the associated trade plan rate line.
    Periodic Cost Start DateSpecifies the data from which periodic costs should be calculated. This value is calculated by increasing the receipt date with the Free Storage Period field value on the associated Trade Plan Rates page.
    Periodic Costing ApplicableSpecific the periodic costing applicable. This checkbox is selected if the calculation date is equal or after the periodic cost start date.
    Inventory ChangesSpecifies whether the periodic cost entry involves inventory changes.
    Net ChangeSpecifies the calculated net change of inventory levels on the calculation date.
    Remaining QuantitySpecifies the calculated remaining quantity, based on the Net Change field value.
    Packaging Quantity (Expected)Specifies the expected number of shipping containers at the time the receipt is posted, based on the default packaging setup of the item.
    Packaging Quantity PostedSpecifies the number of shipping containers received at the time the receipt was posted, based on the packaging lines that are linked to the specific receipt line.
    Eligible BaseSpecifies the calculated eligible base. Depending on the rate type, this could be the quantity of the item, net weight of the item, or gross weight of the item that was received. For packaging costs, the system inherits this field value from the actual or expected quantity based on the Rate Application Method field value. For more information, see Set up trade plan rates for periodic costs.
    RateSpecifies the calculated rate as originating from the selected trade plan rate line.
    AmountSpecifies the calculated amount to be added for periodic costing on the specific calculation date. This value is calculated by multiplying the Eligible Base field value with the Rate field value.
    PostedSpecifies whether the periodic cost line entry is posted.
  4. Select a periodic cost line and then on the action bar, select Post Periodic Costs to post the periodic costs for the selected trade plan.
    The system updates the Posted Amount and Open field values, posts the periodic cost lines using trade cost orders, and creates relevant value entries and optionally trade accrual entries (interim).
    The system will continue to post periodic costs for each day based on the rules set out in the trade plan. This process ensures that all applicable costs are accounted for on an ongoing basis.

  • If any errors occur during the posting of the trade cost order, the system will retain the related periodic cost lines in an unposted state. You can resolve the issue and then post the periodic cost.
  • You cannot delete a periodic cost line with the Open field value set to No.
  • You can view periodic cost lines related to trade plans, posted purchase receipts, and posted transfer receipts using the Periodic Cost Lines action.