AR wants the customer statement report to Group By Invoice Suffix at the bottom as in:
Suffix Current 30 60 90 120 150 Balance Due
IN 100 50 0 (Note there is no suffix for Invoices)
CM 50 0 0 Credit Memo
DN 10 0 0 Debit Note
UR 0 0 0 Unapplied Receipt
The values above would be totals for the Customer for each of the suffixes.
I have spent a lot of time with this to no avail. Has anybody done this, or can you suggest what method to use.
Kind ragards,
Randy Weber
Suffix Current 30 60 90 120 150 Balance Due
IN 100 50 0 (Note there is no suffix for Invoices)
CM 50 0 0 Credit Memo
DN 10 0 0 Debit Note
UR 0 0 0 Unapplied Receipt
The values above would be totals for the Customer for each of the suffixes.
I have spent a lot of time with this to no avail. Has anybody done this, or can you suggest what method to use.
Kind ragards,
Randy Weber