web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

How to get Released Product Variants with product Category and sub Category from AX Using X++

(0) ShareShare
ReportReport
Posted on by 32

How to get Released Product Variants with product Category and sub Category from AX Using X++

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    301,035 Super User 2025 Season 2 on at

    Hi Abdul,

    Can you provide some more information how and where you need help? Are you looking for table names, help with writing coding, both or something else?

  • Shakoor Taj Profile Picture
    32 on at

    actually I have to get released product and product master with category and sub category which tables are involve and how to join these tables, please provide me sample code, also review my below given code.

    while select InventTable

           join EcoResProduct

           where  EcoResProduct.RecId == InventTable.Product

           join EcoResProductCategory

           where EcoResProductCategory.Product == EcoResProduct.RecId

           join EcoResCategory

           where EcoResCategory.RecId == EcoResProductCategory.Category

    I need to join these table with InventDimCombination to get items dimension and varientId.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 584 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 499 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 254 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans