Migrate from Oracle JD Edwards EnterpriseOne to Epicor Prophet 21

JDE Address Book is the master entity for customers, suppliers, employees, and prospects. We export F0101 (master), F0111 (contact info), and F0116 (phone numbers) and map to Epicor Customer or Supplier records by party type. Address book category codes (AN8, AB4, AB5) map to Epicor Custom Fields or Character fields in the party master. Multi-legislative addresses resolve to Epicor's country-specific address formats. The search name from F0101.SRCH becomes Epicor's Name field.

JDE Account Master (F0901) with chart of accounts stored in business units (MCU), object (OBJ), and subsidiary (SUB) segments maps to Epicor's GL Account structure. We flatten the JDE 3-segment account code (Business Unit.Object.Subsidiary) into Epicor's account string format. Account balances from F0902 migrate as opening balances in Epicor GL. Multi-currency ledgers in JDE map to Epicor separate company currencies or functional currency configurations.

JDE Accounts Payable stores invoices in F0411 and payments in F0414. We extract open AP transactions with outstanding balances and payment terms, mapping JDE payment terms codes to Epicor Terms records. Vendor hold status and 1099 flag from F0411 map to Epicor Supplier flags. Retainage records in F0414 migrate as separate Payable records with retainage hold status.

JDE Accounts Receivable stores invoices in F0311 and receipts in F03B11. We extract open AR transactions with outstanding balances, aging buckets, and dunning levels. JDE's document type (RD, RI, RM) maps to Epicor Invoice, Debit Memo, and Credit Memo types. Multi-currency AR with exchange rate variances migrates with the original rate preserved in Epicor's currency history table.

JDE Item Master in F4101 maps to Epicor Part master with stocking type, unit of measure, and category code assignments preserved. The stocking type (B/M/O/S) maps to Epicor's Type Code (Stock, Make, Buy, Special). JDE unit of measure conversions from F41003 migrate to Epicor's UOM class and conversion rules. Category codes from F4101 map to Epicor Part Class codes and custom fields.

JDE F4102 stores per-branch-plant inventory quantities, lot information, and location data. We map each F4102 branch-plant record to Epicor PartBin entries by site and warehouse. Lot number records from F4108 migrate to Epicor Lot records linked to PartBin. Cost layer information from F41026 (Item Cost file) migrates as Epicor Part transactions for FIFO or average cost valuation.

JDE F4211 stores sales order headers with order type, status, customer address number, and branch plant embedded in the header. We extract order headers and map JDE order status codes to Epicor OrderHed Status (open, partially shipped, closed). Header-level pricing from F4211 is preserved; line-level pricing is extracted from F42119. JDE multi-currency pricing migrates with the original exchange rate.

JDE F42119 stores sales order lines with pricing, tax, and branch plant assignments. We map to Epicor OrderDtl with resolved PartNum, SalesUM,IUM conversions, and quantity breaks. JDE line status and promise date migrate to Epicor OrderDtl Status and ReqDate. Line type codes map to Epicor's line types (standard, make-to-order, job).

JDE F4311 uses a complex row structure where receipt and invoicing lines are intermingled with purchase order lines. We split F4311 into Epicor POHeader and PODetail records, separating open purchase order lines from completed receipt lines. Schedule dates from F4311.PRDJ migrate as Epicor line delivery dates. JDE approval workflow status maps to Epicor POHeader approval status.

JDE Work Orders carry routing and operation step data across multiple linked tables: F4801 (header), F3112 (operations), F3003 (BOM). We extract the complete work order assembly structure and reconstruct it as Epicor Job records with JobMtl (materials) and JobOper (operations) entries. JDE status codes map to Epicor Job status (planned, released, complete, closed).

JDE Advanced Pricing schedules stored in F4072 with effective dates, break quantities, and adjustment types map to Epicor Price List records and Price Break conditions. We extract the full pricing hierarchy including volume discounts, customer-specific pricing, and formula-based adjustments. JDE price adjustment rules become Epicor Price Break conditions with matching Qualifiers (customer, quantity, date range).

JDE BOM data in F3002 (BOM header) and F3003 (BOM detail) with revision and effectivity dates migrates to Epicor PartMtl records. The bill structure type (M for manufactured, K for kit) maps to Epicor BOM Type. Phantom bills map to Epicor Material Type 4. BOM rollup costs from JDE migrate as Epicor BomMtlBurdenCost and BomMtlMtlCost fields.

JDE media objects (attachments, images, embedded documents) stored in F00165 require running the R98MODAT utility to load filesystem-based media objects into the database before export. We invoke R98MODAT as a pre-export step on Tools Release 9.2.1 and later systems, then export F00165 records as Epicor Document Management records linked to the parent entity (Part, Order, Job, Quote).

JDE custom reports (UBEs), custom tables, and other UDOs tracked in the Object Management Workbench do not migrate to Epicor ERP as functional equivalents. We document every UDO's name, project reservation, and data structure in a written inventory. Custom UBEs require a rewrite in Epicor Kinetic Studio Report Builder or a third-party reporting tool (Power BI, SSRS). Custom tables require schema re-creation in Epicor with a migration of their data through standard Epicor data import tools.

JDE Fixed Assets stored in F1201 (master) and F1202 (transactions) migrate to Epicor Asset records with original cost, accumulated depreciation, fiscal year depreciation schedules, and asset status. JDE asset category codes map to Epicor Asset Group. Depreciation methods (straight-line, declining balance, units of production) migrate to Epicor depreciation rules. In-service date and placed-in-service date from F1201 map to Epicor acquisition date fields.