Overview
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.
Note: This report is run by suppliers/vendors (creditor). For more information on Supplier/Vendor Invoices in Actionstep see Vendor invoices / Supplier invoices. |
Accessing the Creditor Activity Report
The Creditor Activity Report is located at Reports > Accounting Reports in the Purchases category.
Report Configuration Options
Producing the Creditor Activity Report
First, you will want to generate the report to see it displayed on the screen. Once you do that, you will be able to print or download a copy of it as an Excel or PDF file.
Generate report (on-screen) |
Below the configuration options is a Generate report button. This button will generate and display the report on the current screen. It will also display further output options. |
|
The Print button will launch your browsers print dialog. This will adhere to your browser and workstation settings to print the report. |
EXCEL |
The EXCEL button will download the report in xls format. |
|
The PDF button will download the report in PDF format. |
Understanding the Output of 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 |
Creditor Table
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. |