optimize the performance of this report,

(2) Share

Report

Posted on by CU20091458-1

I am working on a report that aggregates customer data from the Customer table and the Customer Ledger Entry table. However, the report currently takes a long time to run due to the summation calculations being performed on the Customer Ledger Entry table.

I am looking for suggestions on how to optimize the performance of this report, specifically in relation to reducing the time required for the summing operations within the Customer Ledger Entry table.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Nimsara Jayathilaka. 2,745 on at

Like (4)

Report

optimize the performance of this report,

Hi

Replace manual CLE summations with FlowFields or indexed CALCSUMS, and if data volume is very large, build a summary table updated periodically. This will cut runtime drastically

Thanks

Nimsara

1 people found this reply helpful.

Was this reply helpful? Yes No
Sahan Hasitha 1,374 on at

Like (4)

Report

optimize the performance of this report,

hi

like this

Was this reply helpful? Yes No
Suggested answer

Sahan Hasitha 1,374 on at

Like (4)

Report

optimize the performance of this report,

hi

you can use calcsum for calculation

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 988 on at

Like (1)

Report

optimize the performance of this report,

Hi,

> In addition to FlowFields and queries, check that your Customer Ledger Entry table has proper keys matching your filters (e.g., by Customer No., Posting Date). Add a dedicated key if needed for faster lookups.

> If you must loop through entries, do it once, store results in a temporary table, and use that table as the data source for the report sections — this avoids repeated CALCFIELDS calls.

> You can also schedule Adjust Cost – Item Entries and Update Customer Statistics jobs regularly so that calculated values are always up to date and faster to retrieve.

Thanks

Rishabh

Was this reply helpful? Yes No