ERP migration

Migrate from Infor XA to Dolibarr ERP

Field-level mapping, validation, and rollback between Infor XA and Dolibarr ERP. We move data and schema; workflows are rebuilt natively in Dolibarr ERP.

Infor XA logo

Infor XA

Source

Dolibarr ERP

Destination

Dolibarr ERP logo

Compatibility

75%

9 of 12

objects map 1:1 between Infor XA and Dolibarr ERP.

Complexity

BStandard

Timeline

6-10 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

Migrating from Infor XA to Dolibarr is a platform-class migration that trades deep discrete manufacturing capability for open-source simplicity and browser-based access. Infor XA holds data in Db2 for i with no documented REST API, so we coordinate direct read access with the customer's IBM i administrator and sequence table extracts in dependency order. Dolibarr's object model covers third parties, products, stock, projects, and basic accounting—but it lacks native support for multi-level BOMs, manufacturing routings, and work orders, which are central to Infor XA's schema. We map what has a direct equivalent, document manufacturing records for manual rebuild or custom module implementation, and deliver an explicit gap report before extraction begins. Workflows, RPG custom programs, and IFS-hosted attachments do not migrate; we provide written inventories for the customer's team to address post-migration.

Field-level fidelity

Every standard and custom field arrives verified.

Schema-aware mapping

AI proposes the map; you confirm before any record moves.

Relationships preserved

Parent–child, lookups, and ownership stay linked.

Full activity history

Calls, emails, meetings — with original timestamps.

Attachments & notes

Documents, uploads, and inline notes move with the record.

Why teams make this switch

Two sides of the same decision

Leaving

Infor XA logo

Infor XA

What's pushing teams away

  • The aging green-screen interface requires Citrix XenApp access and frequent password rotations, creating friction for shop floor operators and increasing IT overhead for every user session.
  • Extracting large datasets from Db2 for i requires additional steps and tooling; customers report that bulk data exports are time-consuming and often need custom scripting.
  • The pool of developers skilled in RPG and IBM i administration is shrinking, making long-term maintenance costs and customization risk escalate as tenured staff retire.
  • Limited native cloud capabilities and difficulty integrating modern CRM, eCommerce, WMS, and automation tools put XA customers at a disadvantage against competitors with cloud-native architectures.
  • High cost of customizations layered over decades of site-specific modifications creates a growing total cost of ownership that drives evaluation of modern ERP alternatives.

Choosing

Dolibarr ERP logo

Dolibarr ERP

What's pulling them in

  • Free open-source core with no per-user license fee makes it the lowest-cost entry point for small teams needing ERP and CRM in one package.
  • Self-hosted deployment gives full data ownership and eliminates vendor lock-in, especially attractive to businesses with compliance requirements.
  • Modular architecture means teams enable only the features they use, keeping the interface uncluttered and reducing learning curve.
  • Fast installation with no technical knowledge required — one reviewer set up multiple businesses in minutes using their own hosting.
  • Active community forum and marketplace of third-party add-ons provide support and extension options without mandatory subscription costs.

Object mapping

How Infor XA objects map to Dolibarr ERP

Each row shows how a Infor XA object lands in Dolibarr ERP, including any object-level transformations, lookup resolution, or schema-design dependencies.

Typical mapping — final map is confirmed during the sample migration step.

Infor XA

Third Parties (Customers and Suppliers)

maps to

Dolibarr ERP

ThirdParty (llx_societe)

1:1
Fully supported

Infor XA stores customer and supplier entity records in the Companies/Entities file with address, terms, and payment method fields. We map these directly to Dolibarr ThirdParty records, distinguishing customers from suppliers via a Type field (Customer or Supplier). The customer number or supplier number from XA becomes the Dolibarr ref_int or customer_code field for reconciliation. Multi-address and multi-contact records in XA map to Dolibarr contact and address sub-objects with the parent ThirdParty as the anchor.

Infor XA

Contacts

maps to

