Skip to Content
0

Query to compare inventory transfer request and inventory transfer

Jul 19, 2017 at 05:14 AM

87

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thank U sir. It works Fine

0