ERP migration
Field-level mapping, validation, and rollback between JD Edwards World and Acumatica. We move data and schema; workflows are rebuilt natively in Acumatica.
JD Edwards World
Source
Acumatica
Destination
Compatibility
12 of 12
objects map 1:1 between JD Edwards World and Acumatica.
Complexity
BStandard
Timeline
3–6 weeks
Overview
JD Edwards World runs on IBM iSeries (AS/400) using a green-screen terminal interface and stores data in DB2/400 tables structured around business units, document types, and fiscal date patterns that Acumatica does not replicate natively. Acumatica organizes data around Customers, Vendors, GL Accounts, Inventory Items, Projects, and Cases with a REST API and user-defined fields (UDFs) that support custom schemas. FlitStack AI extracts data from JD Edwards World via direct database reads from the IBM i (or via JDE-published APIs for supported versions), maps F0101 address-book records into Acumatica Customers and Vendors, maps F0911 account ledger lines into Acumatica GL Transactions, and maps F0301 (Customer Master) and F0401 (Vendor Master) into the appropriate Acumatica entities. We preserve original document numbers, batch numbers, fiscal periods, and user-entered dates as Acumatica custom fields so financial historians survive the cutover. Workflows, approval routing, and UBE (Universal Batch Engine) programs do not migrate — we export their logic as rebuild references for your Acumatica implementation team. The migration uses a staged load: master data first (GL accounts, tax agencies, warehouses), then transaction history in date-range slices to stay within Acumatica's import API rate limits.
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 JD Edwards World 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.
JD Edwards World
F0101 — Address Book
Acumatica
Customer / Vendor / Employee (shared contact)
1:1JDE World F0101 is the master contact record for customers, vendors, employees, and prospects. Acumatica splits these into separate entities (Customer, Vendor, Employee) with their own schemas. We map ABAN8 (address number) to the respective entity's internal ID and create separate Acumatica records for each role a JDE contact plays. Contact details (name, address, phone) map 1:1; payment terms and credit limits migrate as entity-specific fields.
JD Edwards World
F0301 — Customer Master
Acumatica
Customer
1:1JDE World F0301 stores the customer-specific fields: credit limits (CRLM), payment terms (PTC), ship-to defaults (SHAN), and parent customer (PAN8). Acumatica Customer carries all equivalent fields natively (CreditLimit, PaymentTerms, DefaultWarehouse). Parent-child customer hierarchy in JDE (where a parent AN8 controls billing for child accounts) maps to Acumatica's CustomerLocation parent link structure, preserving organizational relationships.
JD Edwards World
F0401 — Vendor Master
Acumatica
Vendor
1:1JDE World F0401 holds vendor-specific data: 1099 flag, W-9 status, TIN number, and default expense accounts. Acumatica Vendor carries TaxID, 1099 box settings, and default accounts natively. We preserve the JDE vendor number (AN8) in Vendor's ExternalRef field for cross-system traceability.
JD Edwards World
F0911 — Account Ledger
Acumatica
GL Transaction (Batch → Transaction)
1:1JDE World F0911 is the core journal entry table with document type (DCT), document number (DOCM), company (CO), and amount fields (AAmount, BAmount per distribution). Acumatica stores GL transactions under a Batch (BatchModule, BatchNbr) linked to individual Transactions (AccountID, DebitAmt, CreditAmt). We preserve JDE batch numbers and document numbers in Acumatica's BatchNbr and reference fields.
JD Edwards World
F0901 — Account Master
Acumatica
Account (Chart of Accounts)
1:1JDE World F0901 defines the chart of accounts: account number (GLBA), description (GLDS), account type (TPYE), and active flag. Acumatica Account carries AccountCD, Description, AccountType, and Active flag natively. Multi-company account structures (4-digit company + 6-digit account) collapse to Acumatica's flat 10-character account code or map to the segment schema depending on Acumatica configuration.
JD Edwards World
F4111 — Item Master (Inventory)
Acumatica
InventoryItem
1:1JDE World F4111 stores item master records: item number (LITM/IMID), description, unit of measure (UM), cost method (CMCZ), and stocking type. Acumatica InventoryItem carries StockItem flag, Description, BaseUnit, and ValuationMethod natively. JDE unit-of-measure conversions migrate as Acumatica UnitOfMeasure records with conversion factors.
JD Edwards World
F4211 — Sales Order Header
Acumatica
SalesOrder (SO301000 screen)
1:1JDE World F4211 stores sales order headers: order number (DOCO), customer (AN8), order type (DCTO), status (DLTX), and totals. Acumatica SalesOrder carries OrderNbr, CustomerID, OrderType, Status, and line items. JDE document number (DOCO) is preserved in Acumatica's ReferenceNbr field. Open and completed orders are migrated with status mapping based on JDE line status codes.
JD Edwards World
F4311 — Purchase Order
Acumatica
PurchaseOrder (PO301000 screen)
1:1JDE World F4311 holds purchase order records: PO number, vendor, order type, and line items with receipt and invoicing data. Acumatica PurchaseOrder mirrors this structure with OrderType, VendorRef, and POLine. We map JDE line status codes to Acumatica status values and preserve the original PO number in ReferenceNbr.
JD Edwards World
F03B11 — AR Invoice
Acumatica
ARInvoice (AR301000 screen)
1:1JDE World F03B11 stores accounts receivable invoices: invoice number, customer, invoice date, due date, and amount. Acumatica ARInvoice carries DocType, CustomerID, DocDate, DueDate, and CuryOrigDocAmt natively. JDE document number preserved in ReferenceNbr; JDE aging buckets map to Acumatica's terms-based due date calculation.
JD Edwards World
F04B11 — AP Invoice
Acumatica
APInvoice (AP301000 screen)
1:1JDE World F04B11 stores accounts payable invoices: vendor invoice number, vendor, invoice date, and amount. Acumatica APInvoice mirrors with VendorRef, DocDate, and CuryOrigDocAmt. The original JDE vendor invoice number (INVT) is preserved in Acumatica's InvoiceNbr field. Tax codes on JDE invoices migrate as TaxCategory references on Acumatica AP lines, and payment hold status translates to Acumatica's hold flag settings.
JD Edwards World
F1201 — Equipment Master
Acumatica
FixedAsset
1:1JDE World F1201 stores fixed-asset records: asset number, acquisition date, depreciation method, and NBV. Acumatica FixedAsset carries asset identification and depreciation settings natively, but JDE asset-specific fields (property type, location codes, insurance policy) require Acumatica custom fields (UsrAssetPropertyType, UsrLocationCode) created before migration.
JD Edwards World
Custom Z-Tables (customer-modified JDE tables)
Acumatica
Custom Fields (Usr* UDFs) or Custom DACs
1:1JD Edwards World customers frequently add Z-fields to standard tables for industry-specific tracking. These Z-fields are discovered during the schema audit phase and mapped to Acumatica custom fields (UsrFieldName) on the matching entity. Custom JDE table structures (F55xxx) that have no Acumatica equivalent are migrated as Acumatica custom DACs with junction relationships.
| JD Edwards World | Acumatica | Compatibility | |
|---|---|---|---|
| F0101 — Address Book | Customer / Vendor / Employee (shared contact)1:1 | Fully supported | |
| F0301 — Customer Master | Customer1:1 | Fully supported | |
| F0401 — Vendor Master | Vendor1:1 | Fully supported | |
| F0911 — Account Ledger | GL Transaction (Batch → Transaction)1:1 | Fully supported | |
| F0901 — Account Master | Account (Chart of Accounts)1:1 | Fully supported | |
| F4111 — Item Master (Inventory) | InventoryItem1:1 | Fully supported | |
| F4211 — Sales Order Header | SalesOrder (SO301000 screen)1:1 | Fully supported | |
| F4311 — Purchase Order | PurchaseOrder (PO301000 screen)1:1 | Fully supported | |
| F03B11 — AR Invoice | ARInvoice (AR301000 screen)1:1 | Fully supported | |
| F04B11 — AP Invoice | APInvoice (AP301000 screen)1:1 | Fully supported | |
| F1201 — Equipment Master | FixedAsset1:1 | Fully supported | |
| Custom Z-Tables (customer-modified JDE tables) | Custom Fields (Usr* UDFs) or Custom DACs1: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.
JD Edwards World gotchas
Direct database access required for World migrations
Oracle Client version mismatch after database migration
Custom table modifications require manual conversion program updates
Account format (Object.Subsidiary) varies by company
Contract Billing limit processing must be preserved manually
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
Schema discovery and source audit on the IBM i
FlitStack AI connects directly to the JDE World IBM iSeries database using ODBC or native DB2/400 access to read the system catalog. We inventory every table referenced in the JDE World environment: standard tables (F0101, F0301, F0911, etc.), custom Z-fields on those tables, and standalone custom tables (F55xxx). We document MCU-to-company mappings, fiscal date patterns from F0008, and next-number settings from N0001. The output is a Source Data Map: a complete list of tables, row counts, and field definitions that will feed the Acumatica mapping plan. This phase typically takes 3–5 business days and requires read-only DB access on the AS/400.
Acumatica schema preparation and custom field creation
Before data loads, your Acumatica admin (or our team) creates the necessary entities, branches, number sequences, and custom fields in Acumatica. Based on the Source Data Map, we deliver an Acumatica setup plan that includes: branch creation for each JDE MCU, chart of accounts import using the GL Accounts screen, customer class and vendor class definitions, and all Usr-prefix custom fields for Z-field equivalents. Numbering sequences for each document type are set to Manual or External so JDE document numbers are preserved on import. This step runs in parallel with schema discovery and typically takes 1–2 weeks depending on Acumatica configuration complexity.
Master data migration: GL accounts, customers, vendors, and inventory items
We sequence the migration so master data loads before transaction history. The order is: GL accounts (F0901) → tax agencies and payment terms (F0008/F0006) → customers (F0101/F0301) → vendors (F0101/F0401) → inventory items (F4111). Each entity is extracted from the JDE World DB2/400 tables, transformed according to the field mapping plan, and loaded into Acumatica via the REST API or Direct SQL insert for high-volume tables. Original JDE account numbers, customer numbers, and vendor numbers are stored in Acumatica's ExternalRef fields for cross-system traceability. Unmatched parent records (e.g., a JDE customer whose parent doesn't exist) are flagged and resolved before moving to the next entity.
Transaction history migration in date-range slices
GL transactions (F0911), open sales orders (F4211), open purchase orders (F4311), and AR/AP records (F03B11/F04B11) are migrated in date-range batches to manage API volume and preserve audit continuity. We begin with the current fiscal year and work backward in annual slices. Each batch is validated against Acumatica's chart of accounts (no orphaned account codes), branch assignments (MCU → BranchID), and document type mappings (DCT → DocType). Validation reports are generated after each slice showing record counts, error counts, and a field-level sample comparison. GL balance verification — total debits minus total credits per account — is run after each batch to confirm account integrity before moving to the next period.
Sample migration with field-level diff and delta pickup
A representative sample (typically 500–2,000 records per entity type) migrates first against a staging Acumatica instance or a copy of your production tenant. We generate a field-level diff comparing source JDE World values against the Acumatica destination values for each mapped field. You review the diff and confirm that Z-field values, fiscal period assignments, document number references, and balance totals are correct. After sample sign-off, the full migration runs. A delta-pickup window (24–48 hours) captures any JDE World records created or modified during the cutover window. An audit log records every insert operation, and one-click rollback reverts the Acumatica tenant to its pre-migration state if reconciliation reveals unexpected discrepancies.
Platform deep dives
JD Edwards World
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 JD Edwards World 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
JD Edwards World: Not applicable.
Data volume sensitivity
JD Edwards World 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 JD Edwards World to Acumatica migration scoping. Not seeing yours? Book a call.
Walk through your JD Edwards World 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 JD Edwards World
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.