How To Remove The CEIP Reminder

Microsoft DynamicsWhen you install Microsoft Dynamics GP it automatically creates a recurring reminder for the Microsoft Customer Experience Improvement Program. In most cases this reminder is not wanted but removing it through the system for every user can be a bit time consuming;

For each user, log into Microsoft Dynamics GP and open the Reminders window (Microsoft Dynamics GP menu >> Reminders) and open the CEIP task. In the window click Name and select an option. Flag the task as Completed and move onto the next user and repeat.

However, help is at hand in with two short SQL scripts.

As always, before running the scripts ensure you have a valid backup of your system and company databases.

The first script removes the reminder from all users;
DELETE FROM
   DYNAMICS..SY01403
WHERE
   LinkTo = 2
   AND CmdID = 269
   AND CmdFormID = 1568
   AND CmdDictID = 0

The second script flags all users as not participating in CEIP;
USE DYNAMICS
SET NOCOUNT ON
DECLARE @Userid CHAR(15)
DECLARE cCEIP CURSOR FOR
      SELECT A.USERID
      FROM SY01400 A LEFT JOIN SY01402 B ON A.USERID = B.USERID AND B.syDefaultType = 48
      WHERE B.USERID IS NULL OR B.SYUSERDFSTR NOT LIKE '1:%'
OPEN cCEIP
WHILE 1 = 1
BEGIN
   FETCH NEXT FROM cCEIP INTO @Userid
   IF @@FETCH_STATUS <> 0 BEGIN
      CLOSE cCEIP
      DEALLOCATE cCEIP
      BREAK
   END

   IF EXISTS (SELECT syDefaultType FROM DYNAMICS.dbo.SY01402 WHERE USERID = @Userid AND syDefaultType = 48)
   BEGIN
      PRINT 'adjusting ' + @Userid
      UPDATE DYNAMICS.dbo.SY01402
      SET SYUSERDFSTR = '1:'
      WHERE USERID = @Userid AND syDefaultType = 48
   END
   ELSE BEGIN
      PRINT 'adding ' + @Userid
      INSERT DYNAMICS.dbo.SY01402 ( USERID, syDefaultType, SYUSERDFSTR )
      VALUES ( @Userid, 48 , '1:' )
   END
END /* WHILE */
SET NOCOUNT OFF

Ian Grieve

About Ian Grieve

Ian is a Microsoft Dynamics GP certified consultant specialising in the delivery of Microsoft Dynamics GP projects and currently working for Perfect Image Ltd., a Microsoft Partner and VAR in the North East of England. Ian has worked with Microsoft Dynamics GP since 2003 and, over the nine years since, has dealt with all aspects of the product life-cycle from presales, to implementation, to technical and functional training, to post go-live support and subsequent upgrades and process reviews. In his spare time, Ian runs the azurecurve | Ramblings of a Dynamics GP Consultant blog dedicated to Microsoft Dynamics GP and related products.
This entry was posted in Dynamics, GP, Microsoft and tagged , , , . Bookmark the permalink.

Leave a Reply

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

*

* Copy This Password *

* Type Or Paste Password Here *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>