optimizations to reduce the processing time

(6) Share

Report

Posted on by CU20091458-1

188

I am currently working on a report that involves customer-led entries, which includes certain summation calculations. However, the report generation process takes an extended amount of time due to the complexity of these calculations.

Could you kindly advise on potential solutions or optimizations to reduce the processing time and improve the efficiency of the report generation?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (3)

Sort by

Suggested answer

Sumit Singh 11,795 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!
Hi,
Key optimizations for improving report performance in Business Central:
1. Data Modeling

Use SumIndexFields (SIFT) and FlowFields for pre-aggregated totals.

Replace loops with Query objects or CALCSUMS for SQL-side aggregation.

Use temporary tables for complex grouping.

2. Indexing

Ensure keys match filters and sort order.

Add SumIndexFields for frequently summed fields.

3. Query Design

Apply filters early (SETFILTER, SETRANGE) before fetching data.

Avoid calculating FlowFields inside loops.

Limit dataset size at the source.

4. Report Layout

Include only necessary fields.

Avoid deeply nested DataItems; use pre-joined queries or temp tables.

5. Caching & Incremental Processing

Cache reusable totals.

For recurring reports, store intermediate results and update incrementally.

6. Execution

Run heavy reports in background sessions.

Monitor SQL performance via telemetry or SQL Profiler.

Please mark "Verified" it it helps

Was this reply helpful? Yes No
Verified answer

Rishabh Kanaskar 6,225 Super User 2026 Season 1 on at

Like (7)

Report
Copy link

Link copied!

Hi,

> Optimize by filtering data as early as possible (using SETFILTER/SETRANGE) and minimizing data iteration inside report triggers.

> Avoid nested loops where possible, use temporary tables to pre-aggregate data, and leverage FlowFields/Query objects for summations instead of manual calculations.

> Also, ensure keys on tables match your filters to speed up data retrieval.

Thanks

Rishabh

Was this reply helpful? Yes No
Verified answer

Sahan Hasitha 2,683 on at

Like (5)

Report
Copy link

Link copied!

hi

you can use calcsum function to reduce the processing time

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Nimsara Jayathilaka. 5,102 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!

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
Verified answer

Gerardo Rentería Ga... 26,511 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

Report performance - Business Central | Microsoft Learn

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Pallavi Phade 5,570 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Namaste @CU20091458-1

Customer Ledger Entries columns have flowfields coming from Detailed Customer LEdger Entries . Flow fields slows down performance

Detailed Customer ledger Entries

You can have two approaches i can suggest

1) Create Query out of report

https://www.youtube.com/watch?v=GrAEs1tNFxw - youbtube link in detail

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-query-object

2) Create REpot base data item as "dEtailed Customer Ledger Entry" and do summation

Else verify in telemetry insights

Regards

Pallavi Phade

Was this reply helpful? Yes No