Dynamics Community Forum Thread Details

How to find Product Number of an Invent On-Hand item based on productr variant.

Hello Member's.

Please some one can help me in finding solution of my requirement.

The requirement is, need to get Product number of an invent on-hand item based on its size, color, style and etc..... and need to display it quantity and other things etc...

The code i used is as below:

ecoResProduct       = EcoResProduct::find(inventTable.Product);
ecoResSize          = EcoResSize::findByName(inventDim.InventSizeId);
ecoResStyle         = EcoResStyle::findByName(inventDim.InventStyleId);
ecoResColor         = EcoResColor::findByName(inventDim.InventColorId);
ecoResConfiguration = EcoResConfiguration::findByName(inventDim.configId);

select inventDimCombination
    where inventDimCombination.ItemId        == inventSum.ItemId
    join EcoResDistinctProductVariant
    where EcoResDistinctProductVariant.RecId == inventDimCombination.DistinctProductVariant
    join ecoResProductVariantSize
    where ecoResProductVariantSize.DistinctProductVariant == EcoResDistinctProductVariant.RecId
    && ecoResProductVariantSize.Size                      == ecoResSize.RecId
    join ecoResProductVariantColor
    where ecoResProductVariantColor.DistinctProductVariant == EcoResDistinctProductVariant.RecId
    && ecoResProductVariantColor.Color                     == ecoResColor.RecId
    join ecoResProductVariantStyle
    where ecoResProductVariantStyle.DistinctProductVariant == EcoResDistinctProductVariant.RecId
    && ecoResProductVariantStyle.Style                     == ecoResStyle.RecId
    join ecoResProductVariantConfiguration
    where ecoResProductVariantConfiguration.DistinctProductVariant == EcoResDistinctProductVariant.RecId
    && ecoResProductVariantConfiguration.Configuration             == ecoResConfiguration.RecId;

                    itemId = EcoResDistinctProduct::find(inventDimCombination.DistinctProductVariant).DisplayProductNumber;

But it is not displaying the product number. Can some one help me with any better solution to print product number.

Quick Links

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