Small and medium business | Business Central, N...

Migration from Intuit QuickBooks to Dynamics 365 Business Central

(0) Share

Report

Posted on by Bob Manjoney

105

I'm facing an issue when attempting to use the Quickbooks data migration process ("Data Migration Exporter" tool) to export QB company data. When attempting to run this tool against the client's company file, it immediately errors out telling us that "An account number cannot be empty".

This is in fact true - this source company file in question does not use account numbers and instead uses account name/ID's - the account number field evidently is not a required field in QB.

Other than retrofitting every GL account in the source company file with a dummy account number just to please the export tool, is there any other workaround for this problem? If account numbers are required by D365 BC, then couldn't the migration tool at least create them automatically?

Thanks in advance,
Bob

Categories:

Data Migrations

All responses (3)

Answers (0)

Suggested answer

Mehreen. on at

Like (0)

Report

RE: Migration from Intuit QuickBooks to Dynamics 365 Business Central

Hi,I have also migrated data from quick book desktop application to Business Central but I didn't find my QB invoices in sales invoices in BC ...but they are in G/L accounts how can I fix this?
Community Member Microsoft Employee on at

Like (0)

Report

RE: Migration from Intuit QuickBooks to Dynamics 365 Business Central

Bob Manjoney did you find any solution about this problem?

I am facing the same problem. I have only one charts of accounts record that has account number but still Microsoft Data Exporter tool is giving the error "An account number cannot be empty".

Please help me in this

Thanks
Suggested answer

Olister Rumao 3,957 on at

Like (0)

Report

RE: Migration from Intuit QuickBooks to Dynamics 365 Business Central

Hi Bob,

I have not worked on Quick Books Data Migration in detail but I should be able to help you on the Business Central side.

As per Microsoft Document, Data Exporter Tool only works with QB 2017 and QB 2018.

docs.microsoft.com/.../ui-extensions-quickbooks-data-migration

As far as migrating Chart of Accounts is concerned, it should be automatically done probably there might be an issue in the process that you are following.

Let me know if you need any help.