An available update error while login to Microsoft Dynamics GP

Last few days I was working on a problem reported by my customer. Finally, I have decided to create my customer’s environment to debug the problem they were facing. After going through several steps to set up the GP environment (up to the same GP service pack level), I was ready to synchronize the account framework and login to GP application to troubleshoot the issue. At this point, I ran into the following error message while I was log into GP application–

“An available update may be required for your computer, but the update process couldn’t verify information. Contact your system administrator for additional information.”

(this happened only when you log in to GP and not while connecting to GP utilities…)

Immediately I knew that this error has something to do with Dynamics GP client update. I queried SYUPDATE table in DYNAMICS database and found 2 entries with UNC path pointing to my customer’s environment. Initially, I was little hesitant to delete the records. I have decided to dig little more before I delete the records. I stumbled up blog articles which gave me all the answers that I needed to solve the issues.

Thanks to Doug Pitcher for their wonderful blog article.

Open SQL Server Management Studio

USE DYNAMICS;
GO

SELECT * FROM SYUPDATE;
GO

DELETE SYUPDATE;

Doug’s Article:

Error when login to Dynamics GP – An Available Update…