Tiny Taxable and VAT Amounts Rounding Issue in the XML

XML and business rules
9

Dear @mnuaimi,

Please calculate the line item VAT on unrounded line extension amount, then round the line extension amount and line item VAT amounts after calculations. In your example above, please consider applying following steps:

  1. Item net price = 43.4782608696
  2. Invoiced Quantity = 3
  3. Line Extension Amount (intermediary step to calculate VAT) unrounded = 1 * 2 = 130.4348
  4. Line VAT amount (intermediary step) = 15% of 3 above = 19.56522
  5. now apply 2 decimal place rounding on line extension and VAT amounts which gives 130.43 and 19.57.
  6. Line Amount incl VAT = 150.00

You can perform intermediary calculations on unrounded values, then later round the output to 2 decimal places as explained above.

2 Likes