Skip to Content
0
Former Member
May 11, 2011 at 04:59 PM

tracking payments of an invoice

20 Views

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!