Printing Standard Vendor Reports

Printing the Vendor Master Listing (Standard)

There are no default limits for the Vendor Master Listing. If you do not set limits, every record in the vendor database is included.

Note: You must use wide paper or set your printer for compressed print (17 characters per inch) to print this report. To set your printer for compressed print, change the print setting manually. Refer to your printer manual for instructions.

1. In the Report Type field of the (PR) Vendor Reports screen, type R.

2. The cursor moves to the Nbr From field. Use the From and To fields to define the vendor information to include on the report.
   
   To include information for all your vendors, press Enter. Go to Step 3.
   
   To specify a range, enter the beginning of the range to include on the report in the From field. If you do not completely fill the field, press Tab. Enter the end of the range to include on the report in the corresponding To field. If you do not completely fill the field, press Tab.
   
   Set as many limits as you need. A record must meet all limits, however, to be included on the report.

3. Use the Nbr From and To fields to limit the report to a range of vendor numbers. Vendor numbers are set in the Vendor # box in the Vendor Master tab.

4. Use the Name From and To fields to limit by vendor name. Vendor name is set in the Name box in the Vendor Master tab.

Note: You cannot limit by both vendor number and vendor name.

• Use the Terms From and To fields to limit by vendor payment term codes.

• Use the Code From and To fields to limit by vendor code. Vendor codes are used to group similar vendors. They are also used to exclude vendors from certain applications. Vendor codes are set in the Code box in the Vendor Master tab.

• To limit the report to vendors with discounts, type Y in the With Discounts field. To omit vendors with discounts, type N. Vendor discounts are set in the Discount % box in the Vendor Master tab.

• To limit the report to vendors with auto pay, type Y in the With Auto Pay field. To omit auto pay vendors, type N. Auto pay is set in the Vendor Account Status tab.

• The Dates O/P field and the From and To fields work together. Use the Dates O/P field to specify whether you want to limit by order date or payment date. The last order and last payment dates are set in the Vendor Account Status tab. To limit the report using the last order date, type O. To limit using the last payment date, type P. Use the From and To fields to specify the beginning and ending dates.

• Use the Outstanding Balance From $ and To $ fields to limit the report by outstanding balance. The outstanding balance appears in the Balance box in the Vendor Account Status tab.

• Use the Month To Date Paid From $ and To $ fields to limit the report to a range of month-to-date paid balances. This figure appears in the MTD Total box in the Vendor Account Status tab.

• Use the Year To Date Paid From $ and To $ fields to limit the report to a range of year-to-date paid balances. This figure appears in the YTD Total box in the Vendor Account Status tab.

• Use the Last Year Paid From $ and To $ fields to limit the report to a range of balances paid last year. This figure appears in the Last Year Total box in the Vendor Account Status tab.

3. Use the Printer field to specify the logical name of the printer to use.

4. Use the Copies field to specify the number of copies to print.

5. Use the Totals Only field to omit report detail and print only the totals and subtotals for each vendor.
   
   Type Y to include only the following totals and subtotals:

6. Total number of records

7. Total balance

8. Month-to-date total

9. Year-to-date total

10. Last year's total.

See also:

In the Vendor Master Tab

In the Vendor Account Status Tab

Printing the Vendor Master Listing (Custom)