Dynamics Community Forum Thread Details

Report Generation - GSTR-1

Dear Experts,

We have implemented a GSTR-1 report in Dynamics 365 Business Central. The report contains multiple sheets by transaction type, and its format complies with Government requirements.

The report is working successfully for most projects where the number of Posted Sales Invoice transactions is relatively limited. However, we are facing a performance issue in one project where the monthly transaction volume is significantly higher.

Due to the large amount of data, the report generation process takes a considerable amount of time and eventually gets cancelled automatically before completion. As a result, the report is not generated.

We would like your guidance on the following points:

What could be the possible reason for the report timeout or automatic cancellation?
Are there any Business Central limitations related to report execution time, memory consumption, or Excel report generation?
What customization approaches can be implemented to handle large data volumes efficiently?
Are there any best practices for optimizing large Excel reports in Business Central SaaS environments?

Any recommendations for improving report performance and handling high transaction volumes would be greatly appreciated.

Thank you for your support.

Categories:

Dynamics 365 Business Central

Quick Links

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