Inventory Transfer Query report

[former_member320372]

Hi,

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.

[former_member312729]

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'

Regards:

Balaji.S