In Focus Resource Center > Insights

How to Restore Quick Links on Your Dynamics GP Home Page

By Citrin Cooperman Digital Services Practice .

Microsoft Dynamics Great Plains (GP) has a great feature that allows users to customize their home page, making it easier to get work done. If these customizations are ever lost, getting them back can be an arduous process. Most users never experience this, but some run into the issue nearly once a month.

Although Microsoft is aware of the issue, that have not been able to fix it yet. So, all users can do is continue to restore the settings when they disappear by creating the script and saving it on a machine for when it happens again.

This process will likely require someone with SQL experience to run the scripts, but it will not interrupt other users’ use of the system.

How to restore quick links on the home page

  1. Run the select statement below to see the user (in this example, Mike/Mike’s) current records in the sy08100
  2. Select * from DYNAMICS..SY08100 where USERID = ‘Mike’
    There are probably less than six records returned, so the easiest thing is to delete what is there and recreate them all.
  3. Delete from DYNAMICS..SY08100 where USERID = ‘Mike’
  4. Run the following script to recreate them:
    Insert into DYNAMICS..SY08100 values (‘mike ‘,1,0,1,1,1,0,0,0)
    Insert into DYNAMICS..SY08100 values (‘mike ‘,2,0,1,0,1,0,0,0)
    Insert into DYNAMICS..SY08100 values (‘mike ‘,3,0,2,0,1,0,0,0)
    Insert into DYNAMICS..SY08100 values (‘mike ‘,4,0,2,3,1,0,0,0)
    Insert into DYNAMICS..SY08100 values (‘mike ‘,5,0,2,2,1,0,0,0)
    Insert into DYNAMICS..SY08100 values (‘mike ‘,6,0,2,4,1,0,0,0)
    Select * from DYNAMICS..SY08100 where USERID = ‘Mike’

All six records for the user should now be visible and the home page should be restored.

Microsoft Dynamics GP support provided by Citrin Cooperman

Citrin Cooperman’s Digital Services Practice can help your business get the most out of its Microsoft Dynamics GP investment and troubleshoot issues you may encounter to can save time, money, and frustration.

To learn more about how our team can assist with Dynamics GP upgrades and support, reach out to your Citrin Cooperman advisor or

Need to make the move from Dynamics GP?

As a Dynamics GP user, it is important that you understand GP End of Life. It is not just a distant event; it carries substantial implications that every business must be aware of. To learn more, please watch our on-demand webinar, Microsoft Dynamics GP End of Life – What’s Next, to:

  • Gain a firm grasp of the critical dates that will shape your decision-making process.
  • Decode the terminology to understand how it will directly affect your day-to-day operations and the future of your organization.
  • Delve into the security and business continuity risks that may jeopardize your organization.

Click here to watch now.

Our specialists are here to help.

Get in touch with a specialist in your industry today. 

* Required

* I understand and agree to Citrin Cooperman’s Privacy Notice, which governs how Citrin Cooperman collects, uses, and shares my personal information. This includes my right to unsubscribe from marketing emails and further manage my Privacy Choices at any time. If you are a California Resident, please refer to our California Notice at Collection. If you have questions regarding our use of your personal data/information, please send an e-mail to