ERP migration

Migrate from JD Edwards World to Microsoft Dynamics 365 Business Central

Field-level mapping, validation, and rollback between JD Edwards World and Microsoft Dynamics 365 Business Central. We move data and schema; workflows are rebuilt natively in Microsoft Dynamics 365 Business Central.

JD Edwards World logo

JD Edwards World

Source

Microsoft Dynamics 365 Business Central

Destination

Microsoft Dynamics 365 Business Central logo

Compatibility

92%

11 of 12

objects map 1:1 between JD Edwards World and Microsoft Dynamics 365 Business Central.

Complexity

BStandard

Timeline

6-10 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

Migrating from JD Edwards World to Microsoft Dynamics 365 requires bridging a 40-year-old IBMi flat-file architecture with a modern cloud ERP that has no native ingestion path for AS/400 RPG table files. We connect directly to the IBMi database to read F-prefixed World physical files (F0101, F0911, F0901, F4311, F4211, F4801, F4101, F4111, F0301, F0401, F060116), normalize the fixed-field records into typed Dynamics 365 entities, and load through Business Central's OData API or Dynamics 365 Finance and Supply Chain Management's Data Management framework. The account structure mapping is the highest-risk step: World's Object.Subsidiary format varies per company code, while Dynamics 365 uses a rigid Chart of Accounts hierarchy that must be validated by the customer's finance team before any GL load. Multi-currency configurations, fiscal period definitions, and government contract billing limits do not migrate automatically; we extract the source values and document the target-side configuration required to replicate them. Workflows, UBE reports, and custom table files (Z-prefixed) are explicitly excluded from automated migration scope. We deliver a written inventory of every active World program, custom table, and automation requiring rebuild so the customer's implementation team has a concrete action list before go-live.

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

Microsoft Dynamics 365 Business Central logo

Microsoft Dynamics 365 Business Central

What's pulling them in

  • Deep integration with Microsoft 365, Power BI, and Power Platform means organizations already on the Microsoft stack get identity, reporting, and workflow continuity out of the box.
  • Unified financials, sales, service, and operations replace multiple disconnected systems — users report that data entered once flows through purchase orders, invoicing, and approvals without manual re-entry.
  • Copilot AI features (predictive analytics, embedded business intelligence) are included in both Essentials and Premium tiers, addressing demand for AI without separate module purchases.
  • Named-user licensing with no concurrent model appeals to organizations that want predictable per-seat costs even if some users access the system infrequently.
  • Strong partner ecosystem with certified NAV-to-Business Central migration specialists gives mid-market companies confidence the cutover from legacy Navision can be executed reliably.

Object mapping

How JD Edwards World objects map to Microsoft Dynamics 365 Business Central

Each row shows how a JD Edwards World object lands in Microsoft Dynamics 365 Business Central, 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

Address Book (F0101)

maps to

Microsoft Dynamics 365 Business Central

Customer and Vendor Contacts

1:1
Fully supported

World's F0101 Address Master with AN8 as the primary key maps to Dynamics 365 Business Central Customer and Vendor contact entities. We preserve name formats, mailing and physical addresses, phone numbers, email addresses, and address categories. The AN8 value is stored in an external reference field so cross-references to F0301 (Customer) and F0401 (Vendor) can be resolved during downstream entity loads. Address Book category codes (AR01, VR01) map to Customer and Vendor posting groups in Business Central.

JD Edwards World

Account Ledger (F0911)

maps to

Microsoft Dynamics 365 Business Central

G/L Register and G/L Entry

1:1
Mapping required

World's F0911 stores every journal entry with account (Object.Subsidiary), amount, batch number, fiscal period, and currency code. We extract full posting history, normalize account numbers against the target Chart of Accounts mapping defined by the finance team, and load into Business Central's G/L Entry table or Finance and Supply Chain Management's LedgerEntry. We flag records that reference obsolete Cost Codes, Business Units, or Subledgers not present in the approved mapping table before loading to avoid validation errors.

JD Edwards World

Account Master (F0901) and Account Balances (F0902)

maps to

Microsoft Dynamics 365 Business Central

G/L Account and G/L Balance

1:1
Fully supported

World's F0901 defines the Chart of Accounts structure with Object.Subsidiary segments that vary by company. F0902 carries period balances and year-to-date amounts. We normalize each World account to the target Dynamics 365 account code structure, preserve account descriptions and categories, and seed opening balances by fiscal period. Account Balances are loaded before any F0911 entry load so that trial balance reconciliation can be performed before the ledger is posted.

JD Edwards World

Customer Master (F0301)

maps to

Microsoft Dynamics 365 Business Central

Customer

1:1
Mapping required

World's F0301 links to F0101 via AN8 and stores billing addresses, payment terms, credit limits, and tax exemption codes. We map payment terms to Business Central Payment Terms codes, tax exemption data to Tax Area assignments, and parent-child customer hierarchies to the Dynamics 365 Contact and Customer hierarchy. Credit limit enforcement logic does not migrate automatically; we document the source values for manual configuration in the destination system.

JD Edwards World

Vendor Master (F0401)

maps to

Microsoft Dynamics 365 Business Central

Vendor

1:1
Mapping required

World's F0401 stores AP vendor records with payment terms, 1099 reporting data, and bank account information for ACH setup. We extract bank account details and remittance addresses subject to PCI scoping, and map 1099 box assignments to the equivalent Dynamics 365 1099 configuration. Vendor payment terms and cash discount codes migrate to Business Central Vendor Payment Terms.

JD Edwards World

Purchase Order (F4311)

maps to

Microsoft Dynamics 365 Business Central

Purchase Order

1:1
Fully supported

Open and historical PO records migrate from F4311 with line-level detail including Receipt Routing information. We extract open POs for active migration and flag closed POs for optional historical carry-forward based on the customer's fiscal year cutoff preference. PO line prices, quantities, and delivery dates map to Business Central Purchase Line records. Receipt Routing steps in World are documented as warehouse configuration notes for the customer's implementation team rather than loaded as data.

JD Edwards World

Sales Order (F4211)

maps to

Microsoft Dynamics 365 Business Central

Sales Order

1:1
Fully supported

World's F4211 stores order header and detail records with pricing, terms, backorder flags, and embedded pricing structures. We extract line items, taxes, and freight charges. World's embedded pricing may not map 1:1 to Business Central's Sales Price and Discount tables; we extract the pricing values as static line amounts and flag any pricing logic that requires rebuild as a sales price or discount group configuration post-migration.

JD Edwards World

Work Order (F4801)

maps to

Microsoft Dynamics 365 Business Central

Production Order

1:1
Fully supported

Manufacturing Work Orders with routing steps and material requirements migrate from F4801. World differentiates between shop floor Work Orders and Maintenance Work Orders; both map to Business Central Production Order records but with separate Order Types. Routing sequences from World are extracted as manufacturing routing configuration notes; bill of material lines are extracted as production BOM component lines. The customer must configure Bill of Materials and Routing templates in the destination system before production order activation.

JD Edwards World

Item Master (F4101) and Branch Plant (F4102)

maps to

Microsoft Dynamics 365 Business Central

Item and Stockkeeping Unit

1:many
Fully supported

World's F4101 is the central product catalog controlling inventory, pricing, and procurement. F4102 stores branch-plant-specific overrides (on-hand quantities, replenishment settings, costing methods). We extract F4101 as the base Item and merge F4102 records into Business Central Stockkeeping Units (SKUs) per location so that location-specific pricing and costing are preserved. Unit of Measure conversions migrate as UOM definitions linked to Items.

JD Edwards World

Inventory Ledger (F4111)

maps to

Microsoft Dynamics 365 Business Central

Item Ledger Entry and Value Entry

1:1
Mapping required

Transaction history for receipts, issues, and adjustments extracts from F4111. We load on-hand balances as Item Ledger Entry open quantities for immediate seeding, and carry forward selected transaction history based on the customer's fiscal year cutoff. Full historical transaction history beyond twelve months requires additional data volume assessment and may affect load sequencing because of Business Central's entry numbering constraints.

JD Edwards World

Employee (F060116)

maps to

Microsoft Dynamics 365 Business Central

Employee

1:1
Fully supported

HR master records including compensation, job data, organizational assignment, and effective-dated employment history migrate from F060116. We extract employee addresses, employment status, pay groups, and org unit assignments. Effective-dated history is preserved for compliance reporting. Compensation amounts and benefit enrollment data migrate as HR configuration notes rather than payroll setup, as payroll configuration is typically handled by the Dynamics 365 Human Resources module implementation separately.

JD Edwards World

Custom Tables (Z-prefixed files)

maps to

Microsoft Dynamics 365 Business Central

N/A

1:1
Fully supported

World customers frequently create custom table files (Z-prefixed, e.g., F55Z100) for industry-specific or company-unique processes. These are not part of the standard World schema and are explicitly excluded from automated migration scope. We document the Z-file names, record counts, and field structures during discovery and deliver a written specification for each custom table so that the customer's implementation team can recreate the data model in Dynamics 365 and manually enter or import historical records. If custom tables are integral to business processes, customers must budget for manual data entry or custom development.

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

Microsoft Dynamics 365 Business Central logo

Microsoft Dynamics 365 Business Central gotchas

High

Named-user licensing has no concurrent-use relief

High

API rate limits throttle large-volume migrations

Medium

Historical posted transactions require selective migration scoping

Medium

NAV-to-Business Central cloud migration requires partner coordination

Low

Custom fields and AL extensions require separate migration handling

Pair-specific challenges

  • Direct IBMi database access is mandatory and requires firewall and credential configuration

    JD Edwards World has no native REST or SOAP API, so we connect directly to the IBMi database via ODBC or native DB2 connectivity to read F-prefixed World table files. This requires the customer to provide IBMi credentials with SELECT permission on the World library, configure VPN or firewall rules to allow FlitStack AI's infrastructure to reach the AS/400 host, and in some cases involve the customer's security team in a formal access request. If the customer's security policy prohibits direct database access from external IP ranges, migration cannot proceed without a workaround such as a customer-mediated CSV export process, which adds time and risk to data extraction.

  • Object.Subsidiary account mapping must be validated by finance before GL load

    World's flexible Object.Subsidiary account numbering scheme is defined per company code, meaning the same account number can represent different accounts in different subsidiaries. Dynamics 365 uses a rigid Chart of Accounts hierarchy with fixed account code lengths and dimension structures. We extract the complete World account matrix and the company's proposed target account mapping, but the finance team must sign off on the account assignment before any General Ledger data loads. An incorrect account mapping will corrupt financial reporting in the destination system and require a full GL reload to correct.

  • Dynamics 365 API rate limits require batch chunking and exponential backoff

    Business Central enforces a limit of 5 concurrent requests per tenant with a queue depth of 95 requests. Dynamics 365 Finance and Supply Chain Management enforces per-user request limits in the 6,000-requests-per-5-minute range depending on the endpoint. We handle this by chunking large record sets into batches of 200-500 records, implementing Retry-After handling on 429 responses, and distributing load across non-peak hours. Migrations that ignore these limits experience silent record drops and timeout errors that corrupt the load if not caught by row-count reconciliation.

  • Fiscal period and currency configurations do not migrate and must be rebuilt

    World's fiscal period definitions (12-period, 13-period, or 52 weekly) are stored per company and differ from the fixed 12-period calendar Dynamics 365 uses by default. Exchange rate tables, currency decimal precision settings, and multi-currency posting rules also differ structurally. We extract the World period definitions, exchange rates, and currency settings as configuration data files, but the customer's Dynamics 365 administrator must configure the fiscal calendar, exchange rate providers, and currency decimal rounding in the destination system before any financial data posts. Government contract users with funded and awarded limit enforcement must configure limit alerts or workflows separately.

  • Oracle Client version mismatch blocks World-to-Dynamics connectivity post-migration

    When World data is exported and loaded into Dynamics 365, the Oracle Client software version on any World fat clients and application servers that remain connected to the IBMi must match the Oracle Database server version exactly. Mismatches cause connection failures, truncated data displays, and application crashes on the remaining World side. We verify Oracle Client version alignment during migration scoping and flag any version mismatches before data transfer begins. This is a common post-migration issue for organizations that plan to run World in a reduced capacity after go-live.

Migration approach

