In the October '18 update of Dynamics 365 Business Central, we have expanded the amount of data we bring in to Business Central from Dynamics GP using the data migration extension.

Here is a breakdown of the data we bring over from Dynamics GP:

  • Accounts
  • Customers
  • Vendors
  • Items

Let’s look at this in more detail.

Accounts

In the Data Migration wizard, you can specify whether you want to use existing account numbers or new account numbers.   

  • If you choose to use the existing account numbers, we will bring over the beginning balance of the main segment (new account number) as a summation of the main account number at the time of the migration.
  • If you choose to create new account numbers, we will bring summary information for the equivalent of two fiscal years based on the fiscal periods you have set up in Dynamics GP.

Let’s look at this based on the Fabrikam sample company in Dynamics GP (amounts are examples):

000-1300-01   Inventory Retails/Parts (2018)

Period 1           1/1/18             $2,000

Period 2           2/1/18             $4,000

Period 3           3/1/18             $4,000

 

000-1300-02   Inventory Finished Goods (2018)

Period 1           1/1/18             $3,000

Period 2           2/1/18             $2,000

Period 3           3/1/18             $4,000

If you use the existing chart of accounts, the following happens during the migration:

  • Account numbers are created based on the account main segment.
  • Dimensions are created for the additional segments. The number schemes for the additional segments will be created as dimension codes.
  • Accounts based on the main segment are created as one account, and use the name of the first account.

In our example, we will create account number 1300 Inventory Retail/Parts, and dimension codes for division and department based on the setup in Dynamics GP.  The division (first segment) will have a value of 000, and department (third segment) will have 01 and 02 values. The descriptions will also be based on the setup in Dynamics GP

Continuing with our example, the general journal entry record for this account number will be:

1300                $19,000 – a summary value of all of the accounts with a 1300 account number will be created as of the migration date.

If you create a new chart of accounts, the following happens during the migration:

  • Account numbers are created based on the account number provided in the Excel spreadsheet that you upload during the migration process.  The spreadsheet will list all of the account numbers found in Dynamics GP, and you will need to provide a new, unique number for each account. If you leave the New Number column blank, or there are duplicates, the migration will not succeed. 

In our example we will create account numbers 130000 Inventory Retail/Parts and 130001 Inventory Finished Goods. These are the new numbers that were entered in the spreadsheet. No dimension codes are created. 

Continuing with our example, the general journal entry records for these account numbers will be:

130000

1/31/2018            $2,000

2/28/2018            $4,000

3/31/2018            $4,000

 

130001

1/31/2018            $3,000

2/28/2018            $2,000

3/31/2018            $4,000

 

The summary values will pull for the current year and one year prior based on the fiscal periods and the data of the migration.

Customers:

Open transactions for customers in the Receivables module are migrated to Business Central as a customer ledger entry. The amount is the outstanding amount on the transactions.

Example: In Dynamics GP, Aaron Fitz has an invoice for $1000 with an amount remaining of $450. An invoice in the customer ledger table is created for $450.

Vendors:

Open transactions for vendors within the Payables module are migrated to Business Central as a vendor ledger entry.  The amount is the outstanding amount on the transactions.

Example: In Dynamics GP, Ace Travel has an invoice for $700 invoice with an amount remaining of $500. An invoice in the vendor ledger tables is created for $500.

Items:

The quantity on-hand is migrated for items to the blank location, and the items' valuation method uses the method that was chosen when the company was set up. Service items are automatically set to FIFO.

On a side note, we're planning to also migrate site data for items in one of the upcoming updates to Business Central. 

Additional migrated information:
Along with these transactions, we also migrate some setup information that is needed for posting. We create a posting group for customers, vendors, and inventory, and a general posting group and general product posting group. The accounts for these groups come from the posting accounts set up in the company in Dynamics GP.

Get a list of all posts in the Holiday count down series here:
https://community.dynamics.com/business/b/financials/archive/2018/11/28/counting-down-to-the-holidays-with-daily-blogs