Vendor List Tab

AP: Vendor List Tab

Make the following menu selections to display this tab:

eFinancials—Reports—AP Reports—Vendor List or
ePO—Reports—Vendor List

Use this tab to print a list of Vendors from Vendor Setup.

You can run the report for a range of Vendor IDs and can display the vendors by group, if desired.
You can select to show only Direct Deposit vendors.
The information appearing on these reports is from the tabs in Vendors Setup.
Two versions of the report are available: Summary and Detail. The Detail report requires a permission (refer to Effect of Permissions section below).
A list of the report parameters that you select appears at the end of each report.

The Summary and Detail reports show information maintained in the system vendors. Note that what appears in your report is based on the options you select.

Summary Report Fields

Report name

Vendor List By Summary

Header across columns

Vendor ID, Short Name, Expense Code, Approval Status (Y/N), Priority, Hold Code, Closed status (Y/N), 1099 Category (Y/N)

Detail Report Fields

Report name

Vendor List By Detail

Header across columns

Vendor ID, Short Name, Expense Code, Approval Status, Priority, Main Address including vendor name, contact, phone number and email address, Mail Address including vendor name, contact, phone number and email address

From the Setup Vendors General tab

Hold Code, Allocation, Category, Approved By, Invoice Type, Location, Priority, Vendor Type

Customer ID, Closed (Y/N), PO Required (Y/N), Address on Invoice Required (Y/N), Separate Check/Invoice (Y/N), Create Lien Waiver (Y/N), Outstanding Lien Waiver

Discount %, Discount Days, Net Days, Credit Limit, Retainage %

From the 1099 tab

Business Type, Tax ID, Tax Type, Tax Name, 1099 Category (Y/N), W9 (Y/N), 1099 Address including vendor name, contact, phone number, and email, Contact name including phone, fax, email

From the Required Documents tab

Type, Required (Y/N), Carrier, Policy/Document #, Effective Date, Expiration Date

From the Direct Deposit tab

Active, (Y/N), Bank Name, Routing #, Account #, account Type, Amount Type, Amount Value, Email

To Print the Report

From the eFinancials menu, select Reports—AP Reports—Vendor List. Or, from the ePO menu, select Reports—Vendor List.
From the From Vendor # and Thru Vendor # fields, click the Lookup icon to display the Select Vendor Tab and select a vendor ID range for the report.
From the Changed since field, type a starting date for changes. Or use the Calendar icon to select a date.
If the Type of Report drop-down list is available, you can select the level of report: Detail or Summary. Only users with permissions can select an option. If the options are not available, the Summary report prints by default. Refer to Effect of Permissions, below, for more information.
From the Sort by drop-down list, select the sort order for the report: Vendor ID or Name.
If you have the proper permission, and in step 4 you selected to print a Detail report type, the Include Required Documents check box is available. Check the box to include Required Documents in the report.

NOTE that if you select the Include Required Documents check box and you run report for All Vendors, the report can take awhile to print, depending on the number of Vendors set up in your system.
At the Direct Deposit Vendors Only check box, check the box to include only direct deposit vendors.
From the Groups section, select the check box next to each group you want to include on the report. Or, click the All link to include all of the groups on the report or click the None link to include none of the groups.
To include closed vendors on the report, select the Include Closed Vendors check box.
Select one of the following report printing options:

PDF Format: Print the report in PDF format for use in a PDF viewer, such as Acrobat.

Create Spreadsheet: Prints the report in an Excel spreadsheet.

Click Print. If you selected Create Spreadsheet, you are prompted to open or save the report Excel file. Otherwise, the report opens in PDF format.

Effect of Permissions

User security permissions for eFinancials and/or ePO must be granted in the System module to access this menu item.

System—Security—Users—eFinancials—Reports—AP Reports—Vendor List or

System—Security—Users—ePO—Reports—Vendor List

A secondary level permission, Vendor List Detail, affects the ability to print the Detail report format.

Summary format - Without the Vendor List Detail permission, the Vender List report prints in Summary format only.

Detail format - With the Vendor List Detail permission, the user can select to print in Detail format, which is the only format in which Required Documents is available.