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 sales@citrincooperman.com.

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.