ERPNext Foundation ERPNext Cloud Chat Blog Discuss Frappé* Donate

Manufacturer and Manufacturer Part Numbers

manufacturing

#1

Hi there, our company tracks Manufacturers and Manufacturer Part Numbers as well as Suppliers (Vendors) and Supplier Part Numbers (Vendor Part Numbers).

These do not seem to be implemented OOTB with ERPNext … am I missing something? What is the best way to implement these?


#2

Bump!

Can someone help me customize our ITEM page to include a child table with Manufacturer Part Numbers?

Thanks!!


#3

If each Item has one manufacturer, but can be purchased from multiple vendors:

Click on Item icon on the desktop
click New, upper right corner
Edit Full Page, at bottom of dialog box
Scroll down to Supplier Details.

You can Enter Manufacturers part number for the item , as well an Item Code for each supplier.

Hope this helps.


#4

Thanks!

We have various parts that have multiple manufacturers, with multiple manufacturer part numbers.

We assign an internal part number (“DPN”).

So, for example, for our part number DPN100, it could be made by ManufacturerA with part number MA100, MA101, MA102; ManufacturerB with part number MB786, MB787, MB889, and Manufacturer C with part number ZZZX1.

These are often little tiny things like electrolytic capacitors for which various different capacitors will all be within spec. Due to outages, shortages, and shipping delays, which are all very frequent in this industry, it is necessary to be flexible and able to build one of our products at a moment’s notice from what we have on hand…and to be able to keep these things straight when we are ordering parts to have on hand.


#5

I think you need to add an item for each manufacturer’s item , MA100, MA101 etc. Then update the BOM for your item as component availability requires. See if the BOM Update Tool will help. This new thread might also be helpful: https://discuss.erpnext.com/t/different-bom-for-same-item/43090/2


#6

isn’t that what you need?

In my eyes the distinction between Supplier vs Manufacturer may be a bit misleading. I believe Manufacturer is a Supplier in the logic of ERPNext.
(Can’t really say what the field Manufacturer on the item form (Supplier Details Section) is meant to be for though and I could imagine it can just be ignored)


#7

What we need is this Manufacturer Part Number table from this github item: https://github.com/frappe/erpnext/pull/8134

We rarely purchase products directly through the manufacturer and can purchase the same MFG/MPN from multiple suppliers.

In our current system, we only have the MFG/MPN’s only up in the supplier table, and we end up with table like this.
image

While this is fine for the supplier table, the problem is when printing BOM’s (and/or other reports) we end up with a lot of redundancies with the same MFG/MPN displaying several times.

To properly print reports, we need to have separate tables for MFG/MPN’s and Supplier Price List. Can this be accomplished in ERPNext?