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
     
     
     
     

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,584 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,864 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans