Contents
Warehouse reports provide visibility into storage locations, cycle count activity, space utilization, and warehouse operations. Use these reports to optimize warehouse layout, track inventory accuracy, manage cycle counting programs, and ensure efficient use of storage space.
| Report Category | Access Path | Use For |
|---|---|---|
| Cycle Count Reports | Reports → Warehouse Reports | Count scheduling, variance tracking, accuracy monitoring |
| Location Reports | Reports → Warehouse Reports | Storage tracking, bin contents, location utilization |
| Warehouse Activity | Reports → Warehouse Reports | Movement tracking, zone analysis, operational metrics |
| Space Utilization | Reports → Warehouse Reports | Capacity planning, storage efficiency, overflow management |
Access: Reports → Type: Warehouse Reports (Type 12)
Warehouse reports help you manage physical storage locations and maintain inventory accuracy through cycle counting. These reports support:
Location Management - Track what’s stored where, identify empty bins, and optimize warehouse layout based on item velocity and picking patterns.
Cycle Count Programs - Schedule counts, assign tasks to counters, track variances, and measure counting accuracy to maintain high inventory record precision.
Space Utilization - Monitor warehouse capacity, identify underutilized zones, and plan for storage expansion or consolidation.
Operational Efficiency - Analyze movement patterns, pick paths, and zone activity to reduce travel time and improve productivity.
All warehouse reports include:
| Filter | Purpose | Available In |
|---|---|---|
| Warehouse | Limit to specific warehouse or show all | All reports |
| Zone | Filter to picking, storage, or overflow zones | Location and activity reports |
| Date Range | Show activity or counts within timeframe | Activity and cycle count reports |
| Item Category | Focus on specific product types | Most reports |
| Count Status | Show scheduled, in-progress, or completed counts | Cycle count reports |
| Location Type | Filter by bin, bulk, floor, or rack locations | Location reports |
Cycle count reports support systematic inventory verification programs. They help you schedule counts, assign tasks, track completion, and analyze variances to maintain accurate inventory records.
Shows items and locations scheduled for cycle counting based on frequency, ABC classification, or last count date. Use this report to:
Typical Columns: Item Number, Description, Location, Warehouse, Last Count Date, Next Count Due, ABC Class, Frequency, Count Priority, Assigned Counter
Filters: Warehouse, Date Range, ABC Class, Count Frequency, Location Zone
Related: Cycle Count Guide for count procedures
Tracks differences between physical counts and system quantities. Use to:
Typical Columns: Count Date, Item Number, Description, Location, Expected Quantity, Counted Quantity, Variance, Variance Value, Counter, Reason Code, Resolution Status
Filters: Date Range, Warehouse, Variance Threshold, Counter, Resolution Status
Use Cases:
Analyzes counting efficiency and accuracy metrics across counters, zones, and time periods. Shows:
Use this report to identify training needs, recognize top performers, and improve counting processes.
Typical Columns: Counter Name, Counts Assigned, Counts Completed, Completion Rate, Average Time, Accuracy Rate, Total Variances, Variance Value, Recounts Required
Filters: Date Range, Warehouse, Counter, Location Zone
Lists items that haven’t been counted within their required frequency. Helps you:
Typical Columns: Item Number, Description, Location, Warehouse, Last Count Date, Days Since Count, Count Frequency, Priority Level, ABC Class
Filters: Warehouse, Days Since Last Count, ABC Class, Location Zone
Alert: Items not counted beyond their frequency appear here automatically
Complete record of all cycle counts performed over a specified time period. Use for:
Typical Columns: Count Date, Item Number, Description, Location, Expected Quantity, Counted Quantity, Variance, Counter, Adjustment Posted, Reason Code, Notes
Filters: Date Range, Warehouse, Item, Location, Counter
Location reports show what’s stored where and help you optimize warehouse layout and storage efficiency.
Shows current inventory in each storage location. Use to:
Typical Columns: Location, Warehouse, Zone, Item Number, Description, Quantity, Lot Number, Serial Numbers, Last Activity Date, Days in Location
Filters: Warehouse, Zone, Location Range, Item, Empty Locations (show/hide)
Use Cases:
Lists storage locations that are currently unused. Helpful for:
Typical Columns: Location, Warehouse, Zone, Location Type, Capacity, Last Used Date, Days Empty, Previous Item Stored, Location Dimensions
Filters: Warehouse, Zone, Location Type, Days Empty
Space Planning: Use to plan receiving of large shipments or new product lines
Tracks movement in and out of each location over time. Shows:
Use this to identify hot zones requiring optimization and slow-moving storage areas.
Typical Columns: Location, Warehouse, Zone, Receipts, Issues, Moves, Total Transactions, Average Dwell Time, Turnover Rate, Last Activity Date
Filters: Date Range, Warehouse, Zone, Activity Threshold
Optimization: Identify high-traffic locations for fast-moving items, slow locations for bulk storage
Lists all items currently stored in warehouse locations with quantities and lot information. Use for:
Typical Columns: Item Number, Description, Warehouse, Location, Zone, Quantity, Lot Number, Expiration Date, Last Count Date, Days in Location
Filters: Warehouse, Zone, Item Category, Lot Tracking (Yes/No)
Shows items stored in multiple locations across warehouses. Helps you:
Typical Columns: Item Number, Description, Total Quantity, Number of Locations, Warehouses, Primary Location, Overflow Locations, Suggested Consolidation
Filters: Minimum Locations, Warehouse, Item Category
Efficiency: Items in fewer locations reduce pick time and counting effort
Activity reports analyze movement patterns and operational metrics across warehouse zones and time periods.
Tracks all inventory movements (receipts, issues, transfers) by warehouse and zone. Use to:
Typical Columns: Date, Warehouse, Zone, Receipts, Issues, Transfers, Adjustments, Total Transactions, Value Moved, Primary Users
Filters: Date Range, Warehouse, Zone, Transaction Type, Shift
Operational Planning: Align staffing levels with activity volume by zone and time
Analyzes storage usage and activity by warehouse zone (receiving, picking, bulk, overflow). Shows:
Typical Columns: Zone, Warehouse, Total Locations, Occupied Locations, Utilization %, Capacity Available, Receipts, Issues, Turnover Rate, Average Dwell Time
Filters: Warehouse, Zone Type, Utilization Threshold
Space Planning: Identify underutilized zones for better space allocation or overflow storage
Tracks receiving activity by warehouse, including quantities, values, and processing times. Use for:
Typical Columns: Receive Date, Warehouse, Receiving Zone, Items Received, Quantity Received, Value Received, Time to Putaway, Received By, Supplier
Filters: Date Range, Warehouse, Receiving Zone, Supplier
Performance Metrics: Track items per hour, putaway time, receiving accuracy
Analyzes picking activity and efficiency by warehouse zone. Shows:
Typical Columns: Pick Date, Warehouse, Zone, Picker, Orders Picked, Items Picked, Pick Accuracy, Average Pick Time, Items per Hour
Filters: Date Range, Warehouse, Zone, Picker
Optimization: Use to improve pick paths, zone assignments, and picker training
Lists all transfers between warehouses over a time period. Use to:
Typical Columns: Transfer Date, From Warehouse, To Warehouse, Item Number, Description, Quantity, Value, Transfer Reason, Transfer By, Received Date
Filters: Date Range, From Warehouse, To Warehouse, Item, Transfer Reason
Space utilization reports help you maximize warehouse capacity and plan for expansion or consolidation.
Shows storage capacity, current usage, and available space by warehouse and zone. Use for:
Typical Columns: Warehouse, Zone, Total Locations, Occupied Locations, Utilization %, Cubic Capacity, Cubic Used, Available Space, Trend (30/60/90 days)
Filters: Warehouse, Zone, Utilization Threshold
Planning: Forecast capacity needs based on utilization trends and growth projections
Compares actual storage usage to optimal density targets. Shows:
Typical Columns: Warehouse, Zone, SKU Count, Space Allocated, Space Used, Density %, Wasted Space, Optimization Opportunity, Suggested Actions
Filters: Warehouse, Zone, Density Threshold
Optimization: Identify opportunities to increase storage density through reorganization
Tracks items in overflow or secondary storage locations. Use to:
Typical Columns: Item Number, Description, Primary Location, Overflow Location, Quantity in Primary, Quantity in Overflow, Picking Frequency, Consolidation Opportunity
Filters: Warehouse, Item Category, Days in Overflow
Efficiency: Items picked from overflow take longer and increase labor costs
Compares utilization, activity, and performance metrics across multiple warehouses. Use for:
Typical Columns: Warehouse, Total Capacity, Utilization %, Items Stored, Activity Volume, Throughput, Cost per Transaction, Efficiency Rating
Filters: Warehouse Group, Time Period
Many warehouse reports benefit from automated scheduling to support daily operations:
| Report | Recommended Schedule | Use Case |
|---|---|---|
| Cycle Count Schedule | Daily (morning) | Assign counting tasks for the day |
| Cycle Count Variance | Daily (end of shift) | Review and resolve variances immediately |
| Empty Locations | Daily (before receiving) | Plan putaway for incoming shipments |
| Warehouse Capacity | Weekly | Monitor space utilization trends |
| Zone Utilization | Weekly | Optimize zone assignments |
| Uncounted Items | Weekly | Maintain cycle count compliance |
| Warehouse Performance | Monthly | Review efficiency metrics and improvement opportunities |
Setup: See Report Scheduling for configuration
On this page