Skip to main content
Post a question

Notifications

Announcements

No record found.

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

Migration from Quickbooks Desktop to Business Central ft. Data Export Tool

Like (1) ShareShare
ReportReport
Posted on 30 Jan 2025 11:00:30 by 136

Hello Community,

I attempted to migrate data from QuickBooks Desktop to Business Central using the Microsoft Data Export Tool but encountered an error during the process.

Additionally, I am using QuickBooks Desktop 22.0, whereas Microsoft's documentation states that the Data Export Tool is only compatible with QuickBooks versions 2017 and 2018. Given this limitation, I am unsure how to proceed.

I would appreciate any suggestions or alternative approaches to resolve this issue. One option I am considering is migrating QuickBooks Desktop to QuickBooks Online first, and then transferring data from QuickBooks Online to Business Central. Has anyone tried this approach for migration?

Below is the error message I encountered when exporting data from QuickBooks using the Data Export Tool:

---------------------------------------------------------------------------------------------------------------------------------------

See the end of this message for details on invoking 

just-in-time (JIT) debugging instead of this dialog box.

 

************** Exception Text **************

System.Runtime.InteropServices.COMException (0x80040301): An exception occurred! Type:UTFDataFormatException, Message:invalid byte 2 (x) of a 3-byte sequence.SAXParseException: error at line 2379, column 20 in XML data.

   at Interop.QBFC13.IQBSessionManager.DoRequests(IMsgSetRequest request)

   at Microsoft.DataMigrations.QBDConnector.QBDDataContext.QBSession.InvokeRequest[TResponse](Action`1 constructRequest)

   at Microsoft.DataMigrations.QBDConnector.QBDDataContext.<GetCustomers>b__17_0()

   at Microsoft.DataMigrations.QBDConnector.QBDDataContext.InvokeWrappedException[TResult](Func`1 invoke)

 

 

************** Loaded Assemblies **************

mscorlib

    Assembly Version: 4.0.0.0

    Win32 Version: 4.8.9290.0 built by: NET481REL1LAST_C

    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll

----------------------------------------

Microsoft.DataMigrations.WindowsDesktopApp

    Assembly Version: 1.0.10.16

    Win32 Version: 1.0.10.16

    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Data%20Exporter/Microsoft.DataMigrations.WindowsDesktopApp.exe

----------------------------------------

System.Windows.Forms

    Assembly Version: 4.0.0.0

    Win32 Version: 4.8.9251.0 built by: NET481REL1LAST_C

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

----------------------------------------

System

    Assembly Version: 4.0.0.0

    Win32 Version: 4.8.9282.0 built by: NET481REL1LAST_C

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll

----------------------------------------

System.Drawing

    Assembly Version: 4.0.0.0

    Win32 Version: 4.8.9037.0 built by: NET481REL1

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

----------------------------------------

System.Configuration

    Assembly Version: 4.0.0.0

    Win32 Version: 4.8.9037.0 built by: NET481REL1

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

----------------------------------------

System.Core

    Assembly Version: 4.0.0.0

    Win32 Version: 4.8.9277.0 built by: NET481REL1LAST_B

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll

----------------------------------------

System.Xml

    Assembly Version: 4.0.0.0

    Win32 Version: 4.8.9037.0 built by: NET481REL1

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

----------------------------------------

Accessibility

    Assembly Version: 4.0.0.0

    Win32 Version: 4.8.9037.0 built by: NET481REL1

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll

----------------------------------------

Microsoft.DataMigrations.QBDConnector

    Assembly Version: 1.0.10.16

    Win32 Version: 1.0.10.16

    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Data%20Exporter/Microsoft.DataMigrations.QBDConnector.DLL

----------------------------------------

System.ComponentModel.Composition

    Assembly Version: 4.0.0.0

    Win32 Version: 4.8.9037.0

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ComponentModel.Composition/v4.0_4.0.0.0__b77a5c561934e089/System.ComponentModel.Composition.dll

----------------------------------------

Newtonsoft.Json

    Assembly Version: 9.0.0.0

    Win32 Version: 9.0.1.19813

    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Data%20Exporter/Newtonsoft.Json.DLL

----------------------------------------

System.Numerics

    Assembly Version: 4.0.0.0

    Win32 Version: 4.8.9037.0 built by: NET481REL1

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll

----------------------------------------

System.Runtime.Serialization

    Assembly Version: 4.0.0.0

    Win32 Version: 4.8.9241.0 built by: NET481REL1LAST_C

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll

----------------------------------------

System.Xml.Linq

    Assembly Version: 4.0.0.0

    Win32 Version: 4.8.9037.0 built by: NET481REL1

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.Linq.dll

----------------------------------------

System.Data

    Assembly Version: 4.0.0.0

    Win32 Version: 4.8.9214.0 built by: NET481REL1LAST_B

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll

----------------------------------------

 

************** JIT Debugging **************

To enable just-in-time (JIT) debugging, the .config file for this

application or computer (machine.config) must have the

jitDebugging value set in the system.windows.forms section.

The application must also be compiled with debugging

enabled.

 

For example:

 

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

 

When JIT debugging is enabled, any unhandled exception

will be sent to the JIT debugger registered on the computer

rather than be handled by this dialog box.

---------------------------------------------------------------------------------------------------------------------------

 

Any insights or recommendations would be greatly appreciated!

Thanks in advance.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 77,461 Super User 2025 Season 1 on 03 Feb 2025 at 00:24:06
    Migration from Quickbooks Desktop to Business Central ft. Data Export Tool
    Hi, Quickbooks has standard migration tools. But if you encounter problems from Quickbooks, it is recommended to post the problem into the Quickbooks forum.
     
    Thanks
    ZHU
  • gdrenteria Profile Picture
    gdrenteria 14,170 Most Valuable Professional on 02 Feb 2025 at 18:54:27
    Migration from Quickbooks Desktop to Business Central ft. Data Export Tool

    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

  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 8,227 Super User 2025 Season 1 on 01 Feb 2025 at 15:56:45
  • BBC_dhanvi Profile Picture
    BBC_dhanvi 136 on 01 Feb 2025 at 13:52:19
    Migration from Quickbooks Desktop to Business Central ft. Data Export Tool
    @Bilal Haider By Manual Process, we are facing issue while exporting BOM. QB Desktop is not generating aggregate report.
    Can you suggest some ways to extract all of the data? as it is one of the road blocker to take the manual way. Thank you for you suggestion.
  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 175 on 30 Jan 2025 at 12:03:00
    Migration from Quickbooks Desktop to Business Central ft. Data Export Tool
    Hi,
     
    The easy way in terms of Business Central is to migrate to quick books online and then to Business central using tool. (I am not sure how big effort is to migrate to Quick Books online).
     
    Other manual way is to export data in csv/excel and then  use configuration packages from Business Central to transform and import data.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,257 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,028 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Loading started