Field size limitation in query???

Lawson KB indicates that queries with decimal places beyond two digits are truncated, but this doesn't explain the issue we have found.

Excel can handle that size just barely I think. I am not aware of a Addins limition in this respect. I assume you double checked the cell format to make sure it specifies two decimal places.

In my copy of Excell, I could enter a value of approximately 3 trillion, with two decimal places. But when I enterd $53 trillion I lost the last digit, that is it was rounded off to the nearest dime.

That is, 3123456789123.67 was ok, but 53123456789123.67 was rounded, to 53123456789123.6

The Excel help specifies that the product should be able to handle a total of 15 digits of precision which seems to match my test.

Thanks, Ben.  Yes, the 15 digit precision limitation of Excel caught us. 

Please note that Crystal Reports has a similar limitation (or at least the version that we are on). 

We wouldn't have encountered this except a miskeyed entry mega-inflated the total debits and then the correction the total credits.  The ending balance is a manageable length.