Accounts Payable Outstanding Invoices by Vendor Report

The Accounts Payable Outstanding Invoices by Vendor 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 Outstanding Invoices by Vendor report is generated based on a user specified range of Vendors and a user specified range of dates. For each Vendor within the range, all Invoices that are dated within the specified range of dates will be included in the report.

Report information is organized by Vendor, and within each Vendor section, the details for each Invoice include: Invoice Number, Invoice Date, Discount Date, Due Date, Invoice Amount, Invoice Tax, Invoice Total, Amount Paid, Amount Owing, and the Last Paid Date.

Totals are provided per Vendor. Invoices carrying a zero balance will not be included in this report.

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). Only those Invoices associated with Vendors within this range will be included in the report.

Report By
From the list provided, the user must select the format of the report. Valid options include Invoice Date (i.e. the report will be generated by the Invoice Dates) and Due Date (i.e. the report will be generated by the date on which payment is due). The user also has the option to manually enter their Report By selection. If the user selects the Invoice Date option, they must continue to the Option 1 section of the screen. If the user selects the Due Date option, they must continue to the Option 2 section of the screen. This field defaults to the Invoice Date option.

Option 1
Invoice Date X to X
The user must manually enter the dates to define the range of Invoices included in the report. These fields default to the current system date. Only those Invoices dated within the specified range of dates will be included in the report.

Option 2
Due Date X to X
The user must manually enter the dates to define the range of Invoices included in the report. These fields default to the current system date. Only those Invoices with due dates within the specified range of dates will be included in the report.