# Business Central Data Migration Field Mapping Worksheet > Source: https://netray.co/tools/business-central-data-migration-field-mapping-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Map every legacy source field to a Business Central table and field, record the transformation rule and volume, and see how much data is ready to load. ## Category microsoft-dynamics ## Erp Microsoft Dynamics 365 Business Central ## Audience - BC partner consultant - Data migration lead - ERP project manager ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Source table / file **Key:** src_table **Type:** text #### Source field **Key:** src_field **Type:** text #### BC table **Key:** bc_table **Type:** select **Options:** - Customer - Vendor - Item - G/L Account - Bank Account - Fixed Asset - Dimension Value - Contact - Other #### BC field **Key:** bc_field **Type:** text #### Transformation **Key:** rule **Type:** select **Options:** - Direct copy - Lookup / cross-reference - Concatenate - Split - Default value - Manual review #### Records **Key:** records **Type:** number **Format:** integer #### Clean % **Key:** clean_pct **Type:** number **Format:** percent **Help:** Share of records passing validation today #### Ready to load **Key:** ready **Type:** number **Expr:** records * clean_pct / 100 **Format:** integer #### Owner **Key:** owner **Type:** text **Rows:** **Src table:** CUST_MASTER **Src field:** CUST_ID **Bc table:** Customer **Bc field:** No. **Rule:** Direct copy **Records:** 1850 **Clean pct:** 97 **Owner:** Sales ops **Src table:** CUST_MASTER **Src field:** PAY_TERMS **Bc table:** Customer **Bc field:** Payment Terms Code **Rule:** Lookup / cross-reference **Records:** 1850 **Clean pct:** 72 **Owner:** Finance **Src table:** VEND_MASTER **Src field:** VEND_NAME **Bc table:** Vendor **Bc field:** Name **Rule:** Direct copy **Records:** 640 **Clean pct:** 91 **Owner:** Purchasing **Src table:** ITEM_MASTER **Src field:** UOM **Bc table:** Item **Bc field:** Base Unit of Measure **Rule:** Lookup / cross-reference **Records:** 5200 **Clean pct:** 83 **Owner:** Engineering **Src table:** GL_ACCT **Src field:** ACCT_NO **Bc table:** G/L Account **Bc field:** No. **Rule:** Lookup / cross-reference **Records:** 420 **Clean pct:** 100 **Owner:** Controller **Src table:** ASSET_REG **Src field:** ASSET_DESC **Bc table:** Fixed Asset **Bc field:** Description **Rule:** Manual review **Records:** 310 **Clean pct:** 55 **Owner:** Finance **Totals:** #### Total field records **Key:** records **Agg:** sum **Format:** integer #### Total ready to load **Key:** ready **Agg:** sum **Format:** integer **Summary:** #### Overall data readiness **Key:** overall_clean **Expr:** sum_ready / sum_records * 100 **Format:** percent **Primary:** true **Description:** Weighted share of mapped records that already pass validation #### Mapped fields **Key:** mapped_rows **Expr:** count **Format:** integer **Notes:** Add one row per field you plan to load. Records are counted per field so weak fields stand out. Export to Excel and share with the data owners listed in the Owner column. ## Content **Intro:** A mapping sheet is the first document a Business Central migration lives or dies by. This worksheet gives you one row per legacy field, the BC table and field it lands in, the rule you will apply and how clean the data is today. Edit it in the browser and export to Excel. **Sections:** #### How to use the worksheet **Body:** Start with the master data that everything else depends on: customers, vendors, items, the chart of accounts and dimensions. For each legacy field add a row, choose the target BC table, and type the target field name as it appears in the BC page or in the configuration package field list. Pick the transformation type, then record how many records exist and what share passes your validation rules. The ready-to-load column and the overall readiness figure update as you type. **Bullets:** - One row per field, not per table, so weak fields are visible - Use Lookup / cross-reference for anything that needs a BC code to exist first, such as payment terms or posting groups - Assign every row an owner who can fix the source data #### What good mapping looks like **Body:** Business Central requires that referenced setup records exist before the master data that uses them. Payment terms, units of measure, posting groups, countries and dimension values must be loaded or configured first, or the import of customers, vendors and items fails on validation. Sort your sheet by load sequence, not alphabetically, and add the dependency to the Transformation or Owner text. Keep the numeric key rules explicit: BC number series, code length limits such as 20 characters for many code fields, and case handling all affect legacy IDs. #### Reading the readiness figure **Body:** Overall readiness is the sum of ready records divided by the sum of records across all rows. It is weighted by volume, so a field with thousands of records drags the figure more than a small table. Treat anything below roughly 80 percent as a signal to schedule a cleansing sprint before the first trial load. A high figure does not prove correctness; it only says records pass the rules you wrote down. #### Common mistakes **Body:** Teams often map only the visible fields and discover mandatory ones during the first import. Check required fields on each BC page and any extension fields your partner has added. Another frequent gap is ignoring open transactions: balances, open sales and purchase documents, inventory by location and bin, and fixed asset depreciation books each need their own mapping rows and a reconciliation plan. **Cta:** If your source is NAV, SyteLine, Epicor or a spreadsheet estate, Netray can help profile the data and build repeatable load scripts under human review. Ask for a review of your mapping sheet. **Faq:** #### Should I map into configuration packages or use Excel and the Edit in Excel feature? **Answer:** Configuration packages suit larger first loads of master data across several tables, with validation and error reporting. Edit in Excel suits small corrections to existing records. Many partners use packages for cutover and Excel for cleanup. This sheet works for either approach. #### How many fields should a typical BC mapping sheet include? **Answer:** It depends on scope, but master data alone for customers, vendors, items and accounts often reaches 100 to 300 mapped fields once extensions and dimensions are included. Start with required fields and the fields that drive posting, then add reporting fields. #### Does the worksheet connect to my BC environment? **Answer:** No. It runs entirely in your browser and nothing is sent anywhere. You export the sheet to Excel and use it as a planning and tracking document alongside your own configuration packages or load tools. #### How do I handle data that does not fit any BC table? **Answer:** Choose Other as the BC table, describe the intended handling in the BC field column, and decide whether it needs an extension field, an attachment, a dimension or should be archived outside the system. Record the decision so it is not lost. ## Search terms business central data migration template, dynamics 365 business central data mapping excel, business central migration field mapping, nav to business central data mapping template, business central data cleansing worksheet, business central customer vendor item import mapping, erp data migration mapping template --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json