How to Recover Lost Dynamics GP Home Page Features using SQL
Posted by Georgia Stewart on October 26, 2017
Recently, a client contacted me because her home page features in Dynamics GP 2013 R2 had disappeared. This had happened once before, and she was able to re-add the features in the “Customize this page” window – but this time, that didn’t work. In spite of every attempt to re-activate the Quick Link (and other Home Page features), her selections would not save or stay in place on the home page, and the features would not reappear. The home page was completely blank.
Why did this happen?
What happened? Important entries for the SY8100 (a user preferences table associated with Home Page Feature settings) associated with the users ID in Dynamics GP had become stranded or lost in the data somewhere.
How to fix with SQL:
To repair the issue, run the following scripts in SQL against the DYNAMICS database. When using these scripts, simply substitute the “userid” field with the user’s designated Dynamics GP User ID, and then run the scripts.
insert into DYNAMICS..SY08100 values ('userid',1,0,1,1,1,0,0,0) insert into DYNAMICS..SY08100 values ('userid',2,0,1,0,1,0,0,0) insert into DYNAMICS..SY08100 values ('userid',3,0,2,0,1,0,0,0) insert into DYNAMICS..SY08100 values ('userid',4,0,2,3,1,0,0,0) insert into DYNAMICS..SY08100 values ('userid',5,0,2,2,1,0,0,0) insert into DYNAMICS..SY08100 values ('userid',6,0,2,4,1,0,0,0)
After running these scripts to repair the problem, we logged in with the end user, and the home page features had returned with the required link she needed for her work.
Please note: for this recovery to work, it’s important that NO CHANGES to the HOME PAGE ROLE occur. If this happens, all Quick link data is lost in the GP data so be careful to warn your users not to change roles in an attempt to recover the palettes.
Another common home page problem we’ve seen is an error message in the “Connect” section. If this is what you’re experiencing, here’s a post on how to fix that.
If you need assistance, send us an email at Support@Crestwood.com and we can assist you with this.