The C5 Data Migration Extension

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.

Note

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.

What Data is Migrated?

The following data is migrated for each entity:

Customers

  • Contacts
  • Location
  • Country
  • Customer dimensions (department, center, purpose)
  • Shipment method
  • Sales Person
  • Payment terms
  • Payment method
  • Customer price group
  • Customer invoice discount

If you migrate accounts, the following data is also migrated:

  • Customer posting setup
  • General journal batch
  • Open transactions (customer ledger entries)

Vendors

  • Contacts
  • Location
  • Country
  • Vendor dimensions (department, center, purpose)
  • Invoice discount
  • Shipment method
  • Purchaser
  • Payment terms
  • Payment method
  • Vendor invoice discount

If you migrate accounts, the following data is also migrated:

  • Vendor posting setup
  • General journal batch
  • Open transactions (vendor ledger entries)

Items

  • Location
  • Country
  • Item dimensions (department, center, purpose)
  • Sales line discounts
  • Customer discount groups
  • Item discount groups
  • Sales price
  • Tariff number
  • Units of measure
  • Item tracking code
  • Customer price group
  • Assembly BOMs

If you migrate accounts, the following data is also migrated:

  • Inventory posting setup
  • General posting setup
  • Item journal batch
  • Open transactions (item ledger entries)

Note

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

  • Standard dimensions: Department, Cost Center, Purpose
  • Historical G/L transactions

Note

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.

File Size Requirements

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.

To migrate data

There are just a few steps to export data from C5, and import it in Business Central:

  1. In C5, use the Export Database feature to export the data. Then send the export folder to a compressed (zipped) folder.
  2. In Business Central, choose the Lightbulb that opens the Tell Me feature icon, enter Data Migration, and then choose Data Migration.
  3. Complete the steps in the assisted setup guide. Make sure to choose Import from Microsoft Dynamcis C5 2012 as the data source.

Viewing the Status of the 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.

Note

While you are waiting for the results of the migration, you must refresh the page to display the results.

How to Avoid Double-Posting

To help avoid double-posting to the general ledger, the following balance accounts are used for open transactions:

  • For vendors, we use the A/P account from the vendor posting group.
  • For customers, we use the A/R account from the customer posting group.
  • For items, we create a general posting setup where the adjustment account is the account specified as the inventory account on the inventory posting setup.

Correcting Errors

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:

  • The number in the Error Count field for the entity.
  • The entity, and then the Show Errors action.

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.

Tip

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.

Note

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.

Verifying Data After Migrating

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

Stopping Data Migration

You can stop migrating data by choosing Stop All Migrations. If you do, all pending migrations are also stopped.

See Also

Customizing Business Central Using Extensions
Getting Started