Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Multiple Manufacturing...
Supply chain | Supply Chain Management, Commerce
Suggested answer

Multiple Manufacturing Part number (MPN) against Single item code

(1) ShareShare
ReportReport
Posted on by Mannem Raju 39

Hi All,

We have a requirement from our customer as below.

They are maintaining one part number in system which is assigned to their FG BOM, but they have 5-10 Manufacturing part numbers (MPN) for the same.

during purchasing that item, they are sending an RFQ to Supplier for item with 5 to 10 MPN (engg. Part numbers)

out of 10 MPN they choose the lowest price and create PO for the same.

 

Even though we have multiple MPN, receipt is made in one number only.

How to maintain / manage this in D365 F&O. Any suggestion would be helpful.

  • Suggested answer
    ColbyGallagher Profile Picture
    ColbyGallagher 3,666 on at
    Multiple Manufacturing Part number (MPN) against Single item code
    I've seen this requirement when the buying company is sourcing the same item from multiple different distributors (their vendor) but the part(s) are actually made by different manufacturers.  IE an alternator for a 2009 Ford Fusion, you could buy from 3 different distributors, the vendors all stock the part number as the manufacturers part number, to us, its still an alternator for a Ford Fusion.  We've always had to do a modification around external item ID to support this.  You're going to have some new data elements on CustVendExternalItem, you need to consider the customer side of this table as its shared, and then consider the initialize to Purch/SalesLine and the corresponding reports (Confirmation, product receipt / packing slip, invoice, etc). 
     
     
  • Suggested answer
    andreasraithel Profile Picture
    andreasraithel 4,812 Super User 2024 Season 2 on at
    Multiple Manufacturing Part number (MPN) against Single item code
    As mentioned before it is not a good approach to handle different physical item with just one F&O one item number. Instead it would be an idea to have different items for each physical item, so you can make the vendor request with these multiple items.
    Within the production BOM the planned item on the BOM line should be replaced by the item you decided to buy based on the pricing or any other reasons
     
    Hope this helps.
     
    Herzliche Grüße / kind regards,
     
    Andreas Raithel
    D365FO Solution Architect
  • Suggested answer
    TimDownie Profile Picture
    TimDownie 2 on at
    Multiple Manufacturing Part number (MPN) against Single item code
    I have a similar client requirement.  Out current design idea is to use variants to manage MFG and MFG Part number.  At transaction entry we use the Size and Color dims to represent Manufacturer and MFG Part #.  We register each dim with each process (receiving, picking, etc.).
     
    The one big drawback is defining the dimensions on a BOM.  We default the most common MFG and related part number on the active version.  This does, however, result in having to change the Production BOM to reflect the actual MFG and part number consumed in the BOM.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,602 Super User 2024 Season 2 on at
    RE: Multiple Manufacturing Part number (MPN) against Single item code

    Hi Mannem,

    Thanks for the clarification. This is not directly supported in the standard application. You can't setup multiple external item numbers for the same vendor and product. You can set up multiple barcodes, but these don't have a relation with a vendor. You can consider a customization to make this process work.

  • Mannem Raju Profile Picture
    Mannem Raju 39 on at
    RE: Multiple Manufacturing Part number (MPN) against Single item code

    Hi Andre Thanks for the revert.

    Yes, there are physically multiple different items maintained as one single item in Dynamics

    Example for requirement given below…

    SL.NO ITEM CODE VENDOR         MPN

    1     AAA-000-0001 SUPPLER 1 ZXCVBMNB

    2    AAA-000-0001 SUPPLER 1 ASDFGHLKJ

    3    AAA-000-0001 SUPPLER 1 QWERTPOI

    Requirement is – we need to send the above item for single supplier with 3 lines with 3 different MPN for getting quote and we have to get the lowest price and raise PO for that MPN.

    Challenge is that how to maintain 1 item – 1 vendor – multiple MPN

    Do we have any option in D365 for this.

    Regards,

    Mannem

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,602 Super User 2024 Season 2 on at
    RE: Multiple Manufacturing Part number (MPN) against Single item code

    Hi Mannem,

    When I read this question, my understanding is that there are physically multiple different items maintained as one single item in Dynamics. Is that correct? If not, why are there different part number and can they choose the cheapest? Or can they acquire the same item from different vendors where each vendor has its own item number?

    You can setup external item numbers in the application for each product/vendor combination. If it is about multiple external numbers for a single vendor, you would need to consider a customization.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,340 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans