Handling Rounding Issues in ERP Invoice Line Calculations

We have an invoice with 350 lines, and the total difference between the tax value in the xml file and the original tax value is 0.10 halalas. This means that the total invoice has changed by 0.75 halalas.

This is just one of the many cases we encounter throughout the day with our customers.

When scanning the QR code, the values will appear different from the printed copy for the customer with the copy in the QR code.

Also for compliance, The values provided in XML and values displayed on human readable of invoice must be same.

When the invoice is taxable, the buyer will not accept this invoice from the seller. We are facing a real problem with our customers.
The customer always thinks that the fault lies with our system, unfortunately, and cannot be convinced otherwise.

Of course, we have reduced the difference to 5 halalas by distributing the row from which the problem comes and its larger quantity to several rows, each row’s quantity being equal to only one.

The radical solution to this problem is to allow rounding to 6 decimal places for the price * quantity result.

1 Like

Dear @mnuaimi as discussed in the post Tiny Taxable and VAT Amounts Rounding Issue in the XML - #9 by Ankit.K.Tiwari please try calculating VAT on unrounded line extension amount and then apply 2 decimal rounding on line extension and VAT amount. Hope this should resolve the halala differences.

1 Like