Migrate from PayTraq to Dolibarr ERP

PayTraq's GL account codes and types (Asset, Liability, Equity, Revenue, Expense) map directly to Dolibarr's Plan Comptable. Account groups and cost-center tagging migrate as Dolibarr Categories on the Account object. We establish the full chart of accounts in Dolibarr before any transaction migration begins so that all journal entry debit and credit lines reference valid account IDs. Account numbering convention is preserved from PayTraq's code structure.

PayTraq Clients map to Dolibarr Third Parties with Type = Customer (code 0). We preserve client code as ref_internal, payment terms as conditions_reglement, and currency as fk_multicurrency with the associated rate stored in multicurrency_tx. Tax ID migrates to siret or siren fields for EU businesses. Any custom client properties migrate as Dolibarr extrafields on the Societe object.

PayTraq Suppliers map to Dolibarr Third Parties with Type = Supplier (code 1). Supplier code, payment terms, and default currency migrate similarly to the Client mapping. Purchase terms specific to PayTraq supplier records (such as minimum order quantity or lead time) migrate as extrafields if the customer has configured these in PayTraq, otherwise they are documented for manual entry in Dolibarr.

PayTraq separates Products and Services into distinct CSV import templates. Dolibarr uses a single Products object with a type flag (0 = product, 1 = service). We merge both PayTraq streams into one Dolibarr Products table, setting type based on the source template. Unit of measure (PayTraq's unit field) maps to Dolibarr's units and weight units fields. Cost price from PayTraq becomes the pmp (weighted average cost) in Dolibarr.

PayTraq Sales Invoices map to Dolibarr Factures clients. Invoice headers (date, number, client reference, due date, payment terms) migrate with the client resolved to the Dolibarr Third Party ID. Line items reference the Dolibarr Product ID (resolved from the product merge in Step 4), with quantity, unit price, VAT rate, and discount amount preserved. Multi-currency invoices store the currency as fk_multicurrency with the exchange rate in multicurrency_tx. Status (Draft, Open, Paid, Cancelled) maps directly.

PayTraq Purchase Orders map to Dolibarr Commandes fournisseurs with supplier resolved to the Dolibarr Third Party ID. Line items migrate with product reference, quantity, and price. Status flags (received, partially received) migrate to Dolibarr's status field and the reception status. Any PayTraq PO lines not yet received are flagged in the migration report for reconciliation against expected deliveries.

PayTraq Journal Entries map to Dolibarr accounting entries (Ecritures). Each entry's debit and credit lines are mapped to the corresponding Dolibarr account ID (resolved from Step 1). We preserve the journal entry date, number, and label, and map the entry type to the corresponding Dolibarr journal code. Prepaid expense journal entries linked to the Prepaid Expenses GL account group are flagged for manual review since PayTraq does not expose the allocation schedule via API.

PayTraq warehouses map to Dolibarr Entrepôt records. On-hand stock levels per product-warehouse combination are read individually via PayTraq's product API because PayTraq lacks a bulk warehouse export. Each stock record is written to Dolibarr's llx_product_stock table with the product reference, warehouse reference, and quantity. This step runs after Products (Step 4) and Warehouses are established in Dolibarr.

PayTraq employees migrate to Dolibarr Contacts with category = Employee. We preserve first name, last name, email, phone, job title, and hire date (stored as an extrafield since Dolibarr Contacts do not have a native hire date field). Compensation fields and payroll history migrate as extrafields or are flagged for the HR team to rebuild depending on data sensitivity.

PayTraq Fixed Assets migrate to Dolibarr Immobilisations with acquisition date, acquisition cost, and linked GL account from the PayTraq asset record. Depreciation method (straight-line, declining) and accumulated depreciation amount migrate to the Dolibarr asset record's fields where available; the depreciation schedule itself (monthly breakdown) is flagged for manual reconstruction because PayTraq does not expose the full schedule via API.

PayTraq financial loan records (principal, interest rate, term) migrate to Dolibarr Prêt with the loan amount, start date, and GL account references preserved. The amortization schedule (monthly principal and interest breakdown) is not exposed via PayTraq API, so we migrate the loan header record and flag the schedule for manual reconstruction in Dolibarr's loan module by the customer's accountant.

PayTraq tax rates referenced on invoices migrate to Dolibarr TVA configuration. Each PayTraq tax code (rate and name) becomes a Dolibarr tax rate linked to the appropriate account in the chart of accounts. Tax agency setup in Dolibarr (mandatory for VAT reporting) is not automated and requires manual configuration by the customer's accountant post-migration.

PayTraq price lists (multiple tiers per product) migrate to Dolibarr Prix spécifiques attached to the Product record. Each price level migrates as a separate price line with the customer or customer category filter, currency, and effective date preserved. Multi-currency price lists store the currency reference in the price line.