Part Numbering and it’s Downstream impact

Part Numbers

In one of my previous blogs, I have written about part numbering. Part numbers I would say are still relavent, but the question still remains, are they need to be intelligent? In my engagement with couple of Organizations, one of the biggest decisions is that of Part numbers. Not only for Engineering, but for downstream functions are also involved in this decision process.

For downstream functions like Purchase, Inventory Management, needs an unique number to identify a part.  These functions would like to communicate using unique identified for a part. Now the question still remains, do we need part numbers to be intelligent?

One of the arguments, which came my way during the decision, is that they would like to understand what part it is by looking at a part number. I have few of arguments to counter that,

  1. I asked, how many times do you see a part number in isolation ( without looking at Part Name & Part Description)? The answer to this question was , NEVER. But if you don’t have systems & managing parts in EXCEL, then this won’t be a case
  2. For EX. If there are two part categories, say Batteries & Bumpers, then part numbers can have abbreviations as BA & BU respectively. But if we add “Bushes” as another category, then there is a need of 3 Characters to specify category in part number, and it can end up adding full name of some of the categories.
  3. Another point, user would like to list all parts in a category and even further filter it while searching by giving wild card characters. My question to people implementing ERP: why can’t you add similar classification in ERP or any other downstream application like in PLM? Most of them have never thought of it..

People, who are used to intelligent part numbers, will always keep arguing because of discomfort they have with just numeric part numbers. With advancements in ERPs, Parts can have a separate name and number thus giving lot of valuable information in combination of two. Part numbers should be only used as Unique Identifier, just to avoid confusion like what and relational database does with Primary Key. The solution I feel is around setting up good classification in downstream applications and a decent search mechanism. This should reduce the dependence on part numbers only to identify & search correct part. It is always better to capture as much metadata as possible, to maintain knowledge within organization than just making it dependent on people outside the system

Conclusion: Engineering & other Downstream functions will always want part numbers to be intelligent so that they can use similar to paper based system. But my view is, instead of capturing information as encrypted values in part number, capture them as full text in attributes. This should reduce the defects occurring both upstream and in downstream usage of parts. System can be configured to search parts more efficiently. Intelligent part numbers, I feel are good for manual system.. These are just my views….

Posted in:
About the Author

Rahul Deshpande

Rahul is Principal Consultant at Brainwave Consulting Group – a cutting edge domain consulting group for New Product Introduction and Product Lifecycle Management.   Rahul brings over 16 years of experience in developing Technology and Business Solution for the Manufacturing Industry. He has worked with several clients in the manufacturing space in multiple roles spanning consulting, account management , Solution Architect and Program Management roles across the New Product Value Chain from Requirement / Enquiry management to launch of Product. He brings in cross functional experience covering Pre-Sales& Marketing, Business Planning, &IT Solution deployment. Rahul has worked along with the PLM ISV & Customers to define innovative solution and developed products for BOM Cost analysis and Sourcing Analytics on ENOVIA platform. He has penned different papers on usage of PLM for different processes & industries while addressing their business challenges. He brings a unique 360o view of the IT industry, and has significant contributions in the areas of IT Strategy, Program Management & Product Management.   Apart from holding a Bachelor of Technology in Electronics Rahul holds a Management degree from SIBM(Symbiosis Institute of Business Management). Rahul is associated with SIBM as visiting faculty for Innovation Management & International Business

Leave a Reply