>>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.
If it's not broken, fix it until it is.
My Blog