Skip to main content

BR-CO-16 Amount due for payment must equal total with VAT minus paid plus rounding

Amount due for payment (BT-115) must equal Invoice total amount with VAT (BT-112) minus Paid amount (BT-113) plus Rounding amount (BT-114).

Problem Description

ERROR

EN 16931 calculation and consistency rule (BR-CO)

Context and Significance

The validator checks this equation exactly, without tolerance. Failures usually come from prepayments or rounding: the ERP deducts an advance payment from the amount due but does not export it as BT-113, or it rounds the amount due without stating the difference in BT-114.

Solution

Recompute BT-115 = BT-112 − BT-113 + BT-114, treating BT-113 and BT-114 as zero when absent. UBL: cbc:PayableAmount, cbc:PrepaidAmount, cbc:PayableRoundingAmount; CII: ram:DuePayableAmount, ram:TotalPrepaidAmount, ram:RoundingAmount.

Quick actions

Valid Examples

  • BT-112 = 119.00, BT-113 = 50.00, BT-114 = 0.00 → BT-115 = 69.00
  • BT-112 = 99.98, BT-113 absent, BT-114 = 0.02 → BT-115 = 100.00

Invalid Examples

  • BT-115 = BT-112 even though BT-113 = 50.00 prepaid
  • BT-115 ignores BT-114 rounding adjustment of 0.02

Affected Fields

Validation Tools