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

General Journal Row (Lines) Limit in Business Central

(0) Share

Report

Posted on by MahGah

15,613

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)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Thanks.
MahGah 15,613 on at

Like (0)

Report
Copy link

Link copied!

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

Like (1)

Report
Copy link

Link copied!

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.
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.
MahGah 15,613 on at

Like (1)

Report
Copy link

Link copied!

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
CH-13010144-0 2 on at

Like (0)

Report
Copy link

Link copied!

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.