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

Multiple Vendors per Item

(0) Share

Report

Posted on by ahanson

236

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!

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,307 Super User 2025 Season 2 on at

Like (0)

Report

Hi, what about using Item Reference?

Hope this helps as well.

Thanks

ZHU

Was this reply helpful? Yes No
HVGEEL 308 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Amanda Mayer 207 on at

Like (0)

Report

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.

Was this reply helpful? Yes No