>>>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.
>
>Our software is for payroll and insurance.
>
>If i have 1 cent discrepancy i need to write 2 pages report while the software give different results. And my client want answer and elimination of this error!

I'm thinking the problem may lay in the fact, that we're using Numeric 11,2 in the table. AFAIK if we would use currency field, we can get a better precision.

Basically, I'm using the exact same formula the original commissions were calculated with only difference that I want them broken down by categories.

I'm not sure what should I do. Use Numeric 11,2 instead of currency for my calculations as well?