Migrate from FACT ERP.NG to Odoo ERP

FACT ERP.NG Customer records carry addresses, contact details, GST/Tax IDs, credit limits, and payment terms. We map them 1:1 to Odoo res.partner records with address fields preserved and the customer flag set. We resolve Customer-to-Sales-Order references during load so that the parent relationship is satisfied at the moment of insert. Tax registration numbers map to Odoo's vat field.

Supplier master records include bank details, tax registration, and payment terms. We map them to Odoo res.partner with the supplier flag set. Supplier-to-Purchase-Order and Supplier-to-AP-invoice references are resolved during load. Bank details migrate to res.partner.bank records attached to the vendor partner.

FACT ERP.NG Items carry pricing, BOM links, serial number flags, and barcode data. We map items to Odoo product.template with product.product variants where attribute-based variants exist. Pricing migrates to Odoo's list_price, standard_price, and pricelist items. Barcode maps to barcode field. Serial and lot tracking flags transfer to the tracking field on product.template.

FACT ERP.NG multi-level BOM structures migrate to Odoo mrp.bom records with nested bom.line children representing sub-assemblies. We chunk BOM rows individually and resolve component product references before each bom insert. Routing and work centre data from FACT's manufacturing module map to Odoo mrp.routing and mrp.workcenter.

FACT ERP.NG Sales Orders carry customer references, line items, pricing, taxes, and fulfillment status. We map each order header and its lines as a single transactional unit so that partial fulfillments are preserved. Order state maps to Odoo sale.order state (draft, sale, done, cancel). Tax lines migrate to order_tax records with the relevant account.tax reference resolved.

Purchase Orders carry supplier references, line items, expected delivery dates, and GRN (Goods Received Note) linkages. We preserve header-to-line structure and flag any open versus closed PO status. GRN linkages are noted as Odoo move_ids on the purchase.order.line after the incoming shipment is received.

FACT ERP.NG uses a standard COA with account codes, descriptions, and account types. We map account codes directly to Odoo account.account records with the relevant user_type_id set per Odoo's account.account.type selection. Accounts that carry a balance are flagged so that opening balances are posted correctly via Odoo's opening balance journal. We also map FACT's account type classification to Odoo's account type (receivable, payable, liquidity, etc.).

FACT ERP.NG posts payroll, AR, and AP directly to the GL via journal entries. These are date-stamped, source-referenced records. We extract them in date-range batches and map them to Odoo account.move (header) and account.move.line (lines). Journal references are resolved to Odoo account.journal records. We preserve the debit/credit pairs and the original posting dates to maintain audit trails.

Employee records include salary components, tax deductions, EPF/CPF contributions, and leave balances. We map employees to Odoo hr.employee and hr.contract. Salary rules from FACT map to Odoo hr.contract structure_type_id and associated salary rule categories. Leave balances migrate to hr.leave records. Payroll must load before GL journal entries in a separate migration phase.

FACT ERP.NG inventory balances are maintained per warehouse per item. We migrate current stock positions to Odoo stock.quant records, reorder levels to product.putaway rules, and warehouse assignments to Odoo stock.location hierarchy. Serial and batch tracking fields require value-level mapping where lot/serial numbers are stored on the stock.quant or linked stock.move records.

Fixed Asset records include acquisition cost, depreciation method, accumulated depreciation, and asset location. Depreciation schedules are generated per accounting period. We map asset registers to Odoo account.asset.asset with the depreciation method, account.depreciation.confirmation fields, and analytic account resolved from the COA mapping.

FACT ERP.NG's Configuration Only model stores business rules, workflow states, inventory matrix settings, and tax configurations as platform parameters. We extract every non-default parameter value during discovery and replay them into Odoo ir.config_parameter records or res.config.settings fields. Tax rates, approval thresholds, pricing tier flags, and workflow state defaults are mapped to their Odoo equivalents. A configuration-replay script is delivered as part of the migration package.