ERP migration

Migrate from JD Edwards World to Acumatica

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 logo

JD Edwards World

Source

Acumatica

Destination

Acumatica logo

Compatibility

100%

12 of 12

objects map 1:1 between JD Edwards World and Acumatica.

Complexity

BStandard

Timeline

3–6 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

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.

Field-level fidelity

Every standard and custom field arrives verified.

Schema-aware mapping

AI proposes the map; you confirm before any record moves.

Relationships preserved

Parent–child, lookups, and ownership stay linked.

Full activity history

Calls, emails, meetings — with original timestamps.

Attachments & notes

Documents, uploads, and inline notes move with the record.

Why teams make this switch

Two sides of the same decision

Leaving

JD Edwards World logo

JD Edwards World

What's pushing teams away

  • JD Edwards World runs exclusively on IBM AS/400 hardware that is expensive to maintain, difficult to scale, and increasingly hard to find qualified administrators for as the workforce retires.
  • The user interface is terminal-based and visually dated compared to modern cloud ERPs, making it difficult to attract new employees who expect contemporary software experiences and self-service capabilities.
  • Oracle's Named User Plus licensing model means that as companies grow and add employees who need system access, licensing costs scale in ways that become difficult to predict or control.
  • Support for older World versions (A7.3, A8.1, A9.1) has become increasingly expensive as Oracle narrows its focus to EnterpriseOne, and third-party support providers are harder to find.
  • Integration with modern SaaS tools, API-first applications, and real-time data pipelines is either unavailable or requires expensive middleware that was never part of the original architecture.

Choosing

Acumatica logo

Acumatica

What's pulling them in

  • Unlimited user licensing lets companies add staff without per-seat billing shocks, making Acumatica cost-predictable at scale.
  • Flexibility and scalability earn consistent praise — users value a platform that adapts to vertical workflows without forcing a redesign.
  • Real-time visibility across financials, inventory, and projects gives mid-market businesses a consolidated operational view previously available only in enterprise-tier ERPs.
  • Cloud-native architecture with automatic updates removes infrastructure management burden from in-house IT teams.
  • Modular licensing lets companies start with one or two suites (Financials, Distribution) and expand into Manufacturing or CRM incrementally.

Object mapping

How JD Edwards World objects map to Acumatica

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

maps to

Acumatica

Customer / Vendor / Employee (shared contact)

1:1
Fully supported

JDE 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

maps to

Acumatica

Customer

1:1
Fully supported

JDE 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

maps to

Acumatica

Vendor

1:1
Fully supported

JDE 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

maps to

Acumatica

GL Transaction (Batch → Transaction)

1:1
Fully supported

JDE 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

maps to

Acumatica

Account (Chart of Accounts)

1:1
Fully supported

JDE 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)

maps to

Acumatica

InventoryItem

1:1
Fully supported

JDE 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

maps to

Acumatica

SalesOrder (SO301000 screen)

1:1
Fully supported

JDE 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

maps to

Acumatica

PurchaseOrder (PO301000 screen)

1:1
Fully supported

JDE 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

maps to

Acumatica

ARInvoice (AR301000 screen)

1:1
Fully supported

JDE 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

maps to

Acumatica

APInvoice (AP301000 screen)

1:1
Fully supported

JDE 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

maps to

Acumatica

FixedAsset

1:1
Fully supported

JDE 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)

maps to

Acumatica

Custom Fields (Usr* UDFs) or Custom DACs

1:1
Fully supported

JD 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.

Gotchas + challenges

What specifically takes care here

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 logo

JD Edwards World gotchas

High

Direct database access required for World migrations

High

Oracle Client version mismatch after database migration

High

Custom table modifications require manual conversion program updates

Medium

Account format (Object.Subsidiary) varies by company

Medium

Contract Billing limit processing must be preserved manually

Acumatica logo

Acumatica gotchas

High

API user licenses cap concurrent sessions and request throughput

High

Multi-tenant filtering requires CompanyID awareness

Medium

Custom fields require separate discovery before field mapping

Medium

Notes and attachments use a separate linked table structure

Low

Implementation timelines frequently run 3–9 months end-to-end

