Share
Report*This post is locked for comments
You’re offline. This is a read only version of the page.
655
*This post is locked for comments
Hello Jono,
You could also try running a SQL Trace on the process while it is going:
857246 How to create a SQL Trace with Profiler on Microsoft SQL Server 2000
support.microsoft.com/.../en-US
If you need assistance with reading the trace results I would recommend you contact your Microsoft Partner.
Other things we check for performance issues is if there are any 3rd party products running that could be slowing things down. If there are try disabling them in the Dynamics.set file and then see if the report prints faster:
872087 Steps to disable third-party products or temporarily disable additional products in the Dynamics.set file in Microsoft Dynamics GP
support.microsoft.com/.../en-US
One more thing to check is if the Historical Stock Status report is modified. We see many performance issues with reports that are due to modifications that are incorrect or when a customer is trying to run a modified report from a prior version of GP. Since table structure has changed between version this can sometimes cause issues as well.
If the above does not help I would recommend opening a support incident so that an engineer can look into the issue in more detail.
Best regards,
Dan Moore
Customer Online Technical Community
-----------------------------------------------------------------------------------------
We hope you get value from our new forums platform! Tell us what you think:
social.microsoft.com/.../threads
------------------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights
Hi Jono
Is the company running this report heavy processing inventory transactions? have you noticed any performance issues with other detailed inventory reports?
Sometimes GP appears to be hung up, but if you review the process with task manager > performance monitor it might be still working for you, or trace the sql server for activity, as those are points where you can definitely determine if the app is hung or not.
Also have you tried running the same report as summary? if so, does it delay as well?
Hi Jono,
Did you find a solution to your problem? What version of GP are you running?
Thanks,
Bradley
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (