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

General Journal Row (Lines) Limit in Business Central

(0) Share

Report

Posted on by MahGah

15,529

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

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

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

Thanks.

Was this reply helpful? Yes No
MahGah 15,529 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
MahGah 15,529 on at

Like (1)

Report

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

Was this reply helpful? Yes No
CH-13010144-0 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No