Report with blank lines

Question

We have changed the AP invoice aging w/cut off to show the job number. It worked great except that it has a huge number of lines that have no dollar amount. These lines just show the vendor number and name as well as the job number and name. Can someone tell me how to get rid of these blank lines? 
 
 Thanks, 
 Amanda

Art Minds · Answer

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.

Sage Construction & Real Estate

Report with blank lines

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING