Fixing Microsoft Dynamics GP Toolbar erratic behavior

A few months aback, I blogged about a case where the Microsoft Dynamics GP toolbar menu would reorganized itself erratically even with the Lock Toolbar option activated. Back then, I alluded to the Script Debugging Tool being activated via the DEX.INI. Since then, I have also found that this may (or may not) be the case when returning from Modifier or Report Writer.

If you do happen to experience this issue and do not use the Script Debugging Tool, you can run the following T-SQL script in SQL Server Management Studio to correct the problem:


USE DYNAMICS;
GO

UPDATE SY07121
SET Visible = 0, ROWNMBR = 1, RowSequence = 1
WHERE CmdBarDictID = 3830
AND CmdBarFormID = 22006
AND CmdBarWindowID = 22003
AND USERID ''


UPDATE SY07121
SET Visible = 1, ROWNMBR = 1, RowSequence = 4
WHERE CmdBarDictID = 0
AND CmdBarFormID = 1568
AND CmdBarWindowID = 294
AND USERID ''


UPDATE SY07121
SET Visible = 1, ROWNMBR = 1, RowSequence = 3
WHERE CmdBarDictID = 0
AND CmdBarFormID = 1568
AND CmdBarWindowID = 295
AND USERID ''


UPDATE SY07121
SET Visible = 0, ROWNMBR = 99, RowSequence = 0
WHERE CmdBarDictID = 0
AND CmdBarFormID = 1568
AND CmdBarWindowID = 231
AND USERID ''


UPDATE SY07121
SET Visible = 0, ROWNMBR = 99, RowSequence = 0
WHERE CmdBarDictID = 0
AND CmdBarFormID = 1568
AND CmdBarWindowID = 223
AND USERID ''


UPDATE SY07121
SET Visible = 0, ROWNMBR = 99, RowSequence = 0
WHERE CmdBarDictID = 0
AND CmdBarFormID = 1568
AND CmdBarWindowID = 230
AND USERID ''


UPDATE SY07121
SET Visible = 0, ROWNMBR = 99, RowSequence = 0
WHERE CmdBarDictID = 0
AND CmdBarFormID = 1568
AND CmdBarWindowID = 228
AND USERID ''


UPDATE SY07121
SET Visible = 0, ROWNMBR = 99, RowSequence = 0
WHERE CmdBarDictID = 0
AND CmdBarFormID = 1568
AND CmdBarWindowID = 225
AND USERID ''


UPDATE SY07121
SET Visible = 0, ROWNMBR = 99, RowSequence = 0
WHERE CmdBarDictID = 0
AND CmdBarFormID = 1568
AND CmdBarWindowID = 224
AND USERID ''


UPDATE SY07121
SET Visible = 0, ROWNMBR = 99, RowSequence = 0
WHERE CmdBarDictID = 0
AND CmdBarFormID = 1568
AND CmdBarWindowID = 226
AND USERID ''


UPDATE SY07121
SET Visible = 0, ROWNMBR = 99, RowSequence = 0
WHERE CmdBarDictID = 0
AND CmdBarFormID = 1568
AND CmdBarWindowID = 227
AND USERID ''


UPDATE SY07121
SET Visible = 0, ROWNMBR = 99, RowSequence = 0
WHERE CmdBarDictID = 0
AND CmdBarFormID = 1568
AND CmdBarWindowID = 192
AND USERID ''
GO

The above script is applicable ONLY to Microsoft Dynamics GP v10. Make a backup of your DYNAMICS database before executing this script.

If the above fails to correct the issue, then you will need to remove the records for the user in question:


USE DYNAMICS;
GO
DELETE FROM SY07121 WHERE USERID = 'theUserID';

The scripts were originally provided by Sarah Purdy on the Dynamics GP Partner Technical Community and must be executed without any users in the system.

Until next post!

MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/

Advertisements

One Response to Fixing Microsoft Dynamics GP Toolbar erratic behavior

  1. Anonymous says:

    >Is this fix true in a Citrix environment? Or if multiple users share one machine that have different menus?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: