Rounding tax rates, result wrong tax.

[Swech]

Hi.
Zencart seems to count everything using only 2 decimals.
This would not be any big issue if it did it cleverly but unfortunately it does it in a way that causes rounding errors to become huge.

F.ex.
I have a product that costs 0.42 SEK
Tax rate in Sweden is 25% (VAT)

The price including tax is thus 0.525 sek
Zencart rounds this up to 0.53 sek - fairly ok. BUT
the customer buys 35 pcs.
correct price ist 0.525*35 = 18,375 SEK
but i end up with 0.53*35 = 18,55 Sek

Since I do my invoice in Excel the math does not add up.
The correct way to actually calculate the VAT would be to add up
all the prices and THEN multiply with 1.25..... not do this strange
vat calcuation with rounding errors and then add wrong numbers together.

kind regards
Jonas D.

[rstevenson]

The issue is well known and has been throughly discussed here. It is, I believe, due for correction in v2.0. In the meantime, search this forum for other threads which have a variety of solutions -- or at least workarounds.

Rob