InvoiceGlass

The line net total has too many decimal places · BR-DEC-09

  • Severity · Error
  • Applies to · UBL / CII
  • Editorial review pending

The sum of line net amounts field (BT-106) may have up to two decimal places. This is the sum of the net amounts across the invoice lines. Trailing zeros in the XML also count as decimal places.

As of

Who can correct it?

The sender can correct the invoice.

How to fix it

  1. Export the sum of line net amounts with at most two decimal places. Then verify any totals that use this amount.
  2. XML fields in the affected group · UBL cac:LegalMonetaryTotal/cbc:LineExtensionAmount · CII ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:LineTotalAmount

Rule text and source

Paraphrase · BT-106 is limited to amounts with at most two decimal places.

Message to the sender

Subject: Invoice {invoiceNumber} – The line net total has too many decimal places

Hello,

could you clarify a detail on your invoice {invoiceNumber} dated {issueDate} (BR-DEC-09)? The sum of line net amounts field (BT-106) may have up to two decimal places. Please export the amount with at most two decimal places and verify the totals that use it.

Could you send us the corrected invoice?

Thank you and kind regards

Example

The sum of line net amounts is written as 12.346 in the XML, with three decimal places. The value rounded to two places is 12.35.

UBL

cac:LegalMonetaryTotal/cbc:LineExtensionAmount

Fails the rule
<cbc:LineExtensionAmount currencyID="EUR">12.346</cbc:LineExtensionAmount>

Corrected
<cbc:LineExtensionAmount currencyID="EUR">12.35</cbc:LineExtensionAmount>

CII

ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:LineTotalAmount

Fails the rule
<ram:LineTotalAmount>12.346</ram:LineTotalAmount>

Corrected
<ram:LineTotalAmount>12.35</ram:LineTotalAmount>

Related rules

Business terms

Rule versions

CEN · EN 16931 (KoSIT) 1.3.16

CEN · EN 16931 1.3.17

Validate a file