ERP migration
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
Source
Microsoft Dynamics 365 Business Central
Destination
Compatibility
11 of 12
objects map 1:1 between JD Edwards World and Microsoft Dynamics 365 Business Central.
Complexity
BStandard
Timeline
6-10 weeks
Overview
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.
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.
Source platform
JD Edwards World platform overview
Scorecard, SWOT, gotchas, and pricing for JD Edwards World.
Destination platform
Microsoft Dynamics 365 Business Central platform overview
Scorecard, SWOT, gotchas, and pricing for Microsoft Dynamics 365 Business Central.
Data migration guide
The complete Dynamics 365 Business Central migration guide
Data model, import mechanisms, field mapping strategy, pitfalls, and cutover — by the engineers running it.
Destination checklist
Dynamics 365 Business Central migration checklist
Pre- and post-cutover tasks for moving onto Microsoft Dynamics 365 Business Central.
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 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)
Microsoft Dynamics 365 Business Central
Customer and Vendor Contacts
1:1World'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)
Microsoft Dynamics 365 Business Central
G/L Register and G/L Entry
1:1World'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)
Microsoft Dynamics 365 Business Central
G/L Account and G/L Balance
1:1World'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)
Microsoft Dynamics 365 Business Central
Customer
1:1World'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)
Microsoft Dynamics 365 Business Central
Vendor
1:1World'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)
Microsoft Dynamics 365 Business Central
Purchase Order
1:1Open 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)
Microsoft Dynamics 365 Business Central
Sales Order
1:1World'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)
Microsoft Dynamics 365 Business Central
Production Order
1:1Manufacturing 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)
Microsoft Dynamics 365 Business Central
Item and Stockkeeping Unit
1:manyWorld'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)
Microsoft Dynamics 365 Business Central
Item Ledger Entry and Value Entry
1:1Transaction 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)
Microsoft Dynamics 365 Business Central
Employee
1:1HR 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)
Microsoft Dynamics 365 Business Central
N/A
1:1World 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.
| JD Edwards World | Microsoft Dynamics 365 Business Central | Compatibility | |
|---|---|---|---|
| Address Book (F0101) | Customer and Vendor Contacts1:1 | Fully supported | |
| Account Ledger (F0911) | G/L Register and G/L Entry1:1 | Mapping required | |
| Account Master (F0901) and Account Balances (F0902) | G/L Account and G/L Balance1:1 | Fully supported | |
| Customer Master (F0301) | Customer1:1 | Mapping required | |
| Vendor Master (F0401) | Vendor1:1 | Mapping required | |
| Purchase Order (F4311) | Purchase Order1:1 | Fully supported | |
| Sales Order (F4211) | Sales Order1:1 | Fully supported | |
| Work Order (F4801) | Production Order1:1 | Fully supported | |
| Item Master (F4101) and Branch Plant (F4102) | Item and Stockkeeping Unit1:many | Fully supported | |
| Inventory Ledger (F4111) | Item Ledger Entry and Value Entry1:1 | Mapping required | |
| Employee (F060116) | Employee1:1 | Fully supported | |
| Custom Tables (Z-prefixed files) | N/A1: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
Microsoft Dynamics 365 Business Central gotchas
Named-user licensing has no concurrent-use relief
API rate limits throttle large-volume migrations
Historical posted transactions require selective migration scoping
NAV-to-Business Central cloud migration requires partner coordination
Custom fields and AL extensions require separate migration handling
Pair-specific challenges
Migration approach
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.
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.
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.
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.
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.
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
JD Edwards World
Source
Strengths
Weaknesses
Microsoft Dynamics 365 Business Central
Destination
Strengths
Weaknesses
Complexity grading
Standard ERP migration. All 8 core objects map 1:1 between JD Edwards World and Microsoft Dynamics 365 Business Central.
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
All 8 core objects map 1:1 between JD Edwards World and Microsoft Dynamics 365 Business Central.
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 Microsoft Dynamics 365 Business Central migration scoping. Not seeing yours? Book a call.
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 consultationAdjacent paths
Other ways to leave JD Edwards World
Other ways to arrive at Microsoft Dynamics 365 Business Central
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.