Skip to Content

Inventory Transfer Query report

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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'

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded