Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Dynamics 365 general forum / Release Products by Le...
Dynamics 365 general forum
Suggested answer

Release Products by Legal Entity

(0) ShareShare
ReportReport
Posted on by Community member 15
I'm trying to find out what table there is that identifies what legal entity a product has been released to.  I do not want to go through each legal entity to try and find.  
Categories:
Other Functionality
  • Suggested answer
    sql-troubles@blogspot Profile Picture
    sql-troubles@blogspot 18 on at
    Release Products by Legal Entity
    You can use directly the dbo.InventTable table or the dbo.EcoResReleasedProductV2Entity entity. An entry is available for all the Legal entities the product is released to.
     
    SELECT ItemId
    , Max(CASE WHEN DataAreaId ='cnmf' THEN 1 ELSE 0 END) [cnmf]
    , Max(CASE WHEN DataAreaId ='demf' THEN 1 ELSE 0 END) [demf]
    , count(*) NoRecords
    FROM dbo.InventTable
    WHERE ItemId = 'D0001'
    GROUP BY ItemId
    ORDER BY NoRecords DESC
     
    If you have the System administrator role assigned in Dynamics 365, in many cases you can find the table behind a form by selecting from the menu: .. >> Options >> Page options >> Record info >> Record information >> Script >> (open file). The respective roles can be assigned at least on a Sandbox.


  • Dengliang Li Profile Picture
    Dengliang Li Microsoft Employee on at
    Release Products by Legal Entity
    Hi,
     
    Please refer to the following threads which may be helpful.
    https://community.dynamics.com/forums/thread/details/?threadid=d3932deb-2eeb-437e-8f15-d79b7b7e7b60

    If it still doesn't solve your issue, it is recommended that you post it in the forum of the Dynamics application you are using, where experts will be able to provide more comprehensive solutions.
     
    Best Regards,
    Dengliang Li
     
     
     
     

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans