How to remove the Customer Experience Improvement Program (CEIP) task from Microsoft Dynamics GP

Method 1

Follow these steps for each Microsoft Dynamics GP user:

1. Start Microsoft Dynamics GP.
2. On the View menu, click Reminders.
3. In the Reminders window, click the CEIP task, and then click Task on the Open menu.
4. In the Task window, click Name.
5. In the Customer Experience Improvement Program window, select an option, and then click OK.
6. In the Task window, click Completed in the Status list, and then click Save.

Method 2

1. Open Microsoft SQL Query Analyzer or SQL Server Management Studio.
2. To delete the CEIP reminder, run the following script.

   delete from DYNAMICS..SY01403 where LinkTo = 2 and CmdID = 269 and CmdFormID = 1568 and CmdDictID = 0

3. To select all users not to participate in the CEIP program, run the following script.

   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