In the last post I showed how the FRx menu can be renamed to show Management Reporter instead.
However, it is also a per user setting so would need to be done for each user created in Microsoft Dynamics GP who had access to Management Reporter.
To make the job a lot less onerous, I thought it might be useful to follow up with a SQL script to copy the FRx command customisations from one user to all others;
USE [DYNAMICS]
GO
INSERT INTO SY07105
(USERID
,CmdDictID
,CmdFormID
,CmdID
,CmdCaption
,CmdTooltip
,CmdNormalImageType
,CmdNormalImageDictID
,CmdNormalImageResID
,CmdCheckedImageType
,CmdCheckedImageDictID
,CmdCheckedImageResID
,CmdMenuDisplayOption
,CmdButtonDisplayOption)
(SELECT
['Users Master'].USERID
,CmdDictID
,CmdFormID
,CmdID
,CmdCaption
,CmdTooltip
,CmdNormalImageType
,CmdNormalImageDictID
,CmdNormalImageResID
,CmdCheckedImageType
,CmdCheckedImageDictID
,CmdCheckedImageResID
,CmdMenuDisplayOption
,CmdButtonDisplayOption
FROM
SY01400 AS ['Users Master']
INNER JOIN
SY07105 AS ['Command Customizations']
ON
['Command Customizations'].USERID = 'sa'
AND
CmdDictID = 0
AND
CmdFormID = 1556
AND
CmdID = 28
WHERE
['Users Master'].USERID
NOT IN
(SELECT
USERID
FROM
SY07105
WHERE
CmdDictID = 0
AND
CmdFormID = 1556
AND
CmdID = 28)
)
As with any script, please make sure you have a good backup of all your Microsoft Dynamics GP databases, including the DYNAMICS database as this is the one which this script updates, and are comfortable working with T-SQL and SQL Server Management Studio.
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.
2 thoughts on “Replicate FRx To Management Reporter Command Customisation To Other Users”