Vendor Listing (APR750)

Using Reports

Use the Vendor Listing program to print out vendor information.

You have the option to:

Select the order to print - vendor, alpha or vendor class.
Select the beginning and ending order choice.
Select the code range to print - terms code, GL posting table, document group or no code range.
Select the beginning and ending code range to print.
Print either general or historical information.
Include address, phone and/or contact information.
Select whether to print active, inactive or all vendors.
Skip up to nine lines between vendors.

Report information includes the following: vendor number, name, alphabetical sort key, vendor class, terms codes, document group and GL posting table. Also indicated is whether the vendor is on hold, if it is a permanent or temporary vendor, customer number and tax exempt number. Historical information includes: vendor number, name, balance, date of last invoice, date of last payment, date account opened, date of highest balance, highest balance amount and whether the vendor is on hold.

You can also print the vendor address, phone number, and/or contact may also print on either report. The total number of vendors listed is also included.

FACTS Report Formatter and Multiple Output Options

This report has access to the FACTS Report Formatter and Multiple Output option. The Multiple Output option allows you to print to more than one output for each instance of a report. For example, a report can print to Excel, the viewer, and to a printer all in one print run. To access the multiple output feature simply choose the Multiple option from the Print Options screen. The FACTS Report Formatter allows you to expand your reporting capabilities beyond defining a printer (in Printer F/M). To access the FACTS Report Formatter, select Custom Report Layout--> Customize Report from the menu bar.

Access this program by choosing Accounts Payable-->Reports & Prints-->Vendor Listing.

Use the following fields to print the Vendor Listing:

1. Order

Select the order in which to print the report. Options are vendor, alpha or vendor class.

2. Beginning order choice

Select the beginning order choice to print. Press F1 or $image\ex_allft_shg.gif$ to default to FIRST. Press F2 or $image\find_shg.gif$ to search for vendors and vendor classes.

3. Ending order choice

Select the ending order choice to print. Press F1 or $image\ex_allrt_shg.gif$ to default to LAST. Press F2 or $image\find_shg.gif$ to search for vendors and vendor classes.

4. Code range

The list may be printed for a specific range of terms codes, GL posting tables or document groups. Only vendors with the chosen codes will print. Enter Terms code, GL posting table, or Document group to determine which codes will print. If no code range is desired, press Enter (CR) to skip this and the Beginning/Ending code range fields.

5. Beginning code range

If a code was chosen in the Code range field, enter the beginning code range to print. For example, if terms code was chosen above, enter the beginning terms code to print. Press F1 or $image\ex_allft_shg.gif$ to default to FIRST. Press F2 or $image\find_shg.gif$ to search.

6. Ending code range

If a code was chosen in the Code range field, enter the ending code range to print. For example, if terms code was chosen above, enter the ending terms code to print. Press F1 or $image\ex_allrt_shg.gif$ to default to LAST. Press F2 or $image\find_shg.gif$ to search.

7. Info (general or history)

Enter General or Historical to indicate the type of information to print. The program defaults to G.

8. Include (information to include)

Enter any combination of A-vendor address, P-phone number and/or C-contact to print on the report. Press F1 or $image\none_shg.gif$ to default to NONE. Press F3 or $image\all_shg.gif$ to default to ALL.

9. Status

Enter whether to print Active, Inactive, or press Enter (CR) for all vendors. The program defaults to ALL.

Vendor Listing (APR750)

Using Reports

Use the following fields to print the Vendor Listing:

See Also