Accounts Payable History Report

Return to the Reports & Audit Journals Menu

The Accounts Payable History Report screen is divided into two sections; System Parameters and User Parameters. In the System Parameters section, the user must specify details for the format of the report; in the User Parameters section, the user must specify details pertaining to the content of the report. For general information on running reports and on defining System Parameters, please refer to the Running Reports help document.
Report Description

The Accounts Payable History Report is generated for a user specified range of Vendors, and range of Invoice Dates. The report displays past AP information for each Vendor within the selected range. Individual Invoice details include the following: Invoice Number, Invoice Date, Discount Date, Due Date, Last Paid Date, Invoice Status, Invoice Amount, Invoice Tax, Total Invoice Amount, Amount Outstanding, and Amount Paid. Invoice records are grouped by Vendor Number and Name, then by GL Account and Bank Account. Within each grouping, Invoices are sorted by Invoice Date. Totals are presented per Vendor (i.e. Original Invoice Total, Reversed Invoice Total, and Net Invoice Total) and for the report as a whole (i.e. Original Invoice Grand Total, Reversed Invoice Grand Total, and Net Invoice Grand Total).

 

User Parameters

User Parameters

Start Vendor, End Vendor
From the lists provided, the user must select the Start and End Vendors to define the range of Vendors included in the report. The user also has the option to manually enter the unique identifiers of the Vendors. These fields default to the first and last Vendor in the lists (i.e. by default, all Vendors will be included in the report).

Start Invoice Date, End Invoice Date
The user must manually enter the Start and End Invoice Dates to define the range of Invoices included in the report (i.e. if an invoice has a date that falls within this range, it will be included in the report). These fields both default to the current system date.

Sort By
From the list provided, the user must select the way in which the report information will be sorted. Valid options are by Vendor Number (i.e. Numerically) or by Vendor Name (i.e. Alphabetically). This field defaults to the Vendor Number option.

  

View Reports

Click to view a sample Accounts Payable History Report
Note:
To return to this screen after viewing the sample report, simply click the "Back" button in your browser.

Return to the Reports & Audit Journals Menu