Skip to Content

Query to compare inventory transfer request and inventory transfer

Sir,

I create an inventory transfer request to transfer goods from one warehouse to another warehouse .I create an inventory transfer based on the transfer request .I need a query to compare the Transfer request and Inventory Transfer.

Regards,

Krishna Kumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jul 19, 2017 at 02:26 PM

    Hello,

    You could use this QUERY:

    SELECT T1.ItemCode, T1.DSCRIPTION, T1.WhsCode, T1.Quantity 'Quantity Request', t2.Quantity as 'Quantity Transfered' FROM OWTQ T0 INNER JOIN WTQ1 T1 ON T0.DOCENTRY = T1.DocEntry LEFT JOIN WTR1 T2 ON T2.BASEENTRY = T1.DOCENTRY AND T2.BaseLine = T1.LineNum AND T2.ItemCode = T1.ItemCode left join owtr t3 on t3.docentry = t2.docentry and t3.canceled = 'n'

    where t0.docentry = [%0]

    Put the number of Transfer Request in the prompt variable.

    Regards,

    Diogo.

    Add comment
    10|10000 characters needed characters exceeded