5 Replies Latest reply on Jun 21, 2017 1:37 AM by PeterEvans

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

    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