VRBL: Line-Level Totals
Read about how totals are modeled and calculated at the line level.
Line-level totals generally apply to a specific line item. These are aggregated for some Document-level totals
Item Net Price
If a gross price and discount exist, the Item net price has to be equal to the item gross price less the item price discount.
Calculation details
The following details are used to calculate an item's net price:
Detail | Value |
---|---|
Line Calculation Name | Item Net Price (Invoice/InvoiceLine/Price/PriceAmount ) |
Element Reference Topic | PriceDetails |
Modeling Guide Topic | VRBL: Price Details |
Description | Price of the item is the difference between the amount and base amount for an item. |
Calculation | Invoice Line Allowances and Charges (Invoice/InvoiceLine /AllowanceCharge ) ÷ Invoice Line Base Amount (Invoice/InvoiceLine/AllowanceCharge/BaseAmount ) - Invoice Line Allowances and Charges (Invoice/InvoiceLine/AllowanceCharge ) ÷ Invoice Line Amount (Invoice/InvoiceLine/AllowanceCharge/Amount ) |
Example
Here is an example:
<Invoice>
<!-- code omitted for clarity -->
<cac:InvoiceLine>
<!-- code omitted for clarity -->
<cac:Price>
<cbc:PriceAmount currencyID="EUR">410</cbc:PriceAmount>
<cbc:BaseQuantity unitCode="C62">1</cbc:BaseQuantity>
<cac:AllowanceCharge>
<cbc:ChargeIndicator>false</cbc:ChargeIndicator>
<cbc:Amount currencyID="EUR">40</cbc:Amount>
<cbc:BaseAmount currencyID="EUR">450</cbc:BaseAmount>
</cac:AllowanceCharge>
</cac:Price>
<cac:InvoiceLine>
<!-- code omitted for clarity -->
</Invoice>
Invoice-line net amounts
The invoice line net amount is, as the name implies, the net amount without tax, and includes the line level allowance and charges.
Calculation details
Detail | Value |
---|---|
Line Total Calculation Name | Item Net Price without Allowance or Charge |
Element Reference Topic | PriceDetails and InvoicedQuantity |
Modeling Guide Topic | VRBL: Prices |
Description | The Item's net price divided by the item's base quantity multiplied by the invoiced quantity plus the Invoice line charge amount minus the Invoice line allowance amount. |
Calculation | Item Net Price (Invoice/InvoiceLine/Price/PriceAmount ) ÷ Item Price Base Quantity (Invoice/InvoiceLine/Price/BaseQuantity ) x Invoiced Quantity (Invoice/InvoiceLine/InvoicedQuantity ) + Invoice line charge amount (AllowanceCharge[ChargeIndicator='true']/Amount ) - Invoice line allowance amount (AllowanceCharge[ChargeIndicator='false']/Amount ) |
Example
No allowances or charges
This is an example of an invoice line with no allowances or charges:
<Invoice>
<!-- code omitted for clarity -->
<cac:InvoiceLine>
<cbc:InvoicedQuantity unitCode="C62">10</cbc:InvoicedQuantity>
<cbc:LineExtensionAmount currencyID="EUR">1000.00</cbc:LineExtensionAmount>
<!-- code omitted for clarity-->
<cac:Price>
<cbc:PriceAmount currencyID="EUR">200</cbc:PriceAmount>
<cbc:BaseQuantity unitCode="C62">2</cbc:BaseQuantity>
</cac:Price>
</cac:InvoiceLine>
</Invoice>
Including allowance and charge
The following example includes an example Allowance and Charge:
<Invoice>
<!-- code omitted for clarity -->
<cac:InvoiceLine>
<cbc:InvoicedQuantity unitCode="C62">10</cbc:InvoicedQuantity>
<cbc:LineExtensionAmount currencyID="EUR">900.00</cbc:LineExtensionAmount>
<!-- code omitted for clarity-->
<cac:AllowanceCharge>
<cbc:ChargeIndicator>true</cbc:ChargeIndicator>
<cbc:AllowanceChargeReasonCode>CG</cbc:AllowanceChargeReasonCode>
<cbc:AllowanceChargeReason>Charge</cbc:AllowanceChargeReason>
<cbc:MultiplierFactorNumeric>1</cbc:MultiplierFactorNumeric>
<cbc:Amount currencyID="EUR">1</cbc:Amount>
<cbc:BaseAmount currencyID="EUR">100</cbc:BaseAmount>
</cac:AllowanceCharge>
<cac:AllowanceCharge>
<cbc:ChargeIndicator>false</cbc:ChargeIndicator>
<cbc:AllowanceChargeReasonCode>95</cbc:AllowanceChargeReasonCode>
<cbc:AllowanceChargeReason>Discount</cbc:AllowanceChargeReason>
<cbc:Amount currencyID="EUR">101</cbc:Amount>
</cac:AllowanceCharge>
<!-- code omitted for clarity-->
<cac:Price>
<cbc:PriceAmount currencyID="EUR">100</cbc:PriceAmount>
</cac:Price>
</cac:InvoiceLine>
</Invoice>
Line-level allowances and charges
Allowance and charge on line level (and on document level) consists of elements carrying information on the allowance/charge base amount and the allowance/charge percentage.
Allowances and Charges can be documented at the line level using the InvoiceLine/AllowanceCharge element.
Base amounts and percentages can be used.
You use the Amount
element to specify the total amount. You can use this alone, or you can also add a percentage and a base amount.
To model a percentage and base amount, you specify the percentage in the MultiplierFactorNumeric
element and the base amount in the BaseAmount
element.
Calculation details
The following calculation is used for line-level Allowances and Charges:
Detail | Value |
---|---|
Line Total Calculation Name | Line-level Alowances and Charges |
Element Reference Topic | InvoiceLine/AllowanceCharge |
Modeling Guide Topic | VRBL: Allowances and VRBL: Charges |
Description | Allowance/charge amount = Base amount x (Percentage ÷ 100) |
Calculation | Invoice Line Base Amount (Invoice/InvoiceLine/AllowanceCharge/BaseAmount)(BaseAmount ) x Invoice Line - Percentage (Invoice/InvoiceLine/AllowanceCharge/MultiplierFactorNumeric ) ÷ 100) |
Examples
Base Amount
This example uses a base amount and percentage:
<Invoice>
<!-- code omitted for clarity -->
<cac:InvoiceLine>
<!-- code omitted for clarity -->
<cac:AllowanceCharge>
<cbc:ChargeIndicator>true</cbc:ChargeIndicator>
<cbc:AllowanceChargeReasonCode>CG</cbc:AllowanceChargeReasonCode>
<cbc:AllowanceChargeReason>Cleaning</cbc:AllowanceChargeReason>
<cbc:MultiplierFactorNumeric>20</cbc:MultiplierFactorNumeric>
<cbc:Amount currencyID="EUR">200</cbc:Amount>
<cbc:BaseAmount currencyID="EUR">1000</cbc:BaseAmount>
<cac:TaxCategory>
<cbc:ID>S</cbc:ID>
<cbc:Percent>25</cbc:Percent>
<cac:TaxScheme>
<cbc:ID>VAT</cbc:ID>
</cac:TaxScheme>
</cac:TaxCategory>
</cac:AllowanceCharge>
<!-- code omitted for clarity -->
<cac:InvoiceLine>
<Invoice>
No Base Amount
This example doe not use the base amount or percentages:
<Invoice>
<!-- code omitted for clarity -->
<cac:InvoiceLine>
<!-- code omitted for clarity -->
<cac:AllowanceCharge>
<cbc:ChargeIndicator>false</cbc:ChargeIndicator>
<cbc:AllowanceChargeReasonCode>95</cbc:AllowanceChargeReasonCode>
<cbc:AllowanceChargeReason>Discount</cbc:AllowanceChargeReason>
<cbc:Amount currencyID="EUR">200</cbc:Amount>
<cac:TaxCategory>
<cbc:ID>S</cbc:ID>
<cbc:Percent>25</cbc:Percent>
<cac:TaxScheme>
<cbc:ID>VAT</cbc:ID>
</cac:TaxScheme>
</cac:TaxCategory>
</cac:AllowanceCharge>
<!-- code omitted for clarity -->
<cac:InvoiceLine>
<Invoice>
Updated 11 days ago