Adding Quicklinks for Manually or via SQL

One of the comments on Mark’s blog about using the new GP 10 Module Home Pages is about the under use of quick links – “What I find many users never do is create personalized shortcuts or quick links...takes just a few minutes up front, but saves a time and effort every day.”

The steps to add Quicklinks are nice and easy, you can follow the steps below for each of your users. Or go ahead and create Quicklinks for them via SQL, especially if there are too many users.

Adding Quick Links

To add links to Quicklinks Web part on Home page, Click Edit Icon

To add a GP Window in Quicklinks

Click Add

Select Microsoft Dynamics GP Window

Select the Window to add

New link isn’t added till Home page is refreshed

To refresh Quicklinks web part, Click on the Refresh Button in Toolbar or Click on any other module in navigation links

· Click on Home again

· You’ll see the Added Link in Quicklinks

To add a Navigation List in Quicklinks

· Click Add

· Select Microsoft Dynamics GP Navigation List

For example select Customers

Customers list loaded on Selecting Customers from Quicklinks

If your users are too busy, and you really want to help them – You can add QuickLinks for multiple users via SQL. For example – Here we are adding 'Invoicing Batches', 'Invoice Entry', 'Transaction by Customer', 'Transaction by Document', 'Customer' in the Quick links for “SampleUser”. This method is especially useful when you are setting up quicklinks for multiple users. In this example - we are copying the links, from the user sa.

Run the following query for all users for which you want to copy the list –

DECLARE @userID varchar(15)

SET @userID=' SampleUser'

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')