How To: Migrate Business Data In Microsoft Business Central

Dynamics 365 Business Central includes a set of Assisted Setups to help you configure your system. Assisted setups are configuration wizards to provide step by step instructions to help with the system setup. To migrate your business data from another system or from an external source, use the “Migrate Business Data” assisted Setup.

You & Your Business

Need Help With Microsoft Business Central?

To access the assisted setup, choose the search icon at the top right of the screen, type “Assisted Setup” and choose the Assisted Setup option in the search results.

 In the Assisted Setup list find the “Migrate business data” option and Press Actions – Start Setup.

Assisted set up 1 = Microsoft Dynamics
data mirgration 2

The Data Migration wizard is started. You can import data directly from other finance solutions if the corresponding extension exists. To check if the extension exists press the “open extension Management” to review the extension list.

Select Next, to move to the next step. Now you will need to select the source of your data. 

Move to Next Steps 3
migrating business data in business central

The next steps depend on the Data Source, if you select QuickBooks Online the next step will be to login to your QuickBooks Online subscription. In the case that an extension does not exist for your previous finance system then the data source that can be used is Excel. Business data from the old finance system can be exported into excel and then imported into Business Central. 

In the next step you can download the excel template. Additionally, you can Press the Settings button and define Templates with predefine values for the Customers, Vendors and Items.

The next steps depend on the Data Source, if you select QuickBooks Online the next step will be to login to your QuickBooks Online subscription. In the case that an extension does not exist for your previous finance system then the data source that can be used is Excel. Business data from the old finance system can be exported into excel and then imported into Business Central. 

In the next step you can download the excel template. Additionally, you can Press the Settings button and define Templates with predefine values for the Customers, Vendors and Items.

records data mirgration 5
excel file with data 6

The records included in the Data Migration are G/L Accounts, Customers, Vendors and Items. If you have additional data to import, then you will need to use the Configuration Packages to import them.

In the next step you will need to choose the excel file with your data. Data are imported into the system.