How to Remove the Customer Experience Improvement Program CEIP Reminder Task in Dynamics GP 2016 R2

More by

A customer recently asked me to remove the Microsoft Customer Experience Improvement Program (CEIP) Reminder Task from Dynamics GP 2016 R2.  Every time she logged in, the reminder popped up on her task list.  She attempted to complete and remove the reminder with no avail.

What is this task?

When you install Microsoft Dynamics GP, it automatically creates a recurring reminder for the CEIP in every user’s task list. In most cases, people tend to ignore this task.  For some, it is an annoyance, but there’s no easy way to get rid of it in Dynamics GP.  Trying to remove the reminder can be a lengthy and tricky process.

The easy way:

There is an easier way to address this issue.  Contact your IT department and arrange for someone with SQL Management Studio access to run the following scripts.

  •   Script #1:  removes the reminders for all users
  •   Script #2:  removes the flags, which removes them from the CEIP Program.

Both scripts affect all users, and only need to be run once.  As always, before running the scripts ensure you have a valid backup of your system and company databases.

Script #1:

DELETE FROM
   DYNAMICS..SY01403
WHERE
   LinkTo = 2
   AND CmdID = 269
   AND CmdFormID = 1568
   AND CmdDictID = 0

Script #2:

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 ANDsyDefaultType = 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

This is a fast way of handling the issues all at once and spares end users a lengthy process in the system.  If you have questions or need assistance with SQL, email our experts at Support@Crestwood.com.

Leave a Reply