window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'UA-72416617-1');

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

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

By: Dean Dorton | March 20, 2014

Accounting Software | 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

Have a question? Click here to contact this representative.

Go to Top