Dolibarr ERP

Contact (llx_socpeople)

1:1
Fully supported

XAM contact records associated with entity files map to Dolibarr Contact objects linked to the corresponding ThirdParty. We extract name fields, email addresses, phone numbers, and roles from XA's contact tables and map them to Dolibarr's contact structure with the parent llx_societe_id set at import time.

Infor XA

Items (Inventory)

maps to

Dolibarr ERP

Product (llx_product)

1:1
Mapping required

Infor XA item master records carry stocking codes, cost methods, unit-of-measure, and warehouse assignments. We map these to Dolibarr Product records with the type set to Product (not Service). Stock quantities map to llx_product_stock per warehouse. XAM's cost method (standard, average, FIFO) is preserved as a custom product property in Dolibarr since Dolibarr's default stock valuation does not expose all cost method variants natively.

Infor XA

Bills of Material

maps to

Dolibarr ERP

No direct equivalent (Project or custom module)

lossy
Mapping required

Infor XA BOMs support multi-level, phantom, and substitute item structures with effective dates. Dolibarr has no native BOM or product recipe module in its standard distribution. We extract BOM structures from XA, document them in a written bill-of-materials inventory (item hierarchy, quantities per assembly, scrap percentages, effective dates), and recommend whether the customer's team rebuilds BOMs in a custom Dolibarr module, in a spreadsheet, or through a dedicated PLM add-on from the Dolibarr marketplace. This is a significant gap that must be acknowledged before migration scope is finalized.

Infor XA

Work Orders

maps to

Dolibarr ERP

Project + Intervention (llx_projet, llx_fichinter)

1:many
Mapping required

Infor XA work orders drive shop floor control and link to routing, labor posting, and costing. Dolibarr has no dedicated work-order object. We map open and historical work orders to Dolibarr Project records with a custom work-order reference, and attach labor and material consumption as Project tasks and time entries. Customer-linked work orders reference the corresponding ThirdParty. This is a partial resolution that preserves history but does not replicate the production-scheduling and costing depth of XA's work-order module.

Infor XA

Manufacturing Routings

maps to

Dolibarr ERP

Project tasks (llx_projet_task)

lossy
Mapping required

XAM routings define operation sequences, work centers, and labor or machine standards tied to production. Dolibarr has no routing or work-center object. We extract routing definitions and document them as structured task templates within Dolibarr Projects, with work center references preserved as text fields. Operation times and standards migrate as estimated durations on Project tasks.

Infor XA

Purchase Orders

maps to

Dolibarr ERP

Supplier Order (llx_commande_fournisseur)

1:1
Mapping required

XA PO headers and lines carry supplier assignments, terms, delivery schedules, quantities, and prices. We map open purchase orders (status Open or Released) to Dolibarr Supplier Order records, linking each to the corresponding ThirdParty supplier. Line items map with product reference, ordered quantity, unit price, and delivery date. Historical closed POs are not migrated unless the customer specifically requests them for audit or supplier reconciliation purposes.

Infor XA

Customer Orders

maps to

Dolibarr ERP

Customer Order (llx_commande)

1:1
Mapping required

XA sales orders link to pricing, availability checking, and inventory allocation with order headers, line items, delivery addresses, and order-specific discounts or special terms. We map open customer orders to Dolibarr Customer Order records linked to the ThirdParty customer. Line items preserve product reference, quantity, unit price, and delivery schedule.

Infor XA

General Ledger Accounts

maps to

Dolibarr ERP

Account (llx_accounting_account)

1:1
Fully supported

XAM GL accounts are defined in a structured chart of accounts with account codes, descriptions, and posting controls. Standard GL account definitions export cleanly from Db2 and map 1:1 to Dolibarr Accounting Account records (if the Accounting module is enabled). We preserve account code structure, descriptions, and whether the account is a header or detail account.

Infor XA

Open AP/AR Records

maps to

Dolibarr ERP

Invoice (llx_facture) and Supplier Invoice (llx_facture_fourn)

1:1
Mapping required

Outstanding payables and receivables in XAM carry customer or supplier references, invoice numbers, due dates, and amounts. We extract open AP and AR documents and map them to Dolibarr Customer Invoice and Supplier Invoice records, flagging any invoice that references a GL account not present in the migrated chart of accounts. Historical closed invoices are not migrated unless required for audit trail reconstruction.

Infor XA

Shop Floor Data Collection

maps to

Dolibarr ERP

Project tasks + time entries (llx_projet_task_time)

1:1
Mapping required

Time entries, labor posting, and operation completions in XAM's shop floor module tie to work orders and employees. We extract labor hours by work order and map them to Dolibarr Project task time entries linked to the corresponding Project. Employee references resolve to Dolibarr User records. This preserves labor cost history in aDolibarr Project but does not replicate the costing and variance reporting of XAM's shop floor module.

Infor XA

User Accounts

maps to

Dolibarr ERP

User (llx_user)

1:1
Fully supported

XAM user accounts and IBM i security profiles define access rights and default accounting entities. We extract user records (name, email if populated, department) and map them to Dolibarr User accounts. XAM's role-based access (purchasing approver, shop floor operator, finance clerk) maps to Dolibarr's permission groups, though Dolibarr's permission model is less granular than IBM i's profile-based security. We flag any XAM role that has no direct Dolibarr permission equivalent.

Gotchas + challenges

What specifically takes care here

Platform-specific issues from each side, plus the pair-specific challenges that don't show up on either platform's page on its own.

Infor XA logo

Infor XA gotchas

High

Direct Db2 extraction required for bulk data export

Medium

IFS-hosted document attachments fall outside standard extraction

High

Decades of site-specific RPG customizations resist direct migration

Low

Citrix XenApp dependency complicates user acceptance testing

Dolibarr ERP logo

Dolibarr ERP gotchas

High

Foreign key constraint errors on cross-distribution database restore

High

SQL injection vulnerabilities in version 9.0.1

Medium

Custom fields stored as JSON in extraoptions require field-by-field deserialization

Medium

Decimal precision and rounding configuration affects price fields

Low

No native iOS/Android app forces reliance on browser

Pair-specific challenges

  • Dolibarr has no BOM or work-order manufacturing module

    Infor XA's core value lies in its discrete manufacturing schema—multi-level bills of material, manufacturing routings, work orders, and shop floor data collection. Dolibarr is an SMB ERP/CRM with no native manufacturing execution capability. Work orders and routings have no direct Dolibarr object; BOMs require a custom module or a marketplace add-on that does not match XA's explosion and substitute logic. We extract these records as documented inventories for the customer's team to rebuild in a custom Dolibarr module, in a dedicated MES, or in spreadsheets for audit reference. This gap must be resolved in scoping before any extraction begins.

  • Direct Db2 extraction requires IBM i administrator coordination

    Infor XA does not expose a documented public REST API. Migrating items, work orders, purchase orders, inventory movements, and GL postings requires direct read access to the IBM i Db2 for i database or manual CSV exports generated from within the green-screen interface. We coordinate with the customer's IBM i administrator to establish read-only SQL access, sequence table extracts in dependency order to respect referential integrity, and verify that all required tables (including any site-specific custom files) are included in the extraction scope.

  • Dolibarr's CSV import is date-format sensitive and rejects mismatched rows silently

    Dolibarr's native import function enforces strict field-format validation. A GitHub issue (dolibarr/dolibarr #24700) documents that date fields require the exact format YYYY-MM-DD or YYYY-MM-DD HH:MM:SS; a mismatched date string causes row rejection without a detailed error log beyond the first mismatch. We transform all extracted dates to ISO 8601 format before generating Dolibarr-compatible CSV files and run import in batches of 500 records with row-count validation after each batch.

  • IFS-hosted document attachments fall outside standard migration scope

    Infor XA stores scanned documents, reports, and custom output files in the IBM i Integrated File System rather than as database records. Standard migration extracts cover database objects only. We flag this gap during scoping, recommend a parallel IFS file-copy task managed by the customer's IBM i administrator, and advise customers to validate document naming conventions against their XAM file reference records. Dolibarr's document management stores files in its /documents directory, so any IFS copy requires a naming scheme that maps to Dolibarr's entity-based folder structure.

  • RPG customizations encode business logic that cannot transfer directly

    Many XAM installations carry bespoke RPG programs, CL scripts, and modified Business Objects that extend core functionality beyond standard configuration. These customizations encode business logic—pricing rules, BOM explosion logic, labor posting calculations—that has no equivalent in Dolibarr's PHP codebase. We document all custom objects identified during discovery, categorize them as 'replace with standard ERP feature,' 'migrate as-is (archived),' or 'rebuild in Dolibarr custom module,' and deliver this as a written handoff document. Rebuilding custom business logic in Dolibarr custom modules is outside standard migration scope.