Six steps for a successful JD Edwards World to Microsoft Dynamics 365 Business Central data migration

  1. IBMi connectivity and World schema discovery

    We establish a secure connection to the customer's IBMi system via ODBC or native DB2, authenticate with the customer's provided credentials, and enumerate the World libraries and F-prefixed table files in scope. We read the data dictionary for each target table (F0101, F0301, F0401, F0901, F0902, F0911, F4101, F4102, F4111, F4211, F4311, F4801, F060116), capture record counts, and identify any Z-prefixed custom tables that require separate documentation. We also extract the World company codes, Business Unit definitions, and Object.Subsidiary account format specifications needed for the account mapping phase.

  2. Account structure mapping and finance sign-off

    We extract the complete World Chart of Accounts (F0901) across all company codes and produce an account mapping worksheet that maps each World Object.Subsidiary account to the target Dynamics 365 G/L Account number, name, account type, and account category. This mapping must be reviewed and signed off by the customer's finance team before any General Ledger data is extracted. We also extract fiscal period definitions, exchange rate tables, and currency codes as configuration files to accompany the mapping. Custom Z-file tables are documented in a separate deliverable with field-level specifications for the customer's implementation team.

  3. Sandbox schema provisioning and trial migration

    We provision a Dynamics 365 Business Central sandbox or Finance and Supply Chain Management development environment and configure the base Chart of Accounts, posting groups, payment terms, and location structure based on the approved account mapping. We run a trial migration using a representative data subset (typically 10-20% of total records per object) to validate field mappings, reconciliation row counts, and error rates. The customer's finance and operations leads review the sandbox data against source system reports and sign off before production migration begins.

  4. Master data migration in dependency order

    We run production migration in strict record-dependency order: G/L Accounts and opening balances load first to satisfy account references in all downstream records. Address Book (F0101) loads next to satisfy AN8 lookups in Customer, Vendor, and Employee records. Customer and Vendor masters load with resolved Address Book references. Item Master and Stockkeeping Units load with location assignments. Purchase Orders, Sales Orders, and Work Orders load with resolved item, vendor, customer, and account references. Each phase emits a row-count reconciliation report validated against the source system before the next phase begins.

  5. Transactional history and activity migration

    We load historical purchase orders, sales orders, and inventory transactions from the fiscal year cutoff date onward, applying the Business Central OData API with batch chunking and Retry-After backoff to respect API rate limits. Inventory on-hand balances are seeded as open Item Ledger Entries; transaction history is loaded by period to support reporting continuity. Work Order routing and BOM data is extracted as configuration notes for the manufacturing setup team. Government contract billing limit values are extracted and delivered as a documented configuration specification.

  6. Cutover, final reconciliation, and automation handoff

    We freeze World writes during the cutover window, run a final delta migration of any records modified during the migration process, then reconcile total record counts and account balances between World and Dynamics 365. We deliver the written inventory of World Workflows, UBE report definitions, and Z-file custom tables to the customer's implementation team with recommended Dynamics 365 equivalents. We provide a one-week hypercare window to resolve any reconciliation discrepancies raised by the customer's operations and finance teams. Post-cutover, the customer's administrators own all workflow rebuild, report recreation, and custom object configuration as separate scope.

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
Microsoft Dynamics 365 Business Central logo

Microsoft Dynamics 365 Business Central

Destination

Strengths

  • Tight integration with Microsoft 365 (Outlook, Teams, SharePoint) for users already in the Microsoft ecosystem.
  • Includes Copilot AI, predictive analytics, and embedded Power BI dashboards at no additional cost in both license tiers.
  • Supports multiple companies within a single tenant for holding-company or multi-entity organizational structures.
  • Open REST API v2.0 with OAuth 2.0 authentication and data entity abstraction layer for developer-friendly integrations.
  • Strong partner ecosystem specializing in NAV-to-Business Central migrations provides implementation confidence for legacy upgrades.

Weaknesses

  • Named-user licensing model means every active user account requires a paid license — no concurrent access model to reduce costs for occasional users.
  • SaaS-only deployment means no on-premises option; organizations requiring full data residency control may not have viable alternatives within Microsoft's stack.
  • Manufacturing module (Production Orders, routing, work centers) is only available on Premium tier, pushing cost-sensitive manufacturers to higher-priced plans.
  • Customization and extension development requires AL language knowledge and developer licenses, limiting what power users can do without a partner engagement.
  • Global pricing increases effective October 2024 and again October 2025 after five years of stable pricing, creating budget uncertainty for existing customers.

Complexity grading

How hard is this migration?

Standard ERP migration. All 8 core objects map 1:1 between JD Edwards World and Microsoft Dynamics 365 Business Central.

B

Overall complexity

Standard migration

Derived from compatibility, mapping clarity, API constraints, and data volume across JD Edwards World and Microsoft Dynamics 365 Business Central.

  • Object compatibility

    A

    All 8 core objects map 1:1 between JD Edwards World and Microsoft Dynamics 365 Business Central.

  • 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 Microsoft Dynamics 365 Business Central 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 Microsoft Dynamics 365 Business Central data migrations

Answers to the questions buyers ask most during JD Edwards World to Microsoft Dynamics 365 Business Central migration scoping. Not seeing yours? Book a call.

Can't find your answer?

Walk through your JD Edwards World to Microsoft Dynamics 365 Business Central migration with a real engineer — 30 minutes, free, written quote within 24 hours.

Book a free 30 minute consultation

Most migrations land between six and ten weeks for organizations with clean chart of accounts, fewer than 500,000 GL records, and no complex multi-company structure requiring per-subsidiary account mapping validation. Migrations with multi-company account structures, large transactional histories (Work Orders, multi-line purchase and sales orders), branch-plant inventory splits, or government contract billing carry-forward requirements move to fourteen to twenty-two weeks because of the extended finance team sign-off cycles and manufacturing configuration scope.

Adjacent paths

Related migrations to explore

Ready when you are

Move from JD Edwards World.
Land in Microsoft Dynamics 365 Business Central, 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