This article covers the classic vendor item grid. To read about the new vendor item grid, click here. The Vendor Items page lists all of the Vendor Item Records. Learn more about the classic vendor item record, here. 



TABLE OF CONTENTS

Vendor Items


From the vendor items tab, users can view, edit, link, and create vendor tems. Vendor items are associated directly with a single purchased item and represent the vendor-specific item record for the purposes of AP invoicing and purchase orders. Since a purchased item might be supplied by multiple vendors or in varied case sizes, multiple vendor items can be associated with a single purchased item.



If a vendor supplies the same item with different case packs or item numbers, multiple vendor items representing the different purchase UofMs / item numbers are required. 


The item number for the vendor item should match the vendor order guide and vendor invoices. The vendor item number is used as the lookup value for EDI AP Invoice Imports and order guide imports.


Vendor Items Grid





FieldDescription
1+ CreateClick to Create a new Vendor Item Record.
2View Actions

The following actions allow the User to change the List View:

  • View Dropdown - Click to switch between the current view and other saved grid views
  • Show/Hide Columns Dropdown - Click to select which Columns to show or hide from the grid
  • Save View - Click to save the current view of the grid
  • Clear Filter - Click to remove any filters that have been set
  • Clear Sort - Click to clear any sorts that have been set
  • Set Default - Click to set the current view as the default view
  • Export - Click this icon to export the current view to a .csv file
  • Refresh - Click to refresh the grid

3Column HeadersAll of the column information. The name of the columns are listed at the top of the column.
4SearchSearches the column for entered keyboards or applies the filter selected when the filter option is clicked. 



Column Details


ColumnDescription
ItemThe linked Purchased Item that this vendor item will reference and update.
VendorThe Vendor that this vendor item is supplied by.
Vendor Item NameThe Vendor Item name as it appears on the vendor order guide / vendor invoices. This field is used for reference only.
Vendor Item NumberThe number of the vendor item.

This number should match the Vendor Order Guide and Vendor Invoices. The vendor item number is used as the lookup value for EDI AP Invoice Imports and Order Guide Imports.
Purchasing UofMPurchase unit of measure for the vendor item. UofMs used for vendor items must be tagged as purchasing UofM.
  • Note: If this item is supplied by the same vendor using different case packs, multiple vendor items representing the different Purchase UofMs are required.
PriceThe current price of the vendor item.
Vendor Pack SizeThe pack size name provided by the vendor on order guides. This column is for reference only.
Contract PriceThe current expected price of the vendor item used for purchase ordersand vendor contract price verification. 
  • Note: The current Contract Price will replace the Previous Price each time the Contract Price is updated
VarianceThe difference between the Contract Price and the Previous Price.

Contract Expiration

The date that the Contract Price imported via an Order Guides Vendor Integration will expire.
Effective DateThe date that the Contract Price will be active for the vendor item.
  • Note: When the Contract Price is manually changed, either through the Vendor Item grid or Import Tool, the Effective Date will reflect the date of the update. When the Contract Price is imported via an Order Guides Vendor Integration, the Effective Date will match the Effective Date on the imported Order Guide.
Split UofMThe Split U of M for the vendor item used with EDI Iintegrations.
Split PriceThe current Split Price for the vendor item that is used in Vendor Contract Price Verification. The split price is the broken down price for each individual item that may be part of a casepack. 
Split Contract Price The expected Split Contract Price for the Vendor Item that is used in Vendor Contract Price Verification.
Acceptable Variance PercentThe threshold of variance % between the Contract Price and the Actual Price found on AP Invoices that is acceptable. Used in Vendor Contract Price Verification.
Price SourceIndicates which method was used to update the Contract Price:
  • Invoice - The Vendor Item was created automatically as part of an EDI AP Invoice Import, and the Contract Price was set to the price on the Invoice.
  • User - Contract Price was updated manually by a User on the Vendor Item grid
  • Order Guide - Contract Price was updated via an Order Guide Vendor Integration 
  • Manual Import - Contract Price was updated via the Import tool
Created ByThe user that created the vendor item.
Created OnThe date that the vendor item was created.
Modified ByThe last user that modified the vendor item.
Modified OnThe last time that this vendor item was modified.