More information

Vendor Information List

Access this report using Reports>Accounts Payable>Vendor Information or Reports>Electronic Requisitions>Vendor Information.

Use this report to print a list of vendors which were set up using the Maintain>Accounts Payable>Vendors form.

Additional items, columns, and filters are available if any user defined fields were created by the Administrator using Organization>Set Up User Defined Fields. Only user defined fields with a field type of String, Editable Drop-Down List, Non-Editable Drop-Down List, Date, or Yes/No are available in the Items by Page group box on the Content tab. User defined fields with a field type of Currency follow the formatting of the organization's functional currency. The functional currency was determined by the Administrator when the organization was created (File>New Organization>Functional Currency panel).

Use this tab to assign a report name and determine whether or not to include it on the actual report. The report name can be printed in the header or the footer of the report.

Use this tab to determine what data to include in the report and to define the report layout.

By selecting Available Items, the data is divided onto separate pages. The report starts a new page for each item, and the item is printed in the page header of the report.
By selecting Available Columns, the data that appears in the body of the report is determined.

Column	Description
Class	The class assigned to the vendor—Offsup, Rent, Util, for example. A class is used to limit or sort a range of Vendor IDs. You can assign it to different IDs so that they can be grouped together.
Type	The type assigned to the vendor—furniture, computers, for example. A type is used as a second-level sort for Class. You can use it to limit or sort a range of Vendor IDs.
Vendor ID	The ID assigned to the vendor.
Vendor Name	The vendor's name.
Currency	The currency type assigned to the vendor, such as USD, CAD, or EUR. Currencies were created and activated by the Administrator using the Organization>Currency Setup form.
Currency Description	The description associated with the currency, such as US Dollar, Canadian Dollar, or Euro.
Always Pay in Vendor's Currency	A designation of Yes or No, determining whether to always pay this vendor in the specified currency.
Status	The status of the vendor ID—Active, Inactive, or Discontinued.
Address	The vendor's street or post office address.
City	The city where the vendor is located.
State/Province	The state or province where the vendor is located.
Postal Code	The postal code for the designated city/state.
Country	The country where the vendor is located.
Printed Main Address	The address that overrides the printed format of the main address.
Account Number	The account number assigned to the organization by the vendor.
User ID	The system user ID that is associated with the vendor ID.
Contact Title	The title for the contact person, such as Ms. or Mr.
Contact Name	The contact name for this vendor.
Contact Position	The contact's position with the vendor, such as Sales Rep or Owner.
Contact Email	This is the email address for the contact.
Voice Number	The contact person's voice telephone number.
Fax Number	The vendor's fax number.
Check Address Code	The vendor’s check address code, such as Main or Austin Office.
Check Address Status	The status of the check address—Active, Inactive, or Discontinued.
Check Address Preferred	A designation of Yes or No, determining whether the check address is the preferred choice for this vendor.
Check Address Description	The description associated with the check address.
Check Address	The check address for this vendor. This address was set up using the Maintain>Vendor>Address>Check Address form.
Check City	The city for the check address for this vendor.
Check State/Province	The state or province for the check address for this vendor.
Check Postal Code	The postal code for the designated city/state.
Check Country	The country associated with the Check address.
Printed Check Address	The check address that overrides the printed format of the main address.
Check Contact Title	The title for the contact person, such as Ms. or Mr.
Check Contact Name	The contact name for the check address.
Check Contact Position	The contact position, such as Sales Rep or Owner.
Check Contact Email	The email address for the contact.
Check Voice Number	The contact person's voice telephone number.
Check Fax Number	The fax number.
P.O. Address	The purchase order address for this vendor. This address was set up using the Maintain>Vendor>Address>Purchase Order Address form.
P.O. City	The city for the purchase order address for this vendor.
P.O. State/Province	The state or province for the purchase order address for this vendor.
P.O. Postal Code	The postal code for the designated city/state.
P.O. Country	The country associated with the P.O. Address.
Printed P.O. Address	The post office address that overrides the printed format of the main address.
P.O. Contact Title	The title for the contact person, such as Ms. or Mr.
P.O. Contact Name	The contact name for the purchase order address.
P.O. Contact Position	The contact position, such as Sales Rep or Owner.
P.O. Contact Email	The email address for the contact.
P.O. Voice Number	The contact person's voice telephone number.
P.O. Fax Number	The fax number.
Electronic Payment	A designation of Yes or No depending on if the vendor is paid electronically (Maintain>Accounts Payable>Vendors>Payment and Terms tab).
Bank Routing Number	The vendor's bank routing number.
Bank Account Number	The vendor's bank account number in which the electronic payment file is transmitted. Note that to view this information, you must have been granted Display Sensitive Data rights for Maintain>Accounts Payable>Vendors. These rights are granted by the Administrator using the Security>Set Up Organization Menus form.
Bank Account Type	The account type in which the funds are deposited—checking, savings, or loan account. The system displays a code of 22 for checking, 32 for savings, or 52 for loan.
Disable Pre-note	A designation of yes (Y) or no (N) depending on if a pre-note has been specified for the vendor.
Disable Pre-Note Last Updated Date	The date and time that the Disable Pre-note was last updated.
Electronic Payments Last Updated Date	The date and time that any information related to Electronic Payments was changed.
Pre-Note Sent Date	This is the date that starts the three (3) day period for which pre-notes will be created in the system.
Voucher Available Date	This is the date that ends the three (3) day period for which pre-notes will be created in the system.
Hold Payments	A designation of Yes or No. Yes indicates the vendor has a hold payments status—you do not want the system to produce checks for this vendor. No indicates the vendor does not have a hold payments status.
Print Separate Checks	A designation of Yes or No. Yes indicates you want to print a separate check for each invoice. No indicates that only one check prints for all invoices.
Personal Account	A designation of Yes or No depending on if indicated as a personal account pm the Maintain>Accounts Payable>Vendors>Payment and Terms tab.
Send Payment Notification	A designation of Yes or No depending on if you want the vendor to receive an email notification regarding the electronic payment file (Maintain>Accounts Payable>Vendors>Payment and Terms tab).
Email Address	The vendor's email address in which payment notifications are sent.
Check Stub Comments	The check stub comment for this vendor.
1st Discount %	The vendor's discount percentage
2nd Discount %	The vendor's second discount percentage.
1st Discount Days	The number of days the discount is available.
2nd Discount Days	The number of days the second discount is available.
Days Until Net Amount Due	The number of days until invoices are due to this vendor.
Default General Ledger Account	The general ledger account where payments to this vendor are usually charged, such as 57001 or 52101.
Default Distribution Code	The designated distribution code for this account.
Issue 1099	A designation of Yes or No. Yes indicates this vendor receives a 1099 form, and No indicates the vendor does not receive one.
Foreign Address	A designation of Yes or No depending on if indicated as a Foreign Address on the Maintain>Accounts Payable>Vendors>1099 Information tab.
Override State Tax	A designation of Yes or No. Yes indicates that the organization's default state tax information was replaced, and No indicates that it is not.
Override State ID	The state or province for the tax withholding applied to every vendor.
Override State Tax ID	The state tax identification number applied to every vendor.
Default State ID	The organization's default state or province for the 1099 tax withholding, entered by the Administrator on the Organization>Organization Information form.
Default State Tax ID	The organization's default state tax identification number, entered by the Administrator on the Organization>Organization Information form
Tax ID Type	A designation of Federal Tax ID Number (FEIN), Social Security Number (SSN), Tax ID Applied For (Applied For), or Foreign Tax ID Number (Foreign).
Tax ID Number	The vendor's Federal tax identification number. Note that if Tax ID Type Social Security Number (S) was selected, only the last four digits of the number display. To view the entire social security number, you must have been granted Display Sensitive Data rights for Maintain>Accounts Payable>Vendors. These rights are granted by the Administrator using the Security>Set Up Organization Menus form.
Default 1099 Form Type	The form type designated for the 1099 form, such as Form 1099-NEC (NEC), 1099-MISC (MISC), Form 1099-DIV (DIV), Form 1099-INT (INT), Form 1099-R (R), or W-2G Recipient (W2G).
Default Box Number	The form type-box number designated for the 1099 form, such as NEC-01, MISC-15,, DIV-01a, INT-01, R-09b, or W2G-01. Note: In the MIP 2020.3 release, any MISC-07 coded activities with an effective date of 1/1/2020 or later have been automatically updated to NEC-01.
Name Control	The four character name for the vendor (from the 1099 Information tab), as it appears in positions 7-10 of the B record in Electronic Filing.
Proprietor Name	The proprietor name for the vendor (1099 Information tab).
Notes	The notes for this vendor. They were set up using the Maintain>Vendor>Notes tab.
Original Vendor ID	The Vendor ID used before it was renamed or merged into the new Vendor ID (using the Merge/Rename Vendor ID form).
Merged/Renamed Date	The date the Vendor ID was merged or renamed into the new Vendor ID.
Merged/Renamed Type	Whether the ID was merged or renamed—M (Merge) or R (Rename).
Merged/Renamed By	The user who merged or renamed the ID.
Merged/Renamed Comment	Any comments entered about the merged or renamed vendor.
{User Defined Field} - Vendors	A vendor type user defined field and its data. There will be a separate column for each field that was created by the Administrator using Organization>Set Up User Defined Fields.

Use this tab to narrow down and more explicitly define the data to include in the report by selecting from the Available Filters.

Use this tab to change the font and page setup for a report.

Use this tab to secure the active report so that other users cannot save their changes to it. The user that selects the check box, and then saves the report, is the only user that can change or save it later. This check box cannot be cleared by any user other than the user that locked the report.