web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / User 'xxx' is ...
Microsoft Dynamics AX (Archived)

User 'xxx' is not authorized to select a record in table 'SrsReportPreProcessedDetails'. Request denied. AX 2012 R3

(0) ShareShare
ReportReport
Posted on by Community Member

In our AX client we have multiple legal entities. All allowed users can access the Inventory Aging report (InventAging in AOT) in every company, except three users which have issues accessing the same report on one of the companies.

 

This is a standard AX report which only had some minor modifications to the report design.

 

I have already cleared the caches, reset the usage data, deleted the user's .AUC files, re-deployed the report and restarted the AOS service.

 

The report is located in: Inventory Management > Reports > Physical Inventory > Inventory Aging

 

I haven’t found a solution yet. Any suggestions?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Thanks for your answer. But I prefer not to do that with system tables. There should be another approach to this.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi, I solved the problem. The company that was giving the issue to the users was recently created and the 'System User' role was not assigned to him. I din't notice this issue till now because in the user roles showed in System Administration are not the user roles currently assigned in that company but the roles the user has across all companies.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans