I want to sort the report by Date Paid, showing each invoice number, customer name, payment method and amount paid. I also want to show totals for the accounting categories under each invoice. I currently have each payment per accounting code stored in a table.
I have a report using the Amount Paid as a summary field against each invoice but how do I summarise the account codes under the Invoice to prevent duplication?
Thanks a lot for anyone who can work this one out