Hello,
I am trying to build a query to find out where an unapplied cash receipt
was ultimately applied.
I know that unapplied cash receipts are saved as credit memo invoices
with an invoice suffix of "UR" and are assigned an invoice number but
I'm not sure what table holds the information I'm looking for.
Anyone know which table(s) hold this information?
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]
I am trying to build a query to find out where an unapplied cash receipt
was ultimately applied.
I know that unapplied cash receipts are saved as credit memo invoices
with an invoice suffix of "UR" and are assigned an invoice number but
I'm not sure what table holds the information I'm looking for.
Anyone know which table(s) hold this information?
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]