WO Transaction by Vehicle

Summary/Use Case

Report Summary

The WO Transactions by Vehicle report 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

image-20241106-222309.png

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.

image-20241106-222611.png

Data Filter List

Filter Name

Recommended Filter Condition(s)

Value (Options)

Value (Default)

Work Order Facility

Is Between

1 - 999

1 - 1

Vehicle Facility

Is Between

1 - 999

1 - 1

Vehicle

Is Between

0 - zzzzzzz

0 - zzzzzzz

Date

Is Between

Any Date Range

First Day of Current Month - Current Day

VMRS Major

Is Between

0 - 999

0 - 999

VMRS Inter

Is Between

0 - 999

0 - 999

VMRS Minor

Is Between

0 - 999

0 - 999

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

image-20241106-222640.png

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