I have a constant problem with sales orders. The VAT is calculated on each product line. However, because the VAT on each line is rounded to 2 decimals, this can give rise to an incorrect VAT total on the overall order. The only way to correct this is manually adjust the VAT on individual lines.
e.g. If you have 2 lines with VAT exclusive amount of €7.50 and a VAT rate of 23%, the VAT on each line is €7.50 x 23% = €1.725 which gets rounded to €1.73.
The overall total for the 2 lines shows VAT exclusive amount of €15.00 and VAT total of €1.73 x 2 = €3.46
However €15.00 x 23% = €3.45 not €3.46.
I have to manually change the VAT on one of the lines to €1.72 to get the correct total.
This is totally time consuming and unnecessary if there was a VAT calculation check on the overall total. I should not have to check every order/invoice to ensure the VAT is correct. Depending on the number of lines and what the 3rd decimal is on each VAT calculation, the difference can be greater than 1 cent. If I don't correct the differences, I will inevitably get queries from customers.
Guest
