News and Announcements icon

Dynamics 365 CommunityForums Supply Chain Management forum Released Products per ...

Supply Chain Management forum

Answered

Released Products per Legal Entity

(0) 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.

Categories:

Product Information Management

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... 288,768 Super User 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... 288,768 Super User

#2

Martin Dráb 225,985 Super User

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans