In short, problem can be described as it is caused by? the fact that on certain condition represented by combination of large number of invoices and over 9 digits totals Universe engine creates a small fractional addition to total number. Has anyone heard of this? G
-----Original Message----- From: Rex Gozar <[email protected]> To: [email protected] Sent: Thu, 7 May 2009 5:49 pm Subject: Re: [U2] Any limitation in UniVerse decimal places (This response assumes that your upstream UniVerse billing application is totalling decimal amounts.)? ? I don't know of specific limitations concerning decimal places, but I do know that precision differences in floating point math cause unexpected behavior.? ? If you're trying to total dollar amounts in a program, it's a "best practice" to ICONV them into integers before any math operations -- this eliminates all floating point problems.? ? AFAIK the query language RETRIEVE (i.e. LIST, SORT) performs math operations on the data as-stored in the record, then applies the OCONV before displaying the total (also avoiding floating point problems).? ? rex? ? apogee79 wrote:? > I shall explain the problem that I am encountering in the best detailed way? > that I can. I am working on a billing application (running on UniVerse),? > which sends details to a downstream application for invoicing. If several? > invoice groups are sent in one shot, where the total is approximately more? > that $20 million, an error occurs, due to rounding off. But when those? > invoice groups are sent one at a time, this condition does not occur. Is? > there any upper limit that is set in the configuration parameters? Can? > anyone please throw some light on this?? > > G? -------? u2-users mailing list? [email protected]? To unsubscribe please visit http://listserver.u2ug.org/? ________________________________________________________________________ You are invited to Get a Free AOL Email ID. - http://webmail.aol.in ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
