on hand qty

on hand qty

static void OnHandQty(Args _args)
{
    InventDim       inventDim;
    InventSum       inventSum;
    InventOnhand    inventOnHand;
    InventDimParm   inventDimParm;
    ItemId          itemId;
    InventQty       availQty;
    InventQty       inventQty;

    while select sum(postedQty), sum(received), sum(deducted), sum(registered),
    sum(picked), sum(reservPhysical)
    from InventSum group by itemId
    join InventDim
    where inventSum.inventDimId == inventDim.inventDimId &&
    inventSum.itemId == 'B' &&
    inventDim.inventLocationId == 'Mumbai'
    {
    inventQty = inventSum.PostedQty+inventSum.Received+inventSum.Deducted-
    inventSum.Picked-inventSum.ReservPhysical;
    }
    info(strfmt('%1', inventQty));

    itemId = 'BA1502926-P-WH15766-01';
    inventDim.InventLocationId = 'Mumbai';
    inventDimParm.initFromInventDim(inventDim);
    inventOnHand = inventOnHand::newParameters(itemId,inventDim,inventDimParm);
    availQty = inventOnHand.availPhysical();
    info(strfmt('%1', availQty));
}