Replicate FRx To Management Reporter Command Customisation To Other Users

Microsoft Dynamics GPIn 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?

Your Name (required) -
Your Email (required) -

(Visited 217 times, 1 visits today)

2 thoughts on “Replicate FRx To Management Reporter Command Customisation To Other Users

Leave a Reply

Your email address will not be published. Required fields are marked *