Thanks
@Kerry Hataley for the script! I guess I was a little data blind yesterday. I must have looked at that able 20 times, flipping back and forth.
Later in the day I found this reference.
--https://www.azurecurve.co.uk/tag/microsoft-dynamics-gp-fall-2020-release/page/2/
The column number setting is held in the syHomePageLayout (SY08100) table in the system database; the SectionID column will contain the following values:
1 = To Do
3 = Business Analyzer
4 = My Reports
5 = Quick Links
6 = Connect
7 = Time Management
8 = Procurement
9 = Project Time and Expense
10 = PowerBI
The Column Stack setting is held in the syHomePage (SY08000) table, the ColumnStackPosition column will contain the following values:
0 = Top
1 = Bottom
2 = Right
3 = Left
Thanks
@David Musgrave for the reminder on GPPT. After our much-postponed GP upgrade is complete, there are several pieces I will be turning on.
------------------------------
David Morinello
Senior Developer
TruckPro LLC
Cordova TN
------------------------------
Original Message:
Sent: Jan 19, 2023 12:38 AM
From: David Musgrave
Subject: Home Page - SQL Uncheck "Connect" option
Hi @David Morinello
@Kerry Hataley has provided the answer, but you also have the option with GP Power Tools of repurposing the Connect window or the even using the entire window with the repurposed/replaced Insights tab (depending on GP version).
You can select a web site (internal or external) of your choosing.
Regards
David
------------------------------
David Musgrave MVP, GPUG All-Star
Managing Director
Winthrop Development Consultants
Perth, Western Australia
http://www.winthropdc.com
Original Message:
Sent: Jan 18, 2023 03:45 PM
From: Kerry Hataley
Subject: Home Page - SQL Uncheck "Connect" option
I please the answer on the NEW DCI site...
https://dynamicscommunities.com/community/groups/dynamicsgp/
But here is the SQL for ALL Users...
UPDATE [DYNAMICS].[dbo].[SY08100] SET [Visible] = 0 WHERE [SectionID] = 6
------------------------------
Kerry Hataley
CEO & President
Nanook Software, Inc
Original Message:
Sent: Jan 18, 2023 01:26 PM
From: David Morinello
Subject: Home Page - SQL Uncheck "Connect" option
Can anyone save me some time and send me the SQL to uncheck this "Connect" option for all users?
I've traced through the SY081xx and SY01402 tables and am just not seeing it.
GP 2018 R2
------------------------------
David Morinello
Senior Developer
TruckPro LLC
Cordova TN
------------------------------