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

GL Entry Data Export

(6) Share

Report

Posted on by VG-27060905-0

Hi All,

Does anybody know a way to export the GL Entry Data of a month each month contains 3 to 4 Million entries, i have tried rdlc report but it has limit of 500000 lines, excel/csv report but it has limit of 1048576 lines. Please suggest any other way i could export the data.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Sumit Singh 10,079 on at

Like (1)

Report
You can develop a custom AL report or codeunit that:

Exports G/L Entries in chunks (e.g., 500,000 lines per file).

Writes to Azure Blob Storage, OneDrive, or downloads as .txt/.csv.

Uses StreamWriter or File APIs in AL.

This can be the one of methods within BC SaaS.

Note: This response was created in collaboration with Microsoft Copilot to ensure clarity and completeness. I hope it helps to some extent.
Mark the Answer as Verified if this is Helpful.

Was this reply helpful? Yes No
VG-27060905-0 96 on at

Like (2)

Report

Thank I have already developed a code to export data in chunks though it would have been better if there was a way to export entire month data in one go

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (1)

Report

Txt should not have this limitation, you can try it

PS: Dynamics 365 Business Central: Using TextBuilder Data Type to export data to a text file

https://yzhums.com/21942/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (3)

Report

Have you tried XMLPort to export the data? I think that should work.

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (2)

Report
For millions of G/L entries, RDLC/Excel won’t work due to their row limits. The practical options are:

Configuration Package / RapidStart – works well for large table exports.

API / OData – pull data in chunks (with filters like date ranges).

SQL (On-Prem only) – direct query if you’re running BC on-prem.

Custom report/extension – stream data to CSV or a data lake without row limits.

For SaaS, the best way is to use API with filters or Configuration Package to export monthly batches.

✅ Mark this as the verified answer if helpful.

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,672 Moderator on at

Like (1)

Report

Develop a Query or a Query API:

Query object - Business Central | Microsoft Learn

API query type - Business Central | Microsoft Learn

Method property - Business Central | Microsoft Learn

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,347 Super User 2025 Season 2 on at

Like (2)

Report

Adding it: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/operational-limits-online

Was this reply helpful? Yes No
Suggested answer

Satish Srivastava 242 on at

Like (1)

Report

https://yzhums.com/21942/

Query object - Business Central | Microsoft Learn

API query type - Business Central | Microsoft Learn

Method property - Business Central | Microsoft Learn

Was this reply helpful? Yes No