Re: [Axapta-Knowledge-Village] Axapta query

Try this buddy:         InventDim inventDim;    InventSum inventSum;    InventQty inventQty;    ;     while select sum(postedQty), sum(received), sum(deducted), sum(registered),    sum(picked), sum(reservPhysical)    from InventSum group by itemId    join InventDim

[Axapta-Knowledge-Village] Axapta query

I'm trying to get the quantity on hand for an item in a particular wharehouse. I have the equivalent SQL query, but unable to convert it to Axapta query. This is the SQL query: SELECT SUM(postedQty + received - deducted + registered - picked - reservPhysical) FROM InventSum iSum INNER JOI