425
I would like to know if there is a way to turn off the reminders using SQL , have a user that when she login the overdue invoices reminders won't let her get in as it takes forever to load so she can't get into GP
*This post is locked for comments
Hi Val - would removing the option Customer Experience Improvement Program from the Task ID DEFAULTUSER (Product: Microsoft Dynamics GP | Type: Windows | Series: System) work? I'm wondering if doing this would then eliminate the need of running the script each time a user was added to the application. Obviously if you have created an custom version of the DEFAULTUSER task and used that new version in other roles, that too would need to be reviewed and adjusted. Thanks.
Natarajan, do you happen to know what the SectionID field values 7, 8 and 9 represent in GP2015?
Hi Tom,
The above suggested query to disable the To Do list (Contains Reminder)
To disable the list of task from Reminder window while loading the GP
1. Open SQL Server Management Studio.
2. Take a backup of the DYNAMICS database.
3. Execute the following query in DYNAMICS database.
UPDATE DYNAMICS.dbo.SY01404 SET VisibleTo = 0 WHERE USERNAME not in ('sa', 'DYNSA')
This script will disable all the reminder window for all users except sa and DYNSA.
Here us the script to get rid of the CEIP reminder:
/*
How to remove the Customer Experience Improvement Program (CEIP) task from Microsoft Dynamics GP
The CEIP task appears after you install Microsoft Dynamics GP. CEIP collects information about how a
customer uses Microsoft products and about any problems that customers experience.
REPLACE 'DYNAMICS' WITH THE NAME OF YOUR SYSTEM DB
*/
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
Kind regards,
Leslie
Hi Tony,
The suggested query work for my machine, the snap attached for your reference.
Before executing the query:
After executing the query: To Do list section get removed
You can also disable other features in it by changing the segment numbers in the below query
UPDATE DYNAMICS.dbo.SY08100 SET COLNUMBR = 0, SEQNUMBR = 0, Visible = 0
WHERE (SectionID in (1)) AND (DICTID = 0) AND ((COLNUMBR <> 0) OR (SEQNUMBR <> 1) OR (Visible <> 0)) AND USERID not in ('sa', 'DYNSA', 'GPADMIN')
SectionID field values and the corresponding homepage feature:
1) To Do list
2) Quick Links
3) Metrics
4) My Reports
5) Microsoft Office Outlook
6) Connect
It is highly recommended to execute these scripts only by GP administrator. Also, during this script execution process all the users should be out of GP.
Note: If the Customize Home Page task is assigned to the User’s role then users can enable the features in Dynamics GP.
To restrict the Customize Home Page option, remove the Customize Home Page task from the corresponding user’s role by following steps
1. On the Microsoft Dynamics GP menu, click Tools, click Setup, click System, and then click Security Tasks.
2. In the Task ID area, select the <User Role> (or DEFAULTUSER).
3. In the Product area, select Microsoft Dynamics GP.
4. In the Type area, select Windows.
5. In the Series area, select System.
6. Click to clear the Customize Home Page check box to remove access to the window.
7. Click OK.
Also someone told me there is a way to unable the CEIP reminder but using SQL.
Nataraj S ,
Thanks for the information , I tested that with one user and it didn't work, the end user still gets the reminders and everything on the home page.
Tony
Hi Tony,
Dynamics GP homepage can be customized for each user or role. GP don’t have an option to disable a particular or all features for all the users.
Follow the below steps to reminders using SQL for all the users:
1. Open SQL Server Management Studio.
2. Take a backup of the DYNAMICS database.
3. Execute the following query in DYNAMICS database.
UPDATE DYNAMICS.dbo.SY08100 SET COLNUMBR = 0, SEQNUMBR = 0, Visible = 0
WHERE (SectionID in (1)) AND (DICTID = 0) AND ((COLNUMBR <> 0) OR (SEQNUMBR <> 1) OR (Visible <> 0)) AND USERID not in ('sa', 'DYNSA')
This script will disable reminder features for all users except sa and DYNSA.
I hope this will help you.
Check for the customer reminder options in SY01404. Look for the use specific records.
Your feedback is highly appreciated,
Richard the issue is that when the user login I can even get to it because it gets looked trying to load the reminders for OVERDUE INVOICES so hence trying to find a way to do it via SQL , meaning disable all reminders for XXXXX user via SQL.
Tony
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,356
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
