Audit Trail Report

This report prints an audit trail for the supplier. This provides you with transaction detail that assists with month-end reconciliations when you are reconciling the aged balances to the general ledger.

Header Details

Report process date and time
Page number
Date range selected

Line Details

This information displays, grouped by transaction type (Invoices, Credit Notes, Payments, Journals):

Transaction Reference
Batch
Branch
Supplier name
Transaction value, inclusive of tax
Tax value
Tax rate
Foreign currency value (if in use)
Foreign currency rate (if in use)

If you only want to display transactions of a particular type, specify this in the parameters before running the report.

The report displays sub-totals by Individual Supplier, Transaction Type, and All Suppliers. A grand report total displays, and summary totals by Currency, if the Foreign Currency module is in use.

Currency summaries display separately at the end of the report, as per:

Opening Balance (relating to the Date From selected in the Parameters)
Current Balance
+ Invoice total
Credit Note total
Manual Payment total
Automatic Payment total
+ Journal total
+ Cancelled Cheque total
Closing Balance

Parameters

You can set these parameters for the report:

Branch Code From

Enter the code for the first branch in the range of branches to include in the report.

Branch Code To

Enter the code for the last branch in the range of branches to include in the report. To report on a single branch, leave this field empty.

Leaving the Branch Code From field empty and entering zzzzzz in this field includes all branches in the report.

Date From

Select the first date in the range that the report covers. The date defaults to the date of the earliest transaction in the system.

Date To

Select the last date in the range that the report covers. The date defaults to the current date.

Print Credit Notes

Select this option to include credit notes in the report.

Print Invoices

Select this option to include a list of invoices and their values in the report.

Print Manual Payments

Select this option to include manual payments in the report.

Print Automatic Payments

Select this option to include automatic payments in the report.

Print Journals

Select this option to include journals in the report.

Print Summary

Select this option to include a summary of transactions, broken down by currency, in the report.

Calendar From

Enter the name of the first working calendar in the range of calendars to include in the report.

Calendar To

Enter the name of the last working calendar in the range of calendars to include in the report. To report on a single working calendar, enter a name in the Calendar From field and leave this field empty.

Leaving the Calendar From field empty and entering zzzzzzzzzzzzzzzzzzzzzz in this field includes all working calendars in the report.