Migrate your Jonas Enterprise Service & Construction Software data

Jobs is the primary project object in Jonas, carrying budget, cost codes, phases, and WIP data. The job cost structure is deeply normalized across multiple tables (JobMaster, JobPhases, CostCodes). We pull the full cost hierarchy and reconstruct it in the destination as a project or job record.

Work Orders link to Jobs, Customers, and Equipment, and carry status, labor lines, and parts. We map status codes directly and preserve the job association so service work costs flow into job cost correctly.

Customer records include billing addresses, contact info, and account balances. Multi-company setups store customer IDs per company entity, which we deduplicate during scoping before writing to the destination.

Quotes carry line items, pricing, and proposal text that reference the price book. The quote-to-work-order conversion path is Jonas-specific; we preserve the quote content and link it manually at the destination since not all CRMs have an equivalent conversion mechanism.

Preventive Maintenance Agreements define recurring billing, service intervals, and equipment scope. Jonas stores contract terms, frequencies, and asset associations across multiple tables. We flatten this into a structured record with schedule metadata for the destination.

Payroll posts directly to Job Cost and the General Ledger via configurable labor codes. The pay-rate-to-job-cost mapping is complex — employee earnings codes, union rates, and certified payroll flags all need explicit field mapping. We extract payroll history as a structured ledger and reassign cost postings during import.

Equipment records link to Work Orders and Service Contracts and carry maintenance history, location, and depreciation data. We map equipment to assets or service assets in the destination with full relationship preservation.

Inventory includes parts, assemblies, kits, min/max quantities, and purchase history. Multiple valuation methods (FIFO, average cost) require value-mapping decisions. We extract the current stock positions and purchase history and map to the destination's item or parts object.

Jonas maintains a chart of accounts with multi-company subledgers. GL transactions are linked to Jobs and Payroll. We extract the full chart and transaction history; account code lengths and structures must be normalized at the destination.

Documents are stored as database BLOBs or network file shares referenced by path strings. BLOB documents migrate as binary downloads with reconstructed metadata. File-share references require path re-mapping or re-upload at the destination.

Jonas Forms are custom templates used for document creation and workflow automation. They are tightly coupled to Jonas's proprietary form engine and cannot be meaningfully migrated to a non-Jonas system. We flag these for manual recreation.

Field Time and eTimesheets log labor hours remotely. Time records link to employees, jobs, and cost codes. We extract hours and link them to the correct employee and job at the destination.

AP invoices are linked to Jobs, Vendors, and the GL. Jonas supports multi-company AP processing. We extract open and historical AP records and map them to the destination's vendor payable or bill object.

AR invoices and customer payments are linked to Jobs and Customers. Open AR balances need to be carried forward as outstanding invoices at the destination. We map the invoice header and line detail and preserve the customer link.

Jonas allows custom fields on Jobs, Work Orders, and Customers. These are stored in extension tables. We extract any active custom fields and map them to custom fields or notes fields at the destination, with a naming convention applied.