How to Pull a List of Jobs with Change Orders

The article will show how to use the Job Query Builder to pull all jobs that have had some type of Change Order done.

Overview:

The steps below will show what fields to use, criteria to use to pull records in a certain timeframe, and display the results.

Steps:

1.Click on Query – Job Query

2.When the Job Query Builder Form opens fill in the following areas:

a.Select the following fields to display, on the left, (more fields can be added if needed) by double clicking each filed to display

  • Job – Job_Code
  • Customer – Customer_Number
  • System – Alarm_Account
  • Job – Sold_Date
  • Job – Amount
  • Job – Change_Order
  • Job – Reversal

b.Select the search criteria fields, in the center, by left clicking on field and dragging into the center

  • Job – Sold_Date  >= Date
  • Job – Change_Order = Y

c.Select the Order By fields to sort the data received, on the right, by left clicking on field and dragging into the right box

  • Customer – Customer_Number
  • Job – Job_Code

d.Job Query Builder Form should look like example below

3.Once all fields are filled in, click on the Green Arrow at the bottom of the form

4.The results will fill in the bottom of the form – in this example Job 3851 has 3 change orders indicated by -1, -2, -3 after job 3851

  • NOTE:  Each change order is its own "job" within a job.  So each change order will have the main job number and the number representing the change order.   If both job and job change order is needed, remove the Change_Order filter field.  – see example below

5.Results as well as the Query can be saved by clicking on the Save button to save the query or the Export button to save the results.  To Open the saved query, click on the Open button