As a temporary fix and workaround, you can setup a SQL Server job to run once a day (more depending on the number of users in your environment) that will clear the offending records:
use DYNAMICS;
go
delete from SY07110 where CmdParentDictID = 3180;
Upon logon, the menu items for Analytical Accounting are automatically recreated.
For more information on creating a SQL Server job visit MSDN.
Until next post!
MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/
5 comments:
thank you for this. i ran this query and it instantly fixed my problem!
Does this just cause slowness in the logon process, or a general overall slowness in GP such as when switching from Area Page to Area Page? We have a client that is experiencing an overall slowness in GP since the SP5 install.
Since the area page is stored in the temp folder, you can try removing all files from the temp directory on the machine experiencing the issue.
Exit GP and close all applications running (including those in the system tray) and go to Start > Run, then type %temp%. Highlight all files then delete them.
Go back to GP and check to see if the problem persist. If you require further assistance I would suggest you contact Microsoft Dynamics GP support as I don't provide support via my blog.
MG.-
Mariano Gomez, MVP
I was able to identify this as being my problems as well with Analytical Accouting. The crazy part is my client does not use AA. How would I remove AA from the database so these references to the 3180 product do not load to the SY07110 table?
Thanks in advance!
Cogle23,
The simplest way to remove a product from your environment is by removing the dictionary from the DYNAMICS.SET file. There is a KB article available to help you with the steps to remove a product from the launch file.
MG.-
Post a Comment