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. 

Need to make the move from Dynamics GP? Learn more about your options migrating 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 & future of your org.
  • Delve into the security & business continuity risks that may jeopardize your organization.

Click here to watch now.

Dynamics GP Alternatives