Dynamics 365 for Financials – Import from Quickbooks

Posted on: July 5, 2018 | By: Jim Bertler | Microsoft Dynamics Business Central

Authored by: Brent Stabiner

 

Let’s talk about migrating company data into Dynamics 365 for Financials. Users have the following 3 migration options by default when navigating through the Data Migration wizard, which can be launched from the Assisted Setup window:

  • Import from Excel

  • Import from QuickBooks (IIF)

  • Import from Microsoft Dynamics GP

Users can also find additional migration options from partners in the Extension Marketplace.

Please be aware that once any transactions have been entered into a company the migration tools will not work. If at any point after a transaction is entered there is a need to redo the migration, then a fresh company will need to be created. If a user re-runs the migration without transactions, any existing master records will be updated.

 

This post will specifically cover importing from QuickBooks. Other blog posts are available that discuss importing from the other sources.

 

Import from QuickBooks:

Currently there is only a solution for QuickBooks on-prem. Until then, the best option is to get assistance from 3rd party extensions or partners. To begin, the QuickBooks data must be exported to an IIF file to be imported to Dynamics 365 for Financials. The wizard provides users with the steps to do this when migrate from QuickBooks is selected.

Here are some guidelines to keep in mind when importing from QuickBooks:

  • Beginning Balances are brought in for GL accounts and Items quantity on hand only. There are no beginning balances for Vendors or Customers in an IIF file.

  • QuickBooks does not have a Unit of Measure. When items are imported, use a template that has a Unit of Measure selected. Be careful here as it will let you type in a Unit of Measure that doesn’t exist. Make sure to select an existing one from the drop-down or create a new one that to use.

  • It’s possible to use QuickBooks without account numbers. It is not possible to migrate without account numbers though. Item accounts must exist in QuickBooks in order to bring in quantity on the items.

  • CustomerVendor templates are optional.

  • Accounts are imported first at which point posting groups must be created. Accounts need to be imported first to successfully import the remaining data.

  • It is possible to have 1-sided entries in QuickBooks that create out of balance accounts. Out of balance accounts will not migrate into Dynamics 365 for Financials as this is not allowed in the product.

For further insight on Microsoft Dynamics 365 installation and implementation, contact Logan Consulting, your Microsoft Dynamics 365 Partner of Chicago.



Top 10 Inventory & Operations Decisions Distributors Are Making Blind
Top 10 Inventory & Operations Decisions Distributors Are Making Blind

Free Download:

Top 10 Inventory & Operations Decisions Distributors Are Making Blind

Download the guide ›

2020 Nucleus Research Report on ERP Technology

Free Download:

2020 Nucleus Research Report on ERP Technology

Download the guide ›