GP has a great feature of allowing you to customize your home page making it easier for you to get your work done.  But have you ever lost those customizations?  It can be a real pain getting them back.  It seems this has been going on for years!   I have 1 user from 1 client who loses his home page setting approximately once a month, and other users in the same company who have only lost them once or twice or most of them- never!   I took the problem to Microsoft to find out why it was happening and found out that they have known about it but haven’t been able to fix it yet.  So all we can do is continue to restore the settings when they disappear.  Whenever I have this issue on a client site, I create the script and save it on their machine as this is likely to happen again.

You will need someone with SQL experience to run the scripts.  No need to get people out of the system, except maybe the user having the problem.

Restore Quick Links on Home Page

Run the select statement below to see the user’s current records in the sy08100

select * from  DYNAMICS..SY08100 where USERID = ‘mike’

There are probably less than 6 records returned, so the easiest thing is to delete what’s there and recreate them all.

delete from DYNAMICS..SY08100 where USERID = ‘Mike        ‘

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’

You should now see all 6 records for the user and the home page should be restored.

Need GP help? Get worry free Dynamics GP Upgrades and support from the experts at MIBAR. Contact us for more information.