Outstanding Invoice Report
This report outputs a list of supplier invoices that are currently outstanding for payment.
Header Details
- Report process date and time
- End date specified in the Parameters
- Page number
Line Details
These details display for outstanding transactions (where some or all of the original amount is unpaid) for each supplier:
- Supplier name
- Branch
- Calendar
- Transaction date
- Transaction type (for example invoice, credit note, payment, journal)
- Batch
- Applied total
- Invoice due date
- Original transaction total
- Outstanding transaction total - foreign currency if in use
- Outstanding transaction total - local currency
The report summarises information and display sub-totals using the Profile selected in the report parameters. Options include:
- Supplier code
- Supplier name
- Branch/Supplier code
- Branch/Supplier name
- Currency/Supplier code
- Currency/Supplier name
- Calendar/Supplier code
- Calendar/Supplier name
A Grand Total is printed for all outstanding transactions.
Parameters
These parameters are available when you run the report:
End Date
Enter the last date for which you want to generate the report. Greentree includes all outstanding invoices in the system until that date in the report.
From Supplier Name
Enter the name of the first supplier in the range of supplier that you want to include in the report.
To Supplier Name
Enter the name of the last supplier in the range of suppliers you want to include in the report. If you want to report on a single supplier, leave this field blank.
Leaving the From Supplier Name field empty and entering zzzzzz in this field will include all suppliers in the report.
From Supplier Code
Enter the code for the first supplier in the range of supplier that you want to include in the report.
To Supplier Code
Enter the code for the last supplier in the range of suppliers you want to include in the report. If you want to report on a single supplier, leave this field blank.
Leaving the From Supplier Code field empty and entering zzzzzz in this field will include all suppliers in the report.
From Branch
Enter the code for the first branch in the range of branches that you want to include in the report.
To Branch
Enter the code for the last branch in the range of branches you want to include in the report. If you want to report on a single branch, enter a code in the From Branch field and leave this field blank.
Leaving the Branch Code From field empty and entering zzzzzz in this field will include all branches in the report.
From Currency
Enter the first code in the range of currency code that you want to include in the report.
To Currency
Enter the last code in the range of currency code that you want to include in the report. Leave this field empty to include only currency in the report.
Leaving the From Currency field empty and entering zzz in this field includes all currencies in the report.
From Calendar
Enter the name of the first working calendar in the range of calendars that you want to include in the report.
To Calendar
Enter the name of the last working calendar in the range of calendars that you want include in the report. If you want to report on a single working calendar, leave this field blank.
Leaving the Calendar From field empty and entering zzzzzzzzzzzzzzzzzzzzzz in this field includes all working calendars in the report.