Skip to Content
0
Former Member
Jan 16, 2015 at 01:50 PM

Linking ORDN to ORIN

61 Views

Dear Experts,

Could you please help to modify below code to add RIN1.[Price]?

Also please help to add to the query Return deliveries where credit memo is missing (RDN1.[TrgetEntry] IS NULL)

SELECT

T0.[DocNum], T0.[DocDate], T1.[ItemCode],T1.[Quantity], T3.[DocNum]

FROM

ORDN T0 INNER JOIN RDN1 T1 ON T0.DocEntry = T1.DocEntry left join RIN1 T2 on T1.[TrgetEntry] = T2.docentry INNER JOIN ORIN T3 ON T2.DocEntry = T3.DocEntry

Thanks & Regards,

Yaroslav