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, the beginning/ending vendor numbers are required.

These programs are displays on the Reports and Prints menu.

• Cash Requirements Report which is used to print up to six time periods of cash requirements for invoice payment. You can determine the periods of time as well as whether the documents are to print based on due date or discount date. The report can 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).
  
• Open Payables Report, which is used to print 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).
  
• Aged Payables Report, which is used to print a report of open payables in aging columns as of a specified aging date. You can also specify how many days past due an invoice must be before it is displayed 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).
  
• Inactive Vendor Listing which is used to print 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 you to delete inactive vendors.
  
• Vendor Listing, which is used to print a report of either general or historical information on vendors. The vendor’s address, phone number, and/or contact may print on either report.
  
• Vendor Ledgercards Report which is used to print a list of the transaction types chosen that have affected the vendor’s balance Vendor Ledgercards (APR755)
  
• Vendor Label Print, which is used to print up to 99 labels per vendor and may be sorted by zip code.
  
• Rolodex Vendor Card Print, which is used to print up to 99 Rolodex cards per vendor and may be sorted alphabetically.
  
• Purchase History Report, which is used to print various purchase history information from the vendor’s history. You can select month-to-date, year-to-date or prior year information and determine the minimum purchases to print. You have the option to select specific document groups to print.
  
• Payment History Report, which is used to print total payments made to vendors for up to 6 periods.
  
• Vendor Balancing Register which 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.
  
• AP Code List, which is used to print a listing of the various AP codes: vendor classes, terms codes and GL posting tables.
  

Open topic with navigation