GP 10 Screen Security Question

(0) Share

Report

Posted on by Richard Wheeler

75,788 Moderator

We have a client with one user that when he hits the lookup for customer ID's her is getting the MS Dynamics version and not the Smarlist version. When I check in GP he is setup just like everyone else. Can anyone tell me the table that contains the user specific screen security assignments? I want to see if there is something behind the scenes that is causing this.

*This post is locked for comments

All responses (2)

Answers (1)

Verified answer

Almas Mahfooz 11,006 User Group Leader on at

Like (0)

Report

RE: GP 10 Screen Security Question

If issue is only with one user, you can find it in this way..

first checkout the Alternate/ Modified Forms and Report ID assigned to user from front.

now check in table SY1088.

214 is the SECURITYID for Customer Lookup.

select * from SY10800 where SECURITYID=214 and SECMODALTID='your Alternate/ Modified Forms and Report ID for the user '

check the field ALTDICID, it should be 1493 if you are to use smartlist lookup.

if it is set to anything else then update it to 1493.

update SY10800 set ALTDICID=1493 where SECURITYID=214 and SECMODALTID='ALTERNATE'
and ALTDICID=whatever the current value is in field
Tim Foster 8,515 on at

Like (0)

Report

RE: GP 10 Screen Security Question

The ModAlt Master is SY10800. You should follow David Musgrave's instruction about generating SY09400 to assist you in finding the right Dictionary ID, Security ID and Security Resource Type to located the record in SY10800. If you email me via the forum I can send you a useful graphic of the Security Queries and tables involved.

Tim