I am creating a monthly sales commission report from Sales Analysis. The report is based on paid transactions. I run the Set Invoice Paid Indicator.

I want to include all transactions that were paid for the month. So far so good, filtering on the Date Paid field. The problem is when an invoice is partially credited, the credit appears in the current month, whereas the invoice won't appear until a later month (when the customer pays the balance).

Is there any way I can get around this timing problem?

Thanks

Steve