Accounts Payable Reports
The options on the Accounts Payable Reports menu enable you to use selection criteria for specifying the records to include in the reports. Some options also allow you to choose a report's sort order or format.
This following sections include a synopsis of the Account Payable Reports menu options and the standard procedure for generating reports.
Menu Path: Fund Accounting > Reports > Accounts Payable Reports > select an option
Menu Options
Cash Requirements Report | Use this option to verify that funds are available prior to issuing vendor checks. The report helps you determine whether to hold payments for a vendor or release a hold. For details, refer to Cash Requirements Report. |
Cash Requirements in Check Format | Use this option to generate a version of the Cash Requirements report showing the invoices and credit memos that will be combined when checks are issued. For details, refer to Cash Requirements in Check Format Report. |
Vendor Payment History | Use this option to generate a report listing payments that have been made to selected vendors. You can select records by batch number, year/period, transaction code/ date, check number/date, vendor, purchase order/encumbrance, and invoice/receipt. For details, refer to Vendor Payment History . |
Check Register | Use this option to generate a register that includes regular, manual, and user-voided checks. You can select records by the same criteria used to generate the Vendor Payment History. For details, refer to Check Register. |
Year-To-Date Discounts Report | Use this option to review the discounts taken and lost with the vendors selected. You can select records by year, vendor, fund, budget unit, and account. For details, refer to Year to Date Discounts Report. |
Use Tax Report | Use this option to review use tax on vendor invoices. You can select records by invoice, year/period, purchase order/encumbrance, check number/date, transaction date, batch number, and account information. For details , refer to Use Tax Report. |
Outstanding Checks Report | Use this option to generate a report identifying checks as either cleared or outstanding. You can select checks by number, status, and issue/cleared dates. Other criteria includes batch number, year/period, transaction code/date, vendor, purchase order/encumbrance, invoice/receipt, and account information. This report option also lets you view checks that were outstanding as of a specific system date, regardless of whether they are currently identified as cleared. For details, refer to Outstanding Checks Report. |
Check Register w/System Voids | Use this option to generate a check register that also includes checks voided by the system because of printer-related problems. For details, refer to Check Register with System Voids Report. |
Generating a report
- Select the desired option from the Accounts Payable Reports menu to display a report page.
All Accounts Payable Reports pages include a Report Criteria section for selecting the records to include in a report.- The Use Tax Report and Vendor Payment History Report pages also include an Advanced button for using additional fields in a search.
- The Cash Requirements Report, Accounts Payable Check Register, and Vendor Payment History Report pages provide options for changing the sort order of the reports they generate.
- The Outstanding Checks Report page provides options for selecting the type of report to generate. Additional report criteria fields appear based on your selection.
- In the Report Criteria section, enter selection criteria to specify the records you want to include.
- Click OK
In the Print page, select one of the following radio buttons:
File
Stores the report in a file for printing or viewing later. You can accept or replace the default file name for saving the report.
Screen
Displays the report on your monitor. If needed, you can print or save a report after viewing it.
Excel
Sends the report to excel. Based on your selection in the Data Option field of the print page, you can select to print all the information in the report, or omit totals.
- Click OK to generate the report.