on 2009 May 26 7:17 AM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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]'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.