cancel
Showing results for 
Search instead for 
Did you mean: 

Report to List Incoming Payments and related Invoices

Former Member
0 Kudos

Hi Experts,

I would like a query which lists Incoming Payments and also the related Invoices which were paid.

Is there a table which links together the ORCT and OINV tables?

Thanks

Greig

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi!

OINV.Docentry=RCT2.DocEntry and ORCT.Docentry=RCT2.Docnum

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Greig,

Link to ORCT - OINV( SELECT * FROM ORCT T0 INNER JOIN OINV T1 ON T0.DocEntry = T1.ReceiptNum )

Link to ORCT -RCT1 - OINV( SELECT * FROM ORCT T0 INNER JOIN RCT1 T1 ON T0.DocNum = T1.DocNum

NNER JOIN OINV T2 ON T0.DocEntry = T2.ReceiptNum)

Try this,

Lists of Incoming Payments and related Invoices.


SELECT T0.DocNum, 
COUNT(T0.DocEntry) 'No of Invoice' 
FROM RCT2 T0 
INNER JOIN OINV T1 ON T0.DocEntry = T1.DocEntry
GROUP BY T0.DocNum

Regards,

Madhan.

Edited by: Madhan Babu C on Aug 28, 2009 9:23 AM

Former Member
0 Kudos

You may check this thread to start:

Thanks,

Gordon