icon, enter Data Migration, and then choose Data Migration. This extension makes it easy to migrate customers, vendors, items, and your general ledger accounts from Microsoft Dynamcis C5 2012 to Business Central . You can also migrate historical entries for general ledger accounts.
The company in Business Central must not contain any data. Additionally, after you start a migration, do not create customers, vendors, items, or accounts until the migration finishes.
The following data is migrated for each entity:
Customers
If you migrate accounts, the following data is also migrated:
Vendors
If you migrate accounts, the following data is also migrated:
Items
If you migrate accounts, the following data is also migrated:
If there are open transactions that use foreign currencies, the exchange rates for those currencies are also migrated. Other exchange rates are not migrated.
Chart of Accounts
Historical G/L transactions are treated a little differently. When you migrate data you set a Current Period parameter. This parameter specifies how to process G/L transactions. Transactions after this date are migrated individually. Transactions before this date are aggregated per account and migrated as a single amount. For example, let's say there are transactions in 2015, 2016, 2017, 2018, and you specify January 01, 2017 in the Current Period field. For each account, amounts for transactions on or before December 31, 2106, will be aggregated in a single general journal line for each G/L account. All trascations after this date will be migrated individually.
The largest file size you can upload to Business Central is 150 MB. If the file you export from C5 is larger than that, consider migrating data in multiple files. For example, export one or two types of entities from C5, such as customers and vendors, to a file, and then export items to another file, and so on. You can import files individually in Business Central .
There are just a few steps to export data from C5, and import it in Business Central :
icon, enter Data Migration, and then choose Data Migration. Use the Data Migration Overview page to monitor the success of the migration. The page shows information such as the number of entities that the migration will include, the status of the migration, and the number of items that have been migrated and whether they were successfull. It also shows the number of errors, lets you investigate what went wrong and, when possible, makes it easy to go to the entity to fix the issues. For more information, see the next section in this topic.
While you are waiting for the results of the migration, you must refresh the page to display the results.
To help avoid double-posting to the general ledger, the following balance accounts are used for open transactions:
If something goes wrong and an error occurs, the Status field will show Completed with Errors, and the Error Count field will show how many. To view a list of the errors, you can open the Data Migration Errors page by choosing:
On the Data Migration Errors page, to fix an error you can choose an error message, and then choose Edit Record to view the migrated data for the entity. If you have several errors to fix, you can choose Bulk-Fix Errors to edit the entities in a list. You still need to open individual records if the error was caused by a related entry though. For example, a vendor will not be migrated if an email address one of their contacts has an invalid format.
After you fix one or more errors, you can choose Migrate to migrate only the entities you fixed, without having to completely restart the migration.
If you have fixed more than one error, you can use the Select More feature to select multiple lines to migrate. Alternatively, if there are errors that are not important to fix, you can choose them and then choose Skip Selections.
If you have items that are included in a BOM, you might need to migrate more than once if the original item is not created before the variants that reference it. If an item variant is created first, the reference to the original item can cause an error message.
One way to verify that your data migrated correctly is to look at the following pages in C5 and Business Central .
| Microsoft Dynamcis C5 2012 | Business Central | Batch Job to Use |
|---|---|---|
| Customer Entries | General Journals | CUSTMIGR |
| Vendor Entries | General Journals | VENDMIGR |
| Item Entries | Item Journals | ITEMMIGR |
| G/L Entries | General Journals | GLACMIGR |
You can stop migrating data by choosing Stop All Migrations. If you do, all pending migrations are also stopped.
Customizing Business Central
Using Extensions
Getting Started
© 2019 Microsoft. All rights reserved.