web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Migrating General Journal lines from QB desktop to BC

(0) ShareShare
ReportReport
Posted on by

I am using Configuration packages (table 81) to migrate QB General journal lines to BC. After importing the package I am unable to "Apply Data" into the database.

Is there any other way to migrate Historical transactions into BC?

  • Suggested answer
    JAngle Profile Picture
    161 on at

    Have you looked at using this: docs.microsoft.com/.../ui-extensions-quickbooks-data-migration

    Are you unable to apply the data due to error messages?

    In general, configuration packages, is the way that financial migrations would be done with OOTB tooling. Something that is worth considering as an alternative journal import method is the "Payroll Import" button. Left field suggestion but it is worth looking into. On the general ledger setup page you set the below field to use a data exchange definition (https://docs.microsoft.com/en-us/dynamics365/business-central/across-how-to-set-up-data-exchange-definitions)

    pastedimage1594814977358v1.png

    Once you have a data exchange definition formulated based how your data from QB is exported you can import a CSV for example straight into the journal. This skips out a step when you think about how configuration packages work.

    pastedimage1594815166914v2.png

  • danyal-ss Profile Picture
    30 on at

    Are you unable to apply the data due to error messages?   yes during import there are no errors when I apply data .errors appear 

  • Suggested answer
    Renni Profile Picture
    960 on at

    You can validate first to show the errors.

    If you click on the red number in the errors column it should show you them and why I.e more than 50 characters in  a field  or not a valid option.

    You can then correct these issues before re-validating until all errors are gone. You should then be able to apply the 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 664 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 446 Super User 2026 Season 2

#3
Teagen Boll Profile Picture

Teagen Boll 282 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans