Parts Activity

Owned by Andrew Finch
Last updated: Nov 13, 2024
2 min read

Summary/Use Case

Report Summary

The Parts Activity report provides a comprehensive overview of the current on-hand inventory for parts, capturing purchase, usage, and adjustment details. Fleet managers can leverage this report to track inventory changes, understand usage patterns, and manage inventory costs effectively.

Use Case

  • Monitor and manage on-hand inventory levels for parts in real-time.

  • Track usage patterns and adjust purchasing strategies based on inventory data.

  • Identify high-usage parts to forecast demand and prevent stockouts.

  • Analyze cost adjustments to support budgeting and cost-saving initiatives.

  • Review historical inventory movements to ensure accurate inventory control.

Location: Where to Find It

Reports > RTA Standard Reports > Parts > Parts Activity

image-20241111-160133.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-20241111-160217.png

Filter Name

Recommended Filter Condition(s)

Value (Options)

Value (Default)

Filter Name

Recommended Filter Condition(s)

Value (Options)

Value (Default)

Facility

Equal To

1 - 99999

1

Starting Date

Greater Than or Equal To

Any Date

First Day of Current Month

Part Number

Is Between

blank - zzzzzzz

blank - zzzzzzz

Report Output and Data Elements

The Parts Activity report output displays inventory details such as part numbers, bin locations, inventory counts, pricing, and totals for purchases, usages, and adjustments. This data provides a holistic view of part activity within the specified date range, enabling informed decision-making regarding inventory management.

Report Output

Report Data Elements

Column Number

Column Title

Data Notes

Column Number

Column Title

Data Notes

1

Part Number

Unique identifier for each part

2

Bin Location

Location in the warehouse where the part is stored

3

Filter Date Inv

Initial inventory count on the specified date

4

Price

Average unit price of the part

5

Filter Date Total

Total value of current inventory based on price and count for user defined date

6

Purchases

Total quantity of purchases during the period

7

Usages

Total quantity used during the period

8

Adjustments

Adjustments made to the inventory

9

Current Inv Total

Reflects the overall current inventory value for each part

10

Current Total

Total value of current inventory based on price and count

Â