If you reread my posting, you will see that I had to revert the system BECAUSE OF the correct calculations in 6.5++ which changed many A/R and A/P totals so that long gone transactions re-appeared as if by magic. When a computed column creates a value that is used as a payment value, or is paid by a customer, the rounding error caused innumerable problems with the system.
Tony Luck <[EMAIL PROTECTED]> wrote: > >I believe that this area was discussed a long time back and fixed. So why >compare older results, move up to the later release. >At 10:49 AM 8/20/2003 +0300, you wrote: >>Albert, >> >>the full result of (23850 * 0.4261) is 10162.485 >> >>so I think that 6.5++ is right and 6.1A is wrong. >> >>Polychronis Kontos >>Athens, Greece >> >>-----Original Message----- >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Albert Berry >>Sent: Tuesday, August 19, 2003 5:35 PM >>To: RBASE-L Mailing List >>Subject: [RBASE-L] - Currency rounding difference 6.1A vs 6.5++ >> >> >>We have run across an interesting anomaly between 6.1A and 6.5++. This has >>the unfortunate effect of creating a balance due of $0.01 on a large number >>of transactions, because of a computed column that updates $0.01 higher on >>reload. We have not done enough testing to ensure that BRND would resolve >>the differences in their entirety. We are reverting the system to 6.1A until >>we can figure out how to accommodate this calculation. >> >>6.1A >>R>SET VAR vCurr CURRENCY = (23850*0.4261) >>R>SHO VAR vCurr >>R> � � � � 10,162.48 >> >>6.5++ >>R>SET VAR vCurr CURRENCY = (23850*0.4261) >>R>SHO VAR vCurr >>R> � � � � 10,162.49 >> >>(BRND(23850*0.4261,10,.01)) = 10,162.48 >> >>-- >>Albert Berry >>Full Time Consultant to >>PSD Solutions >>350 West Hubbard, Suite 210 >>Chicago, IL 60610 >>312-828-9253 Ext. 32 >> >> >>__________________________________________________________________ >>McAfee VirusScan Online from the Netscape Network. >>Comprehensive protection for your entire computer. Get your free trial >>today! >>http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 >> >>Get AOL Instant Messenger 5.1 free of charge. �Download Now! >>http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 > >Tony Luck >Brisbane Australia � > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
