Skip to Content
1
Former Member
Dec 13, 2012 at 03:47 PM

Add ODLN DLN1 table to script

87 Views

HI Forum,

How can i add Delivery notes to the following script?...

We have 2 locations one uses Deivery notes the main location doesn't yet... i need to print a report with all transactiones and i am missing invoices..

Kennedy helped me with following script... i just can't get to capture all data needed. Thanks.

SELECT Distinct T0.DocNum 'SO#', T0.DocDate 'SO Date',T2.DocDate 'Invoice Date'

FROM ORDR T0

INNER JOIN INV1 T1 ON T1.BaseEntry=T0.DocEntry AND T1.BaseType='17'

INNER JOIN OINV T2 ON T2.DocEntry=T1.DocEntry

Regards,

Manuel Roman