News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How to get Released Pr...

Finance | Project Operations, Human Resources, ...

Unanswered

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

(0) Share

Report

Report

Posted on by Shakoor Taj

32

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

All responses Img

All responses (2)

Answers Img

Answers (0)

Shakoor Taj 32 on at

Like (0)

Report

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

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.
André Arnaud de Cal... 293,304 Super User 2025 Season 1 on at

Like (0)

Report

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

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?

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,304 Super User 2025 Season 1

#2

Martin Dráb 232,160 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans