List of all released products with dimensions in AX 2012

(0) Share

Report

Posted on by Community Member

Is there an easy way to extract a list of all released product variants with dimensions (Config, size, color) for a company in AX 2012?.

If not, if there is any job, which could help do so, please share. Requirement is to get a list of Item ID, Config ID, Color ID, Size ID for all the released products in a company.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Ivan (Vanya) Kashperuk on at

Like (0)

Report

static void Job1(Args _args)

{

InventDimCombination releasedProductVariants;

InventDim inventDim;

while select releasedProductVariants

join inventDim

where inventDim.inventDimId == releasedProductVariants.InventDimId

{

info(strFmt('%1 : %2 : %3 : %4 : %5', releasedProductVariants.ItemId, inventDim.configId, inventDim.InventColorId, inventDim.InventSizeId, inventDim.InventStyleId));

}

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Ivan. That did the job. But it turns out it brings only the items that have variants, and not the product subtype as product. Any clue?

Was this reply helpful? Yes No
Ivan (Vanya) Kashperuk on at

Like (0)

Report

Well, that's what you asked for in the original post - all product variants + dimensions.

distinct products do not have variants, thus are not shown.

if you want to also show the distinct products, please clarify what exactly and how you want displayed

it should be relatively easy to change the above job, looping on inventtable before looping on inventdimcombination

Was this reply helpful? Yes No
BINAY KUMAR PANDEY 135 on at

Like (0)

Report

Can you please let me know how to get the list of all Released Product both product and product mster .

Inshort , I need to loop all Item which is showing in releasedproduct list page .

I have to save all those Item in a Temp table.

Was this reply helpful? Yes No