Parts Reports

Report Title

Report Description

Location

Use Case Scenario

Current Inventory List by Fit Code

The Current Inventory List by Fit Code report lists active parts in inventory, grouped by their fit code assignment and filtered by facility, stock/consignment/chargeable flags, and part type. Fleet managers can use this to quickly verify stocking levels, review recent purchasing details, and spot items with on-order or backorder quantities.

Reports >

RTA Standard Reports >

Parts >

Current Inventory List by Fit Code

  • Validate on-hand quantities versus reorder points to prevent stockouts

  • Audit parts with open backorders (BO Qty) or on-order quantities (OO Qty) to expedite purchasing

  • Review last PO number/vendor/date and pricing to confirm sourcing and markup accuracy

  • Filter by part type (e.g., Tire, Oil, HydraulicFluid) to prepare cycle counts by category

  • Identify non-stock or consignment parts carried at a location for policy compliance

Current Inventory List

The Current Inventory List report provides a comprehensive view of all parts currently in inventory, including stock and non-stock items, along with detailed cost and quantity information. This report also gives the customer the option to view the inventory with FIFO method. This report is valuable for fleet managers to monitor available inventory, manage purchasing decisions, and ensure part availability across facilities. It is particularly useful for Parts an

Reports >

RTA Standard Reports >

Parts >

Current Inventory List (New)

  • Track real-time inventory levels for all part types

  • Identify high-value inventory items for cost control and budgeting

  • Support purchasing decisions by reviewing reorder quantities and on-hand values

  • Monitor part consumption and demand trends over time

  • Ensure accurate part classification (stock, consignment, chargeable)

High-Low Use Parts

The High-Low Use Parts report provides a detailed list of parts filtered by their usage frequency over a specified date range. Fleet managers can use this report to quickly identify which parts are being used most/least often, enabling better inventory control and purchasing decisions. This helps ensure parts availability while avoiding overstocking rarely used items.

Reports >

RTA Standard Reports >

Parts >

High-Low Use Parts

  • Identify frequently used parts to maintain optimal stock levels

  • Highlight low-use parts for potential removal from inventory to reduce carrying costs

  • Support budgeting and purchasing decisions based on actual usage trends

  • Detect unusual usage spikes that may indicate maintenance or operational issues

Inventory Count Sheet

The Inventory Count Sheet report provides a detailed list of inventory items by facility, showing information such as part number, description, average price, issue units, total quantity, and count. Fleet managers will find this report useful for tracking inventory status and availability across facilities, ensuring accurate and efficient inventory management.

Reports >

RTA Standard Reports >

Parts >

Inventory Count Sheet

  • Monitor inventory levels by part and facility to prevent stockouts.

  • Evaluate inventory usage patterns to inform reordering decisions.

  • Ensure accurate stock counts to reduce discrepancies and maintain inventory accuracy.

  • Support audits by providing an organized record of current inventory by facility.

  • Assist in budgeting and cost analysis by showing inventory quantities and values.

Manual Parts Charge Out

The Manual Parts Charge Out report displays itemized details of parts issued manually from inventory, including account numbers, part details, quantities, costs, and authorizations. This report is essential for fleet managers to monitor parts expenses and track inventory usage accurately across departments.

Reports >

RTA Standard Reports >

Parts >

Manual Parts Charge Out

  • Track manual parts issuance for accounting and auditing purposes.

  • Identify high-usage parts and manage inventory effectively.

  • Analyze parts costs by facility or department for budget planning.

  • Ensure accurate record-keeping for internal or external audits.

  • Support maintenance cost control by monitoring parts usage per job or mechanic.

Part Adjustments

The Part Adjustments report provides detailed information on parts adjustments by facility and part number, including changes in quantities and associated reasons. This report is valuable for fleet managers to track inventory adjustments, understand usage patterns, and monitor authorization and accountability within the parts inventory.

Reports >

RTA Standard Reports >

Parts >

Part Adjustments

  • Track inventory changes and reconcile parts usage and adjustments.

  • Identify discrepancies or unusual usage patterns in parts adjustments.

  • Review authorization details for parts adjustments to ensure accountability.

  • Assist in budgeting by analyzing parts added or removed over time.

  • Monitor facility-specific adjustments for localized inventory management.

Part Kit List

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.

Reports >

RTA Standard Reports >

Parts >

Part Kit List

  • 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

Part Request Log

The Part Request Log report provides a detailed list of requested parts that are currently on order, pending, ready for delivery, or out for delivery. Fleet managers can use this report to monitor the status and aging of part requests to improve service scheduling and parts inventory management.

Reports >

RTA Standard Reports >

Parts >

Part Request Log

  • Track outstanding part requests by facility and request status

  • Identify aging part requests to expedite procurement and minimize equipment downtime

  • Monitor which parts are awaiting delivery to align maintenance planning

  • Assist in evaluating vendor performance based on delivery timeliness

  • Provide documentation for internal auditing or cost recovery

Part Warranty

The Part Warranty report provides a detailed overview of part installations, warranty-related details, and vehicle associations for a fleet. This report is especially useful for fleet managers to monitor warranty timelines, costs, and usage metrics, which helps ensure warranty claims can be tracked and recovered efficiently.

Reports >

RTA Standard Reports >

Parts >

Part Warranty

  • Track warranty durations by mileage and time for installed parts

  • Identify parts that are out of warranty but recently failed

  • Monitor high-cost parts and ensure proper documentation of purchase and installation

  • Review warranty claims by vendor or part to identify reliability issues

  • Optimize parts procurement based on warranty duration and historical performance

Parts Activity

The Parts Activity report summarizes inventory movement for each part since a specified start date, showing beginning inventory (as of that date), purchases, usages, adjustments, and current inventory value. Fleet managers can use this to reconcile stock movement, validate period activity, and quantify inventory value changes by part type or location.

Reports >

RTA Standard Reports >

Parts >

Parts Activity

  • Reconcile monthly inventory by comparing beginning balances, activity, and current on-hand totals

  • Identify high-usage parts to refine min/max and reorder strategies

  • Audit adjustments to spot counting or data-entry issues

  • Report inventory value by category (e.g., Tires, Oil) for finance and compliance

Parts Usage

The Parts Usage (New) report provides a detailed breakdown of parts issued by facility, vehicle, and work order. This report is especially useful for fleet managers needing to track part usage trends, costs, and vendor information for inventory and maintenance budget optimization. It’s particularly helpful for parts department personnel looking to audit usage and spending across VMRS codes.

Reports >

RTA Standard Reports >

Parts >

Parts Usage (New)

  • Monitor part consumption by work order to identify high-usage areas

  • Track vendor sourcing and associated costs for each part

  • Analyze parts cost vs. charge price to identify areas of markup or loss

  • Ensure parts are charged correctly to vehicles and work orders for billing and inventory accuracy

  • Audit VMRS codes for reporting and compliance