Microsoft Dynamics 365 | Integration, Dataverse...

Release Products by Legal Entity

(0) Share

Report

Posted on by Community member

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.

All responses (2)

Answers (0)

Suggested answer

sql-troubles@blogspot 18 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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