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

[edy_simon · Accepted solution]

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

[edy_simon · Accepted solution]

Hi /

Does the query solve  your problems ?

Use the Inventory Transfer DocEntry for the @DocEntry.

As per your requirement : You need only for items without batch/Serial.

Regards
Edy

[ANKIT_CHAUHAN · Accepted solution]

Hi ,

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

[Former Member]

Dear All,

Plz reply for getting this query.

Regards

[Former Member]

Dear All,

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

Regards

[Former Member]

Dear All,

Plz reply..

Regards

[Former Member]

Hi,

I'm not sure what you need exectly.

Do you mean Inventory Transfere?

Then something like this:

select ItemCode, Quantity, WhsCode, FromWhsCod from WTR1

[ANKIT_CHAUHAN]

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

[ANKIT_CHAUHAN]

Hi Kuldeep,

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

Hope it helps.

Thanks & Regards

Ankit Chauhan