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

General Journal Row (Lines) Limit in Business Central

(0) Share

Report

Posted on by MahGah

15,447

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

All responses (6)

Answers (0)

CH-13010144-0 2 on at

Like (0)

Report

General Journal Row (Lines) Limit in Business Central

I have posted an 84194 row journal entry. I pasted the data right into the journal from an excel sheet. Definitely too large for cloud based accounts.
MahGah 15,447 on at

Like (1)

Report

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 1,029 Moderator on at

Like (0)

Report

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 21,571 Moderator on at

Like (1)

Report

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 15,447 on at

Like (0)

Report

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 21,571 Moderator on at

Like (0)

Report

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.