AnsweredAssumed Answered

I have an income report with summary fields, but I want more...

Question asked by PeterEvans on Jun 16, 2017
Latest reply on Jun 21, 2017 by PeterEvans

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

Attachments

Outcomes