Migration approach

Six steps for a successful Infor XA to Dolibarr ERP data migration

  1. IBM i access and extraction planning

    We work with the customer's IBM i administrator to establish read-only ODBC or native DB2 for i access to the XAM database. We run discovery queries against the source tables (item master, BOM header and detail, work order header and operations, purchase order header and lines, customer order header and lines, GL account, AP and AR open documents, shop floor labor, user profiles) and produce a record-count report. We identify any site-specific custom files not in the standard XAM schema and confirm extraction sequencing to respect referential integrity before extraction begins.

  2. Manufacturing gap analysis and scope agreement

    We produce a written manufacturing gap analysis that maps each XAM manufacturing object (BOM, routing, work order, shop floor data) to a Dolibarr resolution: direct object migration, custom module design required, or manual rebuild recommended. The customer reviews and approves the gap analysis before extraction proceeds. This step is critical for Infor XA to Dolibarr because Dolibarr's non-manufacturing architecture means several core XAM objects will not have a home in the target system.

  3. Dolibarr instance provisioning and module activation

    We provision a Dolibarr instance on the customer's target hosting environment (self-hosted on VPS or dedicated server, or via DoliCloud for managed hosting). We activate only the modules required for the migration scope—ThirdParty, Product, Stock, Customer Order, Supplier Order, Project, and the Accounting module if GL and AP/AR are in scope. We configure the accounting chart of accounts (from the XAM GL account extract) and set up warehouse locations for inventory mapping.

  4. Master data extraction and transformation

    We extract XAM master data in dependency order: third parties (customers and suppliers), contacts, products, and GL accounts first. We transform extracted data to Dolibarr-compatible CSV formats, converting date fields to ISO 8601, resolving XAM codes to Dolibarr reference fields, and splitting multi-address or multi-contact records into Dolibarr's normalized sub-object structure. We run import batches of 500 records with row-count reconciliation after each batch and resolve any Dolibarr validation rule rejections before proceeding.

  5. Transaction and order migration

    With master data in place, we extract and migrate open purchase orders, open customer orders, and open AP/AR invoices in that sequence. Each transaction type links to its master-data parents (supplier, customer, product), and we flag any transaction that references an unresolved master record (a supplier not yet migrated, a product with no match) for the customer's review before the import resumes.

  6. Manufacturing records inventory and cutover

    We extract work orders, routing definitions, shop floor labor records, and BOM structures as structured data files and deliver them as a written manufacturing records inventory document. We do not import these into Dolibarr as operational records because no equivalent object exists; the document serves as a reference for the customer's team to rebuild in a custom module or external system. We run a final reconciliation comparing migrated record counts to the source extraction counts and enable Dolibarr as the system of record after sign-off.

Platform deep dives

Context on both ends of the pair

Infor XA logo

Infor XA

Source

