Method 1
Follow these steps for each Microsoft Dynamics GP user:
- Start Microsoft Dynamics GP.
- On the View menu, click Reminders.
- In the Reminders window, click the CEIP task, and then click Task on the Open menu.
- In the Task window, click Name.
- In the Customer Experience Improvement Program window, select an option, and then click OK.
- In the Task window, click Completed in the Status list, and then click Save.
Method 2
- Open Microsoft SQL Query Analyzer or SQL Server Management Studio.
- 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
- 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