BIN LOCATION IN INVENTORY COUNTING

[Former Member]

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

[Former Member · Accepted solution]

The Table ID was my issue. The correct table was IQR1 and not IGR1.

Regards

George