After exporting Invoices and Payments records, I cannot locate any reference key between them. What is the easiest way ( table or field) to match them up? Easy when 1pmt to 1 Invoice, but harder on 1pmt for many Invoices or many pmts on an Invoice. Any help/suggestions are appreciated.
Thanks, but I am looking for the link in order to match the Payments/Credits with the Invoices outside of Quickbooks. I have exported the Invoices, Payments and Credits into sql tables but don't see a field in either which has the other's record number or field that has a link reference.
Is there a seperate xref table or a link field i'm not seeing?
That should provide information on how you can link payments to their invoices. Let me know if there's anything else you need from me by leaving a comment below. I'd be glad to answer. Have a nice day!