Skip to Content
0
Former Member
Dec 05, 2008 at 08:25 AM

Inventory Transfer Query

101 Views

Hi all,

I have made the simple query below to trace inventory transfers. I'm however unable to include a

2ND STEP TRANSFER NUMBER (i.e. Destination Whse DocNum) and DESTINATION DOCDATE.

SELECT distinct T0.DocNum 'Original Doc', T0.DocDate 'Orig. DocDate', T0.Filler 'Original Whse', T1.WhsCode 'Dest. Whse' FROM [dbo].[OWTR] T0 INNER JOIN [dbo].[WTR1] T1 ON T0.DocEntry = T1.DocEntry WHERE T0.DocDate >=[%0] and T0.DocDate <=[%1]

Is it possible to achieve this by way of Query? Any help on achieving this will be very much appreciated. Thanks.

Regards,

Henry