David,
I just calculated the tax on each line item accurate to 9 decimals, summed the
taxes, and I still get a total tax of $13.559.
David E. Jones wrote:
Ummmm.... need more details. There are variations in rounding modes,
precision rules etc.
For example with VAT in pretty much ALL countries that use VAT you must
calculate line item tax amounts with 3 digits of precision, add them
up, then round to 2 digits.
-David
On Apr 4, 2007, at 5:50 PM, <[EMAIL PROTECTED]> wrote:
Hi David,
Thanks for responding.
An excel spreadsheet that our account had verified.
Thanks & Regards,
Peter
-----Original Message-----
From: David E. Jones [mailto:[EMAIL PROTECTED]
Sent: 04 April 2007 22:39
To: [email protected]
Subject: Re: Inaccurate Calculation of Order
Importance: High
What do you mean by "traditional means" here?
-David
On Apr 4, 2007, at 5:15 PM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> wrote:
Hi,
Has anyone run into the problem of having Purchases not calculated
accurately?
These are the figures calculated by traditional means;
Product 1: 35.74
Product 2: 35.74
Shipping : 6.00
Total : 77.48
Tax : 13.56
-----------------
Total : 91.04
These are the figures calculated by Ofbiz Order Manager;
Product 1: 35.74
Product 2: 35.74
Shipping : 6.00
Total : 77.48
Tax : 13.57
-----------------
Total : 91.05
There is a very slight difference of 1c. But the fact of the matter
is that
the figure calculated by the system is very slightly incorrect.
Struck me
that the Tax maybe being calculated to 3 digits rather than 2 digits.
Does anyone know which file(s) control the calculation of the Tax,
so I can
check if it is 2 or 3 digits.
Would appreciated any feedback.
Thanks & Regards,
Peter
