Migrate from Microsoft Dynamics 365 Business Central to Odoo ERP

Business Central Customer master records map to Odoo CRM Contacts with the company flag set to create an associated Partner record. We extract the t Customer table fields (No., Name, Address, Contact, Payment Terms Code, Credit Limit, Posting Group) and map them to Odoo res.partner fields, preserving the BC customer number as a reference field. Payment terms from BC (e.g., NET30) are mapped to Odoo Account Payment Terms by name match.

Business Central Vendor records map to Odoo res.partner records with the Supplier checkbox enabled, activating the Purchase app visibility. We map Vendor Posting Group from BC to Odoo's Property Stock Valuation account and Property Cost of Goods Sold account by name lookup. Pay-to addresses map to the Partner's Contact records for multi-address vendors.

Business Central Inventory Items map to Odoo Product records with type=product (storable). We resolve BC's Item Category code to Odoo Product Category, map Unit of Measure from BC's Item Unit of Measure to Odoo's uom.uom table, and carry forward the costing method (FIFO, Average, Standard) to Odoo's inventory valuation setting. The Costing Method is a critical mapping decision because BC and Odoo handle negative inventory differently and the setting must be configured in Odoo before any stock moves are imported.

Business Central Service items map to Odoo Product records with type=service. These do not carry stock or valuation implications and import without Odoo-side inventory configuration. BC's default unit of measure maps to Odoo's service UOM.

The Business Central Chart of Accounts maps to Odoo's account.account table. We extract G/L Account records with their Account Type (Posting, Heading, Total, Begin-Total, End-Total) and map BC account numbers to Odoo code. The customer must configure the Odoo Chart of Accounts template matching their country localization before this import runs. We flag any BC account with a Consolidation account type or Detailed Counting flag as requiring manual Odoo configuration. This step is the prerequisite for all financial record imports.

Open, unposted Business Central sales invoices map to Odoo account.move records of type=out_invoice in draft state. BC's document-level structure (header with line items) maps to Odoo's invoice line structure, with BC's VAT product mappings resolved to Odoo account.tax records by tax rate and tax scope. Due dates and payment terms carry forward from BC. Posted AP invoices from BC are mapped to Odoo account.move records of type=in_invoice with posting dates preserved.

Open, unposted Business Central Sales Orders migrate to Odoo sale.order records in state=draft. BC's Sales Header (Order No., Sell-to Customer No., Order Date, Shipment Date) maps to Odoo's sale.order fields. BC's Sales Line table maps to Odoo's order line records with product reference resolved to the Odoo product ID via SKU or item number. We flag BC orders with drop-ship or special order flags for Odoo-specific configuration because Odoo handles these through warehouse routes rather than document flags.

Open, unposted Business Central Purchase Orders map to Odoo purchase.order records in state=draft. Expected receipt dates from BC map to Odoo's date_planned field. BC vendor item references are mapped to Odoo vendor Pricelist entries for the associated product. We resolve the vendor's Odoo Partner ID using the vendor number lookup established during vendor migration.

Business Central Item Ledger Entry records with positive open quantity are mapped to Odoo stock.quant records representing on-hand inventory at the cutover date. BC's Location Code maps to Odoo Stock Location via name lookup, and the Lot/Serial Number from BC maps to stock.productionlot. BC Value Entry cost layers are preserved for Odoo's average cost calculation on first receipt. Historical posted ledger entries (closed transactions) are not replayed; instead we carry forward the open quantity balance as an opening Quant.

Business Central Fixed Asset records map to Odoo account.asset records. We carry forward the Acquisition Cost, Depreciation Starting Date, Depreciation Method (Straight-line, Declining Balance), and Number of Depreciation Years. BC's Depreciation Book assignments map to Odoo's Asset Category with the corresponding journal. Insurance policy and location details migrate as asset notes.

Business Central Job records with WBS task breakdowns and resource time entries map to Odoo Project records with task lines and timesheet entries. BC Job Ledger Entries map to Odoo account.analytic.line records linked to the Project. BC Job posting groups are mapped to Odoo analytic account tags. Open Job tasks migrate as Odoo project.task records; closed tasks migrate as project.task records in a completed stage.

Business Central Bank Account records map to Odoo account.journal records of type=bank with the linked account.account record carrying the Bank Account Posting Group from BC. Open bank account ledger entries from BC are mapped to Odoo account.move.line records in the bank journal.