Taxable amount for supplies not subject to VAT

Error BR-O-08 EN 16931

In a VAT breakdown (BG-23) where the VAT category code (BT-118) is " Not subject to VAT" the VAT category taxable amount (BT-116) shall equal the sum of Invoice line net amounts (BT-131) minus the sum of Document level allowance amounts (BT-92) plus the sum of Document level charge amounts (BT-99) where the VAT category codes (BT-151, BT-95, BT-102) are "Not subject to VAT".

Mandatory rule: As long as it is violated, the invoice is invalid and will be rejected by validators.
What is wrong

The ram:BasisAmount for category O does not exactly equal the sum of the net amounts of invoice lines in this category, plus the corresponding document-level charges and minus the corresponding allowances.

What the rule means

O denotes supplies not subject to VAT. The taxable amount in the VAT breakdown must correctly aggregate the net amounts and charges and allowances assigned to this category.

Please reconcile the taxable amount for supplies not subject to VAT

The taxable amount for O does not match the net amounts of the associated invoice lines and document-level allowances or charges. You can adjust the amounts or their tax category.

What to do
  1. Check ram:BasisAmount in ram:ApplicableTradeTax whose ram:CategoryCode is O.
  2. Compare it with the corresponding TradeLineItem.LineTotalAmount and AbstractTradeAllowanceCharge.ActualAmount values.
  3. Check whether the relevant tax categories are assigned to category O through TaxCategoryCodes.
  4. Generate the invoice again and validate it once more.
What it looks like
✗ Triggers the message
<ram:ApplicableTradeTax>
  <ram:CategoryCode>O</ram:CategoryCode>
  <ram:BasisAmount>99.00</ram:BasisAmount>
</ram:ApplicableTradeTax>
<ram:IncludedSupplyChainTradeLineItem>
  <ram:SpecifiedLineTradeSettlement>
    <ram:ApplicableTradeTax>
      <ram:CategoryCode>O</ram:CategoryCode>
    </ram:ApplicableTradeTax>
    <ram:SpecifiedTradeSettlementLineMonetarySummation>
      <ram:LineTotalAmount>100.00</ram:LineTotalAmount>
    </ram:SpecifiedTradeSettlementLineMonetarySummation>
  </ram:SpecifiedLineTradeSettlement>
</ram:IncludedSupplyChainTradeLineItem>
✓ Correct
<ram:ApplicableTradeTax>
  <ram:CategoryCode>O</ram:CategoryCode>
  <ram:BasisAmount>100.00</ram:BasisAmount>
</ram:ApplicableTradeTax>
<ram:IncludedSupplyChainTradeLineItem>
  <ram:SpecifiedLineTradeSettlement>
    <ram:ApplicableTradeTax>
      <ram:CategoryCode>O</ram:CategoryCode>
    </ram:ApplicableTradeTax>
    <ram:SpecifiedTradeSettlementLineMonetarySummation>
      <ram:LineTotalAmount>100.00</ram:LineTotalAmount>
    </ram:SpecifiedTradeSettlementLineMonetarySummation>
  </ram:SpecifiedLineTradeSettlement>
</ram:IncludedSupplyChainTradeLineItem>
Check in FactoorSharp
  • TaxCategoryCodes (BT-151; BT-95; BT-102; BT-118)
  • AbstractTradeAllowanceCharge.ActualAmount (Document level allowance: BT-92; Document level charge: BT-99)
  • TradeLineItem.LineTotalAmount (BT-131)
  • TradeLineItem.TaxCategoryCode (BT-151)
  • TradeLineItem.TaxType (BT-151-0)
Technical details

The test exactly compares ram:BasisAmount with the sum of line amounts and charges minus allowances in category O, rounded to two decimal places.

Where the rule applies

The rule applies to ram:ApplicableTradeTax with category O in the VAT breakdown and its corresponding invoice lines and document-level allowances and charges.

Context (rule/@context)
//rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[ram:CategoryCode = 'O']
Test expression (assert/@test)
ram:BasisAmount = (round(sum(/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeSettlement[ram:ApplicableTradeTax/ ram:CategoryCode = 'O']/ram:SpecifiedTradeSettlementLineMonetarySummation/ xs:decimal(ram:LineTotalAmount))*10*10)div 100) + (round(sum(/rsm:CrossIndustryInvoice/ rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ ram:SpecifiedTradeAllowanceCharge[ (ram:ChargeIndicator/udt:Indicator cast as xs:boolean)=true() and ram:CategoryTradeTax/ram:CategoryCode='O' ]/xs:decimal(ram:ActualAmount[1]))*10*10)div 100) - (round(sum(/rsm:CrossIndustryInvoice/ rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ ram:SpecifiedTradeAllowanceCharge[ (ram:ChargeIndicator/udt:Indicator cast as xs:boolean)=false() and ram:CategoryTradeTax/ram:CategoryCode='O' ]/xs:decimal(ram:ActualAmount[1]))*10*10)div 100)