Strengths

  • Deep discrete manufacturing functionality purpose-built for engineer-to-order and make-to-order production environments on IBM i.
  • Integrated financials, inventory, production, and purchasing within a single Db2 for i database reduces data synchronization overhead.
  • Long product history means extensive module coverage for mid-to-large discrete manufacturers with complex costing requirements.
  • Support for multi-site, multi-currency, and multi-company structures within a single accounting entity framework.
  • Infor ION and Infor OS integration layers provide some pathway for modern middleware connectivity despite limited native APIs.

Weaknesses

  • Green-screen-centric UI requiring Citrix XenApp creates poor user experience for modern workforce expectations and adds licensing complexity.
  • No publicly documented REST API for direct integration; data extraction relies on direct Db2 reads, CSV exports, or third-party connectors.
  • RPG and IBM i developer scarcity drives up consulting and maintenance costs as experienced staff retire from the workforce.
  • Limited cloud capabilities and mobile access lag behind modern ERP platforms with browser-based or native mobile interfaces.
  • Site-specific customizations accumulated over decades create significant migration risk and often require partial reimplementation in the target system.
Dolibarr ERP logo

Dolibarr ERP

Destination

Strengths

  • Free core software with AGPL license and no per-user mandatory fee for self-hosted deployments.
  • Modular architecture lets teams activate only needed features, keeping the interface focused and the database lean.
  • Self-hosted option provides full data sovereignty and avoids recurring SaaS subscription costs.
  • Built-in CSV/Excel import and export wizard with saved profiles simplifies recurring data operations.
  • Low-code Module Builder allows functional extensions without writing PHP code.

Weaknesses

  • No native documented REST API for programmatic bulk operations — all migrations depend on the import/export wizard or direct database access.
  • Reporting and analytics are weak without paid add-ons, and built-in charts are limited compared to modern SaaS platforms.
  • UI design is described as dated by multiple reviewers, with infrequent visual updates to the default theme.
  • Community-only support for self-hosted deployments means no SLA or guaranteed response time for issues.
  • Security vulnerabilities (CVE-2024-5314, CVE-2024-5315) in version 9.0.1 with no immediate patch reported.

Complexity grading

How hard is this migration?

Standard ERP migration. 1 of 8 objects need a mapping; the rest are 1:1.

B

Overall complexity

Standard migration

Derived from compatibility, mapping clarity, API constraints, and data volume across Infor XA and Dolibarr ERP.

  • Object compatibility

    B

    1 of 8 objects need a mapping; the rest are 1:1.

  • Field mapping clarity

    C

    Field mapping is derived from defaults — final spec confirmed during the sample migration.

  • Timeline complexity

    B

    8-object category — typical timelines run 2–7 days end-to-end.

  • API constraints

    B

    Infor XA: Not publicly documented — depends on Runtime Server (nginx gateway) configuration and IDF object limits..

  • Data volume sensitivity

    A

    Infor XA exposes a bulk API — large-volume migrations stream efficiently.

Estimator

Estimate your Infor XA to Dolibarr ERP migration cost

Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.

Step 1

What are you migrating?

Pick a category, then your source and destination platforms.

Category

FAQ

Frequently asked questions about Infor XA to Dolibarr ERP data migrations

Answers to the questions buyers ask most during Infor XA to Dolibarr ERP migration scoping. Not seeing yours? Book a call.

Can't find your answer?

Walk through your Infor XA to Dolibarr ERP migration with a real engineer — 30 minutes, free, written quote within 24 hours.

Book a free 30 minute consultation

Standard master-data migrations covering third parties, products, open orders, and GL chart of accounts land between six and ten weeks. Projects that include work-order history, multi-level BOM documentation, shop floor labor records, and custom module design for manufacturing gaps extend to fourteen to twenty-four weeks because of the extraction complexity from Db2 for i and the non-trivial gap analysis work required before migration begins.

Adjacent paths

Related migrations to explore

Ready when you are

Move from Infor XA.
Land in Dolibarr ERP, intact.

Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.

Accuracy guarantee Rollback included Quote in 1 business day