Amount due for payment (BT-115) = Invoice total amount with VAT (BT-112) -Paid amount (BT-113) +Rounding amount (BT-114).
DuePayableAmount does not equal the invoice total including VAT minus the amount already paid plus the rounding amount. If TotalPrepaidAmount or RoundingAmount is absent, the missing amount is not included in the calculation.
The amount due is calculated from the invoice total including VAT, less amounts already paid and adjusted by the rounding amount. This makes the stated amount due reflect the remaining balance.
The amount due does not match the invoice total, amounts already paid and the rounding amount. You can adjust the amounts so that the outstanding payment is correct.
- Calculate
DuePayableAmountfromGrandTotalAmountminusTotalPrepaidAmountplusRoundingAmount. - Include only the amounts whose elements are present in the invoice.
- Check the
DuePayableAmount,GrandTotalAmount,TotalPrepaidAmountandRoundingAmountproperties. - Generate the invoice again and validate it again.
<ram:SpecifiedTradeSettlementHeaderMonetarySummation> <ram:GrandTotalAmount>120.00</ram:GrandTotalAmount> <ram:TotalPrepaidAmount>20.00</ram:TotalPrepaidAmount> <ram:RoundingAmount>0.01</ram:RoundingAmount> <ram:DuePayableAmount>100.00</ram:DuePayableAmount> </ram:SpecifiedTradeSettlementHeaderMonetarySummation>
<ram:SpecifiedTradeSettlementHeaderMonetarySummation> <ram:GrandTotalAmount>120.00</ram:GrandTotalAmount> <ram:TotalPrepaidAmount>20.00</ram:TotalPrepaidAmount> <ram:RoundingAmount>0.01</ram:RoundingAmount> <ram:DuePayableAmount>100.01</ram:DuePayableAmount> </ram:SpecifiedTradeSettlementHeaderMonetarySummation>
FacturXInvoice.DuePayableAmount(BT-115)FacturXInvoice.GrandTotalAmount(BT-112)FacturXInvoice.RoundingAmount(BT-114)FacturXInvoice.TotalPrepaidAmount(BT-113)
- Information EN16931 XRechnung Extension (UBL Invoice) – overwrites CEN severity level "fatal" to enable Third Party Payment calculations (BR-DEX-09)
Technical details
The XPath check compares DuePayableAmount with GrandTotalAmount minus TotalPrepaidAmount plus RoundingAmount. It also accounts for cases where either or both optional total elements are absent.
The rule applies to DuePayableAmount, GrandTotalAmount, TotalPrepaidAmount and RoundingAmount in SpecifiedTradeSettlementHeaderMonetarySummation.
rule/@context)assert/@test)- 2023-01-312023-01-31 · ChangedSwitched off rules BR-CO-16 and UBL-CR-470 in UBL Extension scenario for Third Party Payment implementation