Streamline Dynamics GP: Disable Home Page Features for Enhanced Performance

Updated: 23 Feb, 2025 • 0 • min read

Table of Contents

Dynamics GP Home Page

This article provides a detailed guide on how to disable the home page feature within Microsoft Dynamics GP. Disabling the home page can be beneficial for streamlining performance and focusing users on specific tasks within the application. This is particularly relevant in environments where users primarily utilize Dynamics GP for transactional processing or specific module operations and do not require the overview provided by the home page.

Introduction¶

Microsoft Dynamics GP offers a role-based home page feature designed to provide users with a personalized overview of key information, tasks, and metrics upon logging into the system. While this feature can be advantageous for many users by offering quick access to frequently used functions and critical data points, there are scenarios where disabling the home page may be preferable.

Organizations might choose to disable the home page feature for various reasons, including:

Performance Enhancement: Loading the home page, especially with numerous components like metrics, Outlook integration, and report links, can consume system resources and potentially slow down the initial login process. Disabling these features can contribute to a faster and more responsive Dynamics GP environment.
Policy Compliance: Some company policies may restrict the use of certain home page features or prefer a more streamlined user interface for specific roles. Disabling the home page can ensure compliance with these internal regulations.
User Preference: Certain users might find the home page unnecessary or distracting, particularly if their roles are highly focused on specific areas of Dynamics GP. Allowing users or administrators to disable the home page provides greater customization and caters to individual work styles.
Network Bandwidth Optimization: In environments with limited network bandwidth, especially in remote locations, reducing the data loaded at login by disabling the home page can improve overall network efficiency and application responsiveness.

To accommodate these diverse needs, Microsoft Dynamics GP provides flexible methods for disabling the home page feature. These methods range from user-specific settings configurable within the Dynamics GP interface itself to system-wide configurations achievable through direct database modifications. This article will outline two primary methods for disabling the home page: utilizing the Dynamics GP user interface and employing SQL queries for more direct control.

Method 1: Use Microsoft Dynamics GP¶

The most straightforward method to disable the home page feature is directly within the Microsoft Dynamics GP application. This method leverages user-specific settings, allowing individual users to customize their login experience. This approach is particularly useful when only certain users or roles need to have the home page disabled, while others can continue to benefit from its features.

The process for disabling the home page through the Dynamics GP interface varies slightly depending on the version of Dynamics GP being used. The following sections detail the steps for different versions.

Microsoft Dynamics GP 2013, Microsoft Dynamics GP 2010, and Microsoft Dynamics GP 10.0¶

These versions of Microsoft Dynamics GP share a similar interface for customizing the home page. To disable the home page features in these versions, follow these steps:

Sign in to Microsoft Dynamics GP: Begin by logging into Microsoft Dynamics GP using your user credentials. Ensure you are logged in as the user for whom you wish to disable the home page.
Access the “Customize this page” link: Once logged in, and if the home page is currently displayed, locate the “Customize this page” link. This link is typically positioned on the home page itself, often near the top or bottom. Click on this link to open the customization window.
Clear Content Check Boxes: The “Customize Home Page” window will appear, presenting a list of check boxes under the section titled “Mark Content to Display.” This section lists various components that can be displayed on the home page, such as “To Do,” “Microsoft Outlook,” “Metrics,” “My Reports,” and “Quick Links.” To effectively disable the home page, you need to clear the check boxes for all these content options. This prevents any of these elements from loading and displaying when you log in.
- To Do: Unchecking this box will prevent the display of tasks and reminders on the home page.
- Microsoft Outlook: Clearing this option will disable the integration with Microsoft Outlook, preventing email previews and calendar information from appearing on the home page.
- Metrics: Disabling metrics will remove performance indicators and key data visualizations from the home page.
- My Reports: Unchecking “My Reports” will hide the list of saved or frequently accessed reports from the home page.
- Quick Links: Clearing “Quick Links” will remove shortcuts to frequently used windows or external resources from the home page.
Select “OK”: After clearing all the desired check boxes under “Mark Content to Display,” click the “OK” button to save your changes and close the “Customize Home Page” window. The next time you sign in to Microsoft Dynamics GP, the home page features you disabled will no longer be displayed. In effect, by deselecting all content options, you are essentially disabling the home page’s functionality for that specific user.

Microsoft Dynamics GP 9.0¶

Microsoft Dynamics GP 9.0 has a slightly different approach to home page customization. To disable the home page in this version, follow these steps:

Sign in to Microsoft Dynamics GP: Log into Microsoft Dynamics GP 9.0 using your user credentials.
Access the “Customize this page” link: Similar to later versions, locate and click the “Customize this page” link on the home page. This will open the customization window.
Clear “Display home page” and “Update my home page” Check Boxes: In the “Customize Home Page” window for Dynamics GP 9.0, you will find check boxes specifically related to the overall home page display. Locate and clear the following check boxes:
- Display home page when Microsoft Dynamics GP starts: Clearing this check box will prevent the home page from loading automatically each time you log in to Dynamics GP. This is the primary setting to disable the home page.
- Update my home page every hour: While less critical for disabling the home page itself, clearing this check box will prevent automatic hourly updates of the home page content if it were to be displayed. It is good practice to clear this as well when disabling the home page.
Confirm Changes: After clearing these check boxes, confirm your changes within the customization window. The exact button label may vary slightly, but it will typically be an “OK” or “Save” button. Once confirmed, the home page will be disabled for your user account.

