Migrate from R4 ENTERPRISE to Odoo ERP

R4 ENTERPRISE Customer records map to Odoo res.partner with partner_type=customer. We preserve credit_limit as credit_limit, payment_terms as property_payment_term_id, and currency preference as property_account_position_id. Multi-currency assignments migrate as read-only fields on the partner record. The customer address fields map to partner's street, street2, city, state_id, zip, and country_id using the standard Odoo contact-address structure.

R4 ENTERPRISE Vendor records map to Odoo res.partner with partner_type=supplier. We preserve 1099 flags and tax ID as vat, and W-9 status as trustedSupplier flag. Multi-currency settings migrate as property_purchase_currency_id on the supplier partner. Vendor IDs are retained as external_id references for reconciliation against R4 purchase order data.

R4 ENTERPRISE Item master records map to Odoo product.product with type set to product (stockable), consumable, or service based on item type flags. Unit of measure conversions map to Odoo's uom.uom structure with category matching. Cost layers from R4 are flattened to a single standard_cost on the Odoo product because Odoo uses average or standard costing rather than R4's layered cost model. We flag any lot/serial-controlled items so that the destination is configured for stockability at import time.

R4 ENTERPRISE Work Orders map to Odoo mrp.workorder records linked to mrp.production. We extract the routing steps (operations), labor standards, and material allocations, then map these to Odoo's workcenter and BoM operation structures. Any routing steps tied to deprecated BOM versions are flagged so the destination receives only the active production routing. Work order status (open/closed) migrates; closed work orders are imported as reference history unless the customer elects to start clean.

R4 ENTERPRISE BOMs are versioned with effective-date-linked revisions. We extract the active BOM revision and map each component line to Odoo mrp.bom.line records with the product_qty and operation_id referencing the correct routing step. Superseded revisions are flagged in a separate inventory table so the customer can audit decommissioned BOMs without cluttering the production BoM table.

R4 ENTERPRISE GL Account hierarchy maps to Odoo account.account with account_type mapped to Odoo's standard types (asset_current, asset_non_current, liability_current, liability_non_current, equity, revenue, expense). Cost-center assignments map to account.analytic.account for analytic accounting. Segment structures in R4 map to Odoo's analytic dimension framework if the customer uses multiple analytic plans.

R4 ENTERPRISE open AP vouchers (vendor, invoice number, due date, functional and transaction currency amounts) map to Odoo account.move with move_type=in_invoice. We preserve the original functional-currency amounts and the exchange rate used at invoice entry so Odoo can re-price or retain historical rates. Open invoices migrate as draft bills pending validation; the customer's AP team reconciles and posts in Odoo.

R4 ENTERPRISE open AR invoices map to Odoo account.move with move_type=out_invoice. We preserve invoice aging buckets so the customer maintains accurate cash-flow reporting from day one. Customer reference, due date, and functional currency amounts migrate directly. Invoices are imported as draft so the AR team can validate before posting.

R4 ENTERPRISE Fixed Asset records (acquisition cost, depreciation method, useful life, location) map to Odoo account.asset with the depreciation board computed from the source depreciation method. Accumulated depreciation balance migrates as the opening book value on the asset record. Asset category mapping aligns R4's depreciation profile to Odoo's asset.category.

R4 ENTERPRISE open Sales Orders map to Odoo sale.order with customer, line items, quantities, pricing, and promised dates. We flag any order lines referencing discontinued items or inactive price lists so the customer can clean up before final import. Line items with product_id resolved to the Odoo product ID; unresolvable SKUs are held in a reconciliation sheet for admin review.

R4 ENTERPRISE open Purchase Orders map to Odoo purchase.order with vendor, line items, quantities, and expected receipt dates. PO lines referencing item numbers not present in the destination item master are flagged in the reconciliation report. Confirmed POs migrate as purchase order state; draft POs migrate as draft and require confirmation in Odoo.

R4 ENTERPRISE on-hand quantities map to Odoo stock.quant per location and per lot/serial number. Lot numbers and bin locations are preserved so the inventory snapshot reflects physical reality at cutover. We extract lot numbers tied to expired items and flag them separately so Odoo does not create inventory records for discontinued SKUs.