Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Improve the performanc...
Microsoft Dynamics GP (Archived)

Improve the performance of Item Stock Inquiry with Manufacturing

(0) ShareShare
ReportReport
Posted on by Robert Brown 70

Hello,

Wondering if anyone has experienced very slow response time with the item stock inquiry window. We are using Dynamics GP with manufacturing and we have a lot of history which I am sure doesn't help. I was wondering if anyone had any suggestions for improving other than purging historical data. I wish the window had the ability to filter by date. Typically the wait time for a heavy volume item is as much as 20-30 seconds before any data shows up and it also causes the application to go into that unresponsive state until data is returned which leads to orphaned sessions when users get impatient and force the application to close.

 

*This post is locked for comments

  • Robert Brown Profile Picture
    Robert Brown 70 on at
    Re: Improve the performance of Item Stock Inquiry with Manufacturing

    Yes if Richard's suggestion is valid, what table or view supplies the item stock inquiry window and since the only filters available are item number and site wouldn't they already be indexed, I can't imagine item number wouldn't be.

  • Robert Brown Profile Picture
    Robert Brown 70 on at
    Re: Improve the performance of Item Stock Inquiry with Manufacturing

    I don't know which table or view supplies the data to the item stock inquiry window and also since the window only allows a filter of item number and site shouldn't those item's already be indexed? Any assistance is greatly appreciated as this is a very popular user window.

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Improve the performance of Item Stock Inquiry with Manufacturing

    You can use MS-SQL to apply suplimental indexes.  If, for example, you are searching by a particular field frequently and that field is not key in one of the existing indexes, searches will be slow.  Adding a suplimental index by that field will help greatly.   One of my customers was waiting 60-120 seconds for data to be returned and a suplimental reduced the search to 1-2 seconds.

    Do not apply to many suplimentals.  Typically, more than 10 indexes can cause inserts and updates to slow down!

  • Greg Willson Profile Picture
    Greg Willson 250 on at
    Re: Improve the performance of Item Stock Inquiry with Manufacturing

    Hello Robert,

    I was going through unanswered posts and notice this post of yours that was never responded to.  I'm wondering if you still had questions on this particular issue.

    Regards,

    -Greg

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans