This field, which cannot be modified, is displayed if the transaction authorizes it.
It displays the amount of the costs used for stock valuation, expressed in the currency of the company.
Notes:
When the order is of the inter-site type, the stock cost calculation does not include the line amount, nor non-deductible taxes.The invoicing elements are taken into account only if the parameter BETFCYCST - Integration of invoicing elements (ACH chapter, COS group) is set to 'Yes'.This amount is never calculated during the entry process but only when saving the document.Its calculation mode varies according to the method used to evaluate the landed costs:
- Global method in which a Landed cost coefficient is applied and/or a Fixed cost per unit is taken into account:
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 in tab "Management".
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 parameter NODVATSTO - 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 parameter NODVATSTO - 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 the following: €175 / 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 parameter NODVATSTO - 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 taken into account are only the ones with the "Stock valuation" flag set to: "Yes").
+ total of the non-deductible taxes (if parameter NODVATSTO - 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 parameter NODVATSTO - 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