on 02-16-2017 4:57 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.