Inventory Count Sheet
Summary/Use Case
Report Summary
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.
Use Case
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.
Location: Where to Find It
Reports > RTA Standard Reports > Parts > Inventory Count Sheet
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.
Parameter List
Parameter Name | Value (Default) | Value (Notes) |
---|---|---|
Blind Count | False | blank |
Data Filter List
Filter Name | Recommended Filter Condition(s) | Value (Options) | Value (Default) |
---|---|---|---|
Facility | Equal To | 1 - 99999 | 1 |
Bin Number | Is Between | blank - zzzzz | blank - zzzzz |
Part Number | Is Between | blank - zzzzzzz | blank - zzzzzzz |
Stock Parts | Is One Of | Y (stock), N (non-stock), Both (all) | N, Y |
Report Output and Data Elements
Report Output
The Inventory Count Sheet report displays inventory items sorted by facility, providing information on part numbers, descriptions, pricing, units, and quantities available. This report highlights total quantities for each item, assisting in accurate inventory management across facilities.
Report Data Elements
Column Number | Column Title | Data Notes |
---|---|---|
1 | Bin Number | Identifies the storage bin or location for each inventory item. |
2 | Part Number | Unique identifier for each inventory part. |
3 | Description | Brief description of the inventory item. |
4 | Avg-Price | Average price per unit of the item. |
5 | Issue Units | Unit of measurement for issuing this item. |
6 | Total Quantity | Total quantity of the item currently in inventory. |
7 | Count | Quantity counted during inventory verification. |