Transaction Listing Report
This report prints and summarise customer 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 customer, this header information displays:
- Customer code
- Customer name
- Branch
- Calendar
Transactions for each customer display and these details display:
- Transaction date
- Transaction type (for example, invoice, receipt, 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.
Customer Name
Enter the range of customer names in the From and To fields. If you want to run a report for a single customer, you only need to enter the name in the From field.
To include all of your customers in the report, enter zzz in the To field.
Customer Code
Enter the range of unique alphanumeric codes that represent customers in the From and To fields. If you want to include a single customer in the report, you only need to enter the code in the From field.
To include all customer codes in the report, enter zzz in the To field.
Branch Code
Enter the range of unique alphanumeric codes that represent the branches that customers 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 of the customers 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 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.
Sales Person
Enter the range of salespeople involved with customers in the From and To fields. If you want to include one salesperson in the report, you only need to enter the name in the From field.
To include all salespeople in the report, enter zzz in the To field.