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

Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Config. Worksheet - Ge...
Small and medium business | Business Central, N...
Suggested Answer

Config. Worksheet - Gen Journal Data Migration 'Updating validation errors' HELP PLEASE

(4) ShareShare
ReportReport
Posted on by S2k_85 22

Hi Guys,

I really need some help.

I am doing some Data Migration for GL journals. 

I have created my Config. Worksheet with Table 81 Gen Journal, ticked the box for Dimensions as Columns and filled in my Excel template.

It is only an 8k journal, which when loaded in, the lines went in within 10 mins however after that i have had a box come up saying 'Updating Validation errors' with a progress bar 0% - 100%

This bar goes to 100% every 10 seconds and then the box pops up again as if its checking a new line.

The ISSUE is that this has been going on for 2 hours now with no hint of stopping.

I have another 20 more journal batches to do, i was expecting it to be done quickly. 

What do i do, and how do i get this to not happen again for the next batch - any chance i can switch the validation errors off?

can anyone please help me?

I have the same question (0)
  • IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 Moderator on at

    In my experience large journals like that does not work very well in the configuration packages.

    I would use another method to import them.

    My others may have other experiences.

  • S2k_85 Profile Picture
    S2k_85 22 on at

    Thanks for the reply.

    What other method can I use to import a journal of that size?

    Thanks

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 101,787 Super User 2026 Season 1 on at

    Hi, This is a bit strange, I don't think 8K is the limit of Configuration Package. And this is still in the Windows Client.

    I think the first thing you should try is to reduce the fields you don't need.

    pastedimage1643932784579v1.png

    Please do not select all fields.

    pastedimage1643932804874v2.png

    If it still doesn't work, you can reduce the number of the record and try again.

    As for other methods:

    1. You can copy directly from Excel to the General Journal page (Ctrl+V)

    2. You can use ExcelBuffer or XMLPort to develop a small tool to import data directly from Excel or CSV.

    Hope this will help.

    Thanks.

    ZHU

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hello,

    Adding to other replies... I have done Configuration Packages that have had 700K records, which was more than 8K in size. How many columns are you importing. As YUN said, remove the columns that are irrelevant. Most of my Table 81 Config. Packages only have these fields:

    pastedimage1644093700158v1.png

    What are your fields? Something is validating that is causing this. Send back a pic.

    Thanks,

    Steve

  • Suggested answer
    Sai Ragavan Profile Picture
    Sai Ragavan 51 on at

    On the Configuration Package card, under 'Tables' Tab-> click Table -> Click 'Fields'

    Click 'Edit List' and only 'Include Field' the ones you need. More importantly to overcome this issue, uncheck the 'Validate field' box for all the included fields.

    This issue is more pertinent when you include Dimensions to your load. Ensure that the Dimensions fields (seen at the very bottom of the list) AND the Dimension Set ID fields are unchecked at 'Validate Field' check box.

    The loading should be much more faster. Since you have opted to remove validation here, it will be done during the journal posting.

  • VS-19090754-0 Profile Picture
    VS-19090754-0 6 on at
    Same issue here same table. The problem is i need all the fields, importing in a SaaS Sandbox and in order to import 30k lines it took me about 10 hours. 
    On the popup while importing i get the message updating validation errors followed by the number 291 blinking (sometimes its 191). My package has dimensions as columns.
  • Suggested answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 17,220 Super User 2026 Season 1 on at
    Hello VS-19090754-0,

    Your import is slow because every field (especially dimensions) triggers full validation in Business Central. This makes RapidStart configuration packages very inefficient for large datasets like 30K lines.

    Suggestion:
    Use XMLports or APIs instead of configuration packages.
    Split data into smaller batches.
    Run during off-peak hours.
    RapidStart is meant for initial setup, not mass imports.

    Regards,
    Oussama Sabbouh
  • Suggested answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 16,865 Super User 2026 Season 1 on at
    May this can help : https://yzhums.com/44435/

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,497 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,778 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,507

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans