Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

rsAccessDenied400 error while accessing Navigation List data

Posted on by 18,265

Hello,

Getting following error on accessing All Sales Transactions from Navigation List.

PRP_5F00_Error.JPG

Any help on this will be highly appreciable.

Thanks much

Sandip

*This post is locked for comments

  • Verified answer
    Mike Bufano Profile Picture
    Mike Bufano 1,480 on at
    RE: rsAccessDenied400 error while accessing Navigation List data

    This is related to SQL permissions (to SSRS reports and underlying SQL objects).  Normally folks will create an SSRS_GP AD/Domain group and assign permissions in SQL.  

    The Group should be assigned to the DYNAMICS and COMPANY databases.   GP comes out of the box with many predefined SQL security schema/roles for specific user duties.  

    To access SSRS objects with Sales Transactions then you will want to assign your AD group to "RPT_customer service rep ", "RPT_order processor" or   "rpt_Sales manager". 

    If you grant the rpt_PowerUser role, then they will have permission to all SSRS reports and objects (including payroll). 

  • Verified answer
    ShawnMD Profile Picture
    ShawnMD 1,456 User Group Leader on at
    RE: rsAccessDenied400 error while accessing Navigation List data

    This is relating to SSRS (Business Analyzer) permissions - I have posted a solution here:

    gplifehacks.com/.../gplifehack-117-how-to-quickly-resolve-navigation-list-errors

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans