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'
Sorry, what is ICILOC? I know it is Inventory Control, but where is ILOC (I am assuming Item by Location)? Thanks!
Sorry, what is ICILOC? I know it is Inventory Control, but where is ILOC (I am assuming Item by Location)? Thanks!
*Community Hub is the new name for Sage City