I have numerous Tax Detail IDs set up to calculate the sales tax for the various jurisdictions in California. As a result , most taxable sales have taxes calculated three times.
All of the Tax Detail IDs have the round set to "To the Nearest Currency Decimal Digit"
Yet, I frequently find that the calculation does not round as expected:
For example: today I have an invoice that on the Sales Tax Summary Entry window it shows Total Taxable Sales of $607.22; Percent/Amount of 1.00000% and Tax Amount of $6.08 (actual calculation is $6.0722 which should round to $6.07)
On this same invoice, I have another tax detail, again showing Total Taxable Sales of $607.22; Percent/Amount of 6.50000% and Tax Amount of $39.48 (actual calculation is $39.4693 which should round to $39.47).
This is not an exception occurrence but happens frequently.
Yes I could change the "Round" option to "Down to the Previous Currency Decimal Digit" but I do not want to consistently undercharge my customers. Besides if the calculation is not correct on the other "Round" option, why should it be correct on this one.
Any fixes?
*This post is locked for comments