News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Copy homepage settings...

Microsoft Dynamics GP (Archived)

Copy homepage settings from one user to another

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hi

Does anybody know if it is possible to copy one users homepage settings (shortcuts , quick links etc) to another users account?

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: Re: Copy homepage settings from one user to another

Hi Rubal

Thanks for that. I was actually thinking more of the shortcuts on the navigation bar rather than the quick links.

I managed to get it resolved by creating a Class ID, entering the shortcuts and then assigning the class to the new users.

Thanks all the same
Community Member Microsoft Employee on at

Like (0)

Report

Re: Copy homepage settings from one user to another

Quick links are stored in SY08140. You can write SQL query to copy the quick links from user to another.
We are copying 'Invoicing Batches', 'Invoice Entry', 'Transaction by Customer', 'Transaction by Document', 'Customer' in Quick links. Similarly, you can all the links from one users

--Query Copy quick links of user sa to DYNSA

Declare @userID varchar(15)

set @userID='DYNSA'

insert into SY08140
(
USERID,SEQNUMBR,TYPEID,CmdID,CmdFormID,CmdDictID,DSPLNAME,ScbTargetStringOne,ScbTargetStringTwo,ScbTargetStringThree,ScbTargetLongOne,ScbTargetLongTwo,ScbTargetLongThree,ScbTargetLongFour,ScbTargetLongFive

)

Select @userID,((SELECT max(SEQNUMBR) FROM SY08140 where USERID=@userID)+ ROW_NUMBER() OVER (ORDER BY SEQNUMBR)),TYPEID,CmdID,CmdFormID,CmdDictID,DSPLNAME,ScbTargetStringOne,ScbTargetStringTwo,ScbTargetStringThree,ScbTargetLongOne,ScbTargetLongTwo,ScbTargetLongThree,ScbTargetLongFour,ScbTargetLongFive
from SY08140 where USERID='sa'
and DSPLNAME in ('Invoicing Batches',
'Invoice Entry', 'Transaction by Customer',
'Transaction by Document',
'Customer')

Table for my report is SY70700. Other tables store home page data are
SY08000
SY08100
SY08120
SY08130
SY08140

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans