This assessment appears to confirm that OFBiz does the rounding this
way: Rounding line items to three digits, then rounding each line item
result to two digits, then add them up.
This is different than what David says is the VAT practice of rounding
line items to three digits, adding them up, and rounding the result to
two digits.
The arithemetic.properties file does not appear to have settings to
control this specific aspect of the rounding behavior.
Chris Howe wrote:
The only way I can get 13.57 tax is to round to three digits, then
round to 2 digits for each line then add them up.
1. 6.2545 (real) -> 6.255 -> 6.26
2. 6.2545 (real) -> 6.255 -> 6.26
3. 1.05 (real) -> 1.05 -> 1.05
13.559 (real)...13.56....13.57
--- Scott Gray <[EMAIL PROTECTED]> wrote:
The only way I can get 13.57 tax is to round the tax for each line
item up
to 2 decimals before totaling.
I think I've send some rounding rules in a config file somewhere but
I'm not
sure on that.
On 05/04/07, Adrian Crum <[EMAIL PROTECTED]> wrote:
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: user@ofbiz.apache.org
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
--
David Shere
Information Technology Services
Steele Rubber Products
www.SteeleRubber.com
