Wednesday, June 27, 2012
How to remove the Connect section on the HomePage in Dynamics GP (via SQL)
Posted by Armanino Dynamics Team
Hello fellow readers, a few of us work in environments where we support many users or even better many instances of GP at a time.
Lately for many of our customers the Connect section has not been working as expected, for a few its just an ugly Error 404: File or directory not Found.
Or simply it has been getting in the way of Integration Manager. Even when many colleagues like Mariano Gomez, Mark Polino, David Musgrave, Leslie Vail and others have provided help to the community on this issues. One question remained unanswered: How to massively remove it without the administrator login into each account?.
Famous engineer Tami Jones from the RoseASP team came up to my beach front office with a wonderful view of the Pacific ocean (ok it’s a 3 wall cubicle with no view) and asked me how can we automate this process as you know we team up with myGPcloud as well.
So I decided to take a look at the homepage behavior and came up with the following descriptions:
|SectionID||Value 1||is the ToDo Section|
|SectionID||Value 2||is the Outlook Section|
|SectionID||Value 3||is the Metrics Section|
|SectionID||Value 4||is the My Reports Section|
|SectionID||Value 5||is the Quick Links Section|
|SectionID||Value 6||is the Connect Section|
The table responsible for storing the values to display or hide those sections is SY08100 in Dynamics DB. So here is the script that will help you remove the connect section:
With a little tweak you can limit the update statement to work only on 1 user or a set of users.
Always remember to backup your database and try statements in a test DB.
We enable an organization by supporting each stage of your company’s growth by implementing scalable Microsoft Dynamics solutions. As Microsoft Certified solutions experts and Inner Circle Partners, we work to eliminate redundant systems and leverage existing software investments, while keeping your goals for the future in mind.