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
...
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) |
|---|---|---|---|---|
Facility | Equal Toitalic | 1 - 99999 | 1 | |
Starting Date | Greater Than or Equal To | Any date | 11/01/2024 | Start date for the inventory period |
Part Number | Is Between | italic blank - zzzzzzzitalic | blank - zzzzzzz | Defines the range of part numbers from A to the end of alphanumeric |
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 |
|---|---|---|
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 |