Inaccurate Calculation of Order
Locked
 
|
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 |
Re: Inaccurate Calculation of Order
|
|
What do you mean by "traditional means" here? -David On Apr 4, 2007, at 5:15 PM, <[hidden email]> <[hidden email]> 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 (3K)
Re: Inaccurate Calculation of Order
|
|
Also what are the applicable tax rates being applied?
Regards Scott On 05/04/07, David E. Jones <[hidden email]> wrote: > > > What do you mean by "traditional means" here? > > -David > > > On Apr 4, 2007, at 5:15 PM, <[hidden email]> <[hidden email]> 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 > > > > > > > |
|
|
In reply to this post by David E Jones
Hi David, Thanks for responding. An excel spreadsheet that our account had verified. Thanks & Regards, Peter -----Original Message----- From: David E. Jones [mailto:[hidden email]] Sent: 04 April 2007 22:39 To: [hidden email] 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, <[hidden email]> <[hidden email]> 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 > > |
|
|
In reply to this post by Scott Gray
Hi,
Thanks for getting in touch Scott. I did check that, the tax rates in both are exactly the same (17.5%). Thanks & Regards, Peter -----Original Message----- From: Scott Gray [mailto:[hidden email]] Sent: 04 April 2007 22:42 To: [hidden email] Subject: Re: Inaccurate Calculation of Order Also what are the applicable tax rates being applied? Regards Scott On 05/04/07, David E. Jones <[hidden email]> wrote: > > > What do you mean by "traditional means" here? > > -David > > > On Apr 4, 2007, at 5:15 PM, <[hidden email]> <[hidden email]> 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 > > > > > > > |
Re: Inaccurate Calculation of Order
|
|
In reply to this post by peter-230
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, <[hidden email]> wrote: > > > Hi David, > > > Thanks for responding. > > An excel spreadsheet that our account had verified. > > > Thanks & Regards, > > Peter > > > -----Original Message----- > From: David E. Jones [mailto:[hidden email]] > Sent: 04 April 2007 22:39 > To: [hidden email] > 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, <[hidden email]> <[hidden email]> 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 >> >> > > |
|
|
Hi,
Rather strikes me that the calculations used here always stay accurate to 2 digits, we never use 3 digits in the calculation at all. May I ask where you got the algorithm of 3 digits per entry then 2 digits to complete the total? Thanks David, Peter -----Original Message----- From: David E. Jones [mailto:[hidden email]] Sent: 04 April 2007 23:12 To: [hidden email] Subject: Re: Inaccurate Calculation of Order 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, <[hidden email]> wrote: > > > Hi David, > > > Thanks for responding. > > An excel spreadsheet that our account had verified. > > > Thanks & Regards, > > Peter > > > -----Original Message----- > From: David E. Jones [mailto:[hidden email]] > Sent: 04 April 2007 22:39 > To: [hidden email] > 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, <[hidden email]> <[hidden email]> 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 >> >> > > |
Re: Inaccurate Calculation of Order
|
|
In reply to this post by David E Jones
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, <[hidden email]> wrote: > >> >> >> Hi David, >> >> >> Thanks for responding. >> >> An excel spreadsheet that our account had verified. >> >> >> Thanks & Regards, >> >> Peter >> >> >> -----Original Message----- >> From: David E. Jones [mailto:[hidden email]] >> Sent: 04 April 2007 22:39 >> To: [hidden email] >> 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, <[hidden email]> <[hidden email]> 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 >>> >>> >> >> > |
Re: Inaccurate Calculation of Order
|
|
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 <[hidden email]> 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, <[hidden email]> wrote: > > > >> > >> > >> Hi David, > >> > >> > >> Thanks for responding. > >> > >> An excel spreadsheet that our account had verified. > >> > >> > >> Thanks & Regards, > >> > >> Peter > >> > >> > >> -----Original Message----- > >> From: David E. Jones [mailto:[hidden email]] > >> Sent: 04 April 2007 22:39 > >> To: [hidden email] > >> 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, <[hidden email]> <[hidden email]> 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 > >>> > >>> > >> > >> > > > |
|
|
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 <[hidden email]> 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 <[hidden email]> 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, <[hidden email]> wrote: > > > > > >> > > >> > > >> Hi David, > > >> > > >> > > >> Thanks for responding. > > >> > > >> An excel spreadsheet that our account had verified. > > >> > > >> > > >> Thanks & Regards, > > >> > > >> Peter > > >> > > >> > > >> -----Original Message----- > > >> From: David E. Jones [mailto:[hidden email]] > > >> Sent: 04 April 2007 22:39 > > >> To: [hidden email] > > >> 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, <[hidden email]> <[hidden email]> > 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 > > >>> > > >>> > > >> > > >> > > > > > > |
|
|
In reply to this post by Adrian Crum
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:[hidden email]] Sent: 04 April 2007 23:34 To: [hidden email] 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, <[hidden email]> wrote: > >> >> >> Hi David, >> >> >> Thanks for responding. >> >> An excel spreadsheet that our account had verified. >> >> >> Thanks & Regards, >> >> Peter >> >> >> -----Original Message----- >> From: David E. Jones [mailto:[hidden email]] >> Sent: 04 April 2007 22:39 >> To: [hidden email] >> 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, <[hidden email]> <[hidden email]> 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 >>> >>> >> >> > |
|
|
In reply to this post by Adrian Crum
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: [hidden email] [mailto:[hidden email]] Sent: 05 April 2007 00:11 To: '[hidden email]' 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:[hidden email]] Sent: 04 April 2007 23:34 To: [hidden email] 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, <[hidden email]> wrote: > >> >> >> Hi David, >> >> >> Thanks for responding. >> >> An excel spreadsheet that our account had verified. >> >> >> Thanks & Regards, >> >> Peter >> >> >> -----Original Message----- >> From: David E. Jones [mailto:[hidden email]] >> Sent: 04 April 2007 22:39 >> To: [hidden email] >> 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, <[hidden email]> <[hidden email]> 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 >>> >>> >> >> > |
Re: Inaccurate Calculation of Order
|
|
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, [hidden email] <[hidden email]> 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: [hidden email] [mailto:[hidden email]] > Sent: 05 April 2007 00:11 > To: '[hidden email]' > 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:[hidden email]] > Sent: 04 April 2007 23:34 > To: [hidden email] > 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, <[hidden email]> wrote: > > > >> > >> > >> Hi David, > >> > >> > >> Thanks for responding. > >> > >> An excel spreadsheet that our account had verified. > >> > >> > >> Thanks & Regards, > >> > >> Peter > >> > >> > >> -----Original Message----- > >> From: David E. Jones [mailto:[hidden email]] > >> Sent: 04 April 2007 22:39 > >> To: [hidden email] > >> 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, <[hidden email]> <[hidden email]> 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 > >>> > >>> > >> > >> > > > > |
Re: Inaccurate Calculation of Order
|
|
In reply to this post by peter-230
[hidden email] wrote:
>>From Excel... >>>>Would appreciated any feedback. Just because you set Excel to display a certain number of digits, that means nothing. You can get it to behave closer with the setting "Precision As Displayed", but using Excel as a "reference" when dealing with floating point numbers like currency is always subject to rounding errors. Spreadsheets are "quick and dirty". The "quick" is obvious, think about how "dirty" applies here. -- Walter |
Re: Inaccurate Calculation of Order
|
|
In reply to this post by cjhowe
So the difference here is:
1. Round before totaling or 2. Round after totaling. Can OFBiz be set to do either, or only one? 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 <[hidden email]> 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 <[hidden email]> 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, <[hidden email]> wrote: >>>> >>>>> >>>>> Hi David, >>>>> >>>>> >>>>> Thanks for responding. >>>>> >>>>> An excel spreadsheet that our account had verified. >>>>> >>>>> >>>>> Thanks & Regards, >>>>> >>>>> Peter >>>>> >>>>> >>>>> -----Original Message----- >>>>> From: David E. Jones [mailto:[hidden email]] >>>>> Sent: 04 April 2007 22:39 >>>>> To: [hidden email] >>>>> 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, <[hidden email]> <[hidden email]> >> 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 |
Re: Inaccurate Calculation of Order
|
|
In reply to this post by cjhowe
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 <[hidden email]> 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 <[hidden email]> 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, <[hidden email]> wrote: >>>> >>>>> >>>>> Hi David, >>>>> >>>>> >>>>> Thanks for responding. >>>>> >>>>> An excel spreadsheet that our account had verified. >>>>> >>>>> >>>>> Thanks & Regards, >>>>> >>>>> Peter >>>>> >>>>> >>>>> -----Original Message----- >>>>> From: David E. Jones [mailto:[hidden email]] >>>>> Sent: 04 April 2007 22:39 >>>>> To: [hidden email] >>>>> 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, <[hidden email]> <[hidden email]> >> 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 |
|
|
Hi,
Still having trouble setting the 'arithmetic.properties' file to give the correct figures. What are the permitted 'rounding parameters'? ROUND_HALF_UP or... # # Arithmetic properties for configuring BigDecimal calculations # # For setting decimal precision and rounding method of operations related to invoices invoice.decimals = 2 invoice.rounding = ROUND_HALF_UP # For setting decimal precision and rounding method of operations related to orders, # such as shopping cart amounts and order amounts order.decimals = 2 order.rounding = ROUND_HALF_UP # For setting decimal precision and rounding method of operations related to customer accounts # such as Financial Accounts finaccount.decimals = 2 finaccount.rounding = ROUND_HALF_UP # Most companies would want their sales tax calculations ALWAYS to round up (ie, 100.081 becomes 100.09) # This could be ROUND_CEILING or ROUND_UP. (The difference is that ROUND_CEILING rounds towards positive infinity, # ROUND_UP away from zero. So, for 1.13, both ROUND_UP and ROUND_CEILING will round to 1.2, but for -1.13, # ROUND_UP gives you -1.2 and ROUND_CEILING -1.1.) salestax.calc.decimals = 2 salestax.final.decimals = 2 salestax.rounding = ROUND_HALF_UP Thanks & Regards, Peter -----Original Message----- From: news [mailto:[hidden email]] On Behalf Of David Shere Sent: 05 April 2007 14:45 To: [hidden email] Subject: Re: Inaccurate Calculation of Order 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 <[hidden email]> 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 <[hidden email]> 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, <[hidden email]> wrote: >>>> >>>>> >>>>> Hi David, >>>>> >>>>> >>>>> Thanks for responding. >>>>> >>>>> An excel spreadsheet that our account had verified. >>>>> >>>>> >>>>> Thanks & Regards, >>>>> >>>>> Peter >>>>> >>>>> >>>>> -----Original Message----- >>>>> From: David E. Jones [mailto:[hidden email]] >>>>> Sent: 04 April 2007 22:39 >>>>> To: [hidden email] >>>>> 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, <[hidden email]> <[hidden email]> >> 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 |
Re: Inaccurate Calculation of Order (arithmetic.properties > Rounding Parameter Options)
|
|
Hi Peter
You can use any of the rounding modes that BigDecimal uses http://java.sun.com/j2se/1.4.2/docs/api/java/math/BigDecimal.html Regards Scott On 12/04/07, [hidden email] <[hidden email]> wrote: > > Hi, > > > Still having trouble setting the 'arithmetic.properties' file to give the > correct figures. > > What are the permitted 'rounding parameters'? > ROUND_HALF_UP > or... > > > # > # Arithmetic properties for configuring BigDecimal calculations > # > > # For setting decimal precision and rounding method of operations related > to > invoices > invoice.decimals = 2 > invoice.rounding = ROUND_HALF_UP > > # For setting decimal precision and rounding method of operations related > to > orders, > # such as shopping cart amounts and order amounts > order.decimals = 2 > order.rounding = ROUND_HALF_UP > > # For setting decimal precision and rounding method of operations related > to > customer accounts > # such as Financial Accounts > finaccount.decimals = 2 > finaccount.rounding = ROUND_HALF_UP > > # Most companies would want their sales tax calculations ALWAYS to round > up > (ie, 100.081 becomes 100.09) > # This could be ROUND_CEILING or ROUND_UP. (The difference is that > ROUND_CEILING rounds towards positive infinity, > # ROUND_UP away from zero. So, for 1.13, both ROUND_UP and ROUND_CEILING > will round to 1.2, but for -1.13, > # ROUND_UP gives you -1.2 and ROUND_CEILING -1.1.) > salestax.calc.decimals = 2 > salestax.final.decimals = 2 > salestax.rounding = ROUND_HALF_UP > > > Thanks & Regards, > > Peter > > > -----Original Message----- > From: news [mailto:[hidden email]] On Behalf Of David Shere > Sent: 05 April 2007 14:45 > To: [hidden email] > Subject: Re: Inaccurate Calculation of Order > > 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 <[hidden email]> 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 <[hidden email]> 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, <[hidden email]> wrote: > >>>> > >>>>> > >>>>> Hi David, > >>>>> > >>>>> > >>>>> Thanks for responding. > >>>>> > >>>>> An excel spreadsheet that our account had verified. > >>>>> > >>>>> > >>>>> Thanks & Regards, > >>>>> > >>>>> Peter > >>>>> > >>>>> > >>>>> -----Original Message----- > >>>>> From: David E. Jones [mailto:[hidden email]] > >>>>> Sent: 04 April 2007 22:39 > >>>>> To: [hidden email] > >>>>> 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, <[hidden email]> <[hidden email]> > >> 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 > > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |