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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Controlling Requisitio...
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Controlling Requisition View by Legal Entity

(5) ShareShare
ReportReport
Posted on by RM-02081500-0 18
Hi All, 
 
I was wondering if anyone had any experience or recommendations on controlling view of all purchase requisitions to only those applicable for the current legal entity? 
 
Due to the global nature of the requisition tables it is causing me some issues for a multi entity client. Ideally when in one legal entity, don't want to see any requisitions pertaining to the others even if they were created by the same user. We are not associating projects so can't use the buying legal entity field on the header unfortunately. 
I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,679 Super User 2026 Season 1 on at
    Hi,
     
    From your question, I do understand that a single user has access to multiple legal entities and should be able to manage requisitions. If you then want to restrict the view to only the current legal entity, you can achieve this by setting an additional join from the header to the lines and checking if there is at least one PR line for the current buying company. This can be set as a personalization or customization. 
     
  • RM-02081500-0 Profile Picture
    RM-02081500-0 18 on at
    Thanks Andre! How can I go about adding the additional join?
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,679 Super User 2026 Season 1 on at
    Do you want to add the join using the development option or via a personalization?
  • RM-02081500-0 Profile Picture
    RM-02081500-0 18 on at
    Ideally just personalisation. I was trying to do an advanced filter but it wasn't cooperating :(
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,679 Super User 2026 Season 1 on at
    Hi,
     
    I also tried several options via the advanced filter, but the Buying legal entity field is not available for selection. In that case, you can make an attempt via a customization.
  • Suggested answer
    TC-18091527-0 Profile Picture
    TC-18091527-0 2 on at
    The issue with your proposal Andre is that the form is using it's own query, created when the form opens, and this will override your advanced filter with the join.
    Only real suitable option is to extend the form and add a filter that is initiated to be the current company, and that way only see the requisitions for the comany you are in.
    You can develop this new filter in such a way that the user can then select from all the legal entities, or maybe only from the LEs the user is hired into, and that way see the requisitions for other legal entities.
     
    On a side note, I am surprised to see that this form is global. Whom ever designed this is not qualified to do designs IMHO.
     
    Tommy.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Mallesh Deshapaga Profile Picture

Mallesh Deshapaga 254

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 188 Super User 2026 Season 1

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 131 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans