- Problem
- Moving 4 years of Business Central & D365 history into a unified ERP without halting daily operations.
- Approach
- Repeatable dry-run scripts to validate COA mappings, merge duplicates, and verify trial balances pre-cutover.
- Outcome
- Live smoothly since January 2026 with 4 years of trial balances reconciled to the exact rupiah.
| Data Domain | Legacy System State | New ERP State | Status |
|---|---|---|---|
| General Ledger (2022-2025) | Legacy Business Central COA | Unmapped to new COA | Unmapped COA Needs Mapping |
| Master Customer & Vendor | Dynamics 365 + BC Master | 2-3 duplicate IDs per company | Duplicate ID Needs Dedup |
Row note (click any row to inspect)
Several expense accounts were merged in year 3.
| Data Domain | Legacy System State | New ERP State | Status |
|---|---|---|---|
| Trial Balance 2022-2025 | Historical Audit vs New ERP | Delta: Rp 0 across all periods | TB Matched Live Jan 2026 |
| Customer & AR/AP History | CRM + Invoicing + Payments | Merged into 1 clean master ID | Clean Master Live Jan 2026 |
Row note (click any row to inspect)
Monthly and annual closing balances match legacy books 100%.
| Data Domain | Legacy System State | New ERP State | Status |
|---|---|---|---|
| Old Invoices w/ Rp 1-50 Rounding | Paid but stuck open on decimals | Written off in original period | Cleaned Resolved Pre-Cutover |
| 2022 Journals to Inactive COA | 3 legacy account codes retired | Flagged by script -> Remapped | Remapped Mapped Pre-Cutover |
Row note (click any row to inspect)
Prevented hundreds of paid invoices from re-appearing as open.