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

image-20241111-142857.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.

Parameter List

image-20241111-142929.png

Parameter Name

Value (Default)

Value (Notes)

Parameter Name

Value (Default)

Value (Notes)

Blind Count

False

blank

Data Filter List

image-20241111-143203.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

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

image-20241113-215403.png

Column Number

Column Title

Data Notes

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.