>>
With all these items sorted I now have a discrepancy less than 50 cents for the whole report, which I think is acceptable.>>
>>Hi Naomi,
>>IMO is abnormal discrepancy # 00.00$. This is money and not
apples.
>>Sorry, this is IMO.
>
>50 cents for 10K do not make much of a difference. At least here in USA. If I would live in Baltic country (say, Russia or Bulgaria) may be I would need to be precise to a penny, if this is possible.
>
>But in fact I now have less than 2 cents discrepancy for a total report.
You should have zero. I've spent my five hours over this in 1990 (mFoxPlus then), and the crux of the matter is that you shouldn't apply any percentage, coefficient or whatever multiplication to any numbers added - only to each number in turn. If you want to calculate 1% out of 100 numbers, and 1% of their total, it's a safe bet you'll be a few cents off each time, because of the rounding.
Now on each of these numbers you have this commission calculated once - when the document was saved. Save this commission as well, and
never calculate it again. Just add the value as it is saved in the commission field, and you'll have zero discrepancy. No such field? Add it.
BTW, for Fox folks here, "memo" is a "memorandum on consignment" and has nothing to do with memo fields.