Part Kit List

COMING SOON!

Summary/Use Case

Report Summary

The Part Kit List report shows each part kit and its component parts, including quantities, on-hand counts, costs, and extended totals. Fleet parts managers can use it to confirm kit completeness, stock levels, and valuation by facility and fit code.

Use Case

  • Audit kit definitions and verify all required components and quantities

  • Check on-hand quantities to ensure kits can be built or issued

  • Review kit valuation (Avg Cost × Quantity) for budgeting and inventory planning

  • Organize kits by facility and VMRS/Fit Code using the report’s sort order

Location: Where to Find It

Reports > RTA Standard Reports > Parts > Part Kit List

image-20251029-194003.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

Data Filter List

image-20251029-194022.png

Filter Name

Recommended Filter Condition(s)

Value (Options)

Value (Default)

Value (Notes)

Facility

Is Between

1 - 99999

1 - 99999

Full facility range

Part Kit Number

Is Between

blank - zzzzzzzzzzzz

blank - zzzzzzzzzzzz

“blank” and trailing z’s represent the first and last possible kit numbers

On Hand Quantity

Greater Than Or Equal To

≥ 0

0

Limits results to kits/components with at least this on-hand quantity

Report Output and Data Elements

Report Output

The Part Kit List report groups results by Facility and Fit Code, then lists each Kit with header details (Kit #/Description, VMRS, Primary Bin, Price). Under each kit, component lines display component number/description, primary bin, on-hand, required quantity, average cost, and extended total. Subtotals roll up at the kit level and at the facility level for Quantity and Total.

Color Formatting Description

Red: This indicates that part within the kit has an on-hand quantity of 0

image-20251029-194051.png

Report Sort Order

  • Facility (ascending)

  • Fit Code (ascending)

  • Part Kit Number (ascending)

  • Component Number (ascending)

Report Data Elements

Column Number

Column Title

Data Notes (the purpose of that datapoint)

1

Part Kit Number

Identifier of the kit being listed

2

Component Number

Part number of the component inside the kit

3

Component Desc

Description of the component part

4

Primary Bin

Storage/bin location for the component

5

On-Hand

Current on-hand quantity for the component part

6

Quantity

Required quantity of the component for one kit

7

Avg Cost

Average unit cost of the component

8

Total

Extended cost for the component (Avg Cost × Quantity)