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