Dynamics GP to Business Central Migration Post – Part 1: What do my migrated Opening Balances look like in Business Central
When migrating from Dynamics GP to Business Central, opening balances for customers, vendors, and general ledger accounts are transferred via Microsoft's migration tool. Customer and vendor unapplied transactions appear as ledger entries, while GL balances migrate as summarized monthly amounts with the main segment becoming the GL code and other segments converted to dimensions.
"The migration will transfer Customer and Vendor unapplied transactions currently in the OPEN tables in Dynamics GP."
Key points
- Customer and vendor opening balances are migrated as unapplied transactions from Dynamics GP OPEN tables, viewable through G/L Registers and ledger entry pages
- GL opening balances can be migrated for multiple years, each appearing as an open year requiring year-end close procedures
- Segmented GL accounts from Dynamics GP are converted so the main segment becomes the GL code and other segments become dimensions in Business Central
- All balances migrate on a month-by-month basis, reconcilable back to Dynamics GP by matching GL codes with dimensions
Quotes
- “The migration will transfer Customer and Vendor unapplied transactions currently in the OPEN tables in Dynamics GP.” (Clarifies which transactions are included in opening balance migration and how to identify them in the source system)
- “Dynamics GP uses a segmented General Ledger account, whereas Business Central uses a single General Ledger account and Dimensions for extra analysis.” (Explains the fundamental structural difference and how GL codes are restructured during migration)
- “All balances have been migrated on a month by month basis.” (Demonstrates the granularity of migration and how to validate completeness of the migration)
AL objects mentioned
As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.
- page “G/L Register”
- page 20 “General Ledger Entries”
- page 25 “Customer Ledger Entries”
- page 22 “Customer List”
- page “GP Company Migration Configuration”
Not found in BC28-30: page “G/L Register”, page “GP Company Migration Configuration”.
Context
- Features: data migration, opening balance migration, customer transaction migration, vendor transaction migration, gl balance migration, dimension mapping, year-end closing
Source: The Dynamics Explorer, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.