News and Announcements icon

Dynamics 365 CommunityForums Supply chain | Supply Chain Management, Commerce Released Products per ...

Supply chain | Supply Chain Management, Commerce

Answered

Released Products per Legal Entity

(1) Share

Report

Report

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.

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Hana Xue Microsoft Employee on at

Like (0)

Report

Released Products per Legal Entity

Hi,
Information about product release status across legal entities is typically stored in tables related to product management and release functionality. InventTable is the main table for products in D365 FO. The DataAreaId field indicates the legal entity. In addition, the EcoResReleasedProduct table is used to manage released products.
InventTableModule in Main - Common Data Model - Common Data Model | Microsoft Learn
Best Regards,
Hana
Suggested answer

André Arnaud de Cal... 291,759 Super User 2024 Season 2 on at

Like (0)

Report

Released Products per Legal Entity

Hi Rod,

The table InventTable is the table where you can find the information. It is possible to include this table in a query setting it cross company. Filtering this table on the product field, you then get the list with companies where a specific product is released to. The same approach is used by Microsoft in the Released to companies form part on the Products list page.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,759 Super User 2024 Season 2

#2

Martin Dráb 230,468 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans