Jobs Sourcing My COs widget

Graph the status of job orders that are sourcing customer orders: in process, stopped, or past due.

Filter: You can show all orders or only your orders, and filter for jobs where the start or end date is today, this week, or this month.

Calculations:

In Process: Quantity Released > Quantity Complete, Status = ‘F’ or ‘R’, Start Date or End Date falls in range of Search Field selection, or Start Date is before and end Date is after the range of Search Field selection, and the job is linked to a CO.
Complete: Quantity Released <= Quantity Complete and Status = ‘F’ or ‘R’, or Status = ‘C’ or ‘H’, Start Date or End Date falls in range of Search Field selection, or Start Date is before and end Date is after the range of Search Field selection, and the job is linked to a CO.
Past Due: Quantity Released > Quantity Complete, Status = ‘F’ or ‘R’, End Date less than Today, and the job is linked to a CO.
Stopped: Status = ‘S’, Start Date or End Date falls in range of Search Field selection, or Start Date is before and End Date is after the range of Search Field selection, or End Date is before the range of Search Field selection, and the job is linked to a CO.