D365 Finance and Supply Chain Data Migration Mapping Worksheet
Most D365 go-lives that slip do so on data. A mapping sheet puts every source field, target entity, rule and owner in one place, so cleansing work is visible long before the first mock load.
| Migration object | Source field | Target data entity | Target field | Transformation rule | Owner | Status | Source records | Rejected records | Reject rate | |
|---|---|---|---|---|---|---|---|---|---|---|
1.5% | ||||||||||
0% | ||||||||||
1% | ||||||||||
0% | ||||||||||
0% |
Entity names above are examples. Confirm the exact data entity and field names in the Data management workspace of your environment and version before loading.
Profile your source data before mock load one
Optional: a private data profiling and mapping assistant that runs on your own infrastructure.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Add a row for each field mapping or each migration object, depending on how detailed you need to be. Name the target data entity as it appears in the Data management workspace, record the transformation rule in plain words, and give every row an owner from the business. Update status after each mock load and enter source and rejected record counts to see reject rates calculate automatically.
- Map to data entities, not tables
- Write rules in plain words a business owner can check
- Record counts after every mock load
- Keep a separate row for each load sequence dependency
Load order and dependencies
Entity load order matters: legal entities, number sequences, main accounts and dimensions precede customers, vendors and released products, which precede open orders and opening balances. Use the data management framework's execution units and sequencing in data projects to enforce order. Staging tables let you validate before copying to target, which keeps errors out of production tables.
Reading the reject rate
A reject rate that stays above a few percent after several mock loads usually points to a rule problem, not random bad data. Look at the most common error message in the execution log and fix the rule or the source cleansing. Aim to reach a stable, explainable rate before cutover rehearsal, and have the business sign off each object on the final mock.
Common mistakes
Teams map to the legacy structure instead of the D365 data model, forget financial dimensions and default values, and migrate far more history than the business will use. Also avoid loading open transactions without a cutoff plan; document how in-flight orders are handled at the freeze. Keep the sheet under version control, because decisions here become audit evidence.
Frequently Asked Questions
Should I map every field?
Map every field you intend to load, and explicitly record fields you decided not to migrate with the reason. A short list of excluded fields prevents later debates about missing data and gives auditors a clear decision trail.
How many mock loads are typical?
Most projects run at least two or three full mock loads before cutover, plus a final rehearsal in a production-like environment. The right number depends on data volume and quality, and each mock should reduce rejects and timings.
Can I use Excel to load data?
Yes, for small volumes. The Excel add-in and the data management import can load templates, but for large volumes use package imports with data entities. Always load into a test environment first.
Who should own each object?
A named business owner who can judge correctness, not only a technical consultant. Finance owns balances and customers, procurement owns vendors and open purchase orders, and so on. Sign-off should come from them.
If you are mapping a large legacy ERP, Netray can help build private tooling that proposes field mappings and spots profile anomalies in your source data, with every mapping reviewed by your team.
Related Tools
D365 Finance and Supply Chain Cutover Plan Template
A cutover runbook skeleton for a D365 F&O go-live: freeze, extraction, load, validation, go/no-go and rollback, with sign-off lines.
Microsoft DynamicsD365 Finance and Supply Chain Fit-Gap Analysis Worksheet
An editable fit-gap register that totals gap hours and cost by fit type, so you can see the true size of customization before you commit.
Microsoft DynamicsD365 Finance and Supply Chain Integration Interface Register
An editable interface inventory for D365 F&O with pattern, direction, frequency, volume and owner, summing daily message volume.
Microsoft DynamicsD365 Finance and Supply Chain UAT Test Case Worksheet
An editable UAT tracker with process area, scenario, expected result, tester, result and defect reference, with pass-rate totals.
More Microsoft Dynamics tools
See all- D365 F&O OData URL Builder
- D365 Data Management Import Worksheet Template
- D365 Batch Job Checklist
- D365 Security Role Design Worksheet
- D365 One Version Update Test Checklist
- D365 Finance and Supply Chain Functional Design Document Template
- D365 Finance and Supply Chain Change Request Form Template
- D365 Finance and Supply Chain Implementation Effort Estimator
- D365 F&O Inventory Dimensions Reference
Keep exploring
Free tools
- D365 Finance and Supply Chain Cutover Plan TemplateA cutover runbook skeleton for a D365 F&O go-live: freeze, extraction, load, validation, go/no-go and rollback, with sign-off lines.
- D365 Finance and Supply Chain Integration Interface RegisterAn editable interface inventory for D365 F&O with pattern, direction, frequency, volume and owner, summing daily message volume.
- D365 F&O Data Migration Load Sequence ReferenceDependency-ordered list of the master, setup and transactional data areas to load when migrating to D365 F&O.
ERP fixes and how-tos
- Dynamics 365 Supply Chain Management API: OData, Custom Services and Data PackagesD365 Supply Chain / F&O APIs explained: OData data entities, custom services, the data management package API, Entra ID authentication and when to use each.
- Dynamics 365 Supply Chain Wave Planning and Inventory JournalsHow wave planning and inventory journals work in Dynamics 365 Supply Chain Management: wave templates, wave steps, work templates, journal names and posting.
- Dynamics 365 Supply Chain Warehouse Only Mode: What It Is and Its LimitsWhat warehouse management only mode is in Dynamics 365 Supply Chain Management, how to enable it, how orders arrive as shipment orders, and its limits.
AI on your ERP
- AI for Dynamics 365 Finance and Supply Chain beyond CopilotAI for D365 Finance and Supply Chain beyond Microsoft Copilot: private LLM grounded on data entities and OData, on-prem-capable via Local Business Data.
- AI for Dynamics 365 Finance and Supply Chain ProcurementAI for Dynamics 365 Finance and Supply Chain procurement: purchase orders, vendor invoices, product receipts and approvals via OData and data lake exports.
Integrations
- How to use ChatGPT with Dynamics 365 Finance and Supply ChainUsing ChatGPT with Dynamics 365 Finance and Supply Chain: custom GPT actions over OData, exports versus live access, data controls and when to go private.
- How to connect Microsoft Teams to Dynamics 365 Finance and Supply ChainConnect Dynamics 365 Finance and Supply Chain to Microsoft Teams: business events, adaptive cards, Power Automate approvals and Entra ID auth, with limits.
Software
- Microsoft Dynamics 365 Finance and Supply ChainDynamics 365 Finance and Supply Chain Management explained for manufacturers: modules, data entities, OData, deployment, strengths, limits and alternatives.
- Dynamics 365 Field ServiceDynamics 365 Field Service handles work orders, resource scheduling and mobile technicians on Microsoft Dataverse. Modules, integrations and alternatives.