Query For Stock Transfer

[Former Member]

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

[former_member205766 · Accepted solution]

Hi

Check the below discusssion

With Regards

Balaji Sampath

[Former Member · Accepted solution]

Hi

The query in the thread is not giving result. I have already checked that. I want From Bin Location and To Bin Location Mandatory. OBTN table is used in this query while in my DB, Items are not managed by Serial or Batch.

Plz help to solve this.

Regards

[kothandaraman_nagarajan · Accepted solution]

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

[Former Member · Accepted solution]

Hi ,

Also this query is not giving any result.

One thing I have seen there is no entry in OITL table where DocType = 67.

Why it is so ?

Regards

[kothandaraman_nagarajan · Accepted solution]

I don't have 9.0 version to test above query. If you want, we can check it through TV by today evening.

[Former Member · Accepted solution]

Dear All,

Please reply me to get this query. It is needed urgently.

Regards

[Former Member]

Dear All,

Please reply. It is urgently needed.

Regards

[Former Member]

Dear All,

Plz reply..

Regards

[kothandaraman_nagarajan]

If you want I will check it through TV now.