I am having a similar tax rounding issue on a number of documents that I cannot seem to solve, and I re-created it at a basic level on a quotation on the demo site under QTN-00090. Also, screenshot below. The rounding yields improper tax calculation for where I live (United States, California), off by $0.01. Tax rate is 7.500%. When one item is $100, the tax is calculated properly as $7.50. However, if there there are two items, one item for $99 and one item for $1, totaling exactly $100, the tax is calculated improperly as $7.51. I’m guessing it’s rounding tax on each item, and since the tax fraction is exactly half a cent on each item, it rounds up for both. In California, the tax must not be rounded until the final tax total.
If we send quotations like this to our customers, they will not do business with us because to their accounting departments it looks like an elementary error.
I’ve increased the currency precision by customizing the “Quotation” and the “Sales Taxes and Charges” forms, but it does not change the tax values. Also, it typically displays an extra decimal that is unwanted.
Any insight on how to mitigate this issue would really be appreciated. Thanks in advance.