Migrate from SYSPRO to Dolibarr ERP

SYSPRO Customer master records map to Dolibarr Third Party objects with the Client type flag enabled. We extract full customer data including billing address, shipping address, contact names, phone, email, tax ID, payment terms, and credit limits. SYSPRO's custom Form Entry fields attached to customer take-on programs extract as Dolibarr extrafields on the llx_societe table. We preserve the SYSPRO customer code as a reference field for audit. Multi-site customers who exist at different sites with different codes require us to deduplicate or create separate Dolibarr third-party records based on the customer's scoping decision during discovery.

SYSPRO Supplier master records map to Dolibarr Third Party objects with the Supplier type flag. EDI/XML trading-partner flags and contract pricing from SYSPRO's vendor master migrate as extrafields on the llx_societe table. SYSPRO's payment terms, bank details, and WIP vendor flags transfer to the corresponding Dolibarr fields. Supplier contacts migrate as Dolibarr contacts linked to the parent third-party record.

SYSPRO Inventory items map to Dolibarr Product records with type=1 (stockable). Unit of measure conversions, stocking locations, and cost layers extract from SYSPRO's inventory master and load into Dolibarr's product warehouse stock tracking. Multi-warehouse setups in SYSPRO require us to create corresponding Dolibarr warehouses and then load warehouse-specific quantities per product. SYSPRO's cost layer method (FIFO, average, standard) is preserved as a Dolibarr extrafield since Dolibarr's default costing is simpler. Product categories from SYSPRO map to Dolibarr categories.

SYSPRO Sales Order headers and lines migrate to Dolibarr Customer Order. Order status (open, back-ordered, shipped, invoiced) maps to Dolibarr Order status (Draft, Validated, Shipped, Closed). Line items carry product reference, quantity, unit price, discount, and tax code; we map these to Dolibarr order lines with resolved product_id from the SKU migration phase. Back-ordered lines are flagged in a custom extrafield for admin review post-migration. We preserve the original SYSPRO order number as a reference field.

SYSPRO Purchase Order headers and lines migrate to Dolibarr Supplier Order. Receipt status and blanket PO release information transfer as extrafields. EDI/XML export flags from SYSPRO are preserved as notes on the Dolibarr supplier order for trading-partner continuity. We resolve supplier_id from the Supplier migration phase before inserting purchase order records.

SYSPRO multi-level BOM structures with phantom assemblies, component routing, and bill versions migrate as Dolibarr BOM/Recipe records attached to the finished product. Multi-level BOMs flatten or nest depending on whether the destination installation has the Dolibarr MRP module enabled. BOM revision and effective dates from SYSPRO are preserved as extrafields or notes. Phantom assembly markers carry over to help the customer's production team understand build dependencies in the destination system.

SYSPRO Jobs (the manufacturing work-order entity tied to routing, labor posting, and material issues) map to Dolibarr Project records with type=0 (project) or to the manufacturing work order module if enabled. Job status, work-center assignments, and WIP valuations transfer as project extrafields. Material issues and labor postings from SYSPRO's job costing extract as project task lines in Dolibarr. WIP valuation amounts migrate as project budget tracking fields.

SYSPRO AR invoices migrate to Dolibarr Customer Invoice with status set to Paid, Unpaid, or Cancelled based on the SYSPRO payment status flag. Multi-currency invoice headers and line-level tax codes transfer directly. Contra-invoice relationships used in SYSPRO for AP netting are preserved via a reference extrafield on the corresponding supplier invoice in Dolibarr. Historical paid invoices retain their original dates; we do not re-date records to the migration timestamp.

SYSPRO account codes, cost-center structure, and journal-entry templates extract cleanly from the master file setup. We map account types and posting groups to Dolibarr's accounting plan equivalents. If the customer enables Dolibarr's double-entry accounting module, we coordinate the chart-of-accounts mapping during the configuration phase. Cost-center hierarchies from SYSPRO translate to Dolibarr's projet or department structure depending on which module is active.

SYSPRO custom fields attached to specific programs (customer take-on, order entry, inventory, etc.) carry lookup references and formula-driven values that require careful extraction. We extract the field definition first to understand which fields exist on which programs, then pull field data in the same program context. Formula fields may need re-evaluation in Dolibarr if the underlying data is also transformed. Dolibarr's extrafields system stores these per object (llx_societe_extrafields, llx_commandedet_extrafields, etc.) and supports field types including string, integer, select, checkbox, date, datetime, link, and text.

SYSPRO's multi-site architecture means the same customer or SKU can exist at multiple sites with different codes or metadata. We identify all active sites, determine which data is site-local versus shared, and extract site-specific data separately before reconciling in Dolibarr. Dolibarr has no native multi-site concept; we address this by creating separate warehouses in Dolibarr (for inventory) and by tagging third-party records with a site reference extrafield. For customers needing full data isolation by branch, we recommend separate Dolibarr instances or the Dolibarr Multi-Entity module.

SYSPRO operators carry security-role assignments and MFA enrollment records. Operator-level restrictions must be translated to Dolibarr's permission model, which uses a per-module permission set. We extract operator records, map role assignments to Dolibarr module permissions, and flag any operators without a clear Dolibarr equivalent for admin resolution. MFA enrollment does not carry forward; users re-enroll in Dolibarr's own authentication system post-migration.