It displays the amount of the costs used for stock valuation, expressed in the company currency.
Notes :
When the order has the inter-site type, the stock cost calculation does not include the line amount, nor the non-deductible taxes. The invoicing elements are taken into account only if the BETFCYCST - Integration of invoicing elements parameter (ACH chapter, COS group) is set to 'Yes'.This amount is never calculated during entry but only when saving the document.Its calculation mode varies according to the method used to value the landed costs:
- Global method where a Landed cost coefficient is applied and/or a method where a Fixed cost per unit is applied:
Line amount -tax * Landed cost coefficient
+ fixed cost per unit (expressed in PUR and converted into STK) * quantity in PUR
+ total of the valued invoicing elements of the line (the elements taken into account are only the ones with the Stock valuation flag set to: 'Yes')
+ total of the non-deductible taxes of the line (if parameter NODVATSTO - Non-deductible taxes in stock is set to ‘Yes’).
This result is converted into the currency of the company using the exchange rate type specified the Management section.
Example for the calculation of the Stock cost of the line (without invoicing elements):
- Hypothesis: the company currency and the document currency are identical (€).
- Net price: €10/box
- Landed cost coefficient: 1.3
- Fixed cost per unit: €20
- 1 box = 15 STK
- Non-deductible tax: 16.9 % but the NODVATSTO parameter - Non-deductible taxes in stock is set to "No".
--> For an order of 1 box:
Stock cost = (10 * 1.3 ) + 20 = €33
The stock cost per unit is the following: €33 /15 STK = €2.20
--> For an order of 5 boxes:
Stock cost = [(10 * 5) * 1.3 ] + (20 * 5) = €165
The stock cost per unit is the following: €165 / 75 STK = €2.20
Example for the calculation of the stock cost of the line (with invoicing elements):
- Hypothesis: the company currency and the document currency are identical (€).
- Net price: €10/box
- Landed cost coefficient: 1.3
- Fixed cost per unit: €20
- 1 box = 15 STK
- Valued invoicing element (transportation): €10
- Non-valued invoicing element (unloading): €7
- Non-deductible tax: 16.9 % but the NODVATSTO parameter - Non-deductible taxes in stock is set to "No".
--> For an order of 5 boxes:
Stock cost = [(10 * 5) * 1.3 ] + (20 * 5) + 10 = €175
The stock cost per unit is €70 / 75 STK = €2.33
Example for the calculation of the stock cost of the line (with invoicing elements):
- Hypothesis: the company currency and the document currency are different.
Company currency: $
Document currency: € - Conversion: €1 = $1.40
- Net price (in document currency): €10/box, converted into company currency --> $14/box
- Landed cost coefficient: 1.3
- Fixed cost per unit (in the currency specified in the Product record): $30
- 1 box = 15 STK
- Valued invoicing elements (transportation) (in document currency): €15, converted into company currency --> $21
- Non-deductible tax: 16.9 % but the NODVATSTO parameter - Non-deductible taxes in stock is set to "No".
--> For an order of 1 box:
Stock cost = (14 * 1.3) + 30 + 21 = $69.20
The stock cost per unit is the following: $69.20 / 15 STK = $4.61
- Method in which a set of costs detailed in a cost structure is taken into account:
Line amount -tax
+ costs of the cost structure
+ total of the valued invoicing elements of the line (the elements considered are only the ones with the "Stock valuation" flag set to: "Yes").
+ total of the non-deductible taxes (if the NODVATSTO parameter - Non-deductible taxes in stock is set to ‘Yes’)
Example for the calculation of the stock cost of the line:
- Hypothesis:
- the company currency and the document currency are identical (€)
- Incoterm Ex-Works (all the costs are paid by the buyer)
- Net price: €10/box
- Valued direct costs: 20 % of the net price
- Non-valued direct costs (calculation mode: unit price per box): €20 per box
- 1 box = 15 STK
- Valued invoicing element (transportation): €10
- Non-valued invoicing element (unloading): €7
- Non-deductible tax: 16.9 % but the NODVATSTO parameter - Non-deductible taxes in stock is set to "No".
--> For an order of 5 boxes:
Line amount -tax: 5 boxes * €10 = €50
+ Valued costs of the cost structure: €50 * 20 % = €10
+ Total of the valued invoicing elements: €10
Stock cost = 50 + 10 + 10 = €70
The stock cost per unit is the following: €70 / 75 STK = €0.933