Pair-specific challenges

  • JDE World multi-company structure requires manual Acumatica branch setup before data lands

    JD Edwards World separates legal entities and cost centers using the CO (Company) code and MCU (Business Unit) fields embedded in every transaction record. Acumatica models this split using Branches and separate Company tenants. Before any GL data can import, your Acumatica admin must pre-create a Branch for each unique MCU in the JDE dataset. If you have five JDE companies, you need five Acumatica Branches configured with the correct fiscal year settings and GL account segment mappings. We deliver a branch-mapping plan as part of the schema discovery phase so the Acumatica side is ready before any data moves.

  • JDE World fiscal year periods use date-effective accounting and may not align with Acumatica's fiscal calendar

    JD Edwards World controls accounting periods through the Date-Effective Accounting feature — the fiscal year is determined by the transaction date (DICJ) and the fiscal date pattern defined in F0008, which can be 12-period, 13-period, or a custom pattern. Acumatica uses Financial Year settings configured per tenant with a defined start date and period count. Transactions from a JDE 13-period calendar cannot automatically land in a 12-period Acumatica fiscal year without period reclassification. We flag fiscal date pattern mismatches during schema discovery and propose either an Acumatica fiscal calendar reconfiguration or a custom UsrFiscalPeriod custom field to preserve the JDE period assignments as reference data.

  • Custom Z-fields and modified Z-tables require explicit schema mapping and Acumatica custom field creation

    JD Edwards World customers commonly extend standard tables with Z-fields — additional columns added to F0101, F0911, and other tables by CNC (Configuration, Network, and Change) administrators. These fields are stored in the same DB2/400 table and carry business-critical data (industry-specific codes, legacy tracking fields) that has no native Acumatica equivalent. The Acumatica Customization Project editor (accessed from the Customization Projects screen) lets administrators create new UDF fields prefixed with Usr before the migration run. We discover all Z-fields during schema audit, map each to a corresponding Acumatica UsrField, and create the fields in Acumatica before the data load. Custom JDE tables (F55xxx) that are entirely customer-built migrate as Acumatica custom Data Access Classes (DACs) with their own screens.

  • UBE batch jobs and approval workflows do not map to Acumatica automation and must be rebuilt

    JD Edwards World automates business processes through UBE (Universal Batch Engine) programs, approval routing chains, and workflow definitions stored in OMW (Object Management Workbench). These automation artifacts are compiled programs on the AS/400 that reference JDE-specific data structures — they have no equivalent in Acumatica. Acumatica handles automation through screen-level workflows, Generic Inquiries (Saved Searches), and business events configured in the Automation Schedules screen. We export the complete list of active JDE workflows and UBE schedules as a rebuild reference document for your Acumatica implementation team. Report outputs (PDF, CSV) that currently come from JDE UBEs can be replicated using Acumatica's Report Designer after migration.

  • JDE World document numbers and batch numbers are not auto-incremented in Acumatica — reference fields must be pre-populated

    JD Edwards World generates document numbers through Next Numbers (N0001–N0009 system) and stores them per document type. Acumatica's auto-numbering uses Numbering Sequences configured in the TX205000 (Numbering Sequences) screen. To preserve financial audit continuity — so auditors can find the same JDE invoice number in Acumatica — the migration must load records with the original JDE document number in Acumatica's ReferenceNbr field. Numbering sequences in Acumatica must be set to Manual or the system will assign its own next number, causing a primary-key conflict on insert. We configure the appropriate Numbering Sequences for each document type before the load phase runs.

Migration approach

Six steps for a successful JD Edwards World to Acumatica data migration

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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

Context on both ends of the pair

JD Edwards World logo

JD Edwards World

Source

Strengths

  • Rock-solid stability on IBMi with decades of proven uptime in manufacturing and distribution environments
  • Deep modularity with 80+ application modules covering financials, supply chain, manufacturing, and HR
  • Flexible deployment options including on-premise, private cloud, public cloud, or hybrid configurations
  • Strong support for multi-company, multi-currency, and complex organizational structures
  • Predictable long-term licensing under Oracle Applications Unlimited through at least 2036

Weaknesses

  • Terminal-based green screen interface that requires significant user training and creates adoption friction
  • No native REST or SOAP API on World versions, requiring direct database access for integrations
  • High total cost of ownership driven by Named User Plus licensing and IBMi hardware requirements
  • Steep implementation complexity requiring specialized consultants and multi-year deployment cycles
  • Limited modern analytics and BI capabilities compared to cloud-native ERP competitors
Acumatica logo

Acumatica

Destination

Strengths

  • Unlimited named-user licensing eliminates per-seat cost scaling as teams grow.
  • Modular architecture lets companies deploy Financials first and add Distribution, Manufacturing, or CRM incrementally.
  • Cloud-native with automatic updates removes infrastructure patching and version management from IT responsibilities.
  • Flexible customization framework (UDFs, extensions) supports vertical-specific workflows without forking core code.
  • Multi-tenant architecture with CompanyID isolation enables safe data segregation across subsidiaries.

Weaknesses

  • Steep learning curve and complex initial setup create significant onboarding friction.
  • Report Designer is widely cited as unintuitive and difficult to use for non-developers.
  • Feature gaps require customizations or third-party add-ons, adding implementation cost and complexity.
  • Implementation timelines frequently exceed initial estimates, especially for multi-module deployments.
  • API rate limits and concurrent session caps are tied to license tier, creating throughput constraints for bulk data operations.

Complexity grading

How hard is this migration?

Standard ERP migration. 1 of 8 objects need a mapping; the rest are 1:1.

B

Overall complexity

Standard migration

Derived from compatibility, mapping clarity, API constraints, and data volume across JD Edwards World and Acumatica.

  • Object compatibility

    B

    1 of 8 objects need a mapping; the rest are 1:1.

  • Field mapping clarity

    C

    Field mapping is derived from defaults — final spec confirmed during the sample migration.

  • Timeline complexity

    B

    8-object category — typical timelines run 2–7 days end-to-end.

  • API constraints

    B

    JD Edwards World: Not applicable.

  • Data volume sensitivity

    B

    JD Edwards World doesn't expose a bulk API — REST + parallelization used for high-volume runs.

Estimator

Estimate your JD Edwards World to Acumatica migration cost

Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.

Step 1

What are you migrating?

Pick a category, then your source and destination platforms.

Category

FAQ

Frequently asked questions about JD Edwards World to Acumatica data migrations

Answers to the questions buyers ask most during JD Edwards World to Acumatica migration scoping. Not seeing yours? Book a call.

Can't find your answer?

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 consultation

A typical JD Edwards World to Acumatica migration runs 3–6 weeks of clock time for under 100,000 source records with standard master data and one JDE company code. Larger setups with multi-company MCU structures, more than 1 million GL ledger lines (F0911), or extensive custom Z-table dependencies extend to 8–14 weeks. The longest single phase is usually the GL transaction history migration in date-range slices, which requires balance verification after each annual period. Schema discovery and Acumatica configuration preparation run in parallel and can compress the overall timeline.

Adjacent paths

Related migrations to explore

Ready when you are

Move from JD Edwards World.
Land in Acumatica, intact.

Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.

Accuracy guarantee Rollback included Quote in 1 business day