MENU
    Vendor Items Grid
    • 04 Nov 2024
    • 5 Minutes to read
    • Dark
    • PDF

    Vendor Items Grid

    • Dark
    • PDF

    Article summary

    This article reviews the Vendor Items tab of the Items page. Learn more about the Classic Vendor Items Page here.

    From the vendor items tab, users can view, edit, link, and create vendor items. 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.


    Security

    Vendor Items are found in the Permission Tree as follows:

    • Food

      • Vendor Items

        • View Vendor Items

        • Edit Vendor Items

        • Create Vendor Items

        • Delete Vendor Items


    These permissions can be added to custom user roles or individual users. The Permission Access report can be used to determine which user roles or users already have these permissions assigned. For more information, see User Setup and Security.


    First, navigate to the Items page under the Food Admin category, then click the Vendor Items tab.


    Vendor Items Grid

    The vendor items grid displays all vendor item records. Clicking on a row will open the associated Vendor Item Record in the new vendor item record sidesheet. 

    Quick Filters

    The vendor items grid has two quick filters at the top of the grid:

    Price Variance

    Click the Price Variance filter to only display vendor items which have a current price variance or split price variance greater than the acceptable variance for the vendor item. Price Variances are calculated as the difference between the contract price and the previous price. 

    Unlinked Items

    Click the Unlinked Items filter to only display vendor items that are not linked to a purchased item. 

    Linked purchased items are displayed in the Item column. This filter will only display vendor items where theLink Item button is displayed. Learn more about linking Vendor Items and Purchased Items here.

    Grid Columns

    The vendor items grid contains the following columns:

    Column

    Description

    Item

    The linked Purchased Item that this vendor item will reference and update.

    If there is no purchased item linked to the vendor item, the Link Item button will be displayed. Learn more about linking Vendor Items and Purchased Items here.

    Vendor

    The Vendor that this vendor item is supplied by.

    Vendor Item Name

    The Vendor Item name as it appears on the vendor order guide / vendor invoices. This field is used for reference only.

    Vendor Item Number

    The 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.

    Brand Item Number

    The identifying number given to the item. This field will only have a number when the vendor utilizes brand item numbers. 

    UofM

    Purchase unit of measure for the vendor item. UofMs used for vendor items must be tagged as purchasing UofM.

    If this item is supplied by the same vendor using different case packs, multiple vendor items representing the different Purchase UofMs are required.

    Price

    The current price of the vendor item.

    Vendor Pack Size

    The pack size name provided by the vendor on order guides. This column is for reference only.

    Contract Price

    The current expected price of the vendor item used for purchase orders and vendor contract price verification. 

    The current Contract Price will replace the Previous Price each time the Contract Price is updated

    Previous Price

    The previous contract price of the item. 

    Primary

     Indicates if the vendor item is a Primary item for the vendor. Used in Purchase Orders to filter and populate orders.

    Variance

    The 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 Date

    The date that the Contract Price will be active for the vendor item.

    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 UofM

    The Split U of M for the vendor item used with EDI integrations.

    Split Price

    The 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. 

    Previous Split Price

    The previous split price. 

    Split Variance

    The difference between the Split Contract Price and the Previous Split Price.

    Split Contract Price

     The expected Split Contract Price for the Vendor Item that is used in Vendor Contract Price Verification.

    Acceptable Variance

    The 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 Source

    Indicates 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 By

    The user that created the vendor item.

    Created On

    The date that the vendor item was created.

    Modified By

    The last user that modified the vendor item.

    Modified On

    The last time that this vendor item was modified.


    Bulk Edit

    Selecting one or more Vendor Items will display the Bulk Edit Menu at the bottom of the screen. 

    Edit

    To edit the selected Vendor Items, click the pencil icon. This will open the Bulk Edit form, where the 'Acceptable Variance' and 'Primary' attribute can be edited.

    Acceptable Variance

    Primary

    Delete

    While Vendor Items can be deleted through bulk edit, vendor items that have been utilized in the system should not be deleted. This tool should only be used to delete vendor items that have never been added to AP invoices or purchase orders. Discontinued vendor items should be retained for historical data purposes.

    To delete the selected vendor items, click the trashcan icon. Deleting a vendor item will remove it from all corresponding order templates, shopping lists, and open purchase orders.


    Creating New Vendor Item Records

    To create a new vendor item record, click Vendor Item from the + Create drop-down menu.

    This will open a blank Vendor Item Record in a sidesheet. Learn more about Vendor Item Records here

    The following fields must be completed before the vendor item record can be created:

    • Items

    • Vendor

    • Purchase Unit of Measure

    • Vendor Item Number

    When the desired configurations are complete, click Save to create the vendor item record.


    Vendor Item Record Deletion

    Once vendor item records are created and utilized in the system, it is recommended that they not be deleted

    While the vendor item grid has a tool for deleting vendor items, this tool should only be used to delete vendor items that have never been added to AP invoices or purchase orders. Discontinued vendor items should be retained for historical data purposes.

    To discontinue a vendor item, confirm that the Primary setting is toggled off, and remove it from Order Templates and Shopping Lists.


    Was this article helpful?