Skip to main content

Notifications

Announcements

Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Assign organizations t...
Supply chain | Supply Chain Management, Commerce
Suggested answer

Assign organizations to security role cannot see report data

(2) ShareShare
ReportReport
Posted on by CU28041255-1 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
Categories:
Dynamics 365 Supply Chain Management
  • NguyenDoHuy Profile Picture
    NguyenDoHuy 18 on at
    Assign organizations to security role cannot see report data
    Hi André and Zain,
     
    Any ideas for this case?
     
    Thanks in advance
     
     
  • NguyenDoHuy Profile Picture
    NguyenDoHuy 18 on at
    Assign organizations to security role cannot see report data
    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
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 294,905 Super User 2025 Season 1 on at
    Assign organizations to security role cannot see report data
    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.
  • Suggested answer
    Zain Mehmood Profile Picture
    Zain Mehmood 3,927 Moderator on at
    Assign organizations to security role cannot see report data

    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

  • NguyenDoHuy Profile Picture
    NguyenDoHuy 18 on at
    Assign organizations to security role cannot see report data
    Dear Zain,
     
    When remove the organization, report showing without issues.
     
    Thanks
  • Suggested answer
    Zain Mehmood Profile Picture
    Zain Mehmood 3,927 Moderator on at
    Assign organizations to security role cannot see report data
    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 

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

News and Announcements

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Zain Mehmood Profile Picture

Zain Mehmood 241 Moderator

#2
Siv Sagar Profile Picture

Siv Sagar 111 Super User 2025 Season 1

#3
Danny Bilodeau Profile Picture

Danny Bilodeau 95 Moderator

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans