A blog by Oleg Shilovitsky
Information & Comments about Engineering and Manufacturing Software

Existing data prevents companies to improve Part Numbers?

Existing data prevents companies to improve Part Numbers?
Oleg
Oleg
15 August, 2014 | 2 min for reading

historical-part-numbers

Part Numbers is a fascinating topic. I’m coming back to blog about what is the best approach to manage Part Numbers. My last post about it was – Part Numbers are hard. How to think about data first? was just few weeks ago. In that article, I outlined few principles how to keep PN separate from surrounding data focusing on different aspects of parts – description, classification, configurations, suppliers, etc.

Yesterday, my attention  was caught by ThomasNet article – Are Part Numbers Too Smart for Their Own Good? The article nailed down a key issue why companies are still having difficulties with management of Part Numbers. Nothing works from scratch in engineering companies. Complexity of characteristics and history of existing Part Numbers and products are making real difficulties to adopt new PN management concepts. The following passage explains the problem:

Another problem with descriptive numbering is that the description can become out of date and irrelevant over time. Individual parts can have their own life cycles; if a part has been identified according to the product, what happens if that product is discontinued but the part continues to be used in a newer product? Or what if a manufacturer changes vendors and the part number contains the name of the vendor that originally provided the piece?

Gilhooley admits that some Ultra Consultants clients have decided that switching from descriptive to auto-generated numbering would require too much organizational change. Some companies stick with old systems, and some opt for hybrid systems that perhaps retain descriptive numbers for existing parts but use auto-generated numbers for new parts.

It looks like there is no single solution or best practice to solve the problem. The “traditional” engineering approach to keep options to manage a diverse set company configuration looks like the only possible way to solve this problem in existing PLM/ERP systems.

What is my conclusion? History keeps customers from moving forward. There are two aspects of complexity in Part Numbers: 1/ complexity of definition and data classification; 2/ historical records of PN in every company including catalogs and existing products. Together, they create a block to make any changes in existing PN schema and prevent companies from migration towards new approaches. New data modeling technologies must be invented to handle existing data as well as supporting customers to migrate into modern PLM and ERP solutions. Just my thoughts…

Best, Oleg

Recent Posts

Also on BeyondPLM

4 6
5 September, 2022

Manufacturing is an industry that has been around for centuries. It is an industry that has seen a lot of...

27 November, 2018

General Motors’ decision to close five plants and lay off tens of thousands of workers in the U.S. and Canada...

21 October, 2013

Shake-ups are not a surprise these days. It happens all the time and especially in technological fields. The last decade...

3 February, 2010

In my view, we are observing the major disruption of enterprise software business models ever. Since yesterday’s post FREE and...

9 September, 2024

Over the weekend, I was captivated by an article by Jos Voskuil titled PLM Can Change – Waiting for the...

6 January, 2010

I’ve been thinking about Microsoft SharePoint success in enterprise organizations. For the last few years Microsoft leapfrog in their ability...

19 April, 2010

I can see multiple debates these days related to the social software – Social Networking, Microblogging and others. Despite the absolute...

23 July, 2014

These days manufacturing businesses are more connected than ever before. Every manufacturing company (even smallest startup) has a tremendous need...

23 May, 2013

Office and other productivity tools are un-separateable parts of product development environment. Some of them such Microsoft Excel literally can...

Blogroll

To the top