Skip to Content

Query For Stock Transfer

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 06, 2015 at 10:27 AM

    Hi Kuldeep,

    DECLARE @DocEntry INT = 1

    SELECT T2.BinCode, T0.ItemCode, T0.ActionType, T0.EffectQty

    FROM OILM T0 JOIN OBTL T1 ON T0.MessageID = T1.MessageID

      JOIN [dbo].[OBIN] T2  ON  T2.[AbsEntry] = T1.[BinAbs]  

    WHERE T0.TransType = 67 AND T0.DocEntry = @DocEntry

    There will be two lines for each item. 1 is From Bin, the other is To Bin.

    Regards

    Edy

    Add comment
    10|10000 characters needed characters exceeded

    • Hi @Edy Simon,

      Thanks dear for your reply. Also thanks for sharing such valuable query. Although I tried to write this query for Kuldeep, But I also was not successful to get the From Bin Location and To Bin Location information. I tried to search for the threads but mostly were not answered.

      Hope your query will help others in future. I also will inform you, if there will be any problem to get the output for the same.

      Thanks & Regards

      Ankit Chauhan

  • Jan 02, 2015 at 05:41 AM

    Hi Kuldeep,

    There are several threads regarding this. You may check these:

    Hope it helps.

    Thanks & Regards

    Ankit Chauhan

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 02, 2015 at 06:57 AM

    Dear All,

    Plz reply for getting this query.

    Regards

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Thomas,

      Is there any field from Where I can get the information of  'From Bin Location' and 'To Bin Location' ?

      Because I have tried with many tables but not able to get that.

      Hope you can help me.

      Thanks & Regards

      Ankit Chauhan