SAP to Dynamics 365 migration: field service data and workflow

What moving from SAP to Dynamics 365 actually involves for field service teams — data mapping, timeline, effort range, and the hardest part.

Why teams move from SAP

SAP's high TCO, long implementation cycles, and requirement for dedicated BASIS staff lead teams to move when they cannot justify the support overhead or when their operation is below the scale SAP is designed for.

What you're moving to: Dynamics 365

Microsoft Dynamics 365 is a ERP platform from Microsoft Corporation, best suited for SMB to Enterprise (10–5000 employees) organisations in Manufacturing, Retail, Professional Services, Government. Strengths relevant to this migration: Deep Microsoft 365 integration; Power Platform for low-code customisation; strong partner ecosystem. Known limitations to factor in: Module fragmentation (F&O vs Business Central vs Sales are separate SKUs); licensing can be complex.

The hardest part of this migration

Data extraction from SAP: SAP stores field service data in highly normalised PM/CS module tables with custom Z-table extensions. Extracting clean work order history with all linked parts, labour confirmations, and measurement documents requires ABAP extraction scripts — not a simple CSV export.

This is the step that consistently takes longer than planned. Budget time for a data audit before any tooling decisions — the quality and structure of your SAP data determines whether the migration runs in months or quarters.

What data needs to move

Data entity	Migration complexity	Notes
Work order history	Medium–High	Volume and schema complexity vary; closed work orders with all linked records (parts, labour, notes) are the most complex
Customer and site records	Low–Medium	Usually cleaner than work orders; watch for duplicate records and address format differences
Asset and equipment register	Medium	Hierarchy structures (parent/child assets) must map to Dynamics 365's asset model exactly
Technician profiles and skills	Low	Skills taxonomy must be rebuilt in Dynamics 365 before work order assignment logic works correctly
Parts and inventory	Medium	Part numbers, UoM, and bin locations need mapping; in-flight inventory levels need a cutover count
SLA and contract terms	High	SLA configuration in Dynamics 365 must be built before any work orders are dispatched from the new system
Open work orders at cutover	High	In-flight jobs at cutover date need manual reconciliation — no automated tool handles this reliably

Migration sequence

Data audit (weeks 1–3). Extract a sample of SAP records. Assess completeness, duplicates, and schema gaps. This is where the effort estimate gets refined — everything that follows depends on data quality.
Target system configuration (weeks 2–8, parallel). Configure Dynamics 365 before any data arrives: work order types, skill definitions, SLA rules, dispatch board layout, and mobile app settings. Data migration into an unconfigured system creates rework.
Historical data migration (weeks 6–14). Migrate closed work orders, customer records, asset register, and technician profiles. Validate record counts and spot-check a sample of complex records.
Integration cutover (weeks 10–16). Connect Dynamics 365 to your billing system, ERP, and any other adjacent tools. Test the full job lifecycle — intake to invoice — end to end before go-live.
Parallel run (4–8 weeks). Dispatch from Dynamics 365. Maintain SAP as a read-only reference. Reconcile daily. This is the phase that teams consistently underestimate — budget the dispatcher time to run both systems simultaneously.
Cutover. Freeze SAP data. Complete delta migration of records created during parallel run. Go live. Retain SAP read-only access for 90 days minimum.

Effort and cost range

Component	Estimate
Dynamics 365 implementation (net-new)	$80,000–$1,500,000
Migration-specific effort (data extraction, mapping, validation)	60–80% of implementation cost on top
Total migration budget range	$48,000–$1,200,000
Timeline	4–18 months from kickoff to cutover

These are ranges, not quotes. The actual number depends on data quality, integration count, and how much SAP has been customised. A data audit in the first 3 weeks will produce a tighter estimate than any figure given before the audit.

Frequently asked questions

How long does a SAP to Dynamics 365 migration take?

4–18 months from kickoff to cutover, including parallel run. The variable is data complexity and integration count. Clean, well-structured SAP data migrates faster than heavily customised instances with years of accumulated work order history.

What is the hardest part of migrating from SAP to Dynamics 365?

SAP stores field service data in highly normalised PM/CS module tables with custom Z-table extensions. Extracting clean work order history with all linked parts, labour confirmations, and measurement documents requires ABAP extraction scripts — not a simple CSV export. Beyond the technical extraction, the hardest operational challenge is the parallel run — running two dispatch systems simultaneously while keeping records reconciled.

Can we migrate open work orders from SAP to Dynamics 365?

In-flight work orders at cutover are the most difficult records to migrate cleanly. Most teams handle these manually: freeze SAP at cutover, complete a snapshot of open orders, and create them fresh in Dynamics 365. Automated migration of open work orders with live technician assignments rarely works without significant reconciliation effort.

Get a migration estimate

Tell us your SAP instance details — how long it's been running, how many open work orders, and what integrations are in place. We'll give you a realistic effort range before you commit to anything.

Get a quote