Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Multiple Vendors per Item

(0) ShareShare
ReportReport
Posted on by 174

We are looking to assign multiple vendors to an item in BC. In some cases, it is because of location, and other cases it's because of supply chain issues. 

If the additional vendor is due to location; has anyone accomplished this by creating a SKU and assigning a vendor to that? 

Has anyone added in an additional field on the item card or another route?

Thanks in advance for the suggestions!

  • Suggested answer
    Amanda Mayer Profile Picture
    Amanda Mayer 205 on at
    RE: Multiple Vendors per Item

    So, the item card itself maintains the default vendor information. That is what you fill in the Replenishment System tab of the item card. If you are going to use Stockkeeping Units, then the SKU's Replenishment System does have priority over the Item Card and once the SKU is created, the default vendor for the SKU must be maintained separately.

    If you add in the Item Cross Reference and the Purchase Price tables to the vendor / item combination, you can maintain vendor specific information, regardless of the SKU they are defined as the default, assuming you source an item by location as opposed to by vendor raking or pricing.

    Item Cross Reference lets you add in the Vendors item number and can be added to the PO for easier communication with the vendor.

    The Purchase Prices and Purchase Discounts tables allow you to manage the Vendor, Item, Unit of Measure, Currency, and Qty break pricing / discounts for all Vendors where the item is purchased.

  • HVGEEL Profile Picture
    HVGEEL 288 on at
    RE: Multiple Vendors per Item

    When using SKU's for an Item, most planning fields on the Item card are disregarded, in favour of their SKU-counterparts.

    As aconsequence: adding this info on an item card would be contraproductive.

    Furthermore, since your question implies a many-to-one relation, it will not even be possible to add the multiple vedor info onto one field on an Item card.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    RE: Multiple Vendors per Item

    Hi, what about using Item Reference?

    pastedimage1673569310814v1.png

    Hope this helps as well.

    Thanks

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Multiple Vendors per Item

    For location you can use the SKU' that should solve the problem for you there.

    For supply chain issues, maybe safety lead time can be a field to look into?

    learn.microsoft.com/.../design-details-planning-parameters

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans