Skip to main content

BR-12 Sum of Invoice line net amount is required

An invoice shall have the Sum of Invoice line net amount (BT-106), the total of all line net amounts before document allowances, charges and VAT.

Problem Description

ERROR

EN 16931 core business rule (CEN)

Context and Significance

This is an EN 16931 core rule. BT-106 is the starting point of the document totals: the sum of all line net amounts (BR-CO-10). In UBL, cbc:LineExtensionAmount in cac:LegalMonetaryTotal is optional in the schema, so an export that writes only the tax-exclusive and payable totals passes the schema and fails on BR-12. In CII, BT-106 is ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:LineTotalAmount.

Solution

Add cac:LegalMonetaryTotal/cbc:LineExtensionAmount equal to the sum of every line’s BT-131 net amount.

Quick actions

Valid Examples

  • BT-106 = 1000.00 — equals the sum of all line net amounts

Invalid Examples

  • cac:LegalMonetaryTotal has no cbc:LineExtensionAmount element

Code Examples

Valid XML
<cac:LegalMonetaryTotal>
  <cbc:LineExtensionAmount currencyID="EUR">1000.00</cbc:LineExtensionAmount>
  <cbc:TaxExclusiveAmount currencyID="EUR">1000.00</cbc:TaxExclusiveAmount>
</cac:LegalMonetaryTotal>
Invalid XML
<cac:LegalMonetaryTotal>
  <cbc:TaxExclusiveAmount currencyID="EUR">1000.00</cbc:TaxExclusiveAmount>
  <cbc:PayableAmount currencyID="EUR">1190.00</cbc:PayableAmount>
</cac:LegalMonetaryTotal>

Affected Fields

Validation Tools