Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) How to fix Smartlist B...

How to fix Smartlist Builder -> Excel Report Builder submenu problem

(0) Share

Report

Posted on by Community Member Microsoft Employee

I have GP 2010 installed with Smartlist Builder.

When logged in on the server (2008 R2 64bit) or onto any workstation as the "sa" user or the "DYNSA" user the
Tools->Smartlist Builder->Excel Report Builder submenu incorrectly shows
->Maintenance-> Refresh Cache / Refresh Lists / Check List Names / Process Queue.

When logged in as any other user on the same computer the Excel Report Builder submenu shows up correctly with the ->Excel Report Builder / Publish / etc.. menu.

I have the same problem on a virtual machine running 2008 32bit.

Help.

Anyone know how to solve / fix this problem?

*This post is locked for comments

All responses (1)

Answers (0)

Paul.Livengood 95 on at

Like (0)

Report

Re: How to fix Smartlist Builder -> Excel Report Builder submenu problem

I had the same issue and I fixed it by running the following commands in SQL (of course you should make backups before doing this).

1. Delete DYNAMICS..SY07121 where CmdBarDictID = 3830 and USERID = 'sa'

2. Delete DYNAMICS..SY07125 where CmdBarDictID = 3830 and USERID = 'sa'

3. Delete DYNAMICS..SY07121 where CmdBarDictID = 3830 and USERID = 'DYNSA'

4. Delete DYNAMICS..SY07125 where CmdBarDictID = 3830 and USERID = 'DYNSA'