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) -

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 *