cancel
Showing results for 
Search instead for 
Did you mean: 

query for displaying Sales order copied to AR DP Invoices

Former Member
0 Kudos

Dear All,

Please guide me on a query which would enable me to get the AR DP INVOICE docnum for a particular sales order docnum.

Kind Regards,

Monil.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member187989
Active Contributor
0 Kudos
SELECT T3.DocNum FROM [dbo].[RDR1]  T0 INNER JOIN [dbo].[DPI1]  T1 ON T1.BaseEntry = T0.DocEntry INNER JOIN ORDR T2 ON T0.DocEntry = T2.DocEntry INNER JOIN ODPI T3 ON T1.DocEntry = T3.DocEntry WHERE T2.DocNum = '[%0]'