Rules are used to calculate net mass, mass in supplementary unit, statistical values, and the total value of collected transactions.
Net mass is drawn from the Weight field of the document row. If the Weight field is blank, but you have defined the sales weight and the purchase weight for the item later, net mass is calculated as shown in the table below:
Transactional Type |
Net Mass |
---|---|
Sales – A/R |
Net Mass = Sales Weight * Quantity |
Purchasing – A/P |
Net Mass = Purchase Weight * Quantity |
Note
The sales weight and the purchase weight are drawn from the item master data. Rounding applies only to net mass, not to the sales weight or purchase weight of single items.
Mass in supplementary unit is calculated for items to which you have assigned a supplementary unit.
Note
If you want an item's mass in supplementary unit calculated, you must define a factor of supplementary unit in the item's Intrastat settings.
The weight value used in the calculation comes by default from the Weight field in the document. If the Weight field is blank, the weight value comes from the sales weight or the purchase weight in the item master data. Your setting of the Use Weight in Calculation of Mass in Supplementary Unit checkbox on the Intrastat Settings tab of the item master data also has an impact on the calculation.
The mass in supplementary unit is calculated in one of the following ways:
If you use weight in the calculation, Mass in Supplementary Unit = Quantity × Factor of Supplementary Unit × Weight
If you do not use weight in the calculation, Mass in Supplementary Unit = Quantity × Factor of Supplementary Unit
Example
Supplementary Unit |
Quantity |
Factor |
Weight (kg) |
Use Weight in Calculation |
Formula/Result |
---|---|---|---|---|---|
Ton |
5 |
0.001 |
10 |
Yes |
Mass = 5 × 0.001 × 10 = 0.05 |
No |
Mass = 5 × 0.001 = 0.005 |
||||
0 |
Yes |
Mass = 5 × 0.001 × 0 = 0 |
|||
No |
Mass = 5 × 0.001 = 0.005 |
The statistical value of each transaction row depends on your setting of the Simplified Procedure checkbox on the General tab of the Intrastat Configuration window.
Simplified Procedure checkbox |
Calculation Rule |
---|---|
Not selected |
Statistical Value = Row Total × Percentage Statistical Value of the Incoterms |
Not selected and the document row is not assigned an Incoterms |
Statistical Value = Row Total |
Selected |
The value of each declared transaction row is collected according to the following rules:
By default, it is drawn from the Total (LC) field of each row, or the Total (Doc) field if the transaction is recorded in a foreign currency.
If you have defined a discount for the document, the transaction value is the discounted row total.
If a delivery or goods receipt PO is fully invoiced, the invoiced value is declared.
If a partly invoiced delivery or goods receipt PO is included in a declaration, only its uninvoiced value is declared
The total declaration value is the sum of all collected transaction values. Depending on its value sign, a transaction value is deducted from or added to the total value.