Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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