web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Report Performance

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

Suggested Answer

Report Performance

(3) Share

Report

Report

Posted on by Vijay R

139

Hi all,

I have Design One Report Called Customer Balance Report .. based on Cust Ledger Entry Table,

when I'm running the report Its take Lot of time to Show values in the report layout

I taken a flow field values for Calculation , So its Not Feasible to use Calcsum() for flowfield

In request page I filter the value based on Posting Date , User can enter From date & todate

I write MyCode In Onaftergetrecord() trigger

There's Any way to increase the performance of the report to fast?

Kindly Suggest any solution For this ?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Sort by

Suggested answer

Yi Yong 2,730 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

You can take a look on how Aged Accounts Receivable Report and Customer Detailed Ageing is designed, i believe the concept is similar

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 16,690 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

I do Agree with Yi Yong.

If the Logic and Purpose is same then you can use Aged Account Reports from the Base System.

Was this reply helpful? Yes No
Ramesh Kumar 7,561 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You need to debug to see why its taking so long and work backward. Cust Ledger entry table is one of the complex table when comes to Business central to make sure you filter properly or use OnAfterGetRecord

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,464 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Use SETAUTOCALCFIELDS, apply SETRANGE early, use a Query Object for aggregation, minimize OnAfterGetRecord() processing, and consider background processing

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 2,216 Super User 2026 Season 1

#2

YUN ZHU 1,471 Super User 2026 Season 1

#3

AndrewThomas81 1,369

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans