Supply chain | Supply Chain Management, Commerce

Multiple Manufacturing Part number (MPN) against Single item code

(1) Share

Report

Posted on by Mannem Raju

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.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

ColbyGallagher 3,666 on at

Like (0)

Report

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).

Was this reply helpful? Yes No
Suggested answer

Andreas Raithel 4,963 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

TimDownie 4 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 297,929 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Mannem Raju 39 on at

Like (0)

Report

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

Was this reply helpful? Yes No
André Arnaud de Cal... 297,929 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No