c2c-oerpscenario team mailing list archive
-
c2c-oerpscenario team
-
Mailing list archive
-
Message #06667
[Bug 685963] [NEW] Calculating failure rates and total precision error of rounding
Public bug reported:
At this time, OpenERP works, but I found a peculiar problem. This is
the scenario, creating a budget:
Tax: 12.5%
Product: XYZ
Product Price: 50.00
Product Size: 1.00
That is: Real World: 50.00 * 1.00 = 50.00, in OpenERP 50.00 * 1.00 =
50.15$
Later
But the SubTotal is 5.90
Tax Total: 5.90
Total: 56.05
Equal, in the Real World the tax 50.15$ * 0.125 (%) = 6.27$ in OpenERP
50.15$ * 0.125 (%) = 5.90$!!!!!!
It makes no sense that if a product costs $ 50.00 per item, the subtotal of $ 50.15 for a single (1) piece. Still less, that the error is propagated with a tax of 12.5% giving a total tax of $ 5.90. To that end, the total of all the calculation of $ 56.05.
Some of the comments argue that users should adjust prices to go even
"square" in quotes, values. This is absolute nonsense, taking into
account the great responsibility that must have ERP software in the
reliability of its results and operations.
Please, should you make any adjustment of the code? It is an irreparable
error? What is the strategy recommended to resolve the situation?
** Affects: openobject-server
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/685963
Title:
Calculating failure rates and total precision error of rounding
Status in OpenObject Server:
New
Bug description:
At this time, OpenERP works, but I found a peculiar problem. This is
the scenario, creating a budget:
Tax: 12.5%
Product: XYZ
Product Price: 50.00
Product Size: 1.00
That is: Real World: 50.00 * 1.00 = 50.00, in OpenERP 50.00 * 1.00 = 50.15$
Later
But the SubTotal is 5.90
Tax Total: 5.90
Total: 56.05
Equal, in the Real World the tax 50.15$ * 0.125 (%) = 6.27$ in OpenERP 50.15$ * 0.125 (%) = 5.90$!!!!!!
It makes no sense that if a product costs $ 50.00 per item, the subtotal of $ 50.15 for a single (1) piece. Still less, that the error is propagated with a tax of 12.5% giving a total tax of $ 5.90. To that end, the total of all the calculation of $ 56.05.
Some of the comments argue that users should adjust prices to go even "square" in quotes, values. This is absolute nonsense, taking into account the great responsibility that must have ERP software in the reliability of its results and operations.
Please, should you make any adjustment of the code? It is an irreparable error? What is the strategy recommended to resolve the situation?
Follow ups
-
[Bug 685963] Invitación a conectarnos en LinkedIn
From: Roger Zavala, 2011-04-14
-
[Bug 685963] Re: Calculating failure rates and total precision error of rounding
From: RME(OpenERP), 2010-12-28
-
[Bug 685963] Re: Calculating failure rates and total precision error of rounding
From: Roger Zavala, 2010-12-17
-
[Bug 685963] Re: Calculating failure rates and total precision error of rounding
From: RME(OpenERP), 2010-12-14
-
[Bug 685963] Re: Calculating failure rates and total precision error of rounding
From: Roger Zavala, 2010-12-13
-
[Bug 685963] Re: Calculating failure rates and total precision error of rounding
From: Jas(OpenERP), 2010-12-13
-
[Bug 685963] Re: Calculating failure rates and total precision error of rounding
From: Jas(OpenERP), 2010-12-13
-
[Bug 685963] Re: Calculating failure rates and total precision error of rounding
From: Roger Zavala, 2010-12-10
-
[Bug 685963] Re: Calculating failure rates and total precision error of rounding
From: Jas(OpenERP), 2010-12-09
-
[Bug 685963] [NEW] Calculating failure rates and total precision error of rounding
From: Roger Zavala, 2010-12-06
References