Acumatica· Data mapping
Overview
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

Acumatica data mapping

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

Start an Acumatica projectTalk to us

How this step works

What the agent does

  • Proposes field mappings and value translations from the source structure to Acumatica.
  • 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 Acumatica mapping decisions

  1. 01

    Accounts versus subaccounts

    Map each legacy segment to an account, a subaccount segment or an attribute. Keep only the segments the client needs for reporting.

  2. 02

    Classes carry the defaults

    Customer, vendor and item classes set accounts, terms and other defaults. Map records to classes instead of setting defaults on each record.

  3. 03

    Numbering

    Decide where legacy numbers must survive, such as customer and invoice numbers, and set the numbering sequences to match.

From Acumatica partners
18
ERP implementation firms in Pine Services Group
10,000+
customers served by those firms

Through Pine Services Group, work is underway with i-Tech, an Acumatica partner.

Read the announcement

Frequently asked questions

What are the key Acumatica mapping decisions?

Accounts versus subaccounts; Classes carry the defaults; Numbering. 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 Acumatica?

Common sources are Microsoft Dynamics GP, QuickBooks, Sage 100, MYOB 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 Acumatica project. Connect the client's systems, give the agent the statement of work, and run the first steps together with us.