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.