Bin Location

[Former Member]

I am looking for a solution to adding the bin location to a query.  I cannot seem to get the right combination of tables.  I need to pull the 'First Bin Location' from my Inventory Posting List.  I am working in SAP Business One 9.0(9.00.059).  Below is what I currently have:

SELECT T0.[DocTime], T0.[DocDate], T0.[DocNum], T2.[ItemCode], T2.[ItemName] FROM OWTR T0  INNER JOIN WTR1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode WHERE T1.[WhsCode] ='03' AND  T2.[ItemCode] = '90909240a'

Thanks,

James

[kothandaraman_nagarajan]

Hi,

Please note that your query is for inventory transfer request not for inventory posting list.

Refer this thread for query:

Thanks & Regards,

Nagarajan