How to Create ERP Items from CAD Automatically

Pick one authority for numbering. If the ERP issues numbers, engineers wait for ERP access and often work around it with temporary names. If CAD file names are the numbers, any renaming or copying creates a conflict. A numbering service in PDM or PLM is usually the most practical, because it sits where engineers already work and it is upstream of both CAD and ERP.

Numbering schemes come in two forms. Significant numbers encode meaning (a prefix for family, digits for size), which helps humans but is fragile when the product changes. Non-significant sequential numbers are stable but need good descriptions and attributes to be searchable. Many companies choose non-significant numbers plus classification attributes.

Whichever you pick, issue the number at the moment a part is first created, not at release. That way drawings, models and early purchase requests can refer to the same identifier from the start.

Duplicate items cost money in inventory split across two numbers, in buying the same part from two suppliers at two prices, and in engineers redrawing parts that already exist. The most reliable control is a search step in the numbering workflow that makes engineers look for an existing part before a new number is issued.

Standardize descriptions with a template per class (noun first, then modifiers, then size and material). Consistent descriptions make both search and reporting work. Add a classification scheme so a similar part can be found by attributes rather than by guesswork.

Run a periodic duplicate report on the ERP item master: same description and UoM, same manufacturer part number, same drawing number on different items. Clean up by merging or obsoleting, but check where-used and open transactions first.