How to Add or Update Vendor Item Numbers and Costs One Item at a Time

Overview

Use this guide to record a supplier’s part number, cost, and purchasing details for an existing item in 1place. You can maintain separate entries for each supplier you purchase the item from.

Steps

  1. Open Items from the Main Menu and find the item.

  2. Open its Item Details screen, then select the Vendors tab.

  3. Locate the vendor entry you want to update. To add a supplier, select a Vendor Name in the blank row at the bottom of the table.

  4. Enter or review the applicable columns.

    ColumnWhat to enter or review
    SortUse the handle to arrange the vendor rows.
    DefaultSelect the checkbox for the item’s primary supplier.
    Vendor NameSelect the supplier from your existing vendor list. Use the magnifying glass to open its vendor record.
    Vendor Item #Enter the supplier’s part number for this item.
    Vendor CostEnter the cost the supplier charges for the item.
    Lead Time (# Days)Enter the supplier’s delivery lead time in days.
    Case PackEnter the number of units per case.
    CSF/VolumeEnter the supplier’s volume measurement, if applicable.
    Duty %Enter the applicable import duty percentage.
    Qty On OrderReview the quantity currently on order from this supplier.
    Rnd Case QtySelect to round purchase quantities up to a full case when creating automatic Purchase Orders.
    Conv Case QtySelect to convert purchase quantities to case quantities on Purchase Orders.
    Last Order DateReview the date the item was last ordered from this supplier.
    Cost Last UpdatedReview the date the vendor cost was last updated.
    Ven QISEnter or review the quantity in stock reported by the vendor.
    QIS Last UpdatedEnter or review when the vendor’s stock quantity was last updated.
    NotesEnter supplier-specific purchasing instructions or other notes for this item.
    ActionClick X to remove the vendor entry from this item.

  5. Review the vendor item number, cost, and other changes, then click Save.

  6. Reopen the Vendors tab and verify that the changes were saved correctly.