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

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Olister Rumao 3,967 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Mehreen. on at

Like (0)

Report

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?

Was this reply helpful? Yes No
PhillipsB 102 on at

Like (0)

Report

The "account number" error occurs because D365 BC requires account numbers. Manually adding dummy numbers is one fix, but it’s tedious. A workaround could be exporting QB data to Excel, adding numbers there, then importing to D365 BC. Tools like Skyvia can also streamline the migration by automating the mapping process and avoiding manual adjustments.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,371 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

Transfer data from a QuickBooks app - Business Central | Microsoft Learn

Best Regards
Gerardo

Was this reply helpful? Yes No