Migrate from Deacom ERP to Acumatica

Deacom customer records (dmCUST) map directly to Acumatica Customer DAC records. The customer ID (cu_id), name, address, and payment terms transfer as-is. Deacom's customer class (cu_classid) maps to Acumatica's Customer Class (CustomerClassID). Email and phone fields land in the respective Contact sub-tab. We resolve Deacom's owner assignment by matching cu_buyerid to Acumatica users by email.

Deacom vendor records (dmVEND) map to Acumatica Vendor DAC records. The vendor ID (ve_id), name, address, and AP terms transfer. Deacom's vendor class maps to Acumatica's Vendor Class. Remit-to addresses in Deacom become separate Address records on the Acumatica Vendor. We preserve the original vendor ID in a custom Vendor_TempID__c field for reconciliation.

Deacom items in dmPROD split into Acumatica StockItem (for inventoried items) or NonStockItem (for non-inventoried materials). The split is based on Deacom's item type flag (pr_type). Inventoried items carry over warehouse-bin assignments, lot/serial settings, and stocking UOM conversions. Non-stock items transfer without inventory tracking fields. Each item's Deacom ID (pr_id) is preserved in a custom LegacyItemID__c field.

Deacom BOM structures (dmBOMH for header, dmBOMM for lines) translate to Acumatica's Bill of Materials screen. Deacom's BOM revision system requires mapping each active revision to a separate Acumatica BOM revision record. Material quantities, scrap factors, and operation steps from Deacom's routing (dmROUTEH) map to Acumatica's BOM Materials and Operations tabs. We flag inactive Deacom BOM revisions as inactive BOMs in Acumatica.

Deacom's dmFACCT table maps to Acumatica GLAccount records. The account number (fa_id), description, and account type (fa_type) transfer. Deacom's account segments map to Acumatica's account format segments if Deacom uses a segmented chart. Active/inactive status in Deacom translates to Active flag in Acumatica. Subaccount structure in Deacom requires mapping to Acumatica's Subaccount dimension.

Open Deacom AR invoices (dtARIN) map to Acumatica ARInvoice records. The invoice number, date, due date, customer reference, and line items (dtARINL) transfer. Deacom's payment terms code (dtARIN.terms) maps to Acumatica's Terms ID on the invoice. Historical paid invoices are imported with a status flag; open invoices import as open records. Line-level discounts and tax amounts from Deacom land in Acumatica's Amount and TaxAmount fields.

Open Deacom AP invoices (dtAPIN) map to Acumatica APInvoice records. Vendor reference, invoice date, and due date transfer. Deacom's AP terms map to Acumatica's Terms ID. Line items (dtAPINL) with GL account assignments and amounts land in the invoice detail grid. Prepaid invoices in Deacom (where partial receipts occurred) require Acumatica's Prepayment Invoice type. We flag unmatched vendor IDs before migration for manual resolution.

Deacom warehouse records (dmWHSE) map to Acumatica Warehouse records. The warehouse ID (wh_id), name, and address transfer. Deacom's bin structure (dmBIN) maps to Acumatica Location records within each Warehouse. Multiple Deacom facilities map to multiple Acumatica warehouses. We preserve the original warehouse ID in the Warehouse_OrigID__c field.

Deacom user-defined fields stored via dxCAPTION pick-list options and dmUDFH definitions require Acumatica custom fields on the respective DACs. Each UDF field's data type (text, date, pick-list) maps to the equivalent Acumatica field type. Pick-list UDF values in Deacom (stored via d3_c2guid links) translate to Acumatica custom pick-list values on the field. We create custom fields using the Usr prefix convention and map the data during the entity migration pass.

Open Deacom production orders (dtPRODH with dtPRODL lines) map to Acumatica Production Order records. The production order number, status, scheduled start/end dates, and BOM reference transfer. Deacom's production operations (from dmROUTEH) require Acumatica's production routing setup per item before orders can be scheduled. We import orders in Released status where routing data exists; orders without routing data land in Planned status for manual routing assignment.

Deacom contact records attached to customers or vendors (dmCONTACT) map to Acumatica Contact records linked to the respective Customer or Vendor. The contact name, email, phone, and title transfer. Primary contact designation in Deacom (co_primary flag) sets IsPrimaryContact on the Acumatica Contact. Multiple contacts per customer map to separate Contact records under the same parent Customer.

Deacom ship-to addresses (dmSHIPTO) attached to customers map to Acumatica Address records on the Customer DAC. The address line, city, state, postal code, and country transfer. Deacom's default ship-to flag maps to the IsDefaultShipping flag on the Address. Multiple ship-to addresses per customer become multiple Address records with distinct types.

Deacom system lookup codes stored in dxCAPTION (such as department codes, cost center codes) map to Acumatica Subaccount values. Each Deacom code group becomes a separate subaccount segment in Acumatica. The dxCAPTION c2_description maps to the Subaccount description. We preserve the original Deacom code value in the Subaccount_OrigCode__c field for audit traceability.