The Creditor Activity Report provides a statement of Purchase transaction history (invoices, credits and payments) with a running balance within a given date range. This report is useful for viewing updates of your money owing to particular creditors.
Accessing The Creditor Activity Report
- Accounting Reports.
- Creditor Activity Report.
- To generate the report you will need to fill in the following information:
- The dates that you want to run the report
- From & ToEnter the name of the creditor.
- Select a matter number if you would like to limit the report to a matter (this is optional).
Click the Generate Report button.
You will be able to print or download a copy of the report as an Excel or PDF file.
Understanding the Creditor Activity Report
Header and Output Information
|From||The first date on which to report.|
|To||The last date on which to report. Creates a span from the From date to the To date.|
|Creditor||The vendor or supplier of the invoice.|
|Expand/contract display button||This button controls the on-screen display of the report. |
When the arrows face out and the button is clicked, the report will span the width of the window.
When the arrows face in and the button is clicked, the report will display with space on both sides of the screen.
Expanding the display can be useful for longer text values in some table rows to avoid them spilling over to the next line.
|Show settings button||Displays the configuration options for the report. Once displayed, the configuration options can be hidden by selecting the Hide settings button.|
|Reload||This button will re-generate the report. This can be useful if changes are being made while viewing the report to see difference between before and after the changes.|
|Generated Stamp||Displays the name of the user who generated the report, as well as the date and time the report was generated.|
|This will launch your browser's print dialog. The behavior and display of the dialog is dependent upon your browser and workstation settings.|
|Excel||Downloads the report in xlsx format|
|Downloads the report in PDF format|
|Opening Balance (row)||Balance owed as of the From date|
|TX Date||The date of the General Ledger transaction for the row item|
|TX ID||The ID of the General Ledger transaction for the row. The ID is hyperlinked to the GL Transaction Details report for the selected transaction. This report provides further details on the transaction.|
|Journal Memo||For rows describing a Supplier Invoice, this displays the "Supplier Invoice" followed by the invoice number and ID (sequence number). |
For payments, this displays "Withdrawal" followed by the withdrawal ID and the text entered in the withdrawal Journal Memo field.
Withdrawal Journal Memo field:
|Their Reference||Unique identifier sent from the supplier.|
|Invoice||The total amount of the invoice.|
|Payment||The amount paid on the invoice.|
|Balance||The amount which can be paid on Supplier/Vendor invoices.|
|Closing Balance (row)||Running total from the opening balance plus the invoice amount, minus the payment amount.|