Migrate from Tech Cloud ERP to Dolibarr ERP

Tech Cloud ERP Customer records (contact details, addresses, payment terms, tax registration numbers) map directly to Dolibarr ThirdParty records with the IsCustomer flag enabled. The Tax ID / GSTIN number maps to Dolibarr's tvaIntra and tvaNum fields. We validate the email format and deduplicate on email address before insert. Phone and mobile numbers transfer as-is; address fields map to the Dolibarr address block.

Tech Cloud ERP Vendor master data (supplier categories, payment terms, customs license details for import/export operations) maps to Dolibarr ThirdParty with the IsSupplier flag. We map payment terms to Dolibarr's cond_reglement_code and fk_payment_terms. Supplier-specific fields such as customs license or import license numbers map to custom fields in Dolibarr that we create during schema setup.

Tech Cloud ERP Item masters (unit of measure, cost price, sales price, item type, and BOM links) map to Dolibarr Product records. We set the product type (product vs service) based on Tech Cloud ERP's item classification. Cost price maps to pmc (buying price) and sales price maps to pmp or the standard price book. BOM links for manufactured goods are extracted separately and mapped to the Product BOM table (see BOM entry below). Stock valuation method (FIFO, Average) is confirmed with the customer before writing because Dolibarr's default stock valuation may differ.

Tech Cloud ERP account codes and types map to Dolibarr Accounting Account records (Account + SubAccount hierarchy). Account groupings and cost-center hierarchies vary by organization configuration in Tech Cloud ERP and must be mapped field-by-field. We extract the full account code structure, account name, account type (Asset, Liability, Income, Expense), and parent-account relationship, then create corresponding Dolibarr accounts in the correct row and hierarchy order. Validation includes checking that account codes do not conflict with Dolibarr's reserved numbering ranges.

Open and historical Sales Orders from Tech Cloud ERP carry customer references, line items (product, quantity, unit price), taxes, and shipping details. We preserve order status (Draft, Confirmed, Invoiced) and map them to Dolibarr's llx_commande (Customer Orders) with status codes mapped (DRAFT, VALIDATED, APPROVED, CLOSED). Line items resolve to Dolibarr Product references during migration. We flag any Sales Order with status INVOICED that has no corresponding invoice record in the source for manual review.

Tech Cloud ERP Purchase Orders map to Dolibarr llx_commande_fournisseur (Supplier Orders). Vendor references resolve via the ThirdParty mapping. Line items map to product quantities and buying prices (pmc from the Product record). Order status (Draft, Confirmed, Received) maps to Dolibarr status codes. We flag Goods Receipt Notes (GRN) in Tech Cloud ERP as a separate step for inventory receipt mapping.

GRN records in Tech Cloud ERP link purchase orders to actual stock received and carry tax/duty implications. We map GRNs to Dolibarr Stock Receptions (llx_stock_mouvement with origin referencing the supplier order). If the destination Dolibarr does not have the stock reception module activated, we convert GRN records to stock movement entries directly, preserving the receipt date, warehouse, product, and quantity.

Tech Cloud ERP stock balances, warehouse locations, and batch/serial numbers map to Dolibarr llx_product_stock (product warehouse stock). Stock valuation methods (FIFO, Average) must be confirmed with the customer before writing records to Dolibarr because the costing approach affects the PMP (average buying price) calculation. Multi-warehouse configurations in Tech Cloud ERP map to multiple Dolibarr warehouse records (llx_entrepot) before stock levels are assigned. Batch and serial number traceability requires the Dolibarr stock batch module; we flag this for activation at the destination.

Open and historical Sales Invoices migrate to Dolibarr llx_facture (Customer Invoice) with status (DRAFT, VALIDATED, PAID, ABANDONED). We map customer references via the ThirdParty lookup, line items via the Product lookup, and tax lines to Dolibarr's VAT configuration. Invoice totals and payment status are validated against the source before committing. Historical closed invoices are migrated as paid or open based on the source status; any discrepancy triggers a reconciliation exception for the customer's finance team.

Tech Cloud ERP Purchase Invoices map to Dolibarr llx_facture_fourn (Supplier Invoice) with vendor lookup resolved via the ThirdParty mapping. Tax deduction and payment terms transfer. We validate that the supplier invoice number in Tech Cloud ERP does not conflict with an existing Dolibarr supplier invoice number for the same vendor.

Tech Cloud ERP Fixed Asset records (acquisition cost, depreciation method, location, useful life, acquisition date) map to Dolibarr Asset records. We create the asset master in Dolibarr and flag the depreciation method mismatch risk: Tech Cloud ERP's internal depreciation engine generates journal entries that are not independently exportable, so we migrate the asset register and let Dolibarr's accounting engine regenerate depreciation entries from the acquisition date, cost, method, and useful life fields. The customer confirms the depreciation method alignment (straight-line, declining balance) before we commit.

Tech Cloud ERP BOM structures and component links are extracted from the database where accessible because the Production module export format is undocumented. We map formula-based BOMs to Dolibarr's BOM table (llx_bom_bom with lines in llx_bom_bomline). If Tech Cloud ERP uses a step-based or operation-level BOM representation that Dolibarr does not support natively, we flag this for the customer's production engineer to review and manually configure at the destination. Routing data (operation sequences, work centers) is migrated as notes on the BOM record when available; otherwise it is documented for manual re-entry.

Tech Cloud ERP HRM Employee records (designations, departments, compensation details, role-based access) map to Dolibarr llx_societe_person (contact within the organization) or to the HR module's employee table if the destination Dolibarr has the HR module activated. Role-based access mappings in Tech Cloud ERP are documented as a written role matrix for the customer's admin to reconfigure in Dolibarr's permission system (global vs per-contact-type permissions). Org structure hierarchies map to Dolibarr's Projects or third-party HR module structures.

Tech Cloud ERP Production orders and job work orders referencing BOMs and tracking work-in-progress map to Dolibarr Projects (llx_projet) with task breakdown in llx_projet_task. Production order status and completion percentages transfer. We link production order tasks to the corresponding BOM via a custom field if the destination Dolibarr has the Manufacturing module activated.

Notes and file attachments linked to Customer, Vendor, Item, Order, or Project records migrate to Dolibarr Note records and llx_ecm_files (document management). We preserve the attachment filename, MIME type, and file content by extracting from the Tech Cloud ERP database or filesystem and loading to Dolibarr's documents directory structure. The parent object reference (fk_module, fk_element) is remapped to Dolibarr's element and rowid scheme.

Open Accounts Payable and Accounts Receivable records from Tech Cloud ERP are migrated as opening balances at a designated go-live date. We create a dedicated Opening Balance account in Dolibarr's chart of accounts and generate aged receivable (customer) and payable (supplier) entries as of the cutover date rather than attempting to carry forward historical transactions that do not translate cleanly. This approach avoids closed-period inconsistencies and is standard practice for ERP migrations where source transaction formats are incompatible.