How many times have consultants faced the situation where the system menu password in Dynamics GP is forgotten? This typically happens when we return to a client for an upgrade after about a year and it happens to be the case where the client side admin has forgotten the password as well…
Most of the time we handle this by deleting the record from the System Password Master table (SY02400) and then re-defining the password once more. But is there a way to recover the existing password without manipulating the data at SQL level? Fortunately, we do have an alternate solution and I am going to elaborate on the steps to recover this password, in this article.
When you have logged into Dynamics GP, go to Microsoft Dynamics GP >> Tools >> Customize >> Report Writer and choose the product as Microsoft Dynamics GP. This will open GP in the Report Writer mode as shown below. Click on the Reports button in the Toolbar.
Click on the New button in the Report Writer window and enter the following details for the new report that you have decided to create.
|Report Name||System Password Master|
|Main Table||System Password Master|
The report definition window would look as shown below.
Now click on the Layout button. Add the Password field from the System Password Master table into the Body section of the report as shown below.
Close the report and choose Save on the prompt that shows up.
Click OK on the Report Definition window to close the report definition window as well. Now you should be noticing the new report that we had created in the Report Writer window as shown below.
Select the new report that we had created and click on the Print button. On the Report Destination window, choose to print the report on Screen and click on the OK button.
The report will print on the screen and it will display the decrypted system menu password on the report as shown below.
Note: Note that in order to create this recovery report, we need to have access to this system series table, which is only available to users having the POWERUSERS role. Thanks to David Musgrave for providing this information.
This is an alternate method for GP administrators to recover the system menu password without having to delete the System Password Master table and resetting the password. Hope this article is helpful to all.
Until next post…