Here is the configuration file, you can change the settings to whatever you want them to be: http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/config/arithmetic.properties?view=markup
From the default settings, it looks like calculation takes place at 3 digits
then gets rounded up to 2 places. Regards Scott On 05/04/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi, There must be something we are missing here. This can't be a bug, someone would have noticed already. Especially something so fundimental. Thanks & Regards, Peter -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 05 April 2007 00:11 To: 'user@ofbiz.apache.org' Subject: RE: Inaccurate Calculation of Order Importance: High Hi, Whichever way I work it out the Order Entry system does seem to be slightly out. From Excel... Price tax 2 digits tax 3 digits tax 9 digits Product 1 35.74 6.25 6.255 6.254500000 Product 2 35.74 6.25 6.255 6.254500000 shipping 6 1.05 1.050 1.050000000 Tax 13.56 13.56 13.56 13.56 Total 91.04 The Order Manager came up with 91.05, I have screenshots if anyone is interested. Thanks & Regards, Peter -----Original Message----- From: Adrian Crum [mailto:[EMAIL PROTECTED] Sent: 04 April 2007 23:34 To: user@ofbiz.apache.org Subject: Re: Inaccurate Calculation of Order 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 >>> >>> >> >> >