Customer case study
Dynamics GP to Business Central Migration Staffing at Calderwood Estates
Engagement summary
Calderwood Estates added one full-time data migration engineer and one Business Central functional consultant working three days a week from MS Dynamics Guys to its client-led migration from Dynamics GP 2018 to Business Central 23. The Financial Controller signed the 14 June 2024 reconciliation for both companies, and the Finance Director authorised cutover on 21 June.
Engagement Facts
| Field | Detail |
|---|---|
| Client | Calderwood Estates, 210 employees |
| Industry | Property and estates management |
| Client and delivery locations | Perth, UK / Lisbon |
| Source and target | Dynamics GP 2018 to Business Central 23 cloud |
| Scope | 2 companies; 14 years of history; 42 customisations |
| Roles | 1 Data migration engineer (full-time), 1 BC functional consultant (3 days/week) |
| Engagement dates | 15 Jan – 28 Jun 2024; cutover 21 Jun 2024 |
| Overlap | 7 hours GMT |
| Reporting line | Client Finance Director |
Why the Client Added Capacity
The migration covered two companies, 42 customisations and 14 years of transaction history. Calderwood's finance team needed help moving accounts, balances and open transactions and deciding how much history to carry into Business Central. The Finance Director owned scope and cutover decisions.
Decision Rights
| Decision | Owner |
|---|---|
| Migration scope and history retention | Client Finance Director |
| Financial reconciliation | Client Financial Controller |
| Archive access design | Client IT Manager |
| Cutover authorisation | Finance Director |
Work Delivered
The engineer ran trial loads and closed 67 exceptions, then delivered a reconciliation workbook for Financial Controller sign-off. The functional consultant configured opening balances and documented how users would retrieve archived data. Calderwood's decision log records six years of history migrated and eight years archived with documented access.
| Role | Assignment | Accepted output | Reviewer | Approver |
|---|---|---|---|---|
| Data migration engineer | Accounts, balances, open transactions | Trial loads for 2 companies; 67 exceptions closed; reconciliation workbook | Client IT Manager | Financial Controller |
| BC functional consultant | History retention and archive | Retention decision log (14 years); archive access design; opening balance configuration | Client IT Manager | Finance Director |
Outcomes
The signed trial-load record shows both companies balanced on 14 June, and the cutover sign-off records the 21 June move. Calderwood's defect log records one critical issue in the first 30 days, resolved on day three.
| Measure | Baseline | Result | Window | Source |
|---|---|---|---|---|
| Companies reconciled at trial load | — | 2 of 2 balanced | 14 Jun 2024 | Signed reconciliation |
| Exceptions opened / closed | 67 opened | 67 closed | Jan–Jun 2024 | Exception log |
| History retention decision | Undocumented | 14 years: 6 migrated, 8 archived with documented access | Jun 2024 | Client decision log |
| Cutover date | Planned 21 Jun | 21 Jun | — | Cutover sign-off |
| Post-cutover critical defects | — | 1 (resolved day 3) | 30 days | Client defect log |
| First accepted trial load | — | 16 business days | Feb 2024 | Client ticket record |
Client perspective
“Fourteen years of history and someone had to decide what to keep. Our Controller signed that decision and signed the reconciliation.”
Your next step
Discuss the capacity your team needs
Share the application, workstream and specialist allocation you need. Your team can define its own backlog, acceptance and release responsibilities.