Vendor Information List Report

To access this report, go to Reports > Accounts Payable > Vendor Information List

Use this report to print a list of vendors which were set up through Maintenance > Accounts Payable > Vendors.

Tip: If you're not familiar with the MIP Cloud Report Builder, see Report Builder for an introduction.

You can choose to use the report as-is by selecting Export or View, or make edits to the report by selecting Edit.

If you choose to make edits to the report, the Report Builder page will display. From this page, use the Setup tab to choose the columns you'd like to appear on the report. You can rename the columns under the Column Heading.

The following columns are available to include in the report:

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 Maintenance>Vendor> 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 Maintenance>Vendor 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 (Maintenance>Vendors).
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 Maintenance>Vendors. These rights are granted by the Administrator
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 on Maintenance>Vendors.
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 (Maintenance>Vendors).
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 Maintenance>Vendors form.
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
Default State Tax ID	The organization's default state tax identification number, entered by the Administrator
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 Maintenance>Vendors. These rights are granted by the Administrator
Default 1099 Form Type	The form type designated for the 1099 form, such as Form 1099-NEC (NEC), Form 1099-MISC (MISC), Form 1099-DIV (DIV), Form 1099-INT (INT), Form 1099-R (R), or W-2G Recipient (W2G).
Default 1099 Box Number	The form type-box number designated for the 1099 form, such as MISC-15, DIV-01a, INT-01, R-09b, or W2G-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 Maintenance>Vendor form.
Original Vendor ID	The Vendor ID used before it was renamed or merged into the new Vendor ID
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.

Use the Filter tab to narrow down and define the data using the available filters.

Use the Options tab to Summarize Amounts on the report, implement security features, and more.

Select "Summarize Amounts" to add amounts together and display one line item with the total amount. All document information must be identical for the system to add items together.

Select "Do Not Allow Changes to this Report" to secure the report so that other users cannot save their changes to it. This option can only be undone by the user that locked the report.
Select "Year End Adjustments" to include year end adjustments on the report. This entry type was designated during transaction entry.
Select "Open Entries in Detail" to include opening balances (system or user opening entries) in detail.
Select "Replace total debits and credits with Balance" to show the net amount for each segment where totals have been requested. Otherwise, the report displays the total debits and total credits for each segment.
Select "Suppress Lines with All Zeros" so that documents with zero amounts do not print. This eliminates records having zero in all amount columns. If it is not selected, every line prints, even if it has a zero value.

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