Summary/Use Case
Report Summary
The WO Transactions by Vehiclereport details all work order transactions associated with individual vehicles within a specified date range. This report helps fleet managers track the parts, labor, and associated costs for each work order by vehicle, allowing for effective cost tracking and maintenance planning.
Use Case
Analyze work order costs on a per-vehicle basis to manage budgets effectively.
Identify trends in vehicle maintenance expenses for preventative action.
Track specific parts or services provided across multiple work orders.
Assess labor hours and costs associated with each vehicle to optimize resource allocation.
Support decision-making in vehicle repairs or replacements based on cost history.
Location: Where to Find It
Reports > RTA Standard Reports > Work Order > WO Transactions by Vehicle
...
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 - 999 | 1 | Facility range for filtering |
Vehicle Facility | Is Between | 1 - 999 | 1 | Facility range for vehicles |
Vehicle | Is Between | 0 - zzzzzzz | 0 - zzzzzzz | First and last possible vehicle values |
Date | Is Between | Custom date range | 11/01/2024 - 11/06/2024 | Specific date range for transactions |
VMRS Major | Is Between | 0 - 999 | 0 - 999 | Range of VMRS Major codes |
VMRS Inter | Is Between | 0 - 999 | 0 - 999 | Range of VMRS Intermediate codes |
VMRS Minor | Is Between | 0 - 999 | 0 - 999 | Range of VMRS Minor codes |
Report Output and Data Elements
When the WO Transactions by Vehicle report is run, users will see detailed transaction data grouped by vehicle, including work order numbers, transaction types, dates, VMRS codes, parts used, descriptions, hours, prices, and total costs. Totals for labor, parts, and additional fees are provided, helping users analyze individual and cumulative transaction costs for each vehicle.
Report Output
...
Report Data Elements
Column Number | Column Title | Data Notes |
---|---|---|
1 | WO# | Work order number associated with the vehicle |
2 | LN | Line number within the work order |
3 | TRN TYP | Transaction type, e.g., labor or note |
4 | DATE | Date of the transaction |
5 | VMRS CODE | Code specifying the VMRS part or service |
6 | PART NUMBER / MECHANIC | Part number or mechanic identifier |
7 | DESCRIPTION | Description of the part or service provided |
8 | HRS / QTY | Hours or quantity associated with transaction |
9 | PRICE / WG | Price or wage per hour/unit |
10 | TOTAL COST | Total cost for the transaction line |