Transaction Listing Report

This report prints and summarises supplier transactions. 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
Period date range selected (see Parameters below)

Line Details

For each supplier, this header information displays:

Supplier code
Supplier name
Branch
Calendar

Transactions for each supplier display and these details display:

Transaction date
Transaction type (for example, invoice, payment, credit note, journal)
Transaction reference
Batch number
Gross value
Discount value
Net value
Hold value
Total value
Outstanding value

The report displays sub-totals (Group Summary totals) and a grand total (Listing Summary) depending on the Group by option and the Print Group Summary and Print Listing Summary options.

Parameters

These parameters are available when you run the report:

Period Date

Enter the date range for the transactions that you want to report on in the From and To fields.

Supplier Name

Enter the range of supplier names in the From and To fields. If you want to run a report for a single supplier, you only need to 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. If you want to include a single supplier in the report, you only need to 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. If you want to include a single branch in the report, you only need to 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. If you want to include a single currency code in the report, you only need to 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. If you want to include one working calendar in the report, you only need to enter the name in the From field.

To include all working calendars in the report, enter zzz in the To field.