Microsoft Dynamics GP (Archived)

Batch Posting Security setup

(0) Share

Report

Posted on by Community Member

Would anyone know how to remove/deny access to AR and AP from accessing Posting Setup?

Thanks in advance!!

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Jeff451QL 155 on at

Like (0)

Report
Copy link

Link copied!
Sergio - The first step is to use the SQL query below to determine which tasks and roles have this window assigned. On my system, the task ADMIN_COMPANY_007* has this window. Several roles have that task assigned. Run the query and make note of the tasks and roles returned.

Step 2 is to determine what task(s) the window should be removed from based on the roles that include that task. You may need to create a new task with just this window and then assign it to a role that should have access to the window. If you remove the window from all tasks then only POWERUSER can access the window.

Step 3 is to modify the task by un-checking the window as shown in the screen capture.

Let me know if you need additional information on this issue.

select distinct rol.SECURITYROLEID as 'Role' ,tsk.SECURITYTASKID as 'Task' from SY10700 as tsk with (nolock) --All operations assigned to a task join SY09400 as dsc with (nolock) --descriptions on tsk.DICTID = dsc.DICTID and tsk.SECRESTYPE = dsc.SECRESTYPE and tsk.SECURITYID = dsc.SECURITYID left outer join SY10600 as rol with (nolock) --roles / tasks on tsk.SECURITYTASKID = rol.SECURITYTASKID left outer join SY09100 as rlm with (nolock) --roles master on rol.SECURITYROLEID = rlm.SECURITYROLEID where tsk.SECURITYID = 129 and tsk.SECRESTYPE = 2 order by rol.SECURITYROLEID, tsk.SECURITYTASKID

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Your solution worked....thank you again for sharing your knowledge.

Was this reply helpful? Yes No