Business Central· Data mapping
OverviewMCP server
Pre-implementation
  1. Implementation plan
  2. Discovery
  3. Data assessment
  4. Solution design
Implementation
  1. Configuration
  2. Data mapping
  3. Data migration
  4. Testing and UAT
  5. Cutover
Post go-live
  1. Hypercare
  2. Handover
Step 6 of 11 · Implementation · Updated October 26, 2026

Business Central data mapping

Data mapping is where the business decisions of a Business Central migration are made. A mapping that copies the legacy structure one to one usually carries the legacy problems into Business Central. superglue's agent proposes field mappings and transformations, you decide the ambiguous cases, and the client signs transformed files before anything loads.

Start a Business Central projectTalk to us

How this step works

What the agent does

  • Proposes field mappings and value translations from the source structure to Business Central.
  • Lists the ambiguous cases and the records that cannot map, with counts.
  • Builds a client questionnaire for questions only the client can answer.
  • Produces transformed files for review.

What you decide and approve

  • The business meaning of ambiguous fields and codes.
  • What happens to records that cannot map.
  • When the mapping is ready for the client's signature.

What the client gets

  • A mapping report to sign.
  • Transformed files to review before the load.

Key Business Central mapping decisions

  1. 01

    Choose the two global dimensions carefully

    Business Central has two global dimensions that appear on every entry, and further shortcut dimensions. Put the most-used reporting values in the global ones.

  2. 02

    Posting groups decide the accounts

    Customer, vendor, item and general posting groups decide which G/L accounts a transaction hits. Map legacy classes to posting groups.

  3. 03

    Number series

    Decide where legacy document and customer numbers must survive, and set up the number series to match.

Frequently asked questions

What are the key Business Central mapping decisions?

Choose the two global dimensions carefully; Posting groups decide the accounts; Number series. The agent proposes an answer from the source data, and you confirm or change it.

Can the client review the mapping before anything loads?

Yes. The agent produces transformed files and a mapping report. The client signs the mapping, and the load uses exactly the signed mapping.

How does superglue work with our consultants?

superglue works alongside your team. The agent takes on the repetitive work, such as reading documents, drafting, mapping, loading and reconciling. Your consultants keep the client relationship and the decisions, and they approve every change to a client system.

Can we use our own implementation method?

Yes. Write your firm's method as a playbook, and every consultant and every session follows it. The documents the agent produces carry your firm's branding.

Which systems can we migrate from into Business Central?

Common sources are Microsoft Dynamics GP, Dynamics NAV, QuickBooks, Sage 50 and spreadsheets. The agent also reads Excel, CSV and XML exports and most systems with an API or a database.

Is client data safe?

superglue holds a SOC 2 Type 2 report and works under GDPR. Credentials are encrypted with AES-256. On the Enterprise plan, superglue can run on your own infrastructure.

How do we start?

Start with one live Business Central project. Connect the client's systems, give the agent the statement of work, and run the first steps together with us.