ERP migration
Field-level mapping, validation, and rollback between EQUAL and Acumatica. We move data and schema; workflows are rebuilt natively in Acumatica.
EQUAL
Source
Acumatica
Destination
Compatibility
9 of 10
objects map 1:1 between EQUAL and Acumatica.
Complexity
CModerate
Timeline
72–120 hours
Overview
EQUAL ERP stores financial data across a traditional relational model: separate customer and vendor master files, a segmented chart of accounts, inventory records keyed by item IDs, and open AR/AP transactions with aging buckets. Acumatica consolidates these into a Business Account model (one table for both customers and vendors), a unified Chart of Accounts with unlimited subaccount dimensions, and Inventory Items supporting both stock and non-stock types. The migration carries over all EQUAL master records, open invoices, historical balance totals, and custom fields using Acumatica's Import by Scenario tool and REST API endpoints. Workflows, automation rules, and scheduled processes do not migrate—they require rebuild using Acumatica's State Workflow Engine. FlitStack AI sequences the migration so foreign-key dependencies resolve in the correct order: GL accounts first, then subaccounts, then inventory items, then business accounts, then open transactions. A delta-pickup window captures any entries created during the cutover window so the final Acumatica state matches EQUAL's closing balance.
Every standard and custom field arrives verified.
AI proposes the map; you confirm before any record moves.
Parent–child, lookups, and ownership stay linked.
Calls, emails, meetings — with original timestamps.
Documents, uploads, and inline notes move with the record.
Why teams make this switch
Leaving
What's pushing teams away
Choosing
What's pulling them in
Object mapping
Each row shows how a EQUAL object lands in Acumatica, including any object-level transformations, lookup resolution, or schema-design dependencies.
Typical mapping — final map is confirmed during the sample migration step.
EQUAL
Customer Master
Acumatica
Business Account (BA.BusinessAccount)
1:1EQUAL's Customer Master maps to Acumatica's BusinessAccount with IsCustomer = true and IsVendor = false unless the entity also appears in Vendor Master. The CustomerID from EQUAL becomes the BA.BAccountID in Acumatica. Addresses and contact info map to BA.Address and BA.Contact records respectively.
EQUAL
Vendor Master
Acumatica
Business Account (BA.BusinessAccount)
1:1EQUAL vendors map to the same BusinessAccount table with IsVendor = true. When a single entity is both customer and vendor in EQUAL, Acumatica preserves this as one BA record with both flags set to true, which is the recommended configuration in Acumatica's vendor setup screen.
EQUAL
Chart of Accounts
Acumatica
Account + Subaccount
1:manyEQUAL's segmented account code splits into two fields in Acumatica: the leading segment becomes the Account.AccountCD, and the trailing segment(s) become Subaccount.SubaccountCD. The SubaccountMask in Company Setup determines which segments are active. Balance carryforward from EQUAL's period-end balances maps to GL.Batch entries with BatchType = 'VB' (Version Batch).
EQUAL
Inventory Item
Acumatica
InventoryItem
1:1EQUAL inventory items map directly to InventoryItem with ItemType determined by EQUAL's Item Type field: Stock items map to Stock, non-stock items map to Non-Stock, and service items map to Service. The InventoryID from EQUAL becomes InventoryItem.InventoryID in Acumatica. Unit of measure conversions require a UOM class to be defined in Acumatica first.
EQUAL
AR Invoice Header
Acumatica
AR Invoice (AR.SalesInvoice)
1:1Open EQUAL AR invoices map to AR.SalesInvoice with DocType = 'Invoice'. The EQUAL invoice number maps to the Reference Nbr field which Acumatica uses for cross-referencing to source documents. Line items map to AR.SalesInvoiceDetails with inventory ID lookups resolving to the Acumatica InventoryItem records created in Step 4.
EQUAL
AP Invoice Header
Acumatica
AP Bill (AP.Bill)
1:1Open EQUAL AP invoices map to AP.Bill with DocType = 'Bill'. EQUAL vendor invoice numbers become AP.Bill.RefNbr for matching against vendor statements. Line items map to AP.BillDetails with expense account lookups resolving to the Acumatica Account records created in Step 3.
EQUAL
Sales Order
Acumatica
SO.SalesOrder
1:1EQUAL open sales orders map to SO.SalesOrder with status Open. Completed or closed orders from EQUAL do not migrate as orders—they are archived; only their final revenue impact appears in GL. SO.SalesOrder.Cancelled status is set for orders with a Cancellation Date in EQUAL.
EQUAL
Purchase Order
Acumatica
PO.POOrder
1:1EQUAL open purchase orders map to PO.POOrder. The POStatus field determines whether the order appears as Open, PendingApproval, or Closed in Acumatica. Line receipts already processed in EQUAL do not recreate receiving transactions—they are reconciled through the migration's opening balance.
EQUAL
Custom Fields (Customer)
Acumatica
BusinessAccount extension table custom fields
1:1EQUAL custom fields on Customer Master (e.g., CreditLimit override, TerritoryCode, SalesRep) become custom fields on BA.BusinessAccount using Acumatica's Customization Project editor. Each custom field requires a corresponding attribute definition in Acumatica's Customization menu before the data import can reference it.
EQUAL
Payment Terms
Acumatica
CA.PaymentMethod
1:1EQUAL payment terms codes (Net 30, 2/10 Net 30, etc.) map to Acumatica's TermsID on AR/AP documents. A value-mapping table aligns each EQUAL terms code to the corresponding Terms record created in Acumatica during schema setup. Terms are defined in AP > Payment Methods > Terms.
| EQUAL | Acumatica | Compatibility | |
|---|---|---|---|
| Customer Master | Business Account (BA.BusinessAccount)1:1 | Fully supported | |
| Vendor Master | Business Account (BA.BusinessAccount)1:1 | Fully supported | |
| Chart of Accounts | Account + Subaccount1:many | Mapping required | |
| Inventory Item | InventoryItem1:1 | Fully supported | |
| AR Invoice Header | AR Invoice (AR.SalesInvoice)1:1 | Fully supported | |
| AP Invoice Header | AP Bill (AP.Bill)1:1 | Fully supported | |
| Sales Order | SO.SalesOrder1:1 | Fully supported | |
| Purchase Order | PO.POOrder1:1 | Fully supported | |
| Custom Fields (Customer) | BusinessAccount extension table custom fields1:1 | Fully supported | |
| Payment Terms | CA.PaymentMethod1:1 | Fully supported |
Gotchas + challenges
Platform-specific issues from each side, plus the pair-specific challenges that don't show up on either platform's page on its own.
EQUAL gotchas
No documented public API for self-service extraction
Regional tax and compliance baked into modules
One-time licensing model complicates cutover budgeting
Limited independent review data complicates customer-side validation
Acumatica gotchas
API user licenses cap concurrent sessions and request throughput
Multi-tenant filtering requires CompanyID awareness
Custom fields require separate discovery before field mapping
Notes and attachments use a separate linked table structure
Implementation timelines frequently run 3–9 months end-to-end
Pair-specific challenges
Migration approach
Source data extraction and schema profiling
FlitStack AI connects to EQUAL via its ODBC export interface and native report writer to extract all master files and open transaction records. We profile the data for duplicate records, missing foreign keys, and orphaned addresses. The profiling report identifies every EQUAL custom field, non-standard account code structure, and any vendor records that also appear as customers. This report drives the Acumatica schema setup checklist.
Acumatica schema setup and subaccount mask configuration
Your Acumatica admin (or our implementation team) configures the Acumatica Company record including the SubaccountMask, number sequences for AR/AP documents, payment methods, and terms codes. Each EQUAL custom field on customers, vendors, or inventory items gets a corresponding custom field definition in Acumatica's Customization menu. This setup step must complete before any data imports run because field existence is validated during import.
GL account and subaccount import with balance carryforward
EQUAL chart of accounts import first, decomposing segmented account codes per the SubaccountMask. GL account balances as of the cutover date are imported as Version Batches (BatchType='VB') in Acumatica GL so the opening balances appear in financial reports without being double-counted in the current period. We validate that debits equal credits after the balance batch posts before proceeding.
Master record import (business accounts, inventory items, contacts)
EQUAL customers and vendors import into BA.BusinessAccount with the IsCustomer and IsVendor flags set correctly. Inventory items import with ItemType and UOM class assignment. Contact records are linked to their parent BusinessAccount via the BAccountID relationship. During this step we run de-duplication logic for entities that appear in both EQUAL's customer and vendor tables.
Open transaction import and sample migration validation
Open AR invoices, AP bills, sales orders, and purchase orders import with Reference Nbr values prefixed by source system code. A representative sample of 200–500 records across all entity types is validated first, generating a field-level diff report that your team reviews against the source EQUAL records. Discrepancies in amounts, dates, or account assignments are corrected in the mapping before the full migration runs.
Cutover delta pickup and post-migration reconciliation
The full migration commits to Acumatica. A 24–48 hour delta-pickup window captures any invoices, payments, or inventory transactions created in EQUAL during the cutover. FlitStack AI generates a reconciliation report comparing total AR balance, total AP balance, and inventory on-hand between EQUAL and Acumatica. If any balance sheet account is out of tolerance (default: $0.01), one-click rollback is available to reset the Acumatica data and re-run.
Platform deep dives
EQUAL
Source
Strengths
Weaknesses
Acumatica
Destination
Strengths
Weaknesses
Complexity grading
Moderate ERP migration. 8 of 8 objects need a mapping; the rest are 1:1.
Overall complexity
Moderate migration
Derived from compatibility, mapping clarity, API constraints, and data volume across EQUAL and Acumatica.
Object compatibility
8 of 8 objects need a mapping; the rest are 1:1.
Field mapping clarity
Field mapping is derived from defaults — final spec confirmed during the sample migration.
Timeline complexity
8-object category — typical timelines run 2–7 days end-to-end.
API constraints
EQUAL: Not publicly documented.
Data volume sensitivity
EQUAL doesn't expose a bulk API — REST + parallelization used for high-volume runs.
Estimator
Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.
Step 1
Pick a category, then your source and destination platforms.
Category
FAQ
Answers to the questions buyers ask most during EQUAL to Acumatica migration scoping. Not seeing yours? Book a call.
Walk through your EQUAL to Acumatica migration with a real engineer — 30 minutes, free, written quote within 24 hours.
Book a free 30 minute consultationAdjacent paths
Other ways to leave EQUAL
Other ways to arrive at Acumatica
Ready when you are
Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.