cancel
Showing results for 
Search instead for 
Did you mean: 

tracking payments of an invoice

Former Member
0 Kudos

hi, i'm building a query to track the payments of a invoice, my problem is this:

The OINV table only holds the last payment made (in the ReceiptNum field, keeps the id of the ORCT table)

how can i keep track of ALL the payments?

cheers!

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

found the answer

Former Member
0 Kudos

sorry about that, i found the answer, is the RCT2 table that holds all the payments ORCT to invoices OINV

cheers!