Is there an AP Invoices by Job report that sorts by job, vendor and invoice (no extra)?
Description

Cause

The sort order on the AP Invoices by Job report is in SRT-Project Manager, Job, Extra, Vendor, Invoice order and prints at the invoice distribution level. Therefore the invoice will show multple lines if there are multiple combinations of job and extra on the invoice distributions.

Resolution

The AP Invoices by Job (HB).rpt has a sort order of Job, Vendor, Invoice order. This report can be added to the reports menu using the Report Manager by following the instructions in the article linked below.

NOTE:

The reports sorts the invoice distribution records by Job, Vendor and Invoice. This report does not include a project manager sort option. A run time prompt is provided to control what invoices print, based on the status of the invoice (Open vs Paid) and the payment date.

Conditions:
1. Only invoice distributions that are coded to a job are printed.
2. If the Payment Date Cut Off prompt is left blank, then this parameter is ignored when selecting invoices for printing. Otherwise, the payment date of the invoice must be before or on the date entered.
3. The "Print" drop down box is used to control what job invoices are printed, based on the distribution status.

How do I add a report to a Reports menu?

Steps to duplicate
Related Solutions