Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Answered

General Journal Row (Lines) Limit in Business Central

Posted on by 15,409

Hi 

Does Business Central has any limitation around how many rows (lines) you can populate in general journal? I mean can you populate 20,000 rows (lines) in general journal than post? How about 50,000? 

(Let say we want to populate it through API) 

Thanks 

  • MahGah Profile Picture
    MahGah 15,409 on at
    RE: General Journal Row (Lines) Limit in Business Central

    Thanks Mr Bruvik for detailed information here. I just tried with 15000 line and had the same issue. Looks like I need to stay close to 5000 as you mentioned.

    I will try Json importer as well.

    Thanks

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,720 Super User on at
    RE: General Journal Row (Lines) Limit in Business Central

    In theory there is no limit but for practical reasons there is a limit. I did a test around this a couple of weeks ago.

    Then I was able to insert 30000 lines into a journal, but when I tried to post the lines in one big batch the system broke and the posting never went through even after several attempts. This I did in BC Online. It would probably be more robust in BC on-prem.

    So I think you for practical reasons should try to limit the number on lines you handle in a row to somewhere around 5000 lines and if you have larger datasets than that try to break them into smaller batches.

    And for the import I would recommend you create your own xml og json import - the API's have some limitations when it comes to workloads.

    And I would prefer Json import because I think that works faster than handling XML.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 20,991 Super User on at
    RE: General Journal Row (Lines) Limit in Business Central

    I would not say that it will not take time, yes it will take time for this much records, yes you can use XML Importer in first place then edit in excel.

    Thanks.

  • MahGah Profile Picture
    MahGah 15,409 on at
    RE: General Journal Row (Lines) Limit in Business Central

    Thanks Nitin Verma  if we want to upload that 50k into general journal what is the fastest and efficient method? Edit in Excel? XML importer? or ...? (except API I mean)  

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 20,991 Super User on at
    RE: General Journal Row (Lines) Limit in Business Central

    Yes you can do it with 50K lines in General journal, you can try with running the API.

    Thanks.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans