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

Report 10155 Purchase Advice taking 40 minutes

(0) Share

Report

Posted on by Micheleish

105

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,

I have the same question (0)

All responses (5)

Answers (0)

Valentin Castravet 31,481 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Micheleish 105 on at

Like (0)

Report

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]

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No