GPADMIN

(0) Share

Report

Posted on by Tony Fernandez

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

I have the same question (0)

All responses (11)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

In the upper right-hand corner of the user's home page there is a link to 'Customize this Page' Click on that and turn off reminders.

Was this reply helpful? Yes No
Tony Fernandez 425 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

Check for the customer reminder options in SY01404. Look for the use specific records.

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Tony Fernandez 425 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Tony Fernandez 425 on at

Like (0)

Report

Also someone told me there is a way to unable the CEIP reminder but using SQL.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Kristie McNulty 1,008 on at

Like (0)

Report

Natarajan, do you happen to know what the SectionID field values 7, 8 and 9 represent in GP2015?

Was this reply helpful? Yes No