Migrate from FACT ERP.NG to Dolibarr ERP

FACT ERP.NG Customer records (addresses, GST/Tax IDs, credit limits, payment terms) map to Dolibarr Third Parties with the IsCustomer flag set to 1. The FACT customer_code becomes ref_client on the Dolibarr side. We resolve the primary contact on the Third Party record and preserve all billing/shipping addresses as Dolibarr address records (llx_element_contact and llx_address). Credit limit and payment term parameters replay into Dolibarr's Payment Conditions module settings.

FACT ERP.NG Supplier records (bank details, tax registration, payment terms) map to Dolibarr Third Parties with the IsSupplier flag set to 1. Supplier bank details migrate to llx_bank_account linked to the Third Party. We preserve Supplier-to-Purchase-Order linkage as Dolibarr Purchase Order records attached to the same Third Party ID.

FACT ERP.NG Items carry pricing tiers, BOM links, serial number flags, and barcode data. We map FACT items to Dolibarr llx_product records with type (0=service, 1=product), barcode, and price levels. Multi-level BOM structures in FACT map to Dolibarr's MRP module via llx_product_bom if the manufacturing extension is active on the destination. Serial and batch tracking flags transfer to Dolibarr product lot records (llx_product_lot).

FACT Sales Orders map to Dolibarr llx_commande records with status mapped from FACT order state. Each order header and its line items migrate as a single transactional unit. The FACT customer reference maps to ref_client, and line item taxes migrate to the Dolibarr TVA (VAT) rate fields. Partial fulfillment status is preserved in the Dolibarr status and shipped quantities fields.

FACT Purchase Orders map to Dolibarr llx_commande_fournisseur records. Supplier reference, expected delivery dates, and GRN linkage flags migrate. We preserve header-to-line structure and flag open versus closed PO status so that Dolibarr's purchase workflow reflects the original FACT order state. GRN records in FACT map to Dolibarr's Receiving module if the stock receiving extension is active.

FACT ERP.NG account codes, descriptions, and account types map to Dolibarr's llx_bank_account and llx_accounting_account tables. Accounts with non-zero balances are flagged for opening balance entry in Dolibarr. Dolibarr's accounting module must be enabled on the destination (it is optional). Accounts with subledger detail (AR/AP detail) are mapped to Dolibarr's third-party accounting accounts separately from the nominal ledger codes.

FACT ERP.NG posts all transactions (AR, AP, payroll, GL) as dated, source-referenced journal entries. We extract these in date-range batches and split them into Dolibarr accounting entries (llx_accountingbookkeeping) by journal type. Payroll journal entries are extracted first (see sequencing dependency below). GL batches are loaded after Payroll to prevent duplicate debit/credit pairs in Dolibarr. Source reference numbers preserve audit trails for reconciliation.

FACT ERP.NG Employee records (salary components, EPF/CPF deductions, leave balances) map to Dolibarr llx_user records with HR module fields. Employee compensation and deduction components migrate to Dolibarr's expense report and HR modules if active. Payroll journal postings are extracted as a linked batch and loaded after llx_user to ensure account references are satisfied. EPF/CPF contribution rates replay as Dolibarr HR parameter settings.

FACT ERP.NG Fixed Asset records (acquisition cost, depreciation method, accumulated depreciation, location) map to Dolibarr llx_asset records. Depreciation schedules are converted to Dolibarr amortization entries. If the destination Dolibarr instance does not have the Asset module enabled, we map assets to a custom table and flag this as a configuration gap requiring module activation before load.

FACT ERP.NG inventory balances per warehouse per item map to Dolibarr llx_product_stock records. Reorder levels and warehouse assignments migrate. Serial and batch number values (stored at value-level in FACT) map to Dolibarr llx_product_lot. Multi-warehouse configurations in FACT map to multiple warehouse entries in Dolibarr's stock module. We flag any stock records with null warehouse assignments for customer resolution before load.

FACT ERP.NG's CRM module holds Leads, Contacts, and Opportunities as linked objects. We map Contact records to Dolibarr Third Parties (IsCustomer=1) with the primary contact on llx_contact. Opportunity records map to Dolibarr llx_projet with opportunity stage, amount, and owner preserved. FACT opportunity-to-contact links replay as project-linked contacts in Dolibarr via llx_element_contact.

FACT ERP.NG's Configuration Only model stores business rules, tax rates, pricing matrices, approval workflows, and inventory parameters as platform settings rather than user-defined fields. We extract every non-default parameter during discovery and replay them into equivalent Dolibarr module parameter pages (Setup > Modules) or custom extra fields (llx_extrafields) on each object. If parameters cannot be mapped to a Dolibarr equivalent, we document them in a Configuration Gap Report for the customer's admin to address post-migration.