By following these steps for either Dynamics GP 2013, 2010, 10.0, or 9.0, users can easily disable the home page features through the application interface, customizing their Dynamics GP experience to better suit their needs and preferences. This method provides a user-friendly way to manage home page display without requiring direct database modifications.

Method 2: Use Microsoft SQL Query Analyzer, SQL Server Management Studio, or Support Administrator Console¶

For more advanced control and system-wide changes, the home page feature can be disabled directly through database modifications using tools like Microsoft SQL Query Analyzer, SQL Server Management Studio, or the Support Administrator Console. This method is particularly useful for administrators who need to disable the home page for multiple users or implement a default setting for all users across the system.

The configuration settings for the home page layout are stored within specific tables in the Microsoft Dynamics GP database. The table name varies slightly depending on the Dynamics GP version:

Microsoft Dynamics GP 10.0 and Higher Versions (including 2010, 2013, etc.): The relevant table is SY08100 within the DYNAMICS database.
Microsoft Dynamics GP 9.0: The relevant table is SY08000 within the DYNAMICS database.

To disable home page features using SQL queries, you will need to execute UPDATE statements against these tables. The specific queries differ based on whether you want to disable the home page for a particular user or for all users.

Microsoft Dynamics GP 2013, Microsoft Dynamics GP 2010 and Microsoft Dynamics GP 10.0¶

For Dynamics GP versions 10.0 and above, the SY08100 table controls home page visibility.

Disable the home page feature for a particular Microsoft Dynamics GP user: To disable the home page for a specific user, you need to update the Visible column in the SY08100 table for that user’s record. Execute the following SQL query:
```
UPDATE DYNAMICS..SY08100 SET Visible=0 WHERE USERID='XXX'
```
Note: Replace XXX with the actual User ID of the Dynamics GP user for whom you want to disable the home page. User IDs are typically alphanumeric strings representing individual user accounts within Dynamics GP. Ensure you use the correct User ID to avoid unintentionally disabling the home page for the wrong user.
Disable the home page feature for all Microsoft Dynamics GP users: To disable the home page for every user in the Dynamics GP system, you can update the Visible column for all records in the SY08100 table. Execute the following SQL query:
```
UPDATE DYNAMICS..SY08100 SET Visible=0
```
This query will set the Visible flag to 0 for all entries in the SY08100 table, effectively disabling the home page for all Dynamics GP users upon their next login.

Dynamics GP 9.0¶

For Dynamics GP 9.0, the SY08000 table is used to manage home page settings.

Disable the home page feature for a particular Microsoft Dynamics GP user: To disable the home page for a specific user in Dynamics GP 9.0, you need to update the DISPHP column in the SY08000 table for that user. Execute the following SQL query:
```
UPDATE DYNAMICS..SY08000 set DISPHP = 0 where USERID = 'XXX'
```
Note: Again, replace XXX with the correct User ID of the target Dynamics GP user. The DISPHP column, likely short for “Display Home Page,” controls whether the home page is shown for that user. Setting it to 0 disables the display.
Disable the home page feature for all Microsoft Dynamics GP users: To disable the home page for all users in Dynamics GP 9.0, update the DISPHP column for all records in the SY08000 table. Execute this SQL query:
```
UPDATE DYNAMICS..SY08000 set DISPHP = 0
```
This query sets the DISPHP value to 0 for all entries, globally disabling the home page for all Dynamics GP 9.0 users.

Important Considerations When Using SQL Queries:

Database Backups: Before executing any UPDATE queries directly against the Dynamics GP database, it is highly recommended to perform a full backup of your DYNAMICS database and any company databases. This ensures you have a recovery point in case of any unintended consequences or errors during the database modification process.
User IDs: Double-check and verify the correct User IDs when disabling the home page for specific users. Incorrect User IDs can lead to unintended changes for other users.
SQL Tool Familiarity: Ensure you are comfortable and familiar with using SQL Query Analyzer, SQL Server Management Studio, or Support Administrator Console before attempting these database modifications. Incorrect SQL syntax or accidental execution of wrong queries can potentially cause data integrity issues.
Testing: After applying changes via SQL queries, thoroughly test the results by logging in as the affected user(s) to confirm that the home page is indeed disabled as intended.

By utilizing these SQL query methods, administrators gain precise control over the home page feature in Microsoft Dynamics GP. This approach is particularly valuable for implementing consistent home page settings across user groups or the entire organization, and for situations where direct database modification is the preferred or required method of configuration management.

Feel free to share your experiences or ask any questions you have about disabling the Dynamics GP home page in the comments below!

Computacionvinchi