Linking the payments back to the invoices

[crystalpro]

I am trying to create a report that lists the checks paid to a specific vendor for a specific gl account in Peachtree Complete 2003. The problem arises when the check pays for a vendor invoice and the invoice has the gl account I am looking for. So, I need the report to search the invoices paid for the gl account and amount posted and then list the check, check date, and amount for the gl account (not necessarily the amount of the check).

I am using the vendor, jrnlhdr and jrnlrow tables. I also brought in the jrnlhdr and jrnlrow tables again and called it jrnlhdr_payments and the jrnlrow_payments. I am linking the tables on the postorder field (jrnlrow.postorder to jrnlhdr.postorder and jrnlrow_payments.postorder to jrnlhdr_payments.postorder. I get an error message when I try to run the report that the fields in tables jrnlrow_payments and jrnlhdr_payments cannot be linked and 0 records are selected.

My selection criter includes rowtype=0 and journal in [2,4].

Any help in how I can resolve this issue is greatly appreciated.