Does anyone else have a problem with this? We have (for about 30 years) allowed users to use a decimal point when entering quantity.
In the dim dark past (was it under Prime or Ultimate? don't remember) we discovered that correlatives ignored anything after a decimal point, so wrote horrible correlatives multiplying the bit before the point by 10000, appending 0000 to the bit after, taking the first 4 chars of this and adding it, doing arithmetic then dividing result by 10000. In the slightly less dim dark past (before 1997, when we introduced our current change control system), we noticed that this problem had been fixed, and removed the complication from correlatives involving quantity. Now, many years and much development later, we extensively use dictionary output rather than programs for reports, forms (eg invoices) and queries. Inaccurate data is an unexpected result. On type S (or A) dictionaries, result of calculation in A or F correlatives is truncated to the decimal point (eg 3.99 x 3 = 11). Minor result is incorrect figures. Major result is under-reporting of totals which are not able to be reconciled to General Ledger (eg value of stock on hand). Rocket's response is that the manual says correlatives only do integer arithmetic. This is not quite true, as integer 3.99 x 3 would be 9. I-type dictionary items handle the data correctly (3.99 x 3 = 11.97). I-types have their own problems, in that fields after 10 are used for internal purposes, so are not able to carry extra information needed for data entry (such as data required, display only, validation rules, data change stamp, etc. I-types also are hard to work with as using a changed dictionary without compiling the dictionary logs the user out, and inadvertent attempt to display data in fields beyond F10 can lock user up, as well as untidily logging out. We are asking Rocket to consider this a bug. What do you think? TIA, Kate Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Phone: + 64 9 360 5310 Mobile: + 64 21 400 486 Email: k...@walstan.com _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users