Hi,
We need to know the quantity available for one location only. Is there an inquiry for that?
Thanks,
H
SELECT QTYONHAND FROM ICILOC WHERE ITEMNO = 'X' AND LOCATION = 'Y'
SELECT QTYONHAND FROM ICILOC WHERE ITEMNO = 'X' AND LOCATION = 'Y'
QtyOnHand+QtyRecevidNoCost+QtyAdjustedNoCost-QtyShipedNoCost. Otherwise you miss everything that had a transaction that day
Sorry, what is ICILOC? I know it is Inventory Control, but where is ILOC (I am assuming Item by Location)? Thanks!
Thanks.
*Community Hub is the new name for Sage City