web
You’re offline. This is a read only version of the page.
close
Skip to main content
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

(4) ShareShare
ReportReport
Posted on by RM-02081500-0 16
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
    TC-18091527-0 Profile Picture
    TC-18091527-0 2 on at
    Controlling Requisition View by Legal Entity
    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.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 298,655 Super User 2025 Season 2 on at
    Controlling Requisition View by Legal Entity
    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.
  • RM-02081500-0 Profile Picture
    RM-02081500-0 16 on at
    Controlling Requisition View by Legal Entity
    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... 298,655 Super User 2025 Season 2 on at
    Controlling Requisition View by Legal Entity
    Do you want to add the join using the development option or via a personalization?
  • RM-02081500-0 Profile Picture
    RM-02081500-0 16 on at
    Controlling Requisition View by Legal Entity
    Thanks Andre! How can I go about adding the additional join?
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 298,655 Super User 2025 Season 2 on at
    Controlling Requisition View by Legal Entity
    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. 
     

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,098

#2
André Arnaud de Calavon Profile Picture

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

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 215 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans