on 05-11-2011 5:59 PM
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!
found the answer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
sorry about that, i found the answer, is the RCT2 table that holds all the payments ORCT to invoices OINV
cheers!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.