Tuesday, July 24, 2012

Dynamics GP Window Opens Automatically When GP Is Launched

Today I fielded an interesting question on Experts Exchange regarding a random Dynamics GP window that was opening when a user logged into GP 2010.

It started out as an error message when the user logged in, saying "You don't have security privileges to open this window."  Most of us are familiar with this message.

So the consultant solved that problem with David Musgrave's instructions and the Support Debugging Tool.  In the process, he discovered that the window that was causing the error was the Report Schedule window.  The what?  I haven't had a client that used the GP Report Scheduler, so I had to dig out the documentation just to find the window.

So now that the permissions were fixed, the Report Schedule window would open automatically every time the user logged in.  This is pretty odd, since the user doesn't use the Report Schedule window, and never had permissions to open it.  And the fact that it was opening automatically was pretty strange as well.

So we both reviewed the documentation, but didn't see any option that would cause the window to open automatically.

The only other thing I could think of was that maybe a window shortcut had been placed in the user's Startup folder.  But oddly, no shortcuts were displayed in the user's Startup folder in GP.

The consultant then had a pretty good idea--he traced the location of the user shortcuts to the DYNAMICS..SY01990 table.  He then queried that table for the specific user, and found that sure enough, there was a record for the Report Schedule window for that user.

He deleted the shortcut record from SY01990, and the window stopped opening automatically.

There might have been a few clues that we missed that explained how and why this happened, but the details that were found made it a pretty odd problem.  Fortunately the fix was pretty easy--once the consultant found the mysterious shortcut record.

Steve Endow is a Dynamics GP Certified Trainer and Dynamics GP Certified IT Professional in Los Angeles.  He is also the owner of Precipio Services, which provides Dynamics GP integrations, customizations, and automation solutions.


No comments: