UBL import Arithmetical issue warning. Document discounts and Charges are not taken into Payable total amount

[LukasHaefelinger]

Hello good morning,

we just recently updated to the new version and now get a warning when validating our file (see attachment)
What I investigated so far is that the document discount/ document allowance are not taken into to payable total sum which then leads to a mismatch between the value in the xml (with both discount and allowance in sum).

Can you help me further on how the proceed?

Thank you very much for your help

DiscountAllowance-Berechnung.xlsx

UBL_2Items_withC&D_and_DocumentC&D_files_attachments.xml

[ThomasChr]

Error is:

<validation filename="test.xml" datetime="2026-01-21 12:29:32">
  <xml>
    <info>
      <version>2</version>
      <profile>urn:cen.eu:en16931:2017#compliant#urn:xeinkauf.de:kosit:xrechnung_3.0</profile>
      <validator version="null"/>
      <rules>
        <fired>18</fired>
        <failed>0</failed>
      </rules>
      <duration unit="ms">3362</duration>
    </info>
    <messages>
      <warning type="10">Arithmetical issue:Payable total in XML is 72.82, but calculated total is 71.39 with tax basis 59.99 and with positions 59.99 = 54.49 + 5.50</warning> 
    </messages>
    <summary status="valid"/>
  </xml>
  <messages></messages>
  <summary status="valid"/>
</validation>

[LukasHaefelinger]

Thank you for your fast response

This is what I can reproduce too. But I`d like to understand, why the validator ignores the document charges/allowances when calculating the payable total

Can we neglect this warning, if our document contains document allowances/charges?

Our system so far sets invoice on a "check manual" status, if there are warnings/errors from the validator.

[ThomasChr]

no warning in: ea14c70
warning started in: 1b174e2 or 8ce3d21

Seems that this was deliberately: #878

[ThomasChr]

Yeah, I can see the problem now. How has this invoice been generated?
Seems that this part doesn't get parsed:

  <cac:AllowanceCharge>
    <cbc:ChargeIndicator>false</cbc:ChargeIndicator>
    <cbc:AllowanceChargeReason>Document Discount</cbc:AllowanceChargeReason>
    <cbc:MultiplierFactorNumeric>10</cbc:MultiplierFactorNumeric>
    <cbc:Amount currencyID="EUR">6.00</cbc:Amount>
    <cbc:BaseAmount currencyID="EUR">59.99</cbc:BaseAmount>
    <cac:TaxCategory>
      <cbc:ID>S</cbc:ID>
      <cbc:Percent>19</cbc:Percent>
      <cac:TaxScheme>
        <cbc:ID>VAT</cbc:ID>
      </cac:TaxScheme>
    </cac:TaxCategory>
  </cac:AllowanceCharge>
  <cac:AllowanceCharge>
    <cbc:ChargeIndicator>true</cbc:ChargeIndicator>
    <cbc:AllowanceChargeReason>Document Charge</cbc:AllowanceChargeReason>
    <cbc:MultiplierFactorNumeric>12</cbc:MultiplierFactorNumeric>
    <cbc:Amount currencyID="EUR">7.20</cbc:Amount>
    <cbc:BaseAmount currencyID="EUR">59.99</cbc:BaseAmount>
    <cac:TaxCategory>
      <cbc:ID>S</cbc:ID>
      <cbc:Percent>19</cbc:Percent>
      <cac:TaxScheme>
        <cbc:ID>VAT</cbc:ID>
      </cac:TaxScheme>
    </cac:TaxCategory>
  </cac:AllowanceCharge>

[LukasHaefelinger]

I created it and some more on my own and validated it on some other some web-interfaces which didnt raise a warning/error
Can you give me some info why it isnt parsed?

[ThomasChr]

This code doesn't find the Charges: https://github.com/ZUGFeRD/mustangproject/blob/5a787c31f2c713271085359eac4b42471b7e81bc/library/src/main/java/org/mustangproject/ZUGFeRD/ZUGFeRDInvoiceImporter.java#L1120C7-L1120C181

Reason beeing an "incorrect" xPath. In this case the xPath needs to be something like:

xpath.compile("//*[local-name()=\"AllowanceCharge\"]")

If I read the xRechnung Standard correctly this is correct and allowed but it seems the library can't parse it.

Possible fix would be this: #1016
Leaving as draft for now and waiting for @jstaerk to decide.

Possible problem:
I'm not quite sure if the top-level Node is always called <Invoice>. It's called <CrossIndustryInvoice> in ZUGFeRD and the xPath would fail in this case. But leaving the root element out of the xpath would make it find the item level AllowanceCharge also, which is also wrong.

[LukasHaefelinger]

DiscountAllowance-Berechnung_CreditNote.xlsx

Hello @ThomasChr
I also just prcessed a CreditNote xml in which I also get the arithmetical issue (as the xml above had too). It looks to me as if in the CreditNote type the allowances and charges both on item and document level are also not taken into consideration. Maybe this is linked to the previous issue we had

XRechnung_CreditNote-12345-15_UBL.xml

[LukasHaefelinger]

Hello @ThomasChr
any updates on the CreditNote.xml?

Thank you very much