How To Remove The CEIP Reminder

Microsoft Dynamics GPWhen 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

Can ISC Software help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you would like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.

Your Name

Your Email

Subject

Your Enquiry

What should we write about next?

Your Name

Your Email

Suggested Topic

Suggestion Details

Leave a Reply

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