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

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... / Inventory Valuation (1...
Small and medium business | Business Central, N...
Suggested Answer

Inventory Valuation (1001) - Report is not running well

(0) ShareShare
ReportReport
Posted on by Jasta 10

Hello Community,

i got a Problem with the above mentioned report. 2 Weeks ago (and today in our Stage System) the Report was doing well (running time OK). Yesterday we used it once again and don`t get any data in several hours of processing. 

After a short test with Stage Database i had to realize that there the report is doing well and delivers the queried information several minutes later.

The Code in itself doesn't seems to be the Problem so i moved my investigations to the SQL Database and i suspect that the server no longer applies the index.

Is there a possibility in the SQL Tracing to find out which index the system uses to execute the query? If yes, i would take the information from the Stage system and re-create the broken index in Live System to get the performance back.

Thank you in advance for your help.

Best Regards,

Jasta

  • Suggested answer
    Gearoid Profile Picture
    Gearoid Microsoft Employee on at

    Hi Jasta,

    With a SQL Profiler trace you can capture the Event "Performance:Showplan XML". This will show you the plan used by SQL Server to execute each query and the information it provides includes the index name used. 

    Hope that helps.

  • AriaConsulting Profile Picture
    AriaConsulting 4 on at

    This sounds like something you should definitely open a ticket with MS support for.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Jasta,

    If you are capable of performing a SQL Trace it will help with what might be effecting the reports performance. Not sure if you like Report Inventory Valuation but try running Inventory to G/L Reconcile, which uses the Valuation in first column.

    If you still have issues, please ask your Partner to submit a Microsoft Support ticket.

    Thanks,

    Steve

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 796 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 481 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 377 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans