Migrate from WINLine to Dolibarr ERP

WINLine's G/L account codes, cost center assignments, and Australian tax codes map to Dolibarr's llx_accounting_account table. Account number maps to account_number, label to label, parent account to蛙(parent), and tax code to vat_reverse_charge_subject. We extract from WINLine's flat-file account masters and generate INSERT statements or CSV for Dolibarr's accounting module import profile. Cost center mapping requires customer confirmation on whether cost centers map to Dolibarr's cost center module or to sub-account structure.

WINLine customer records (billing addresses, payment terms, credit limits, currency) map to Dolibarr's llx_societe table with typent = 'C' for customer. Customer name becomes nom. We use company name as the dedupe key during import. Payment terms map to cond_reglement_id (looked up from llx_conditions_reglement), and credit limits map to invoice_maximum. Billing address maps to address, zip to zip, town to town, and country to pays.

WINLine vendor master data maps to Dolibarr's llx_societe table with typent = 'F' for supplier. Tax registration numbers map to siret or siren depending on Australian vs French context (flag for customer review). Bank account info maps to rib fields. Vendor name becomes nom with vendor name as dedupe key.

Outstanding WINLine invoices, credit memos, and payment records map to Dolibarr's invoice tables. Open items with invoice numbers, amounts, due dates, and aging buckets push as open transaction records in Dolibarr (facture = 'open' status). We extract aging buckets from WINLine's aged payable/receivable report and create matching records with due dates preserved. Partial payments link through llx_paiement_facture. Customer invoices use facnumber as external reference.

WINLine Items (SKU, description, unit of measure, cost price, sell price) map to Dolibarr's llx_product. ref maps to ref, label to label, unit to unit, cost price to cost_price, and sell price to price. The inventory valuation method (FIFO or average cost) must be confirmed with the customer before mapping because Dolibarr's MRP module handles this differently than WINLine's native inventory valuation.

WINLine asset registers (acquisition date, cost, accumulated depreciation, useful life) map to Dolibarr's llx_asset and llx_asset_depreciation tables. Acquisition date becomes date_achat, net book value becomes px_devise, and depreciation method maps to accounting_asset_account for the depreciation journal. We recalculate remaining depreciation schedule against Dolibarr's accounting entries, flagging any discrepancies for customer review before finalizing.

WINLine sales orders and quotes map to Dolibarr's llx_propal (proposals) and llx_commande (customer orders). Open orders migrate as propal status 'opened' or 'signed' and closed orders as historical records. Line items map to llx_propaldet with product reference, quantity, and unit price resolved against the imported product catalog.

WINLine stock levels by warehouse location map to Dolibarr's llx_product_stock linked to llx_entrepot (warehouses). Current quantities per warehouse migrate with reel as the stock quantity. We flag any negative stock, discrepant counts, or obsolete items during extraction for customer reconciliation before loading into Dolibarr's warehouse inventory module.

WINLine's Bill of Materials with version history and effective dates map to Dolibarr's llx_mrp_bom and llx_mrp_production tables. The active BOM version at cutover date must be identified from WINLine's versioning metadata; we flag any BOMs with pending revisions for customer review before migration. Production orders map to llx_mrp_production with qty and status preserved. Dolibarr's MRP module must be activated in the destination before this object type can be loaded.

WINLine work orders map to Dolibarr's llx_mrp_production. We extract production order status, quantity, and the parent BOM reference. Work order dates migrate as scheduled start and end dates. If WINLine tracks sub-assemblies or multi-level BOMs, we flatten them or flag multi-level resolution for customer confirmation.

WINLine contact persons linked to customers or vendors map to Dolibarr's llx_socpeople (third-party people). firstname, lastname, phone, email, and role map to the corresponding Dolibarr fields. We link each contact to the parent llx_societe via fk_soc. Role or job title maps to poste.

WINLine's document archive linked to transactions and master records is extracted as binary files and re-attached in Dolibarr's document management. Dolibarr stores documents in the documents directory tied to the object type and ID. We create the directory structure and link files to the migrated record IDs post-load. Binary attachments are exported as-is and re-uploaded; we do not parse internal WINLine document metadata.

WINLine project management data maps to Dolibarr's llx_projet and llx_projet_task tables. If WINLine tracks time against projects, we map project tasks and any time entries. Dolibarr's project module must be activated for this object type. Project status maps from WINLine's project state field.

WINLine extended flat-file columns map to Dolibarr's extrafields system (llx__extrafields) or the CustomFields module if the customer uses it. Each WINLine extended property requires a new extrafields definition in Dolibarr before data can be inserted. We document every custom field found in WINLine's schema and recreate each as a Dolibarr extrafields entry with matching data type (string, int, date, select, etc.) during the schema design phase.