AI Automation

Explore
ResourcesMicrosoft Dynamics 365

Business Central Data Migration Checklist

Published by DataDaur Engineering•6 min read

Data migration is often the most underestimated phase of a Business Central implementation. Moving from a legacy system (like QuickBooks, Xero, or an older version of NAV) requires strict discipline to ensure you don't import years of bad data into your new ERP.

1. Pre-Migration Strategy

Before extracting any data, establish the ground rules. You should never migrate *all* historical data.

  • Define Scope: Will you import open transactions only, or historical data? (Recommendation: Open AR/AP, Open PO/SO, and Current Inventory balances only. Keep history in a data warehouse).
  • Master Data Cleanup: Identify duplicate vendors, inactive customers, and obsolete items in the legacy system. Clean it *before* exporting.
  • Number Series Mapping: Map legacy IDs to the new Business Central No. Series.

2. Data Extraction & Transformation (ETL)

Use Business Central's Configuration Packages (RapidStart) to build your templates.

The Core Templates to Prepare:

  • Chart of Accounts (G/L): Must align with the new reporting structure and Dimensions.
  • Customers & Vendors: Include payment terms, tax setup, and posting groups.
  • Items: Costing methods, unit of measure, and inventory posting groups.
  • Fixed Assets: Acquisition costs, accumulated depreciation, and FA posting groups.

3. Validation in the Sandbox

Always load data into a sandbox environment first. Never load directly to Production.

  • Import via Configuration Packages: Apply the data and check the error logs. Fix errors in Excel and re-import.
  • Validate Posting Groups: Ensure that every Customer, Vendor, and Item has the correct posting groups assigned. If these are missing, future transactions will fail.
  • Trial Balance Check: Compare the legacy system's Trial Balance with the imported G/L balances. They must match to the penny.

4. The Cutover Weekend (Opening Balances)

This is the point of no return. The legacy system is frozen.

  • Post General Journals: Post the G/L opening balances.
  • Post Item Journals: Bring in current inventory quantities and values.
  • Post AR/AP Journals: Bring in open invoices. (Ensure the offset accounts balance against the G/L opening balances to avoid double-counting).

Struggling with Data Migration?

DataDaur provides expert data engineering to extract, clean, and transform your legacy data into Business Central safely.

Talk to our Migration Experts