Multiple Vendors for a single Item

  • Multiple Vendors for a single Item

    Posted by Laura Brandon on April 27, 2023 at 10:24 am

    Hello-

    I am looking for best practices in setting up multiple vendors for a single item. In almost all cases we have a primary vendor who we use for 90% of purchases but we are looking to add more secondary sources and I would like them listed and searchable in BC. Thanks!

    David Wiser replied 4 months, 3 weeks ago 4 Members · 4 Replies
  • 4 Replies
  • Chris Warren

    Member
    April 27, 2023 at 10:42 am

    Good morning Laura!

    You can accomplish this by doing the following:

    If you purchase the same item from more than one vendor, you must enter information about each vendor of the item, such as prices, lead time, discounts, and so on.

    1. Choose the icon, enter Items, and then choose the related link.
    2. Select the relevant item, and then choose the Edit action.
    3. Choose the Vendors action.
    4. Choose the Vendor No. field, and then select the vendor that you want to set up for the item.
    5. Optionally, fill in the remaining fields.
    6. Repeat steps 2 through 5 for each vendor that you want to buy the item from.

    The vendors will now appear on the Item Vendor Catalog page, which you open from the item card, so that you can easily select an alternate vendor.

    (From: https://learn.microsoft.com/en-us/dynamics365/business-central/inventory-how-register-new-items)

    Does that help?

  • Amanda Mayer

    Member
    April 27, 2023 at 10:52 am

    Laura,

    Chris is spot on with this information. I would add one additional piece of advice. The item card itself holds the default information: default vendor, lead time, price, etc. I would remove everything from that area of the item card except the default vendor, if you do have a vendor that you typically buy from.

    One follow-up question: do you have multiple locations you order into? And if so, are you using SKUs (stockkeeping units)?

  • Laura Brandon

    Member
    April 27, 2023 at 4:49 pm

    Thanks to you both!!

    Amanda- could you elaborate more on why you recommend deleting information out of the item card?

    Follow up question – does listing multiple suppliers for an item impact the planning worksheet process at all or will the planning worksheet always use the default supplier?

    • David Wiser

      Member
      May 2, 2023 at 2:07 pm

      Generally, when planning for an item using the Planning or Requisition Worksheet, the system will use the default vendor on the item card when adding the purchase suggestion on the worksheet. The exception to this goes back to Amanda’s question on whether you’re using Stockkeeping Unit Cards by location. If so, you can specify the default vendor for the item for that specific location. As a result, on the planning worksheet, it there is demand for that item at the specific location, the system will first look to the SKU card for the vendor before going back to the item card for the vendor. This can really help purchasing as different locations may source items from different vendors.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!