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
>>>
>>>
>>
>>
>
