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