Saturday, January 10, 2015

Best Practices of Part Numbering Logic in PLM


Current best practice, when using a computer planning system, is for the part number to be non-significant (not descriptive), all numeric and as short as possible to accommodate the largest number of parts envisaged. As this is a surprise to many people who are used to using long part numbers containing characters to denote the part's characteristics and/or description, I have listed below 12 good reasons for this approach.
  1. The part number is entered many times daily. A descriptive part number is re-entering the description which is already held by the system so is double entry and a waste of time and effort.
  2. Descriptive part numbers frequently contain alpha (letters) as well as numeric characters which are in different parts of the key board so cause a disproportionate increase in entry time. If alpha characters are case sensitive the entry time (and aggravation) increases again.
  3. Long part numbers often have to have spacing characters such as hyphens and slashes to make them readable which add to the entry cost.
  4. The more characters that are entered the greater the chance of errors. People can remember up to 6 characters easily (e.g. a telephone number) after that errors increase.
  5. People can guess descriptive part numbers but, because they are close, errors are harder to spot. An error in a non-significant part number is more obvious.
  6. The increasing use of bar codes is another incentive for a short part number. Short bar codes are easier to read and the equipment is cheaper and smaller. Alpha numeric bar codes are over twice the length of numeric bar codes.
  7. All new employees need training in a significant part numbering system. In practice it is rare that everyone really understand the part numbering systems eliminating any advantage. If "wrong" part numbers are created, parts change their use, have multiple use or are inherited from other sites or companies, descriptive part numbers just add to the confusion. Incorrect significance in part numbers is expensive double trouble.
  8. Most systems have part type, classification or codes which are quicker and easier to use to find a type of part and for reports than a descriptive part number. In addition, if there are strict rules for the layout of the description field, it is more flexible and efficient to find a part using the description field than by using a description coded into the part number.
  9. Even significant part numbers still have to be unique which means adding a non-significant element or adding extensions to the part numbers as and when new product variations are introduced. If the part numbering system is updated, do you update all the old part numbers or allow them to be incorrect?
  10. New significant part numbers have to be created manually whilst non-significant part numbers can be allocated by the system which saves time and administration costs.
  11. If absolutely necessary, sales catalogs can carry on using the old part numbering system. Systems can convert the short, numeric "internal" part number to a sales number for invoicing etc. New products should adopt the new codes from the start (your customers are more interested in your description and specification than your part number). It is also possible to convert suppliers part numbers to the internal number.
  12. Finally, for the dinosaurs who will not change (people do get very attached to their antiquated but familiar part numbering systems) the old part number can be stored in an "external" field for them to use. In practice people very soon get used to the new part numbers.
Some people advocate the use of check digits after the part number. In practice, most planning systems will display the description after a part number has been entered and the vast majority of people will check the description before proceeding. Check digits do not therefore justify the extra digit in planning applications.
Note : sensible and logical use of the description field aids the transition to non-descriptive part numbers. 
There are but a few basic rules of item numbering that should not be broken if at all possible.  These are as follows:
1.  Never include any information in the item number that may change over time.
2.  Never adopt a part numbering scheme that comes from an external source, such as customers or vendors.  If they ever decide to change their part numbers, you should never be forced to change yours.
3.  Avoid special characters and bad character combinations like the Plague (spaces, dashes, underlines, slashes, leading zeroes, O and 0 in the same item number, etc.) These lead to more transcription errors.
4.  Keep the part number to the lowest number of characters, but design to have all of your part numbers of the same length.

Reference collected info from Google & my hands on experience,,

Anil 

Tuesday, January 6, 2015

ERP Systems and PLM Part Numbering


Many of the companies we work with operate a production environment that necessitates the tracking of hundreds – if not hundreds of thousands – of parts.

Parts must be managed, stored, retrieved and handled in ways specific to the manufacturer’s unique operation, especially in high mix production environments.

To help manage and effectively track parts, ERP systems and part numbering systems have evolved as a way to reference each part in a standard fashion.

The Evolution of Parts Numbering

Looking back, traditional part numbering systems and document identification methods originated well over five decades ago.  The organizational system has its root in manual paper-based record keeping, and involved the use of document identifiers and descriptive part numbers that give an idea of what the item is.

The structure was such that each lengthy part number served as a detailed description of the particular part or assembly.

As researchers note, over time part numbering moved away from this “descriptive” approach, or what some call “smart” part numbers, and moved toward “insignificant” – essentially a sequence of 5-6 letters and digits without any embedded description or particular meaning.

This streamlined approach serves as the next generation of part numbers or unique IDs. In database terms, the part number is “insignificant” and relevant data fields are attached providing for complex query and data analysis.

This move from “smart” numbers to unique or “insignificant” part number IDs makes sense in this age of modern ERP systems and part numbering. These part numbers can easily be integrated into parts database that can be accessed by materials handling, production, engineering, production control, purchasing, or sales.

Practically speaking, there are many advantages to moving away from “smart” part numbers, which end up being far more cumbersome than unique part numbers.

“Insignificant” part numbers offer substantial benefits including:

·         Reduced training costs: In order to take advantage of “smart” part numbering, everyone throughout the company must be trained in the decoding the part number.  As companies grow and personnel change, more and more time is wasted in training and interpreting these so called “smart” part numbers.  However, with “insignificant” part numbers, reduced training is required to create new part numbers and perform multi-field data queries.

·         Decreased complexity: Instead of relying on lengthy and cumbersome “Smart” part numbers that attempt to describe the particular part or assembly, unique IDs are much shorter and easier to track. Unique IDs traditionally are made up of a sequence of 5 uppercase letters and digits, which is easy to remember.

·         Reduced chance of errors: One of the biggest practical limitations of “Smart” part numbers is that they give similar names to similar parts, which makes them difficult to tell apart during picking and increases the risk of picking errors. Unique IDs are just that – unique to each part, and quickly assessed for accuracy during picking.  Unique IDs also mean part labels are easier for workers to read.

·         Improved part life-cycle management: Unique IDs are not affected when product information changes, as a descriptive part number is.  Instead, a unique ID is assigned to each part as it changes and moves through the life cycle.

ERP Systems and Parts Numbering

In all, the move away from “smart” parts numbering helps in data mining, automated queries and business analytics, especially as relates to ERP systems.

With “insignificant” parts numbers, product catalogs from different companies can be merged without loss of information.  In addition, during an ERP selection project, a reliance on Unique IDs makes the transition and implementation much easier.

We find that many of our clients that have been using older legacy systems are also using some sort of home-grown “smart” part numbering system.  Many use the implementation of a new ERP system as an opportunity to cleanse their data and develop new “insignificant” part numbering system.  However, others find that changing from a “smart” part numbering system that many are comfortable with, combined with the change to a new ERP system is too much change to absorb – and stick with their “smart” part numbering system.  Some use a hybrid approach and retain the old “smart” part numbering system for their old part numbers, but use “insignificant” part numbers for all new parts going forward.

Regardless of the approach, most companies have realized “smart” part numbering is an antiquated approach to part numbering and data analysis. Many are putting plans in place to shift from “smart” to “insignificant” part numbers in the near future.



We discuss few of the best practices of Numbering in next post.



Reference By Google... 

Anil