Re: The Return of...Inaccurate Calculation of Order

2007-04-18 Thread David E. Jones
[EMAIL PROTECTED] Sent: 18 April 2007 22:12 To: user@ofbiz.apache.org Subject: Re: The Return of...Inaccurate Calculation of Order Peter, Sorry it took me so long to take a peek at this... My guess is that the calculation process is not what you are expected, namely in terms of when the roun

RE: The Return of...Inaccurate Calculation of Order

2007-04-18 Thread peter
= 10 > > > Can anyone offer some assistance. > > > Thanks & Regards, > > Peter > > > From: Scott Gray [mailto:[EMAIL PROTECTED] > Sent: 18 April 2007 01:27 > To: user@ofbiz.apache.org; [EMAIL PROTECTED] > Subject: Re: The Return of...Inaccurate Calcul

Re: The Return of...Inaccurate Calculation of Order

2007-04-18 Thread David E. Jones
__ From: Scott Gray [mailto:[EMAIL PROTECTED] Sent: 18 April 2007 01:27 To: user@ofbiz.apache.org; [EMAIL PROTECTED] Subject: Re: The Return of...Inaccurate Calculation of Order Peter Change this line: salestax.calc.decimals = 10 and see if that gives you the results you are expecting.

RE: The Return of...Inaccurate Calculation of Order

2007-04-18 Thread peter
CTED] Subject: Re: The Return of...Inaccurate Calculation of Order Peter Change this line: salestax.calc.decimals = 10 and see if that gives you the results you are expecting. Regards Scott On 18/04/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hi, There is something very odd abo

Re: Doesn't calculate tax correctly...Inaccurate Calculation of Order Total

2007-04-18 Thread Scott Gray
uch a basic requirement. I must be overlooking something. Anyone, can you help. Thanks & Regards, Peter. - original message - Subject:Re: The Return of...Inaccurate Calculation of Order From: "BJ Freeman" <[EMAIL PROTECTED]> Date: 18/04/2007 02:19 i

Doesn't calculate tax correctly...Inaccurate Calculation of Order Total

2007-04-18 Thread peter
urely, Ofbiz must be able to calculate the tax (at 17.5%) correctly, it is such a basic requirement. I must be overlooking something. Anyone, can you help. Thanks & Regards, Peter. - original message - Subject:Re: The Return of...Inaccurate Calculation of Order From: "BJ Fr

Re: The Return of...Inaccurate Calculation of Order

2007-04-17 Thread BJ Freeman
ND_CEILING > will round to 1.2, but for -1.13, > > # ROUND_UP gives you -1.2 and ROUND_CEILING -1.1.) > > salestax.calc.decimals = 3 > > salestax.final.decimals = 2 > > salestax.rounding = ROUND_HALF_UP > > > > > > Thanks & Regards, > >

Re: The Return of...Inaccurate Calculation of Order

2007-04-17 Thread Scott Gray
ls = 2 salestax.rounding = ROUND_HALF_UP Thanks & Regards, Peter _ From: Tim Ruppert [mailto:[EMAIL PROTECTED] Sent: 16 April 2007 19:06 To: user@ofbiz.apache.org Cc: 'Chris Howe' Subject: Re: The Return of...Inaccurate Calculation of Order He means - kill th

RE: The Return of...Inaccurate Calculation of Order

2007-04-17 Thread peter
ent: 16 April 2007 19:06 To: user@ofbiz.apache.org Cc: 'Chris Howe' Subject: Re: The Return of...Inaccurate Calculation of Order He means - kill the process - and then restart it. Shut it down and start it up. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com

Re: The Return of...Inaccurate Calculation of Order

2007-04-16 Thread Tim Ruppert
anks & Regards, Peter ____________ From: Scott Gray [mailto: [EMAIL PROTECTED] Sent: 05 April 2007 01:16 To: user@ofbiz.apache.org; [EMAIL PROTECTED] Subject: Re: Inaccurate Calculation of Order Here is the configuration file, you can change the settings to wha

RE: The Return of...Inaccurate Calculation of Order

2007-04-16 Thread peter
D] Subject: Re: The Return of...Inaccurate Calculation of Order Hi Peter, You need to restart OFBiz, not just clear the cache. Hope that helps. --- [EMAIL PROTECTED] wrote: > Hi, > > > Sure hope you can help with this, I have been going around in > circles. > > I am

Re: The Return of...Inaccurate Calculation of Order

2007-04-16 Thread Chris Howe
orrect' for everyone. What > would > be your guidance as to what the file should be? > > Appreciate your fast responses this evening. It is 1:15am here in the > UK > just can't stay awake any more. > > > Thanks & Regards, > > Peter > > >

The Return of...Inaccurate Calculation of Order

2007-04-16 Thread peter
he UK just can't stay awake any more.     Thanks & Regards,   Peter       From: Scott Gray [mailto: [EMAIL PROTECTED] Sent: 05 April 2007 01:16 To: user@ofbiz.apache.org; [EMAIL PROTECTED] Subject: Re: Inaccurate Calculation of Order   Here is th

Re: Inaccurate Calculation of Order (arithmetic.properties > Rounding Parameter Options)

2007-04-12 Thread Scott Gray
iginal Message- From: news [mailto:[EMAIL PROTECTED] On Behalf Of David Shere Sent: 05 April 2007 14:45 To: [EMAIL PROTECTED] 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 roundin

RE: Inaccurate Calculation of Order (arithmetic.properties > Rounding Parameter Options)

2007-04-11 Thread peter
x.final.decimals = 2 salestax.rounding = ROUND_HALF_UP Thanks & Regards, Peter -Original Message- From: news [mailto:[EMAIL PROTECTED] On Behalf Of David Shere Sent: 05 April 2007 14:45 To: user@ofbiz.apache.org Subject: Re: Inaccurate Calculation of Order This assessment appears to con

Re: Inaccurate Calculation of Order

2007-04-05 Thread David Shere
l 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

Re: Inaccurate Calculation of Order

2007-04-05 Thread David Shere
7, 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.apach

Re: Inaccurate Calculation of Order

2007-04-04 Thread Walter Vaughan
[EMAIL PROTECTED] 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

Re: Inaccurate Calculation of Order

2007-04-04 Thread Scott Gray
ssage- 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...

RE: Inaccurate Calculation of Order

2007-04-04 Thread peter
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 digitstax 9 digits Product 1

RE: Inaccurate Calculation of Order

2007-04-04 Thread peter
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 to

Re: Inaccurate Calculation of Order

2007-04-04 Thread Chris Howe
avid, > > >> > > >> > > >> Thanks for responding. > > >> > > >> An excel spreadsheet that our account had verified. > > >> > > >> > > >> Thanks & Regards, > > >> > > >> Pe

Re: Inaccurate Calculation of Order

2007-04-04 Thread Scott Gray
r responding. >> >> An excel spreadsheet that our account had verified. >> >> >> Thanks & Regards, >> >> Peter >> >> >> -Original Message- >> From: David E. Jones [mailto:[EMAIL PROTECTED] >> Sent: 04 April 20

Re: Inaccurate Calculation of Order

2007-04-04 Thread Adrian Crum
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

RE: Inaccurate Calculation of Order

2007-04-04 Thread peter
: David E. Jones [mailto:[EMAIL PROTECTED] Sent: 04 April 2007 23:12 To: user@ofbiz.apache.org Subject: Re: Inaccurate Calculation of Order U 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

Re: Inaccurate Calculation of Order

2007-04-04 Thread David E. Jones
ubject: 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?

RE: Inaccurate Calculation of Order

2007-04-04 Thread peter
rate Calculation of Order Also what are the applicable tax rates being applied? Regards Scott On 05/04/07, David E. Jones <[EMAIL PROTECTED]> wrote: > > > What do you mean by "traditional means" here? > > -David > > > On Apr 4, 2007, at 5:15 PM, <[EMAIL

RE: Inaccurate Calculation of Order

2007-04-04 Thread peter
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 O

Re: Inaccurate Calculation of Order

2007-04-04 Thread Scott Gray
Also what are the applicable tax rates being applied? Regards Scott On 05/04/07, David E. Jones <[EMAIL PROTECTED]> wrote: 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 pr

Re: Inaccurate Calculation of Order

2007-04-04 Thread David E. Jones
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 Produ

Inaccurate Calculation of Order

2007-04-04 Thread peter
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