Migrate from Industry Software to Microsoft Dynamics 365 Business Central

Industry Software account codes map to Dynamics 365 Business Central G/L Account No. or Finance and Supply Chain Management Ledger Account ID. We identify whether Industry Software uses a flat account code or a segmented structure (e.g., 4-4-4) and replicate it in Dynamics 365 using account categories (Assets, Liabilities, Equity, Revenue, Expense) assigned at import. Account names and balances migrate directly. If Industry Software carries retained earnings or historical period balances, we post those as opening balance transactions to the appropriate prior-period range.

Industry Software Vendor records map to Business Central Vendor or Finance and Supply Chain Management Vendor. We map Vendor name, address, tax ID, payment terms, currency, and the posting groups (Gen. Business Posting Group and Vendor Posting Group) that are required on every Vendor in Dynamics 365 but do not exist in Industry Software. During discovery we identify the Industry Software payment terms model and derive equivalent posting group assignments by vendor type. Vendor balances (open AP) migrate as outstanding purchase invoices and credit memos with original invoice dates preserved.

Industry Software Customer records map to Business Central Customer or Finance and Supply Chain Management Customer. Customer name, address, tax ID, payment terms, currency, and sales person assignments migrate directly. Industry Software payment terms derive Gen. Business Posting Group and Customer Posting Group assignments in Dynamics 365. Open AR balances migrate as outstanding sales invoices and credit memos with original invoice dates, due dates, and aging bucket assignments preserved to maintain the AR aging report in the new system.

Industry Software Item records map to Dynamics 365 Item (Item type = Inventory Item or Service). Item No., description, base unit of measure, and SKU (hs_sku equivalent) migrate directly. Industry Software costing method maps to Dynamics 365 Costing Method (Standard, FIFO, Average, Specific Identification). If Industry Software carries lot or serial numbers, those migrate as Item Tracking Code records linked to the Item, and existing lot numbers populate the Item Registry in Finance and Supply Chain Management or the Lot Information page in Business Central. On-hand quantity per warehouse migrates as an inventory adjustment posting using the Inventory Setup opening inventory function.

Open vendor invoices in Industry Software migrate as open Purchase Invoice records in Business Central or Finance and Supply Chain Management. Invoice number, vendor reference, invoice date, due date, amounts (in foreign currency if applicable), and description migrate. We flag any Industry Software invoice that references a purchase order or receipt; if the PO or receipt exists in Industry Software but not yet in Dynamics 365, we create a matching open receipt or record and link it before posting the invoice to close the payable. Discount terms, prepayment amounts, and GST/VAT applicability carry forward as line-level detail.

Open customer invoices in Industry Software migrate as open Sales Invoice records in Business Central or Finance and Supply Chain Management. Invoice number, customer account, invoice date, due date, line amounts, and tax breakdown migrate. We preserve the original sales person and territory assignments as custom fields if they are not native Dynamics 365 fields. Any partial payments already recorded in Industry Software migrate as open or partially applied invoices with the payment application preserved. Prepayments and deposits migrate as separate deposit records.

Open purchase payments and cash disbursements in Industry Software that are not yet applied to an invoice migrate as open Vendor Ledger Entries in Business Central or Finance and Supply Chain Management. Payment number, vendor, payment date, amount, and currency migrate. We ensure the payment method (check, ACH, wire) maps to the Dynamics 365 Payment Method Code. Unapplied vendor payments and pre-payments post to the appropriate vendor account and carry forward as open credits.

Open sales receipts and cash applications in Industry Software that have not been fully applied to an invoice migrate as open Customer Ledger Entries in Business Central or Finance and Supply Chain Management. Receipt number, customer, receipt date, amount, and currency migrate. We preserve the payment method code and any unrealized gains or losses on foreign-currency receipts. Cash receipt discounts applied in Industry Software carry forward with the discount amount recorded on the ledger entry.

Industry Software inventory adjustments and physical count records migrate as Item Journal lines in Business Central or as inventory closing journals in Finance and Supply Chain Management. We map the adjustment quantity and cost per item to the Item Journal Template with the appropriate Journal Batch Name. Inventory Posting Group assignment is derived from the item category in Industry Software and mapped to the corresponding Inventory Posting Group in Dynamics 365 that controls which G/L accounts receive the adjustment postings.

Industry Software project or job records migrate as Jobs in Business Central (Job feature enabled) or Projects in Finance and Supply Chain Management (Project Management and Accounting module). Project number, description, status, responsible user, WIP calculation method, and budget amounts migrate. Work breakdown structure lines migrate as Job Planning Lines or Project Tasks and Project Lines respectively. If Industry Software carries resource bookings, those migrate as Job Resource Entries or Project Resource Lines with hours, rates, and cost amounts preserved. WIP values recalculate post-migration using Dynamics 365's own WIP engine to align with the new system's costing rules.

Industry Software work orders or job tickets that represent field service or manufacturing orders migrate as Service Orders in Business Central (Service Management module required) or as Production Orders or Service Orders in Finance and Supply Chain Management. Work order number, status, customer, item serial number, description, and labor lines migrate. Item parts used migrate as service line items. If the destination Dynamics 365 edition does not include Service Management, work orders migrate as Job Tasks with a custom work order number field, and the customer admin provisions the Service module as a separate licensing and configuration step.

Industry Software fixed asset records migrate to Business Central Fixed Asset or Finance and Supply Chain Management Fixed Asset. Asset number, description, acquisition date, acquisition cost, depreciation method, useful life, and accumulated depreciation migrate directly. If Industry Software tracks asset locations, departments, or cost centers as custom fields, those map to Fixed Asset attribute fields in Dynamics 365. Depreciation books (tax vs. financial) migrate as separate Depreciation Books on the Fixed Asset record. Depreciation entries already posted in Industry Software that fall within the Dynamics 365 opening fiscal year migrate as posted fixed asset journal entries; prior-period accumulated depreciation posts as an opening balance adjustment.

Industry Software user or owner records referenced on transactions (AP/AR, Projects, Work Orders) map to Dynamics 365 User records. We resolve Industry Software user IDs by email or name match against the Azure Active Directory-synced User table in the destination Dynamics 365 tenant. Users without a matching User record enter a reconciliation queue; the customer provisions missing users in Dynamics 365 before record import proceeds because OwnerId or Assigned UserId references are required on most transactional records.

Any custom fields on Industry Software Vendor, Customer, Item, or Project records migrate as custom fields on the corresponding Dynamics 365 entity. We create the destination field using the Dynamics 365 field type that best fits the source data type (text to Text, numeric to Decimal or Integer, date to Date, dropdown to Option Set). Custom field names append a migration-source prefix (e.g., IS_OriginalValue__c) for audit traceability. Custom fields with no equivalent Dynamics 365 native field migrate to a Custom Fields extension table with a lookup to the parent record.

Industry Software document attachments and notes linked to Vendor, Customer, Item, or Project records migrate as Record Links or Notes in Business Central or as Attachments in Finance and Supply Chain Management. We migrate the file name, file type, URL or binary content, and the linked record ID. The link target resolves via the mapped record ID in Dynamics 365. Attachments exceeding Dynamics 365's size limits (typically 25 MB per file in Business Central) are stored in an associated SharePoint document library linked from the Dynamics 365 record.