Can't Pull Fields for Job Costing Report in Peachtree

[goitworks]

I am new to Crystal Reports, old to Peachtree. I'm trying to pull the following fields into a job report: Vendor, Job#, Phase #, Total, Date of Invoice, Vendor Invoice Number & Company Check Number (if paid). Everything works fine except I am unable to pull the Check # in. I am trying to use the Reference field.

Any ideas?

 

[crystalpro]

You need to add the jrnlhdr and jrnlrow tables in again. Maybe call them jrnlhdr_payments and jrnlrow_payments. Pull the jrnlhdr_payments.reference when the jrnlhdr_payments.jrnlkey_journal=2.