on 01-02-2015 5:20 AM
Dear Experts,
I want to write a query for Stock Transfer Report. I want Item Code, From Warehouse, To Warehouse, From Bin , To Bin, Qty.
Valuation method is FIFO. Item is not managed by Serial or Batch.
Plz reply.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try:
SELECT T0.DocNum, T0.DocDate, T0.CardName, T1.ItemCode, T1.Dscription, T1.Quantity, T0.Filler, T1.WhsCode,
dbo.OBIN.BinCode AS [To Bin Code]
FROM dbo.OBIN INNER JOIN
dbo.OBTL ON dbo.OBIN.AbsEntry = dbo.OBTL.BinAbs INNER JOIN
dbo.OWTR AS T0 INNER JOIN
dbo.WTR1 AS T1 ON T0.DocEntry = T1.DocEntry LEFT OUTER JOIN
dbo.OITL AS T2 ON T1.DocEntry = T2.ApplyEntry AND T1.LineNum = T2.ApplyLine AND T2.ApplyType = 67 INNER JOIN
dbo.ITL1 AS T3 ON T2.LogEntry = T3.LogEntry ON dbo.OBTL.ITLEntry = T3.LogEntry
GROUP BY T0.DocNum, T0.DocDate, T0.CardName, T1.ItemCode, T1.Dscription, T1.Quantity, T0.Filler, T1.WhsCode, dbo.OBIN.BinCode
Thanks & Regards,
Nagarajan
Dear All,
Please reply. It is urgently needed.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
6 | |
4 | |
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.