ERP migration
Field-level mapping, validation, and rollback between NetSuite and Acumatica. We move data and schema; workflows are rebuilt natively in Acumatica.
NetSuite
Source
Acumatica
Destination
Compatibility
14 of 14
objects map 1:1 between NetSuite and Acumatica.
Complexity
BStandard
Timeline
48–72 hours
Overview
NetSuite and Acumatica share a similar ERP footprint — both handle financials, inventory, sales orders, and purchasing — but their data models diverge in how they represent entities and transactions. NetSuite uses a unified record structure with custom fields via SuiteScript and saved searches, while Acumatica uses an industry-standard relational schema with customizable screens and generic inquiries. The migration carries NetSuite's customers, vendors, chart of accounts, inventory items, projects, and transactional history into Acumatica's equivalent entities. Custom records (NetSuite Custom Records) map to Acumatica custom tables, and NetSuite custom fields migrate as user-defined fields on their parent entities. Saved searches require manual reconstruction as Acumatica Generic Inquiries, and NetSuite workflows or SuiteFlow automations do not migrate. FlitStack AI sequences the migration to respect Acumatica's import-by-scenario tool, which requires understanding field-level structure before upload. We deliver a schema preparation plan so your Acumatica instance has the right screen customizations and user-defined fields in place before data lands.
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 NetSuite 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.
NetSuite
Customer
Acumatica
Customer
1:1NetSuite Customer records map directly to Acumatica Customers. NetSuite's subsidiary and territory assignments translate to Acumatica Customer Class and Branch assignments. Primary contact details (name, email, phone) transfer directly; multi-address records are preserved as separate Customer Locations in Acumatica. Addressee and print-on-check information also transfer, and customer-specific pricing maps to Acumatica's customer price classes.
NetSuite
Vendor
Acumatica
Vendor
1:1NetSuite Vendor records map to Acumatica Vendors. Tax ID fields and 1099 flags translate to Acumatica tax settings on the vendor record. Multi-address vendor records become separate Vendor Locations in Acumatica. 1099 flags map to Acumatica tax settings on the vendor record. Payment hold status and default payment account assignments also transfer to maintain vendor payment preferences in the target system.
NetSuite
Employee
Acumatica
Employee
1:1NetSuite Employee records map to Acumatica Employees. E-mail address is the matching key for owner resolution. Inactive employees in NetSuite can be mapped as inactive in Acumatica or excluded based on your migration scope. Department and location assignments transfer as Employee Department and Branch references, preserving the organizational reporting structure across the migration.
NetSuite
Item (Inventory Part)
Acumatica
Stock Item
1:1NetSuite Inventory Part items map to Acumatica Stock Items. The item number, description, base price, and units of measure transfer directly. NetSuite's units types map to Acumatica's Unit of Measure setup on the Stock Item. Item class assignments translate to Acumatica Item Class, and any custom fields prefixed custitem become user-defined fields on the Stock Item DAC.
NetSuite
Item (Non-Inventory Part)
Acumatica
Non-Stock Item
1:1NetSuite Non-Inventory Part items map to Acumatica Non-Stock Items. These are used for services or materials not tracked in inventory. The item number and description transfer; pricing fields map where applicable. Non-stock items typically represent service items, expense items, or job materials that are expensed or invoiced without inventory tracking requirements.
NetSuite
Item (Kit/Bundled)
Acumatica
Kit / Stock Item with bill of materials
1:1NetSuite Kit items with component lists map to Acumatica Stock Items with an attached bill of materials (BOM). The kit header becomes the parent stock item, and each component is created as a BOM line. This requires BOM setup in Acumatica before the migration run.
NetSuite
Account (Chart of Accounts)
Acumatica
Account
1:1NetSuite Chart of Accounts records map directly to Acumatica Accounts. Account number, name, type (Bank, Expense, Income, Asset, Liability), and inactive flag transfer. NetSuite's accounts are scoped to a single book; multi-book configurations require separate account mapping per book. Account currency settings and intercompany account flags also transfer to preserve the full financial structure.
NetSuite
Customer Payment
Acumatica
Payment
1:1NetSuite Customer Payments map to Acumatica Payments applied to AR Invoices. The payment amount, date, reference number, and applied invoice details transfer. Undeposited funds require mapping to an Acumatica Cash account. Payment method (check, credit card, EFT) maps to Acumatica Payment Method, and the deposit ticket reference transfers as a document reference on the payment record.
NetSuite
Vendor Bill
Acumatica
AP Bill
1:1NetSuite Vendor Bills map to Acumatica AP Bills. Header fields (vendor, date, reference, amount) and line items (account, amount, description) transfer. Line-level tax codes are mapped to Acumatica tax zone configurations. 1099 flags and amounts also transfer to preserve vendor tax reporting requirements in the target system.
NetSuite
Sales Order
Acumatica
Sales Order
1:1NetSuite Sales Orders map to Acumatica Sales Orders. Customer, date, line items, quantities, and prices transfer directly. Order status (Pending Fulfillment, Cancelled) maps to Acumatica's order status field. FulfillmentWarehouse assignments and shipment priority flags also transfer to preserve the full sales order fulfillment context in Acumatica.
NetSuite
Invoice (AR Invoice)
Acumatica
AR Invoice
1:1NetSuite AR Invoices map to Acumatica AR Invoices. Line items, amounts, descriptions, and tax amounts transfer. NetSuite's billing schedule attachments are preserved as document attachments in Acumatica. Invoice-level discounts and payment terms also map to ensure the complete billing lifecycle transfers correctly to the target system.
NetSuite
Custom Record (Custom Record Type)
Acumatica
Custom Table (DAC)
1:1NetSuite Custom Record Types map to Acumatica custom tables created via the Customization Project editor. Each custom field on the NetSuite record becomes a user-defined field (UDF) on the Acumatica custom table. Parent-child relationships between custom records may require junction tables in Acumatica.
NetSuite
Saved Search (definition export)
Acumatica
Generic Inquiry
1:1NetSuite Saved Searches are definition exports only — the query logic does not execute in Acumatica. We export the Saved Search definition as a reference document. Acumatica Generic Inquiries must be rebuilt manually or with consultant assistance. This is disclosed upfront as a rebuild item.
NetSuite
Project (SuiteProjects)
Acumatica
Project
1:1NetSuite SuiteProjects Pro project records map to Acumatica Projects. Project ID, name, status, customer association, budget, and task hierarchy transfer. Time entries and resource assignments migrate as Project Tasks and labor allocations. Project-specific custom fields become UDFs on the Acumatica Project entity.
| NetSuite | Acumatica | Compatibility | |
|---|---|---|---|
| Customer | Customer1:1 | Fully supported | |
| Vendor | Vendor1:1 | Fully supported | |
| Employee | Employee1:1 | Fully supported | |
| Item (Inventory Part) | Stock Item1:1 | Fully supported | |
| Item (Non-Inventory Part) | Non-Stock Item1:1 | Fully supported | |
| Item (Kit/Bundled) | Kit / Stock Item with bill of materials1:1 | Fully supported | |
| Account (Chart of Accounts) | Account1:1 | Fully supported | |
| Customer Payment | Payment1:1 | Fully supported | |
| Vendor Bill | AP Bill1:1 | Fully supported | |
| Sales Order | Sales Order1:1 | Fully supported | |
| Invoice (AR Invoice) | AR Invoice1:1 | Fully supported | |
| Custom Record (Custom Record Type) | Custom Table (DAC)1:1 | Fully supported | |
| Saved Search (definition export) | Generic Inquiry1:1 | Fully supported | |
| Project (SuiteProjects) | Project1: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.
NetSuite gotchas
API concurrency limits gate extraction throughput
Subsidiary-to-company mapping is structural, not cosmetic
Service tier transaction-line limits block migration mid-flight
Custom records and custom fields have no standard schema
Historical journal entries require strict sequencing
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
Assess NetSuite schema and Acumatica target configuration
We connect to your NetSuite account using scoped read access and inventory every record type, custom field, custom record type, saved search, and workflow definition. Simultaneously, we review your target Acumatica configuration (organizations, chart of accounts, tax zones, item classes, and custom tables). We deliver a Schema Preparation Plan that specifies which Acumatica entities and user-defined fields need to be created before data import begins. This step typically takes 2–4 days and produces the blueprint your Acumatica administrator uses to stand up the target schema.
Build data extraction jobs for master data before transactions
We build NetSuite data extraction jobs using Saved Searches for customers, vendors, employees, chart of accounts, and items. Each extraction runs against NetSuite's API with pagination and rate-limit handling to ensure complete record retrieval. For Acumatica, we load master data (accounts, customers, vendors, items) first because transactional records reference these as foreign keys. If your NetSuite instance uses multiple subsidiaries, we extract subsidiary-level account hierarchies and map them to Acumatica organizations. This step produces an ordered load sequence that respects Acumatica's import dependency chain.
Run sample migration with field-level diff
A representative slice of records — typically 100–500 across customers, vendors, items, and 50–100 transaction lines — migrates first. We generate a field-level diff comparing the NetSuite source values against what landed in Acumatica, with color-coded mismatches for review. This validates mapping logic for custom fields, value mappings for pick-lists, and date/timestamp preservation before committing the full dataset. Your team reviews the sample diff and approves field mapping logic before the full migration run is scheduled.
Execute full migration with dependency-ordered load sequence
The full migration runs in dependency order: chart of accounts first, then customers and vendors, then items, then transactional records (sales orders, invoices, bills, payments, journal entries). NetSuite custom records load after their parent standard records. We batch records to respect Acumatica's import-by-scenario tool limits and apply delta-pickup at the end to capture any records modified in NetSuite during the cutover window. Audit logging tracks every record written, with rollback capability if reconciliation identifies unexpected data gaps.
Delta-pickup window and go-live reconciliation
A 24–48 hour delta-pickup window captures any NetSuite records created or modified after the main migration run snapshot was taken. During this window, your team continues working in NetSuite. After the delta is applied to Acumatica, we run a reconciliation report comparing record counts, transaction totals, and customer balances between systems. One-click rollback is available if reconciliation fails a pre-defined threshold. Once your team confirms the Acumatica data matches expectations, you go live and NetSuite access can be decommissioned.
Platform deep dives
NetSuite
Source
Strengths
Weaknesses
Acumatica
Destination
Strengths
Weaknesses
Complexity grading
Standard ERP migration. 1 of 8 objects need a mapping; the rest are 1:1.
Overall complexity
Standard migration
Derived from compatibility, mapping clarity, API constraints, and data volume across NetSuite and Acumatica.
Object compatibility
1 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
NetSuite: 15 concurrent requests (default); up to 55 on Tier 5 with SuiteCloud Plus; 1,000 records per request; 60-second and 24-hour frequency windows per account.
Data volume sensitivity
NetSuite 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 NetSuite to Acumatica migration scoping. Not seeing yours? Book a call.
Walk through your NetSuite 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 NetSuite
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.