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
smime.p7s
Description: S/MIME cryptographic signature