The standard report, "AP Open Invoices with Cut-off Date", uses the AP Transaction record as its driving record, sorts in default order of Vendor, Invoice, Dist Seq, and is "summarized" by Invoice to print one line per invoice.  The job number is not stored in the AP Transaction record, but must be retrieved from the AP Distribution record.  You would need to change the "Summarize by" setting to the lower level of AP Distribution record, and make changes to the formula "Print Invoice?" used in the Conditional Print settings.  The results you apparently want requires more extensive report design modifications than merely adding a Job number field from another record.

The standard report "AP Open Invoices by Job with Cut-off Date" uses a custom formula to look-up the job number from the AP Distribution record, and then sorts the AP Transaction records first by Job, and then by the standard order of Vendor, Invoice, Dist Seq, and groups the open invoices by Job.  That report might work for you as is, or might be a better starting point for a customized report.

The standard report, "AP Open Invoices with Cut-off Date", uses the AP Transaction record as its driving record, sorts in default order of Vendor, Invoice, Dist Seq, and is "summarized" by Invoice to print one line per invoice.  The job number is not stored in the AP Transaction record, but must be retrieved from the AP Distribution record.  You would need to change the "Summarize by" setting to the lower level of AP Distribution record, and make changes to the formula "Print Invoice?" used in the Conditional Print settings.  The results you apparently want requires more extensive report design modifications than merely adding a Job number field from another record.

The standard report "AP Open Invoices by Job with Cut-off Date" uses a custom formula to look-up the job number from the AP Distribution record, and then sorts the AP Transaction records first by Job, and then by the standard order of Vendor, Invoice, Dist Seq, and groups the open invoices by Job.  That report might work for you as is, or might be a better starting point for a customized report.

Is there any way to get rid of blank pages?

Hi Agustin,

Yes it can be done, but there would need to be formulas written to suppress those fields.