
Hello everyone,
I’m looking for guidance on best practices for data migration in Microsoft Dynamics 365 Business Central where a company is standardizing its Chart of Accounts (COA) during implementation.
Scenario:
A group company has multiple subsidiaries, each currently operating with different COA structures.
As part of the migration to Business Central, the group has decided to introduce a new standardized COA that will be used across all subsidiaries.
Historical data exists under the old COA structures, which do not fully align with the new standardized COA.
What is the recommended approach to migrate opening balances and historical transactional data when the COA structure has changed?
Is it better practice to:
Map old G/L accounts to the new standardized COA during migration, or
Migrate only opening balances and keep historical data outside Business Central (e.g., legacy system or data warehouse)?
Are there standard tools, templates, or methodologies within Business Central (or common partner practices) that help manage COA re-mapping during migration? Any insights, real-world experiences, or recommended approaches would be greatly appreciated.
Thank you in advance for your support.