- Contents
- Index
- Search
Display results with all search words
Supplier Balances Report
This report prints supplier aged balances, including transaction detail. You can determine the output and format of the report by selecting various options before the report runs.
Header Details
- Report process date and time
- Page number
Line Details
- Supplier code
- Supplier name
- Currency
- Total amount due
- Current period value
- Overdue 1 period value
- Overdue 2 period value
- Overdue 3 period value
- Overdue 4 period value
- Hold value
- Future value
- Branch
If you select the Print Transaction Details option, this detail also display for each transaction:
- Transaction date
- Transaction type (for example, invoice, payment, credit note, journal)
- Transaction reference
- Transaction amount
- Currency
The report displays sub-totals depending on the Group by option that you select. A grand total value also displays.
Parameters
You can set these parameters for the report:
Supplier Name
Enter the range of supplier names in the From and To fields. To run a report for a single supplier, enter the name in the From field.
To include all of your suppliers in the report, enter zzz in the To field.
Supplier Code
Enter the range of unique alphanumeric codes that represent suppliers in the From and To fields. To include a single supplier in the report, enter the code in the From field.
To include all supplier codes in the report, enter zzz in the To field.
Branch Code
Enter the range of unique alphanumeric codes that represent the branches suppliers belong to in the From and To fields. To include a single branch in the report, enter the code in the From field.
To include all branches in the report, enter zzz in the To field.
Currency Code
Enter the range of currency codes associated with the suppliers in the From and To fields. To include a single currency code in the report, enter the code in the From field.
To include all currency codes in the report, enter zzz in the To field.
Calendar Name
Enter the range of working calendars that summarise AP transactions by period in the From and To fields. To include one working calendar in the report, enter the name in the From field.
To include all working calendars in the report, enter zzz in the To field.