Using Reports

Most Accounts Payable reports have the option of printing in vendor number, alphabetical or vendor class order. In addition to the order in which you print information, you can print information in ranges. For example, if the order selected is vendor number, field of the beginning/ending vendor is required.

• The Cash Requirements Report prints up to six time periods of cash requirements for invoice payment. The periods of time are determined by the user as well as whether the documents are to print based on due date or discount date. The report may be printed in summary (total amount due to each vendor within the specified time periods) or detail (information on each document due to each vendor within the specified time periods).
  
• The Open Payables Report prints a list of open payables, zero balance documents or both. The options are to print in summary (vendors and their balances), detail (vendors and information on each document due) or detail with transactions (vendors, and all transactions against each document).
  
• The Aged Payables Report prints a report of open payables in aging columns as of a specified aging date. The user may also specify how many days past due an invoice must be before appearing on the report and whether to include contact information and purchase information. The report may be printed in summary (vendor and balance) or detail (vendor and information on each invoice due to the vendor).
  
• The Inactive Vendor Listing prints a list of all vendors who have been inactive as of a specified cutoff. Purchase history figures may be included in the report. This report will not update any files but may be useful in allowing the user to delete inactive vendors.
  
• The Vendor Listing prints a report of either general or historical information on vendors. The vendor’s address, phone number, and/or contact may print on either report.
  
• The Vendor Ledgercards Report prints a list of the transaction types chosen that have affected the vendor’s balance Vendor Ledgercards (APR755)
  
• The Vendor Label Print program prints up to 99 labels per vendor and may be sorted by zip code.
  
• The Rolodex Vendor Card Print program prints up to 99 rolodex cards per vendor and may be sorted alphabetically.
  
• The Purchase History Report prints various purchase history information from the vendor’s history. The user may select month-to-date, year-to-date or prior year information and determine the minimum purchases to print. The user has the option to select specific document groups to print.
  
• The Payment History Report prints total payments made to vendors for up to 6 periods.
  
• The Vendor Balancing Register is run only when the vendor’s balance does not agree with the invoices for that vendor (i.e., very unlikely - if there is a power failure in the middle of an update, etc.). The register prints all out-of-balance vendors. The optional update will correct each vendor balance and the total AP balance.
  
• The AP Code List prints a listing of the various AP codes: vendor classes, terms codes and GL posting tables.