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





Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to