Vendors (Inquiry)

Additional Information

The Vendors inquiry allows you to view and edit vendor-related data and also provides the ability to show the Vendor document for a selected result in a split panel.

This inquiry provides the ability to view more details and edit a document using the inquiry split pane. Click the View button and then select the Split Pane option. For more information, see View Additional Details in the Split Pane.

The inquiry provides a warning message if it is in split pane view and the Vendor record selected has a version of source document (Vendor doc) with pending changes that exist in Draft state.

Restrictions

The inquiry contains the following default restrictions:

  Restriction Description
  Status Select the status of the document.
  Vendor Enter or select one or more vendors. This limits the results to records associated with the selected vendors.
  Type

Enter or select an active vendor type. This is a reporting parameter that is used to group and sort vendor data.

  Currency

Enter or select an active currency associated with the vendor document.

  Alternate Name

Enter an alternate name for the vendor. For example, this name can be used on payment documents.

For a list of the optional restrictions, see ClosedVendors Optional Restrictions.

The following optional restrictions are available:

  • Address City
  • Address Country
  • Address State / Province
  • Parent
  • Payment Routing Code
  • Payment Term
  • Pay When Paid
  • Tax ID

Results

The initial view (default) is a flattened view by Vendor record. This data is grouped in ascending order by Vendor Code, Vendor Name, Type Code, Type Name, Currency Code, Currency Name, Parent Code, Parent Name, Tax Code, Tax Name, and Status.

For each returned result record, the inquiry provides a Related Items menu where users can open the Vendor input document or access the Insurance Summary inquiry. Please note that the Open Insurance Summary Inquiry option is only enabled if the Vendor has an active insurance record.

To limit the number of records displayed, the inquiry only displays the Primary Address, Primary Payment Routing, and Primary Tax ID values for each vendor. A binary indicator will denote whether there are multiple Payment Routings or Tax ID's for a given vendor.

For additional optional columns, see the ClosedVendors Optional Columns.

The following optional columns of information are available:

  • Alternate Name
  • Expense Resource Class Code
  • Expense Resource Class Name
  • Primary Address Code
  • Primary Address Name
  • Primary Address Street
  • Primary Address City
  • Primary Address State / Province Code
  • Primary Address State / Province Name
  • Primary Address Country Code
  • Primary Address Country Name
  • Primary Address Zip Code
  • Primary Address Mailing Address
  • Primary Address Phone Number
  • Primary Address Fax Number
  • Primary Address Status
  • Primary Routing Account Type
  • Primary Routing Pay When Paid
  • Primary Routing On Hold
  • Primary Routing Payment Term Code
  • Primary Routing Payment Term Name
  • Primary Routing Electronic Payment
  • Routing Separate Check
  • Primary Routing Bank Account
  • Primary Routing Routing Number
  • Primary Routing Vendor Account
  • Primary Routing Address Code
  • Primary Routing Address Name
  • Primary Routing Locale
  • Primary Routing Contact
  • Primary Routing Attention
  • Primary Routing Payment Return Type Code
  • Primary Routing Payment Return Type Name
  • Primary Payment Return Code
  • Primary Routing Status
  • Primary Routing IBAN
  • Primary Routing SWIFT Code
  • Has Multiple Payment Routings
  • Primary Tax Authority
  • Primary Tax ID Type
  • Primary Tax ID
  • Has Multiple Tax IDs
  • Has Insurance Record