How to Remove the Customer Experience Improvement Program CEIP Reminder Task in Dynamics GP 2016 R2
Posted by Kraig Kumlin, Sr. Support Analyst on October 6, 2017
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.
DELETE FROM DYNAMICS..SY01403 WHERE LinkTo = 2 AND CmdID = 269 AND CmdFormID = 1568 AND CmdDictID = 0
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.