Work Order Scheduling
COMING SOON!
Summary/Use Case
Report Summary
The Work Order Scheduling report lists open work orders by facility with priority, customer, age, line counts, costs, and scheduled vs. remaining hours. Fleet managers can use it to prioritize work, balance technician capacity, and follow up on aging WOs before SLA or compliance deadlines.
Use Case
Triage WOs by priority and days opened to schedule the next shift.
Spot bottlenecks using Lines (Completed/Open/Total) and Hours (Scheduled/Remaining).
Review costs to date (parts, labor, tires) for budget control and approvals.
Filter by customer or WO number ranges to manage external/internal work.
Location: Where to Find It
Reports > RTA Standard Reports > Work Order > Work Order Scheduling
Data Filter Prompts
You will be prompted for filtering of the Data to specify and narrow down the data that will be pulled. See Data Filter List Below for Options
Data Filter List
Filter Name | Recommended Filter Condition(s) | Value (Options) | Value (Default) | Value (Notes) |
|---|---|---|---|---|
Work Order Facility | Is Between | 1 - 99999 | 1 - 99999 | Full facility range |
Customer Number | Is Between | blank - zzzzzzzzzz | blank - zzzzzzzzzz | “blank” and trailing z’s represent the first and last possible customer numbers |
Work Order Number | Is Between | 000000 - 9999999 | 000000 - 9999999 | Numeric WO range |
Priority Rank | Is Between | 1 - 9 | 1 - 9 | Limits results to selected priority levels |
Work Order Status | Not Equal To | All work order statuses | Closed | Excludes WOs with status “Closed” (select other statuses as needed) |
Report Output and Data Elements
Report Output
The Work Order Scheduling report is grouped by Facility and then by Priority (e.g., “Priority: (3) Critical”). For each WO, it shows the vehicle, reason, status, customer, creation date, age in days, line counts (completed/open/total), cost buckets (parts, labor, tires), whether costs are posted, and technician hours (scheduled vs. remaining). Each work order is a hyperlink to the work order file within Fleet360.
Report Sort Order
Facility Master Number — Ascending
Priority — Descending
Work Order Number — Ascending
Report Data Elements
Column Number | Column Title | Data Notes (the purpose of that datapoint) |
|---|---|---|
1 | WO Number | Unique identifier of the work order |
2 | Vehicle | Vehicle/asset associated with the WO |
3 | Reason | WO reason/category (e.g., SCHEDULED/MAINTENANCE) |
4 | Status | Current WO status (e.g., Ready for Review, Re-Opened) |
5 | Cust # | Customer number tied to the WO |
6 | WO Created | Date the WO was created |
7 | Days Opened | Number of days since the WO was created; if the WO is closed, then it will be the number of days from Create to Closed |
8 | Lines – Cmpl | Count of completed lines on the WO |
9 | Lines – Open | Count of open lines on the WO |
10 | Lines – Total | Total line count (Completed + Open) |
11 | Costs – Part | Accrued parts cost on the WO |
12 | Costs – Labor | Accrued labor cost on the WO |
13 | Costs – Tires | Accrued tire cost on the WO |
14 | Hours – Posted | Hours that have been posted to the WO so far |
15 | Hours – Scheduled | Technician hours scheduled against the WO |
16 | Hours – Remaining | Technician hours still needed to complete the WO (Scheduled - Posted) |