Individual Invoice Report with Amount Paid & Outstanding

SUGGESTED
Hello I am trying to find a report which details for an individual sales invoice the amount it was raised for, the amount paid, and the amount outstanding? Is this something that is available, or do I need to use the Customer Invoices Overdue report to get these details? Many Thanks
  • 0
    SUGGESTED

    Hi Paddy,

    There are no reports to show this for an individual invoice, but the overdue report would show you the figures you.

    If you like you can edit this report and remove the filter so that it would show all outstanding transactions and not just overdue ones?

    To do this, please right-click the report > Edit.  In Report Designer select Report > Filters and remove all the text up to and including the first AND option, leaving the filter to look like this;

    AUDIT_HEADER.TYPE LIKE "SI" AND AUDIT_HEADER.AGED_BALANCE > 0.00

    Click OK > File > Save As > Save the layout with your own name.  Now you can run the new report via Customers > Reports > My Customer Reports.

    I hope this helps.