Hi,
I have assigned the following FMS in A/R invoice for the item code to display items which has stock in warehouse User will select warehouse and items available in that warehouse will get displayed.
SELECT T0.[ItemCode], T0.[ItemName], T1.[OnHand] FROM OITM T0 INNER JOIN OITW T1 ON T0.ItemCode = T1.ItemCode WHERE T1.[OnHand] > 0 and T1.[WhsCode] = [%0]
The above query is working fine. But in warehouse field in A/R document I again need to select warehouse manually. can we do any automisation where the warehouse picks automatically based on the selection criteria which we give in item code?
As we have more than 150 warehouses. Any workaround for this?
Regards
Shashi
Edited by: shashi mantripragada on Mar 19, 2009 8:44 AM