# How to Create ERP Items from CAD Automatically > Source: https://netray.co/erp-help/eng-cad-to-erp-item-creation-automation > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: ERP Help ## Short answer Generate the part number once, in one place (usually PDM or PLM), carry the attributes as CAD properties, and push a released item to the ERP item master through its import interface with validation. Retyping parts into ERP is the main source of duplicates, wrong units and missing make or buy codes. ## Kind how-to ## System it-leadership ## Erp CAD, PDM and ERP (item master) ## Module CAD to ERP item creation ## Query how to create ERP items from CAD automatically ## Alternate Queries - SolidWorks to ERP item master integration - CAD BOM to ERP part number creation - avoid duplicate part numbers CAD ERP - who creates item numbers engineering or purchasing ## Applies To SolidWorks, Inventor, Creo, NX, CATIA or AutoCAD with PDM or PLM, feeding SyteLine, LN, M3, NetSuite, SAP, Dynamics or Epicor ## Steps ### How to automate CAD to ERP item creation **Items:** - Decide where part numbers are issued: PDM or PLM numbering scheme, not CAD file names and not manual entry in ERP. - Define the minimum attribute set every part needs at release: description, unit of measure, item type, make or buy, material, weight, revision and lifecycle state. - Make those attributes mandatory custom properties in CAD templates, so the drawing or model cannot be released without them. - Add a duplicate check before issuing a number: search by description, material, dimensions or a geometry signature, and by manufacturer part number for purchased parts. - On release, export the item payload from PDM or PLM to a staging table or API in the ERP, not to a spreadsheet. - Validate in the interface against ERP rules: valid UoM, product code, item class, and existing item numbers. - Return the ERP result to PDM so the part shows an ERP-created flag and the ERP item identifier. - Handle purchased and catalog parts through a separate path with manufacturer, vendor part number and an approved source. ## Sections ### Where the part number should be born **Body:** 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. ### Attributes ERP actually needs **Body:** CAD knows geometry and materials. ERP also needs data that engineering may not think about: unit of measure, make or buy, planning type, default warehouse or location, lot or serial control, country of origin, commodity codes and, for regulated industries, flags such as export control classification. Split the attributes by ownership. Engineering supplies description, material, weight, dimensions, revision and drawing references. Purchasing and planning set cost, lead time, safety stock, supplier and order policy in ERP after the item is created. Trying to fill all of this from CAD fails; trying to leave it to ERP alone produces blank fields. Configure the ERP item to be created in an inactive or pending state until the ERP-side fields are completed. That stops an incomplete item being picked up by MRP or placed on an order. **Code:** Item payload (illustrative): { "itemNumber": "100245", "description": "BRACKET, MOUNTING, 3MM AL5052", "uom": "EA", "itemType": "MANUFACTURED", "makeBuy": "MAKE", "material": "AL5052-H32", "revision": "B", "lifecycle": "RELEASED" } ### Stopping duplicates before they exist **Body:** 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. ### Purchased parts and catalog items **Body:** Purchased components should not be created from a drawing at all. They come from a manufacturer catalog or a library, with manufacturer and manufacturer part number as key attributes, and they need an approved vendor list entry. A different path avoids engineers inventing internal numbers for off-the-shelf fasteners that purchasing already buys under another number. Where the CAD library has standard parts such as fasteners and bearings, map them once to existing ERP items and reuse the mapping. Do not allow every user to create their own. ## Pitfalls - Using CAD file names as part numbers, which breaks the moment a file is copied or renamed. - Skipping the duplicate search, then paying for it in split stock and double sourcing. - Exporting item data to a spreadsheet and importing by hand, which reintroduces retyping errors. - Making items active in ERP before planning and purchasing fields are set, so MRP plans with defaults. - Letting each engineer create purchased parts from drawings instead of using the approved catalog. - No description standard, so search and spend reports cannot group similar items. ## Ai Angle An AI assistant grounded in the ERP item master can flag likely duplicates by comparing descriptions, units, manufacturer part numbers and where-used, and can list items missing mandatory attributes. It reads the data and shows the query. It does not create or merge items on its own; the creation path stays in your PDM or PLM and the ERP import interface, with a person approving any merge. ## Faq ### Can ERP automatically read a CAD file to create an item? **Answer:** Not directly in most cases. The practical pattern is that CAD properties flow into PDM or PLM, and PDM or PLM sends a released item payload to ERP through an import interface or API. CAD is the source of attributes, not the thing ERP connects to. ### Who should own item creation, engineering or purchasing? **Answer:** Engineering usually creates manufactured and designed items, since they hold the design data. Purchasing or supply chain creates and maintains commercial items and supplier data. Both should work from the same numbering authority and duplicate check. ### How do I stop duplicate part numbers? **Answer:** Add a mandatory search step before a new number is issued, enforce description templates and classification, and run a periodic duplicate report on the item master. Controls at creation are cheaper than cleanup afterwards, which needs where-used checks on every merge. ### Does this work with SolidWorks and Inventor? **Answer:** Yes, both support custom properties that PDM or PLM can read at check-in and release. The detail differs by product, but the pattern of mandatory properties, a numbering service and a release-triggered export is the same across CAD systems. ## Search terms CAD to ERP integration, SolidWorks ERP item creation, part number automation, avoid duplicate part numbers, PDM to ERP item master, CAD custom properties ERP, item master data quality, part numbering scheme, engineering item creation workflow, Inventor ERP integration --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json