# Epicor DMT Import Template Worksheet for Part and BOM Data > Source: https://netray.co/tools/epicor-dmt-import-template-worksheet-part-bom > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable worksheet for staging part and BOM rows before a Data Migration Tool load, with export to Excel or CSV. ## Category epicor ## Erp Epicor Kinetic ## Industry Discrete Manufacturing ## Audience - Epicor consultant - Data migration lead - Epicor administrator ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Record type **Key:** record **Type:** select **Options:** - Part - BOM #### Company **Key:** company **Type:** text #### PartNum **Key:** partnum **Type:** text #### PartDescription **Key:** desc **Type:** text #### TypeCode **Key:** typecode **Type:** select **Options:** - M - P - K #### IUM **Key:** ium **Type:** select **Options:** - EA - KG - M - LB - FT #### Parent part (BOM) **Key:** parent **Type:** text #### Revision (BOM) **Key:** rev **Type:** text #### Material seq (BOM) **Key:** mtlseq **Type:** number #### Qty per (BOM) **Key:** qtyper **Type:** number #### Load order **Key:** load **Type:** number **Rows:** **Record:** Part **Company:** EPIC06 **Partnum:** HSG-1001 **Desc:** Housing, machined aluminum **Typecode:** M **Ium:** EA **Mtlseq:** 0 **Qtyper:** 0 **Load:** 1 **Record:** Part **Company:** EPIC06 **Partnum:** SCR-0420 **Desc:** Screw, M4 x 20 stainless **Typecode:** P **Ium:** EA **Mtlseq:** 0 **Qtyper:** 0 **Load:** 1 **Record:** Part **Company:** EPIC06 **Partnum:** ASM-2000 **Desc:** Pump assembly **Typecode:** M **Ium:** EA **Mtlseq:** 0 **Qtyper:** 0 **Load:** 1 **Record:** BOM **Company:** EPIC06 **Partnum:** HSG-1001 **Typecode:** M **Ium:** EA **Parent:** ASM-2000 **Rev:** A **Mtlseq:** 10 **Qtyper:** 1 **Load:** 2 **Record:** BOM **Company:** EPIC06 **Partnum:** SCR-0420 **Typecode:** P **Ium:** EA **Parent:** ASM-2000 **Rev:** A **Mtlseq:** 20 **Qtyper:** 6 **Load:** 2 **Totals:** #### Rows **Key:** load **Agg:** count **Notes:** Use this as a planning and cleansing sheet. The exact column headers DMT expects depend on the DMT template you select and your Kinetic version, so map these columns to the headers in the DMT upload screen before loading. Load parts before BOMs, test in a pilot company, and keep the source file for audit. ## Content **Intro:** Data migration fails more often on sequencing and cleansing than on the DMT tool itself. This worksheet helps you stage part and BOM rows in one place, order the loads, and catch missing parents before anything touches the database. **Sections:** #### How to use the worksheet **Body:** Add one row per part and one per BOM component. Set the load order so that parts are loaded first, then BOM components that reference them. Export to Excel or CSV, then copy the columns into the DMT template you select in the Data Migration Tool and map headers. Always do a trial in a pilot company before production. **Bullets:** - Load order 1: part master records - Load order 2: BOM material lines - Check that every BOM component exists as a part first - Keep unit of measure consistent between part and BOM #### Sequencing and dependencies **Body:** A BOM line references a parent part and a component part. If either is not on file yet, the row errors. Revisions add another dependency: the parent revision must exist before material lines are attached. Plan the order on paper first. A short dry run on a few assemblies reveals most structural issues quickly. #### Cleansing before load **Body:** Standardize part numbers, remove trailing spaces, fix unit of measure inconsistencies and resolve duplicates before loading. Decide whether obsolete parts migrate at all. Loading dirty data is easy, but cleaning it afterward in a live system is slow and risky, and costing may be affected by wrong types or units. #### Common mistakes **Body:** Loading BOMs before parts, using different units for the same part, forgetting company on multi-company loads, and testing only in production. Another common one is trusting a column mapping from a previous version after an upgrade. Always compare headers again. **Cta:** If your migration includes thousands of parts and BOMs, we can help build validation checks that run before the DMT load. **Faq:** #### What is Epicor DMT? **Answer:** The Data Migration Tool, or DMT, is Epicor's utility for loading and updating data in bulk from CSV or Excel files. It supports many record types including parts, BOMs, customers and open orders. Each load type expects specific column headers. #### Should I load parts or BOMs first? **Answer:** Parts first. BOM material lines refer to parent and component parts, so the part master must exist. Load revisions next if you use them, then material lines, and then operations and any engineering data your process needs. #### Can I update existing parts with DMT? **Answer:** Yes, DMT can add new records and update existing ones depending on the options you choose. Test the update behavior on a pilot company, because an update with blank cells may behave differently from what you expect. #### How do I check the load worked? **Answer:** Review the DMT log, then reconcile counts against your source file and spot check a sample of parts and BOMs in the Part and Engineering Workbench screens. Run a BOM explosion on a few top-level assemblies to confirm structure. ## Search terms epicor dmt template, epicor dmt part import, epicor dmt bom import, epicor data migration tool excel, epicor part master load, epicor dmt csv format, epicor dmt bill of material, epicor data migration worksheet --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json