Homepage links missing after upgrade to GP 2013 R2?

Posted by Lisa Suggs

We have run into a situation that occurs for some users after upgrading the GP2013 R2:

What's the problem?

After upgrading, a user will be unable to customize his home page even though the user has security rights to do so.

​They will have only the "To Do" and "Business Analyzer" content, and, while they will be able to click on “Customize this page” and mark other content, the home page will not change.

The user will have only 2 records in the SY08100 table instead of the 9 records that should be there.
If the user resets their role, they can customize their home page (but will have to recreate all of their links).
AND…the fix will not stick. The user will likely revert to the uncorrected home page at some point and have to redo these changes.

How do you customize your homepage after the GP 2013 R2 upgrade?

Another option is to make the content visible in SQL, which will recover the user’s existing quick links.  This fix also will not stick, but has the advantage of the user not needing to recreate his links again and again.
The problem affects only a few users. Microsoft is aware of the defect and is working on determining the cause.
In the meantime, here is a workaround query that will allow you to copy homepage settings from another user:

Workaround query

INSERT INTO [DYNAMICS].[dbo].[SY08100]
           ([USERID]
           ,[SectionID]
           ,[DICTID]
           ,[COLNUMBR]
           ,[SEQNUMBR]
           ,[Visible]
           ,[MetricSequence]
           ,[Selected]
           ,[Mode])
   
select

     'user1' as [USERID]
           ,[SectionID]
           ,[DICTID]
           ,[COLNUMBR]
           ,[SEQNUMBR]
           ,[Visible]
           ,[MetricSequence]
           ,[Selected]
           ,[Mode]  
           from sy08100 where userid = 'user2'

    GO

​Use Microsoft Dynamics GP? Live in the Carolinas? Contact us to learn how you can make the most of your business software.