[AP] AP Invoices by Job/WO Report

Created by Crystal Ann Harvey, Modified on Tue, 14 Oct at 2:34 PM by Crystal Ann Harvey

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 Parameters	Description
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 checkbox 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.