Accounts Payable Aging by Vendor Report

The Accounts Payable Aging 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 Aging by Vendor Report is generated based on either a user specified Transaction Date or a user specified Accounting Month and Year. When generated by Transaction Date, the reporting pockets are based on a default number of days, or on a user specified number of days; when generated by Accounting Month, the reporting pockets are one per month, beginning with the user specified Accounting Month. The user must also specify the range of Vendors for which the report will be produced.

For either formatting option (i.e. Transaction Date or Accounting Month), the report information is organized by Vendor. Report details include general Vendor information (i.e. Vendor Number, Vendor Name, etc), and the amount owing for each reporting pocket.

Vendors carrying a zero Accounts Payable balance will not be included in this report. When generated by Accounting Month, the report will balance to the associated General Ledger Accounts.

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).

Report By
From the list provided, the user must select the format of the report. Valid options include Date (i.e. the report will be generated by Transaction Date) and Month (i.e. the report will be generated by Accounting Month). The user also has the option to manually enter their Report By selection. If the user selects the Date option, they must continue to the Date Option section of the screen. If the user selects the Month option, they must continue to the Month Option section of the screen. This field defaults to the Date option.

Date Option
Date
If the user chooses to produce the report by Transaction Date, they must manually enter the Transaction Date in the Date field (i.e. all transactions up to and including the specified date will be included in the report). This field defaults to the current system date.

Aged By
From the list provided, the user must select the date from which Invoices included in the report are aged. Valid options include Invoice Date (i.e. an Invoice aged by 30 days is one that is 30 days beyond the Invoice Date) and Due Date (i.e. an Invoice aged by 30 days is one that is 30 days beyond the Due Date). This field defaults to the Invoice Date option.

Reporting Pockets
By default, reporting pockets are thirty days in length. To change the length of the reporting pockets, the user must manually enter the number of days.

Month Option
Accounting Month, Accounting Year
If the user chooses to produce the report by Accounting Month, they must manually enter Accounting Month and Year for which the report will be produced. With this option the reporting pockets are one per month, starting with the specified Accounting Month. These fields default to the current Accounting Month and Year.