Getting to know your costs and Cost structures (Part I).

1 minute read time.

This blog and the following ones will cover how the costs and cost structures are set up and calculated. 

In Common data, Logistics tables, a Cost function can be set up to define various costs associated with a cost nature. This function can be used with purchased products and the cost can be selected to be added to the stock valuation.

When creating a new cost, a cost nature such as Packing, Loading, …etc. can be selected from the drop-down list.

Selecting a cost nature is mandatory. Once the cost nature is selected, there are seven product cost calculations to choose from:

Percentage per net price: This choice allows the percentage to be added to the net price of the document line.

Fixed amount: With the fixed amount, the amount is added to the document regardless of the QTY or any other criteria defined.

Amount per unit: An amount is added to every N quantity of a unit.

Amount by fixed bracket: A fixed amount will always apply based on a range. For example, if the cost is $5 for every 100 LB. If 200 LB is purchased, the cost will be $10.

Schedule: When the schedule is selected, two choices are present: Per unit & Amount, and normally the amount, base, and unit cost are all set in a schedule. 

Weighted amount: The calculation is calculated based on (Quantity * amount / (Weight /100).

Formula: A formula is defined using the item, supplier, and a corresponding table such as ITMMASTER, ITMBPS, or PORDER table.