How can I get the check # on a job cost report?

The information needed on the report is Vendor, Job #, Phase #, Total,
Invoice Date, Invoice # and Check #.  The check number is stored in
the Reference field, but I can’t get it to display on the report.

 There are a couple of things to note:

1. Create an alias table for payments, i.e., JrnlRow_Payments

Then you can pull the check # from the Reference field in this table.

2. Use a selection condition to select when the {jrnlrow_payments.journal} = 2

The Cash Disbursements Journal is 2, The Purchases Journal is 4.

-- by Gayle Raines, Director of Training at Baytek, an Authorized Peachtree Resource Center.