Skip to Content
0
Former Member
Oct 03, 2013 at 09:58 AM

BIN LOCATION IN INVENTORY COUNTING

142 Views

Dear Forum Team,

I would like to create a formatted search that automatically populates the Inventory counting document in inventort transactions with the default Bin location for the item.

I have challenge linking the warehouse table (OITW) and the Bin Location table (OBIN) in a formatted search. My FMS query is

SELECT T1.[BinCode] FROM OITW T0 INNER JOIN OBIN T1 ON T0.DftBinAbs = T1.AbsEntry WHERE T0.[ItemCode] = $[IGR1.ItemCode.0] and TO.[WhsCode] = $[IGR1.WhsCode.0]

Please help me with a proper FMS query. I am using SBO 9.0 PL6.

Regards

George Njuguna