Migrate from Aptean Compiere ERP to Dolibarr ERP

Compiere's unified Business Partner entity splits into Dolibarr's ThirdParty (the organization-level record) and Contact records (the individual people). We extract BP type flags (customer, vendor, both) to set Dolibarr's Tiers and Customer/Supplier flags. Addresses and locations from Compiere BP location records migrate to Dolibarr Address records linked to ThirdParty. We preserve the original BP name and search keys as Dolibarr ref_int and ref_ext for audit.

Compiere's three-tier System-Client-Org hierarchy has no direct Dolibarr equivalent. We map each Compiere Client to a top-level Dolibarr ThirdParty (marked as internal or parent) and each Organization within that Client to either a child ThirdParty or a Dolibarr Project with the parent ThirdParty linked. The customer chooses the mapping during scoping based on whether subsidiary entities need separate invoicing. We flag any BP records that span multiple Organizations and require disambiguation.

Compiere Products migrate to Dolibarr Product records. We map ProductType (Item vs Service), the sales and purchase flags, and the default unit of measure. Compiere's product stock warehouse location migrates to Dolibarr's warehouse assignment. Product categories map to Dolibarr's Categories.

Compiere multi-level BOMs migrate to Dolibarr's BOM/BoM object under the manufacturing module. We preserve the full component hierarchy with quantities and scrap percentages, and we resolve each component reference back to its migrated Product record. If the destination Dolibarr instance does not have the manufacturing module activated, we flag BOMs as a module activation requirement during scoping.

Compiere warehouses with up to five locator dimensions (aisle, bin, rack, level, bay) map to Dolibarr Warehouses. Multi-dimension locator data beyond Dolibarr's flat location model is collapsed into the warehouse Location field as a hyphenated string. If the customer requires locator-level inventory tracking, we document it as a Dolibarr module or custom field requirement.

Compiere purchase and sales price lists map to Dolibarr multi-price entries on each Product record. We create separate Dolibarr Price Types for each source price list name and associate price entries by effective-from date. Customer-specific pricing migrates as a dedicated price list linked to the relevant ThirdParty.

Compiere's country-specific AccountingXX.csv chart of accounts maps to Dolibarr's accounting chart. We import the natural account hierarchy (Account_Value, Name, Account_Type, Account_Default) and reconstruct the account tree under Dolibarr's categories (Assets, Liabilities, Equity, Income, Expenses). If the destination Dolibarr uses an external accounting module (bookkeeping export), we format the chart for the export format.

Open AP invoices from Compiere migrate as Dolibarr Supplier Invoice records with status Draft or Unvalidated. We preserve vendor reference, invoice number, invoice date, due date, total amount, and line items with account distribution. Payment status carries as unpaid. Historical closed AP is scoped separately and archived rather than migrated to reduce migration volume.

Open AR invoices from Compiere migrate as Dolibarr Customer Invoice records. We preserve customer reference (linked to migrated ThirdParty), invoice number, date, due date, total, and line items. Invoice status migrates as Dolibarr's validated or draft status. Payment reconciliation data migrates as partial payment records where applicable.

Compiere Product Categories with pricing structures, accounting rules, and discount controls map to Dolibarr Categories. We set the Category type to Product and preserve the parent-child hierarchy. Discount structures are carried as Dolibarr extrafields if the module supports them, or documented for admin configuration post-migration.

Compiere users with System, Client, and Organization-level roles map to Dolibarr User accounts. We resolve by email match and map role names to Dolibarr permission groups. Any Compiere user without a matching email in the destination is held in a reconciliation queue. Multi-org access scopes that Compiere handled at the Organization level are not natively replicated in Dolibarr's flat user model.

Compiere's Accounting Schema (combination of Chart of Accounts and accounting rules) maps to Dolibarr's accounting configuration. We set the functional currency from the source accounting schema, map posting rules to Dolibarr's account assignment configuration, and preserve the accounting schema name as a reference field for audit.