Volume calculation and calculated KG

This page explains the logic behind volume calculation in the Quote Line Editor.

User inputs

When Finished Good are added to the Quote, the user sets a :

• “Volume” : corresponding to the product quantity

• and a “Volume unit”: either liter(LTR), kilogram (KG), or “Invoicing unit”

By invoicing unit, we mean the product's min unit of measure stored in the product record and displayed in the Quote Line's” Invoicing Unit” field.

Volume in invoicing unit calculation

The Volume in invoicing units is calculated based on the Volume and its related unit in the Quote Line.

If the invoicing unit equals : 
- “Invoicing unit”, then volume in invoicing units = volume.
- “KG”, then volume in invoicing units = volume × net weight in KG.
- “LTR“, then volume in invoicing units = volume × liquid content in LTR.

“Net weight” and “liquid content” are product attributes stored in the product record sunced from the UoM lookup table.

Calculated total KGs and Calculated total L/KG for Valio guidance purposes

These calculated fields are used in further product calculations.

Calculated total KGs is the inverted calculation of the volume in invoicing unit. It determines the overall KG per product used in product group calculation and equals :

Volume, if “Volume unit” is liter (LTR) or kilogram (KG).
Volume * net weight in KG, if “Volume unit” equals invoicing unit.

“Calculated total L/KG for Valio guidance purposes” on the other hand is based on Volume in invoicing unit and liquid content in LTR

Volume in invoicing unit* liquid content in LTR

Data flow

The Diagram below show the calculation rule between the different fields: