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
28 April, 2016

In software application programming interface (API) is a set of routines, protocols and tools to build a software. An API...

31 August, 2015

SME was always a different nut to crack for PLM vendors. My last year article “Why PLM vendors stuck to...

4 May, 2010

Yesterday, I had chance to read the new paper by Jim Brown: Issue in Focus: The Integrated ERP-PLM Strategy. There are...

13 June, 2021

Data is a new oil. Unless you lived under a rock for the last few years, I’m sure you’ve heard...

30 January, 2013

I’m continue my BOM 101 series of posts. When working on bill of materials, you can often hear about the...

8 August, 2011

I’m still off on vacation until Wednesday. However, as my PLM blogging buddy Jim Brown mentioned on the Facebook – “Blogging...

17 February, 2025

For the past 20 years, the smartphone has revolutionized the way we live, work, and communicate. It is an incredibly...

26 February, 2009

Since last year, I have seen many discussions on the Web about PLM 2.0. The number of posts is growing…...

28 May, 2010

An interesting story about Design to Manufacturing strategies from Desktop Engineering by Tom Kevan. This topic is very important, in my...

Blogroll

To the top