Slow Opening Windows In Microsoft Dynamics GP

Microsoft Dynamics GPI recently implemented Microsoft Dynamics GP for a client who is a UK subsidiary of an American company. This client is a heavy user of the Inventory Control module with over 30,000 items (you’ll see the relevance of this soon).

Shortly after the go-live, users started reporting that windows were opening very slowly; for example, it was taking almost 2 minutes to open the Sales Transaction Entry window. I sat with one of the users and looked at the problem with them; it took a few minutes, due to the slowness, of checking various windows before realising that it was the windows with an Item Number field on them which were slow opening.

I did a quick search online and found a post on Dynamics Code Blocks by Tim Wappat where he had encountered a similar issue which was being caused by the AutoComplete function; this would make sense as by default the AutoComplete will remember 10,000 entries per field.

Which with over 30,000 items and a couple hundred sales orders being processed everyday meant the AutoComplete was quickly building up for each user.

Tim’s solution seemed to be a little more convoluted than I woulr have expected and involved deleting files in the Windows profile. I did a test with one of the users, by deleting the AutoComplete entries via User Preferences (Microsoft Dynamics GP menu » User Preferences) and clicking the AutoComplete button (ringed in red):

User Preferences

Click the AutoComplete button and then the Remove Entries button:

AutoComplete Setup

We also changed the Max. Number of Entries to Store per Field down to 100. Click OK to close AutoComplete Setup. You’ll be presented a reminder that changes won’t take effect until you log out and back in:

Microsoft Dynamics GP - Your changes in the AutoComplete Setup window won

Microsoft Dynamics GP

Your changes in the AutoComplete Setup window won't take effect until the next time you log into the company.

I got the user to log out and back into Microsoft Dynamics GP; when we tested the opening windows they opened at the normal expected speed. Then it was a simple case of passing instructions round the other users to make the same changes.

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.

3 thoughts on “Slow Opening Windows In Microsoft Dynamics GP

Leave a Reply

Your email address will not be published. Required fields are marked *