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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Assign organizations to security role cannot see report data

(2) ShareShare
ReportReport
Posted on by 4
Dear Expert,
 
I have a customized security role that can view Purchase statistics report.
 
But when I assign organizations to the role, the report becomes blank.
 
Is there any idea about this issue.
 
Thanks in advance
I have the same question (0)
  • Suggested answer
    Zain Mehmood Profile Picture
    4,187 Most Valuable Professional on at
    Hi,

    When you assign organizations to a security role, the user’s access gets restricted to those specific legal entities.

    If the Purchase statistics report turns blank, a few things to check:

    Make sure the assigned organization actually has purchase transactions or data available.

    Verify if the user has access to the correct company data (Purchase orders, Vendors, Invoices).

    Confirm if the report is filtering based on current company or expecting cross-company data.

    As a quick test, remove the organization restriction and check if the report populates correctly.

    It’s likely a data access or organization assignment mismatch.

    Hope this helps,

    Zain 

  • NguyenDoHuy Profile Picture
    18 on at
    Dear Zain,
     
    When remove the organization, report showing without issues.
     
    Thanks
  • Suggested answer
    Zain Mehmood Profile Picture
    4,187 Most Valuable Professional on at

    Hi,

    Thanks for confirming that!

    Since removing the organization restriction allows the report to work, it confirms that the issue is likely with how the organization assignment is configured — or that the report data isn’t tied to the legal entity the user has access to.

    Next step:
    Double-check that the assigned organization matches the data’s legal entity, and that the security role includes access to the required tables and data areas. If you could attach some screenshots that would be good as well. 

    Warm Regards,

    Zain

  • André Arnaud de Calavon Profile Picture
    301,130 Super User 2025 Season 2 on at
    Hi,

    Can you tell us how you created the customized role? Did you create new duties/privileges, or are you using out-of-the-box security objects?
    Can you share the exact menu path of the report your question is about? Is it Purchase and sourcing > Inquiries and reports > Purchase requisition statistics > Purchase requisition statistics? I don't have a "Purchase statistics" report with that label in my environment.
  • NguyenDoHuy Profile Picture
    18 on at
    Dear André,
     
    Yes correct, the path: Purchase and sourcing > Inquiries and reports > Purchase requisition statistics > Purchase requisition statistics
     
    We also used the Purchasing manager (standard role) and encountered same issue. Firstly, can able to see the data in report, but when assigned specific organizations, the report becomes blank even though I can still see the record in the PR list
     
    Dear Zain,
     
    The Purchase requisition is shared table, when I accessed the PR list, still be able to see the records. But Purchase requisition statistics report is blank.
     
    Thanks
  • NguyenDoHuy Profile Picture
    18 on at
    Hi André and Zain,
     
    Any ideas for this case?
     
    Thanks in advance
     
     

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…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 301 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 118 Super User 2025 Season 2

#3
Siv Sagar Profile Picture

Siv Sagar 105 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans