web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / GL Entry Data Export
Small and medium business | Business Central, N...
Suggested Answer

GL Entry Data Export

(6) ShareShare
ReportReport
Posted on by VG-27060905-0 96
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)
  • Suggested answer
    Sumit Singh Profile Picture
    Sumit Singh 11,782 Super User 2026 Season 1 on at
    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.
  • VG-27060905-0 Profile Picture
    VG-27060905-0 96 on at
    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
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 100,093 Super User 2026 Season 1 on at
    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
     
    Thanks.
    ZHU
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,278 Super User 2026 Season 1 on at
    Have you tried XMLPort to export the data? I think that should work.
  • Suggested answer
    Sohail Ahmed Profile Picture
    Sohail Ahmed 11,173 Super User 2026 Season 1 on at

    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.

  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,696 Moderator on at
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 22,340 Super User 2026 Season 1 on at
  • Suggested answer
    Satish Srivastava Profile Picture
    Satish Srivastava 242 on at

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,905 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 994 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 668 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans