101
I have a client who is stating this report is taking 30-40 minutes to produce 2 pages, I tried to recreate the issue, it seems it's happening during the work day and just started after the latest update. He tried Performance Analysis but it just timed out. Any suggestions on quickly identifying the reason this report would be slow?
Thanks,
Hi, you can also refer to the Microsoft documentation below to investigate the issue.
How to work with a performance problem: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/performance/performance-work-perf-problem
And if this is the SaaS version, I recommend submitting a Service Request to Microsoft and letting them assist in the investigation.
Hope this helps.
Thanks.
ZHU
Thank you,
We tried the performance analysis, it timed out.
[quote user="Micheleish"]I have a client who is stating this report is taking 30-40 minutes to produce 2 pages, I tried to recreate the issue, it seems it's happening during the work day and just started after the latest update. He tried Performance Analysis but it just timed out. Any suggestions on quickly identifying the reason this report would be slow?
Thanks,
[/quote]Hi, If you are using the latest version of BC, you can use the following method to quickly find out whether it is a standard problem or a custom problem. And which program consumes the longest time.
In-client performance profiler (Performance Profiler page): https://yzhums.com/23121/
Hope this helps.
Thanks.
ZHU
Are there any customizations done to the report or to the purchase functionality in the system?
Are you running BC online or BC on prem?
If you are in BC online with no customization you can open a support ticket to Microsoft around this case.
this is what I would do:
-run the report in a different company or different environment (i.e. in sandbox), or even in a Cronus company in their environment to see if the issue is with the company/data or something else
-run the report with filters (specific item, range of items, specific locations, etc.) to try to find if its still slow or a specific record is making it slow
-check the no. of unposted sales/purchase orders, do they have a lot sitting there the report has to go through
-if its happening during the work day, are they posting a lot of transactions at the same time the report is run
#1
André Arnaud de Cal...
292,884
Super User 2025 Season 1
#2
Martin Dráb
231,758
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
