Skip to main content

Notifications

Announcements

No record found.

Supply Chain Management forum
Answered

Released Products per Legal Entity

Posted on by 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.  
  • Verified answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    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 Calavon Profile Picture
    André Arnaud de Cal... 288,584 Super User on at
    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

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 . . .

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