Khue Trinh: How to get Inventory On-hand number

[Blog bot]

Источник: http://khue.spaces.live.com/Blog/cns...A0C2!326.entry
==============


 
This is a quick and dirty exmple:

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
where           inventSum.inventDimId == inventDim.inventDimId
    &&          inventSum.itemId == 'your item'
    &&          inventDim.inventLocationId == 'your WH'
{
    inventQty = inventSum.PostedQty
                + inventSum.Received
                + inventSum.Deducted
                - inventSum.Picked
                - inventSum.ReservPhysical;
}
info(strfmt('%1', inventQty));

 
Enjoy...

Источник: http://khue.spaces.live.com/Blog/cns...A0C2!326.entry