Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
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:
Let’s look at this in more detail.
In the Data Migration wizard, you can specify whether you want to use existing account numbers or new account numbers.
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
If you use the existing chart of accounts, the following happens during the migration:
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:
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:
The summary values will pull for the current year and one year prior based on the fiscal periods and the data of the migration.
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.
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.
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
Business Applications communities