>>>Out of 10K. E.g I have total commissions paid 9,819.20 and sum by categories gives me 9,824.07
>>
>>Naomi, is this summing in a report or in a prog/method? Each commission field that you're adding up - is there a constraint on the number of dec. places, so rounding is implicitly happening there (See I don't know how many comm's you're adding). Hence, would making each comm. field with more dp help, then the result is rounded to 2 dp just at the end.
>
>There are 52 detail line records in the report with 3 records of discrepancy > 0.5
>
>I added checking of total commissions into the program too, and I have the same result as in reports (e.g. $5 discrepancy)
>
>I'm currently investigating the matter. For one particular invoice the commission doesn't make any sense. Also for that invoice Grand Total = Credit Total, so I'm not sure if it should be included into calculations at all. I have to verify this question with the manager.


Ok, getting closer. I found one wrong case, which I now eliminated (this invoice was paid to a different salesman, so I adjusted my program's logic). Now I have just two wrong cases to investigate...