ERP Part Numbering Standards for Manufacturing (Part 1)
There are many opinions on the subject of “proper” part numbering systems within the manufacturing world. Many companies will fall into what can be called an “accidental” part numbering scheme, and still others end up over-thinking their designs. This blog series will present you with guidelines for developing and using good part numbering techniques within a manufacturing company.
The first thing to note is that a part number is generally not a description of the part; there are separate fields for holding the actual description, as well as part class and product group. Having part numbers defined by whether a part is purchased or manufactured is not recommended, as this can change over time. Anything that can change should not be embedded into the part number.
Every part has a “Part Number,” which is also the primary index for the part table; this may also be called an “Item Number” or a “Stock Keeping Unit” (SKU). There should be only one part number set up for each item that is kept in stock. We assume that each part number represents a specific item, and there are no duplicate items.
Here are 4 different types of part numbers you should be aware of:
- Manufacturer Part Number: Since you may have multiple manufacturers for any one part number, it is possible to have multiple manufacturers and multiple manufacturer part numbers assigned to any one of your part numbers. An enterprise resource planning (ERP) system is able to store cross-references to multiple manufacturers’ part numbers.
- Supplier Part Number: A supplier part number is the number that your supplier/vendor labels your part. Your supplier may be a manufacturer, or they may be a distributor for another manufacturer. Since they may reference their part number differently than the manufacturer, you can create a three-way tie between your part, the manufacturer part, and the supplier part.
- Customer Part Number: The ERP system can also have a customer part number cross-reference. Since multiple customers can purchase the same part, there can be multiple customer part numbers that reference your part. Customer part numbers also have their own descriptions.
- Internal Part Cross-reference: This final part number option is to create an internal, secondary method of calling out a part number. The internal number can be used as a shortcut to a longer part number, or it can modify any serial numbering methodologies for the base part. It is also possible to have multiple internal cross-references.
In the next post of the Part Numbering Standards for Manufacturing blog series, we will be giving a summary of part numbering options. For more information on Epicor consulting services on this and other aspects of ERP, visit here.
Posted by Tim Shoemaker, Senior Principal Consultant, Epicor Professional Services