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
4 May, 2019

Think about information creators and consumers in manufacturing organizations. Old PLM sales assumption was projecting 10 information consumers on one...

8 September, 2015

Control is an interesting thing. It happens in life and business. Often, we think control guarantees us the life we...

20 April, 2009

In one of my previous posts, I already discussed PLM process management: Should PLM develop its own process tools?. In...

10 January, 2012

There is a lot going on in database space these days. Few days ago I posted – PLM, RDBMS and...

1 May, 2014

File sync and sharing became the most requested feature to enable collaboration. The days when everybody were co-located in the...

23 April, 2023

As the manufacturing industry continues its digital transformation journey, Product Lifecycle Management (PLM) systems are becoming more critical for industrial...

8 September, 2009

Interesting prompt today. What do you think about future of 3D? What will be real immesrsive 3D experience? We are...

27 March, 2014

Yesterday’s post about how engineers can collaborate in the office, made me think about another aspect of collaboration – taking notes. You...

23 September, 2010

I want to talk about licenses. The topic I’d normally prefer to avoid. Deelip Menezes made a good post about...

Blogroll

To the top