Skip to Content
0
Former Member
Mar 19, 2009 at 07:43 AM

FMS for Warehouse

262 Views

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