Migrate from ORCA Financial to Dolibarr ERP

ORCA Financial stores a flat or hierarchical COA with account codes, types, and optional cost-center segments. We extract account code, account name, account type (asset, liability, equity, revenue, expense), and any custom segments. Dolibarr's accounting module uses a PCG (Plan Comptable Général) structure by default; for non-French deployments we configure a custom account plan or use the generic accounting module. Account codes with department or cost-center splits are flagged as requiring a manual post-migration account-segments configuration in Dolibarr's accounting setup.

ORCA Financial customer records include name, billing address, payment terms, and contact information. We map these to Dolibarr Third-Party records with the Customer check-box enabled. Address fields map to Dolibarr's address, zip, town, and country fields. Payment terms from ORCA Financial map to Dolibarr's cond_reglement code. Custom fields on ORCA Financial customers migrate as extra attributes on the Dolibarr thirdparty object using Dolibarr's Module CustomFields structure. Multi-site customer records (multiple ship-to addresses) are flagged as requiring manual address-line creation in Dolibarr post-migration.

ORCA Financial vendor records mirror customer records in structure: name, address, AP terms, and contact info. We map these to Dolibarr Third-Party records with the Supplier check-box enabled. Remittance addresses and multi-site vendor records are flagged as requiring manual review post-import because Dolibarr stores a single primary address per third-party with additional addresses as separate contact records.

ORCA Financial tracks items with SKU, description, unit cost, and warehouse location. We map SKU to ref, description to label, unit cost to cost_price, and the ORCA Financial warehouse assignment to a Dolibarr warehouse location. Dolibarr requires the Stock module to be activated for inventory tracking; we confirm this during scoping and map the ORCA Financial inventory valuation method (FIFO, weighted average) to Dolibarr's pmp (prix moyen pondéré) or FIFO setting per product.

Open AP records include vendor name, invoice number, amount, and due date. We export these as a reconciliation-ready table delivered separately from the production import run. Dolibarr supplier invoices are created as draft records with status Open so that the AP team can verify amounts and due dates before validating. Historical paid invoices are migrated as closed records and are not re-opened in Dolibarr; we deliver them as a closed-invoice archive table for audit purposes.

Open AR records include customer name, invoice number, amount, and due date. We export these separately for AR teams to verify post-migration. Unapplied payments and credit memos are migrated as linked records referencing the original invoice. Dolibarr invoice status is set to Draft on import so the AR team can validate before changing status to Open or Validated. Invoice PDF attachments from ORCA Financial are flagged as requiring manual re-upload because binary attachment migration is not in scope.

ORCA Financial warehouse location records define where inventory is stored. We migrate location codes, names, and addresses to Dolibarr Warehouse records. Bin-level location assignments inside warehouses are flagged as a manual post-migration step because Dolibarr's standard Stock module supports warehouse-level tracking but bin-level slot management requires either a custom field configuration or a third-party warehouse management addon.

ORCA Financial user accounts include name, email, and role. We export a user roster and map role names to Dolibarr permission groups. Dolibarr's RBAC model uses predefined permission sets (Read, Write, Delete, Export, Print) per module; ORCA Financial role names are mapped to the closest Dolibarr permission equivalent and flagged where the mapping requires manual confirmation. Active versus inactive user status is preserved; inactive users are imported as inactive Dolibarr users.

ORCA Financial stores attachments against transactions and master records. We do not migrate binary attachments due to inconsistent storage formats and file-size constraints. We export a manifest of document filenames, the record type they were attached to (customer, vendor, invoice, item), and the record identifier in ORCA Financial. The customer's administrator uses this manifest to re-upload documents to Dolibarr post-migration through the Dolibarr document management interface.

ORCA Financial payment terms (e.g., Net 30, 2/10 Net 30) map to Dolibarr Payment Term records with due date configuration (fixed number of days after invoice date, or a specific day of month). We extract distinct payment term values from ORCA Financial customer and vendor records, create matching Dolibarr payment term entries, and map the ORCA Financial term label to the Dolibarr cond_reglement code during third-party import.

ORCA Financial shipping method assignments on sales orders and purchase orders map to Dolibarr Shipping Method records. We extract distinct carrier and shipping method values from ORCA Financial order records, create matching Dolibarr mode entries, and map them by label during invoice and order import. Custom or one-off shipping methods are flagged for manual creation in Dolibarr.

ORCA Financial item category assignments (e.g., Raw Materials, Finished Goods, Services) map to Dolibarr Category records of type Product. We extract distinct category names from ORCA Financial item records, create matching Dolibarr categories, and assign the category ID to each product during item import. Multi-category assignments per item are mapped to multiple Dolibarr CategoryProduct records.