How to get Product Variants from AX Using X++

(0) Share

Report

Posted on by Community Member

Hello there,

I need help in getting the Variants of a Product from AX using X++. I also need the dimensions of the particular variant and uniquevariantid, I have no idea how to go about this, any help would be appreciated.

Regards,

Faizan Batra

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (2)

Mea_ 60,284 on at

Like (0)

Report

Hi FaizanBatra,

Table InventDimCombination contains 3 fields: ItemId, InventDImId and DistinctProductVariant. So it links item and inventory dimensions with variant.

Using findByDistinctProductVariant() you can find record by variant and using find() you can find record by item and inventDIm.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I'm sorry, please can you help me? I need a detailed answer, I'm relatively new to AX

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Can you then give us more details, what exactly you want to achieve and what is your issue ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Okay so simple product is alright, i can get it but when i create a variant, I get a variant id and it's dimensions, now i am looking forward to get that information.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Do you have some x++ code already ?

It's hard to understand from one sentence what exactly are you doing and what is you problem. Do you have item id and inventory dimensions ? what are you going to do with this variant ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Okay so the dimensions are like size,color and weight and yes i have the itemid with me.So i want to provide itemid and get all variants associated(variant id and dimensions(size,color,weight)) i hope you understand now.

I will just print it in info.

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (1)

Report

Here you go

InventDimCombination inventDimCombination;

InventDim inventDim;

while select inventDimCombination

where inventDimCombination.ItemId == '1000'

join inventDim

where inventDim.inventDimId == inventDimCombination.InventDimId

{

info(strFmt('%1 : %2 : %3 : %4 : %5',

inventDimCombination.DistinctProductVariant,

inventDim.configId,

inventDim.InventColorId,

inventDim.InventSizeId,

inventDim.InventStyleId));

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Why does InventDimCombination have limited products and InventTable have all the products? How do i get all master products?

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (2)

Report

You asked how to get variant and product dimensions so this code will give you exactly what you asked.

There are 2 types of products in AX: products and master products.

Inventtable contain all released products to current legal entity, master products + products.

inventDimCombination contains only master products, where itemid is a master product and DistinctProductVariant is a variant.

Was this reply helpful? Yes No

Community site session details

How to get Product Variants from AX Using X++

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

How to get Product Variants from AX Using X++

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates