Migrate from FACT ERP.NG to Microsoft Dynamics 365 Business Central

FACT ERP.NG Customer records (addresses, contact details, GST/Tax IDs, credit limits, payment terms) map directly to Dynamics 365 Business Central Customer or Dynamics 365 Finance Customer. The Customer Posting Group from FACT maps to the Customer Posting Group in Dynamics 365. We preserve Customer-to-Sales-Order linkage as a lookback reference. Currency and payment term codes are mapped to their Dynamics 365 equivalents during the transform phase.

FACT ERP.NG Supplier records (bank details, tax registration, payment terms, GL vendor codes) map to Dynamics 365 Vendor. Supplier Posting Group, Payment Terms, and Vendor Invoice Portal settings migrate as configuration fields. We retain Supplier-to-Purchase-Order and Supplier-to-AP-invoice linkages as reconciliation references.

FACT ERP.NG Items carry pricing, BOM links, serial number flags, and barcode data. We map Items to Dynamics 365 Item records with the appropriate Item Type (Inventory, Service, Non-Inventory). Multi-level BOM structures are extracted as a tree and replayed as Dynamics 365 Manufacturing BOM and Routing records if the destination is Business Central Premium or Dynamics 365 Supply Chain Management. Serial and batch number flags map to Item Tracking Code configurations in the destination.

FACT ERP.NG Sales Orders carry customer references, line items, pricing, taxes, and fulfillment status. We preserve each order header and its lines as a single transactional unit so that partial fulfillments are correctly represented. Sales Order status (open, shipped, invoiced, cancelled) maps to the corresponding Microsoft Dynamics 365 Sales Order status. Header discount and line discount values transfer to Dynamics 365's discount mechanism.

FACT ERP.NG Purchase Orders carry supplier references, line items, expected delivery dates, and GRN linkages. We preserve header-to-line structure and flag open versus closed PO status. GRN (Goods Received Note) linkages map to Dynamics 365 Item Receipt records linked to the Purchase Order. Purchase Order status migrates to the Dynamics 365 corresponding status value.

FACT ERP.NG COA account codes, descriptions, and account types map to Dynamics 365 G/L Account. Account codes that carry a balance (trial balance accounts) are identified during discovery and their opening balances are posted to the destination as General Journal lines before transactional migration begins. We flag any account that has been deactivated in FACT to prevent re-activation in Dynamics 365 without admin confirmation.

FACT ERP.NG posts journal entries from AR, AP, and Payroll directly to the GL as dated, source-referenced records. We extract journal entries in date-range batches, map them to Dynamics 365 G/L Entry records, and load them after the Chart of Accounts and Opening Balances are confirmed. We preserve the source document reference (document number and source application) as the G/L Entry's External Document No. for audit traceability.

FACT ERP.NG Employee records include salary components, tax deductions, EPF/CPF contributions, and leave balances. These map to Dynamics 365 Human Resources Employee or Business Central Worker records. EPF/CPF deduction codes map to the destination's Statutory Deduction configurations. We note that Payroll-to-GL sequencing is mandatory: Payroll must be loaded before GL journal entries that reference payroll postings are loaded.

FACT ERP.NG inventory balances are maintained per warehouse per item. We migrate current stock positions, reorder levels, and warehouse assignments as Item Ledger Entry open quantities and Warehouse entries. Serial and batch tracking values require value-level mapping because Dynamics 365 stores item tracking at the transaction level. We flag any negative inventory positions for admin review before loading.

FACT ERP.NG Fixed Asset records include acquisition cost, depreciation method, accumulated depreciation, and asset location. Depreciation schedules are extracted and replayed as Dynamics 365 Fixed Asset Depreciation Books with the corresponding method (Straight-Line, Declining Balance, Unit-of-Production). Asset-to-GL account linkage is preserved through the Fixed Asset G/L Account mapping.

FACT ERP.NG CRM holds Leads, Contacts, Opportunities, and Activities. We migrate Leads to Dynamics 365 Lead, Contacts to Contact (attached to an Account), and Opportunities to Opportunity with stage and owner assignment preserved. The contact-to-opportunity relationship is maintained by resolving Account lookups at migration time. Opportunity stage values map to the destination Sales Process stage whitelist configured during schema setup.

FACT ERP.NG's Configuration Only model means pricing tiers, tax rates, approval workflow thresholds, inventory matrix settings, and currency precision are stored as platform parameters rather than user-defined fields. We extract every non-default parameter during discovery, map each to its equivalent setup table in Dynamics 365 (e.g., Sales & Receivables Setup, General Ledger Setup), and generate a configuration-replay script as part of the migration package. If parameters are skipped, the destination system runs with default values, causing incorrect pricing tiers, tax rates, and approval workflows in production.

FACT ERP.NG supports Malaysian e-invoicing (LHDN/IRB) and Singapore InvoiceNow. We migrate e-invoice metadata (invoice number, timestamp, tax values, buyer-seller details) and XML payloads where the source format is accessible. Dynamics 365 Business Central and Finance do not include native e-invoicing for Malaysia or Singapore as standard features; this requires an ISV add-on or separate compliance configuration post-migration. We flag this as a rebuild item for the destination admin and provide the e-invoice metadata as a reference dataset for the compliance module configuration.