Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / how to default home pa...
Microsoft Dynamics GP (Archived)

how to default home page type for all user + Dynamics GP 2018

(0) ShareShare
ReportReport
Posted on by Sunneil Chaudhary 332

Hi Team,

we have just upgraded to Dynamics GP 2018  R2. We want to select "Default" for all users through SQL script. Can somebody help please.

pastedimage1566734214364v1.png

*This post is locked for comments

  • Suggested answer
    Sunil Chaudhary Profile Picture
    Sunil Chaudhary 15 on at
    RE: how to default home page type for all user + Dynamics GP 2018

    Hi Derek,

    Many thanks for the support, It resolved my issue.

  • Verified answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: how to default home page type for all user + Dynamics GP 2018

    If you look in the SY08100 table for this one user(s), for the record where the SectionID = 2, is Visible set to 0 (for GP Home page default) or 1 (for Intelligent Cloud Insights default)?

    We want the Section ID 2 records set with Visible = 0 if the user wants the GP Home page to default, when they launch Dynamics GP.

    Thanks

  • Sunneil Chaudhary Profile Picture
    Sunneil Chaudhary 332 on at
    RE: how to default home page type for all user + Dynamics GP 2018

    Thanks for the response. I have tried this table but couldn't by updating visible and selected column but it didn't resolve. 

  • Suggested answer
    kdd281 Profile Picture
    kdd281 465 on at
    RE: how to default home page type for all user + Dynamics GP 2018

    Check out SY08100 in the Dynamics Database. This has all the user records each section.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,309 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans