AP Invoices by Job/WO Report

You can use the AP Invoices by Job/WO report to view invoices by Job or SM Work Order. You can access this report by selecting Accounts Payable > Reports > AP Invoices by Job/WO.

The report sorts by Job/Work Order, Vendor, and Reference, with details to the invoice line level including the original invoice amount and the amount still open as of the current date. Restrictions can be by Job, Work Order, and vendor or include Jobs with a specific status (Open, Soft Closed/Open or Closed) or Work Orders with a specific status. (The Job status parameter only applies to Jobs, and the Work Order status parameter only applies to Work Orders.) Additional restrictions can be to include only invoices open as of today and to include only invoices that were posted to a specific date and/or month range. The open column is based on current status only, not based on the date or month restrictions.
Report ParametersDescription

Company

Accept the default, or press F4 to select a company.

Beginning Vendor Name

Press F4 to select the beginning vendor name for sorting.

Ending Vendor Name

Press F4 to select the ending vendor name for sorting.

Beginning JCCo

Press F4 to select the beginning JC company.

Ending JCCo

Press F4 to select ending JC company.

Beginning Job

Press F4 to select beginning job.

Ending Job

Press F4 to select ending job.

Job Status: (O)pen, (S)oft Closed/Open, (C)losed, (A)ll

Enter O to display jobs with an open status, S to display jobs with a soft closed/open status, or A to display all jobs.

Open Invoices Only?

Select the checkbox to display only open invoices on the report.

Sort by (M)onth or (D)ate

Enter M to sort by month or D to sort by date.

Beginning Month

Enter or select the applicable beginning month.

Ending Month

Enter or select the applicable ending month.

Beginning Invoice Date

Enter or select the applicable beginning invoice date.

Ending Invoice Date

Enter or select the applicable ending invoice date.

Include Unapproved Invoices?

Select the check box to include unapproved invoices.

Include Invoices for (J)ob, (S)ervice or (B)oth

Enter J to sort for job invoices, S for service invoices, or B for both.

Beginning SMCo

Enter or select the applicable beginning SM company.

Ending SMCo

Enter or select the applicable ending SM company.

Beginning Work Order

Enter or select the applicable beginning work order.

Ending Work Order

Enter or select the applicable ending work order.

Break out Job Work Order Groups

Select the checkbox to break out job work order groups.

Work Order Status (blank for all)

Press F4 to select a work order status or leave the field blank to return all statuses.