Migrate from Oracle JD Edwards EnterpriseOne to Infor CloudSuite Corporate

JDE's Address Book is the master entity table for customers, suppliers, employees, and prospects. We export F0101 (address master), F0111 (contact information), and F0116 (phone numbers) and map to Infor's Business Partner structure. Address type codes (AN8, ATO1) from JDE map to Infor's role assignments (customer, supplier, prospect, employee). Alpha name from F0101 becomes the Business Partner description; mailing address components split across Infor's address fields.

JDE GL account structures use a 12-digit business unit plus object account plus subsidiary. We preserve the full account code string and map to Infor's chart of accounts structure. Account type, posting edit, and category codes from F0901 map to Infor's account classification and validation rules. Historical period balances from F0902 migrate to Infor's GL history table with the fiscal period preserved.

JDE AP records carry outstanding balances and payment terms in F0411 with payee detail in F0414. We extract open AP vouchers, invoice numbers, amounts, due dates, and G/L distribution lines. Invoice hold status and approval workflows in JDE require rebuilding in Infor's Accounts Payable configuration. Multi-currency AP records preserve the original transaction currency and exchange rate in Infor.

JDE AR invoices from F0311 and F03B11 carry customer number, invoice amount, invoice date, due date, and payment terms. Open AR items migrate with outstanding balance preserved. Collection manager assignments and aging bucket codes from JDE map to Infor's credit management rules. Credit memos and adjustments from F03B11 migrate as negative invoices in Infor.

JDE Item Master records from F4101 contain stocking type, unit of measure, cost method, and category code assignments. We map unit of measure conversions, stocking type, and primary cost method to Infor's item master. Category codes from F4101 map to Infor's item classification structure. The item number format from JDE (short, middle, long) is preserved as the primary identifier in Infor.

JDE stores branch/plant inventory levels in F4102 with quantity on hand, location, and lot information. We extract each branch/plant as a separate warehouse in Infor and preserve bin locations, lot numbers, and serial numbers where applicable. Cost layers per lot are extracted and mapped to Infor's inventory valuation structure.

JDE embeds pricing, taxes, and branch/plant assignments directly in the sales order header table F4211 with detail lines in F42119. We extract open sales orders with header and line data preserved. Order status codes from JDE map to Infor's sales order hold and processing states. Customer price group from F4211 maps to Infor's price list assignment. Header-level discounts and freight terms migrate to Infor's order-level adjustment structure.

F42119 contains sales order detail lines with line number, item number, quantity ordered, quantity shipped, unit price, and extended amount. We preserve the line number sequence and map item numbers to Infor's item master. Back-ordered and cancelled lines are flagged in Infor with the original JDE status code. Line-level pricing adjustments from JDE map to Infor's price adjustment detail records.

JDE purchase orders in F4311 use a complex row structure where receipt and invoicing lines are often intermingled on the same record. We extract purchase order headers, lines, and schedule dates separately and reconstruct the PO structure in Infor. Receipt schedules, promise dates, and line types (standard, configuration, dropship) are mapped to Infor's purchase order structure. Open POs with partial receipts are flagged for receiving workflow configuration in Infor.

JDE manufacturing work orders carry routing and operation step data across F4801 (header), F3112 (operations), and F3003 (BOM). We extract the complete work order assembly hierarchy and map to Infor's production order structure. Routing operations with work centres, setup time, and run time from F3112 migrate to Infor's routing definition. BOM levels from F3003 are preserved as multi-level assemblies in Infor. Work order status and type codes are mapped to Infor's manufacturing status configuration.

JDE Advanced Pricing schedules in F4072 contain effective dates, break quantities, adjustment types, and formula-based pricing rules. We extract the full pricing hierarchy including volume discounts, customer-specific pricing, and commodity-table pricing. Each JDE price adjustment rule is mapped to Infor's price adjustment type with the adjustment method preserved. Effective date ranges and customer override flags are carried forward into Infor's price list validity rules.

JDE stores attachments, images, and embedded documents in F00165 and the filesystem. We run the R98MODAT utility before export to consolidate all media objects into the F00165 database table. Each media object is associated with its parent record (Address Book, Item, Sales Order, Work Order) and migrated to Infor Document Management linked to the equivalent Infor record. File type, size, and creation timestamp are preserved.