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

Notifications

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... / Report Performance
Small and medium business | Business Central, N...
Suggested Answer

Report Performance

(3) ShareShare
ReportReport
Posted on by Vijay R 129
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)
  • Suggested answer
    Yi Yong Profile Picture
    Yi Yong 2,594 Super User 2025 Season 2 on at
    Hello,
     
    You can take a look on how Aged Accounts Receivable Report and Customer Detailed Ageing is designed, i believe the concept is similar
  • Suggested answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 15,639 Super User 2025 Season 2 on at
    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. 
  • Ramesh Kumar Profile Picture
    Ramesh Kumar 7,529 Super User 2025 Season 2 on at
    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.
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 20,971 Super User 2025 Season 2 on at
    Use SETAUTOCALCFIELDS, apply SETRANGE early, use a Query Object for aggregation, minimize OnAfterGetRecord() processing, and consider background processing

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,116

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 764 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 635 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans