InventItemSalesSetup Table Record Ax 2009

Hello,

I was facing issue in getting InventItemSalesSetup Record in Ax 2009. After few hours of effort, i succeeded in it.

This code below will get you the exact InventItemSalesSetup Record.

//Parm DimId and ItemId

InventItemSalesSetup        InventItemSalesSetup;

InventDim                   InventDim, inventDimSelect;

select inventDimSelect

    where inventDimSelect.inventDimId == _dimId;

select inventItemSalesSetup

    where   InventItemSalesSetup.ItemId         ==  _itemId

    join inventDim

    where inventDim.inventDimId == inventItemSalesSetup.InventDimId

    && inventDim.InventColorId == inventDimSelect.InventColorId

    && inventDim.InventSizeId == inventDimSelect.InventSizeId

    && inventDim.ConfigId == inventDimSelect.configId;