Skip to Content

Inventory Transfer Query report

Feb 16, 2017 at 04:57 AM


avatar image


Can anybody help me to get the below Query report. One of my warehouse (A) get the material from two warehouse by inventory transfer. Now i want to know that warehouse (A) Item code, instock, serial number, filler , ToWhsCode.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Balaji Selvaraj Jun 08, 2017 at 09:39 AM

Hi Prabakaran,

Try this

SELECT T1.[ItemCode], T1.[Quantity], T4.[IntrSerial], T0.[Filler] ,T1.[WhsCode] FROM OWTR T0 INNER JOIN WTR1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITW T2 ON T1.ItemCode = T2.ItemCode AND T1.WhsCode = T2.WhsCode LEFT JOIN SRI1 T3 ON T3.BaseEntry=T1.DocEntry AND T3.BaseLinNum=T1.LineNum AND T3.BaseType='67' LEFT JOIN OSRI T4 ON T3.ItemCode=T4.ItemCode AND T3.SysSerial =T4.SysSerial WHERE T3.[Direction] = '1'



10 |10000 characters needed characters left characters exceeded