Inventory Reports

Inventory reports provide real-time visibility into stock levels, valuations, movement patterns, and profitability across your warehouses. These reports support daily operations, strategic planning, financial reporting, and compliance requirements.

Access: Reports → Type: Inventory Reports (Type 2)

Understanding Inventory Reporting

Inventory Pro’s reporting system offers multiple perspectives on your stock data to support different business needs:

Stock Status Reports answer “What do I have right now?” with current quantities, locations, and availability across all warehouses.

Valuation Reports answer “What is my inventory worth?” using various costing methods (FIFO, average cost, last cost) for financial reporting and tax compliance.

Movement Reports answer “How fast is inventory moving?” by analyzing usage patterns, turnover rates, and velocity to optimize purchasing and identify slow-moving stock.

Historical Reports answer “What did I have on a specific date?” providing point-in-time snapshots for audits, reconciliation, and trend analysis.

Profitability Reports answer “Which items generate the best margins?” by comparing costs to selling prices across different time periods.

Report Features

All inventory reports include:

• Multi-warehouse support: View individual warehouses or consolidated data
• Real-time data: Reports reflect current system state at run time
• Flexible filtering: Filter by category, supplier, location, date range, item attributes
• Export capabilities: Excel, CSV, PDF for external analysis
• Customization: Modify columns, grouping, sorting, and totals (Admin Option 165 required)
• Scheduled delivery: Email reports automatically on recurring schedules

Common Filters

Current Inventory Reports

These reports show real-time stock positions, locations, and availability for daily operations and order fulfillment.

Inventory Count Report (Report 50)

Purpose: Primary inventory listing showing current quantities, locations, and basic item information.

Use For:

• Daily stock verification
• Order fulfillment reference
• Physical count preparation
• Warehouse operations

Key Columns:

• Item ID and Description
• Warehouse and Location
• On Hand Quantity
• Allocated (reserved for orders)
• Available (on hand minus allocated)
• Units of Measure
• Category and Supplier

Variations:

• Lite Mode (Report 139): Simplified view with fewer columns
• Packed Mode (Report 109): Compact format for printouts (Admin Option 153)

Filters: Warehouse, Category, Supplier, Location, Zero Stock, Discontinued

Tips:

• Export to Excel for offline analysis and distribution
• Use “Available” column for fulfillment decisions, not just “On Hand”
• Filter out zero stock items for cleaner reporting

Stock by Location Report (Report 71)

Purpose: Location-centric view showing all items in specific bins, aisles, or zones.

Use For:

• Warehouse organization audits
• Location consolidation planning
• Picking route optimization
• Slotting analysis

Key Columns:

• Location (Bin/Shelf/Zone)
• Item ID and Description
• Quantity at Location
• Serial Numbers (if tracked)
• Last Activity Date

Filters: Warehouse, Location range, Category, Zero Stock

Tips:

• Sort by location to walk warehouse systematically
• Identify overcrowded or underutilized locations
• Use for directed putaway planning

Items Below Min/Max Report (Report 63)

Purpose: Identifies items that have fallen below minimum stock levels or exceeded maximum levels, triggering reorder or excess stock alerts.

Use For:

• Automated reorder point monitoring
• Purchasing decision support
• Excess stock identification
• Par level management

Key Columns:

• Item ID and Description
• Current Quantity
• Minimum Quantity (reorder point)
• Maximum Quantity (par level)
• Variance (under/over par)
• Supplier information
• Last Order Date

Filters: Warehouse, Category, Supplier, Below Min/Above Max toggle

Tips:

• Run daily to identify purchasing needs
• Export for purchase order creation
• Set realistic min/max levels based on lead time and usage

Serialized Inventory Report (Report 84)

Purpose: Detailed listing of all serialized items showing individual serial numbers, locations, and status.

Use For:

• Asset tracking and verification
• Warranty and recall management
• Serial number lookups
• Audit trail documentation

Key Columns:

• Item ID and Description
• Serial Number (and Serial2 if enabled)
• Location
• Date Received
• Supplier/Source
• Current Status (Available, Allocated, Issued)
• Cost and Value

Filters: Warehouse, Item, Serial Number, Date Range, Status

Tips:

• Use for warranty expiration tracking
• Export for asset registers
• Cross-reference with asset reports for capital equipment

Lot Tracked Inventory Report (Report 93)

Purpose: Shows inventory grouped by lot numbers for lot-controlled items (batch tracking, expiration management).

Use For:

• Expiration date monitoring (FEFO management)
• Batch recall management
• Quality control tracking
• Compliance reporting (FDA, ISO)

Key Columns:

• Item ID and Description
• Lot Number
• Expiration Date
• Quantity by Lot
• Location
• Received Date
• Supplier/Batch Source

Filters: Warehouse, Item, Lot Number, Expiration Date Range, Expired toggle

Tips:

• Sort by expiration date to identify FEFO priorities
• Use for recall responses and batch investigations
• Monitor approaching expirations for disposition decisions

Valuation and Costing Reports

Financial reports showing inventory value, cost of goods sold, and pricing analysis for accounting and tax purposes.

Current Inventory Valuation Report (Report 52)

Purpose: Calculates total inventory value using selected costing method (FIFO, average cost, last cost, replacement cost).

Use For:

• Month-end financial close
• Balance sheet reporting
• Tax compliance
• Insurance valuations

Key Columns:

• Item ID and Description
• Quantity on Hand
• Unit Cost (by selected method)
• Extended Value (quantity × cost)
• Warehouse
• Category

Totals: Extended value totals by warehouse, category, and overall

Filters: Warehouse, Category, Supplier, Costing Method, Zero Stock

Costing Methods:

• FIFO (First In, First Out): Values stock at oldest acquisition costs
• Average Cost: Weighted average of all purchases
• Last Cost: Most recent purchase price
• Replacement Cost: Current supplier pricing

Tips:

• Run consistently with same costing method for comparability
• Export for COGS calculations
• Compare costing methods to understand margin exposure

Point In Time Valuation Report (Report 117)

Purpose: Historical inventory valuation as of any past date, supporting retroactive financial analysis and audit requirements.

Use For:

• Historical period closes
• Audit responses
• Prior period adjustments
• Trend analysis

Key Columns:

• Item ID and Description
• Quantity as of Selected Date
• Unit Cost as of Date
• Extended Value
• Variance from Current

Filters: As-of Date, Warehouse, Category, Costing Method

Tips:

• Essential for month-end corrections and restatements
• Compare multiple dates for inventory value trends
• Use for internal audit verification

Point In Time by Lot Report (Report 228)

Purpose: Lot-level inventory snapshot as of any historical date, showing quantities and costs by individual lot numbers.

Use For:

• Lot-specific historical analysis
• Batch costing verification
• Expiration management history
• Regulatory compliance

Key Columns:

• Item ID and Description
• Lot Number
• Quantity as of Date
• Unit Cost by Lot
• Expiration Date (if tracked)
• Extended Value

Filters: As-of Date, Warehouse, Item, Lot Number

Tips:

• Use for expired lot analysis
• Track lot-specific cost variances
• Support recall investigations with historical data

Inventory Value by Category Report (Report 106)

Purpose: Summarizes inventory value grouped by product category for portfolio analysis.

Use For:

• Category performance analysis
• Purchasing budget allocation
• ABC analysis preparation
• Investment focus decisions

Key Columns:

• Category Name
• Total Items in Category
• Total Quantity
• Total Value
• Percentage of Total Inventory
• Average Value per Item

Filters: Warehouse, Costing Method, Zero Stock

Tips:

• Identify high-value categories for tighter controls
• Support strategic purchasing decisions
• Compare category values over time

Movement and Velocity Reports

Analysis of stock turnover, usage patterns, and movement velocity for purchasing optimization and dead stock identification.

Inventory Velocity Report (Report 94)

Purpose: Analyzes turnover rates and usage patterns to classify items as fast-moving, slow-moving, or dead stock.

Use For:

• ABC classification
• Purchasing optimization
• Warehouse slotting decisions
• Dead stock identification

Key Columns:

• Item ID and Description
• Quantity Issued (period)
• Quantity Received (period)
• Current On Hand
• Turnover Rate (issues/average inventory)
• Velocity Classification (Fast/Medium/Slow)
• Days of Supply

Filters: Date Range, Warehouse, Category, Minimum Activity Level

Classifications:

• Fast Movers: High turnover, frequent replenishment
• Medium Movers: Moderate activity, standard reorder cycles
• Slow Movers: Low activity, extended reorder cycles
• Dead Stock: No activity in reporting period

Tips:

• Run quarterly to adjust min/max levels
• Relocate fast movers to accessible locations
• Review slow movers for disposition or obsolescence

Stock Activity Report (Report 58)

Purpose: Detailed transaction history showing all receipts, issues, and movements for selected items over a date range.

Use For:

• Usage pattern analysis
• Demand forecasting
• Transaction verification
• Customer usage tracking

Key Columns:

• Date and Time
• Transaction Type (Receipt, Issue, Move, Adjustment)
• Quantity
• Location
• Source/Destination
• User
• Reference Number (PO, SO, WO)

Filters: Date Range, Warehouse, Item, Transaction Type, User

Tips:

• Identify seasonal patterns
• Verify specific transactions
• Support customer billing and usage reports

Hot Movers Report (Report 87)

Purpose: Identifies highest-volume items by quantity issued over a specified period.

Use For:

• Top item identification
• Safety stock decisions
• Supplier negotiation priorities
• Warehouse layout optimization

Key Columns:

• Item ID and Description
• Total Quantity Issued
• Number of Transactions
• Average Issue Quantity
• Current Stock Level
• Rank (by volume)

Filters: Date Range, Warehouse, Category, Top N items

Tips:

• Focus on top 20% of items for biggest impact
• Negotiate volume discounts for hot movers
• Ensure adequate safety stock for high-velocity items

Slow Moving Items Report (Report 96)

Purpose: Highlights items with little to no activity over specified period, flagging potential obsolescence or overstocking.

Use For:

• Excess inventory identification
• Disposition decisions (clearance, write-off)
• Purchasing adjustments
• Warehouse space optimization

Key Columns:

• Item ID and Description
• Current Quantity
• Last Activity Date
• Days Since Last Activity
• Current Value
• Supplier

Filters: Inactivity Threshold (days), Warehouse, Category, Minimum Value

Tips:

• Review quarterly for disposition actions
• Consider clearance pricing or return to supplier
• Adjust purchasing patterns to prevent recurrence

Zero Stock Items Report (Report 68)

Purpose: Lists items with no current inventory that may need reordering or should be discontinued.

Use For:

• Stockout identification
• Reorder prioritization
• Item status review (active vs discontinued)
• Catalog cleanup

Key Columns:

• Item ID and Description
• Last Activity Date
• Last Supplier
• Min/Max Levels (if set)
• Category
• Discontinued Status

Filters: Warehouse, Category, Supplier, Days Since Last Activity

Tips:

• Distinguish between temporary stockouts and discontinued items
• Reorder active items below minimum
• Mark inactive items as discontinued to clean up catalogs

Historical and Audit Reports

Point-in-time snapshots and transaction trails supporting compliance, audits, and historical analysis.

Complete Adjustment History Report (Report 85)

Purpose: Comprehensive audit trail of all inventory adjustments (receipts, issues, moves, cycle count corrections) across all transactions.

Use For:

• Audit compliance (SOX, ISO)
• Variance investigation
• User activity review
• Error pattern identification

Key Columns:

• Date and Time
• Transaction Type
• Item ID and Description
• Quantity Change
• Before/After Quantities
• Reason Code
• User
• Reference Number
• Approval Status

Filters: Date Range, Warehouse, Item, Transaction Type, User, Reason Code

Tips:

• Essential for internal and external audits
• Identify patterns of shrinkage or data entry errors
• Review user activity for training needs

Archived Inventory Report (Report 141)

Purpose: Historical view of inventory that has been removed from active stock through consumption, sale, disposal, or archiving.

Use For:

• Historical usage analysis
• Consumption trend review
• Discontinued item research
• Long-term pattern analysis

Key Columns:

• Item ID and Description
• Archive Date
• Final Quantity Issued
• Last Location
• Reason for Archive
• Total Historical Value

Filters: Archive Date Range, Warehouse, Category, Reason

Tips:

• Research consumption of discontinued items
• Support long-term demand forecasting
• Investigate disposal and write-off history

Cycle Count History Report (Report 213)

Purpose: Historical record of all cycle count sessions showing variances, adjustments, and accuracy trends over time.

Use For:

• Accuracy trend analysis
• Count program effectiveness
• Shrinkage pattern identification
• Location accuracy scoring

Key Columns:

• Count Date
• Item ID and Description
• Expected Quantity
• Counted Quantity
• Variance
• Location
• User/Counter
• Posted Status

Filters: Date Range, Warehouse, Location, User, Variance Threshold

Tips:

• Track accuracy improvement over time
• Identify high-variance locations for investigation
• Recognize high-performing counters

Issue History Report (Report 60)

Purpose: Complete history of all inventory issues (negative adjustments, sales, consumption) over time.

Use For:

• Historical demand analysis
• Customer usage patterns
• Consumption trend forecasting
• Issue volume analysis

Key Columns:

• Issue Date
• Item ID and Description
• Quantity Issued
• Destination (SO, WO, Manual)
• User
• Reason Code
• Unit Cost and Value

Filters: Date Range, Warehouse, Item, Destination Type, User

Tips:

• Analyze customer consumption trends
• Forecast future demand
• Support customer billing and usage reports

Receipt History Report (Report 99)

Purpose: Complete history of all inventory receipts (positive adjustments, purchases, returns) over time.

Use For:

• Receiving volume analysis
• Supplier performance tracking
• Purchase history review
• Receiving trend analysis

Key Columns:

• Receipt Date
• Item ID and Description
• Quantity Received
• Source (PO, Appointment, Manual)
• Supplier
• Unit Cost
• User

Filters: Date Range, Warehouse, Item, Source Type, Supplier, User

Tips:

• Track receiving volume trends
• Analyze supplier delivery patterns
• Verify purchase history for costing

Negative Adjustment History Report (Report 8)

Purpose: Detailed history of all negative inventory adjustments with reason codes and user attribution.

Use For:

• Shrinkage analysis
• Waste and damage tracking
• User activity investigation
• Process improvement

Key Columns:

• Adjustment Date
• Item ID and Description
• Quantity Reduced
• Reason Code (Damage, Loss, Obsolete, Error Correction, etc.)
• User
• Approval Status
• Value Impact

Filters: Date Range, Warehouse, Item, Reason Code, User

Tips:

• Identify shrinkage patterns and root causes
• Support process improvements and training
• Monitor high-value write-offs

Positive Adjustment History Report (Report 86)

Purpose: Detailed history of all positive inventory adjustments with reason codes and sources.

Use For:

• Unexpected receipt investigation
• Found stock analysis
• Count correction review
• Data entry error patterns

Key Columns:

• Adjustment Date
• Item ID and Description
• Quantity Added
• Reason Code (Found, Count Correction, Return, Error Correction, etc.)
• User
• Approval Status
• Value Impact

Filters: Date Range, Warehouse, Item, Reason Code, User

Tips:

• Investigate unexpected stock additions
• Identify count accuracy issues
• Monitor for data entry patterns

Analysis and Profitability Reports

Strategic reports analyzing margins, profitability, pricing trends, and cost changes to support business decisions.

Landed Cost Report (Report 282)

Purpose: Tracks the complete cost lifecycle of inventory from acquisition through sale, calculating true profit or loss by incorporating all costs including shipping, tariffs, taxes, and fees.

Use For:

• True cost analysis beyond purchase price
• Profit margin analysis per inventory lot
• Supplier cost comparison (including hidden costs)
• International purchasing cost verification
• Landed cost vs. standard cost variance analysis

Key Columns:

Understanding Landed Cost Calculation:

Purchase side costs (Adjusted Cost):

Adjusted Cost = (Unit Price × Units) + Sales Tax + Shipping + Tariffs + Other Charges - Discounts

Sales side costs:

Sales Cost = SO Discounts + SO Shipping + SO Other Charges

Final profit/loss:

Total Cost = Adjusted Cost + Sales Cost
Profit/Loss = Sales Price - Total Cost

PO Cost Components:

Example Calculation:

Purchase:

• 100 units @ $10.00 = $1,000.00
• Shipping: $50.00
• Tariff: $25.00
• Tax: $75.00
• Adjusted Cost: $1,150.00 ($11.50/unit)

Sale:

• Sold 100 units @ $15.00 = $1,500.00
• SO Shipping: $30.00
• SO Discount: $20.00
• Sales Cost: $50.00
• Total Cost: $1,200.00

Profit: $1,500.00 - $1,200.00 = $300.00 (20% margin)

Filters: Item ID, Description, Category, Received (PO#), Shipped (SO#), Date Range

Report Views:

• Active Inventory: Shows PO-side costs only (Shipped column blank) - what you’ve invested in current stock
• Archived Inventory: Shows complete lifecycle including sale price and profit/loss calculation

Tips:

• Compare Adjusted Cost vs. Base Cost to identify items where true acquisition cost exceeds standard cost
• Use for supplier analysis by filtering by vendor to compare total landed costs across suppliers
• Review Profit/Loss columns to identify items with unexpectedly thin or negative margins
• Click on Received or Shipped values to drill into the source PO or SO line items
• Run regularly for international purchases where shipping, duties, and tariffs significantly impact true cost

Inventory Profitability Report (Report 112)

Purpose: Compares item costs to selling prices, calculating gross margin percentages and potential profitability.

Use For:

• Margin analysis by item
• Pricing strategy decisions
• Product line profitability assessment
• Discount limit determination

Key Columns:

• Item ID and Description
• Current Cost
• Selling Price (from price lists or recent sales)
• Gross Margin ($)
• Gross Margin (%)
• Quantity on Hand
• Potential Gross Profit (margin × quantity)

Filters: Warehouse, Category, Supplier, Price List, Minimum Margin

Tips:

• Identify low-margin items for pricing adjustments
• Focus on high-volume, high-margin items for growth
• Support pricing negotiations with data

Cost Change Analysis Report (Report 119)

Purpose: Tracks changes in item costs over time, highlighting significant price increases or decreases.

Use For:

• Supplier price increase monitoring
• COGS trend analysis
• Pricing adjustment triggers
• Budgeting and forecasting

Key Columns:

• Item ID and Description
• Previous Cost
• Current Cost
• Change ($)
• Change (%)
• Last Price Change Date
• Supplier

Filters: Date Range, Warehouse, Category, Supplier, Minimum Change Threshold

Tips:

• Monitor for supplier price increases requiring selling price adjustments
• Identify cost reduction opportunities
• Support budgeting with cost trend data

ABC Analysis Report (Report 125)

Purpose: Classifies inventory using Pareto principle (80/20 rule) based on value, usage, or both to prioritize management focus.

Use For:

• Strategic inventory segmentation
• Cycle count frequency decisions
• Safety stock allocation
• Purchasing priority setting

Key Columns:

• Item ID and Description
• Annual Usage Quantity
• Annual Usage Value
• Current Inventory Value
• ABC Classification (A/B/C)
• Percentage of Total Value

Classifications:

• A Items: Top 20% of items by value (typically 80% of total value) - Tight controls, frequent counts, low stock-outs
• B Items: Middle 30% of items - Moderate controls, periodic review
• C Items: Bottom 50% of items - Loose controls, annual counts, higher stock-out tolerance

Filters: Classification Method (Value, Usage, Combined), Date Range, Warehouse

Tips:

• Focus tight controls on A items for biggest impact
• Allow C items higher stock-out risk to reduce carrying costs
• Review classifications quarterly as patterns change

Inventory Turnover Report (Report 131)

Purpose: Calculates annual turnover ratios (cost of goods sold ÷ average inventory) to measure inventory efficiency.

Use For:

• Performance benchmarking
• Inventory efficiency measurement
• Working capital analysis
• Category comparison

Key Columns:

• Category or Item
• Average Inventory Value (period)
• Cost of Goods Sold (period)
• Turnover Ratio (COGS/Avg Inventory)
• Days of Inventory (365/Turnover)

Filters: Date Range, Warehouse, Category, Grouping Level (Item/Category/Total)

Benchmarks:

• High Turnover (>10): Excellent efficiency, potential stock-out risk
• Moderate Turnover (4-10): Healthy balance
• Low Turnover (<4): Excess inventory, obsolescence risk, high carrying costs

Tips:

• Compare turnover across categories
• Set targets based on industry benchmarks
• Improve turnover through better forecasting and purchasing

Reorder Point Analysis Report (Report 143)

Purpose: Analyzes current min/max settings against actual usage to recommend optimal reorder points and quantities.

Use For:

• Min/Max optimization
• Safety stock calculations
• Lead time analysis
• Stockout prevention

Key Columns:

• Item ID and Description
• Current Min/Max
• Average Daily Usage
• Lead Time (days)
• Recommended Min (usage × lead time + safety stock)
• Recommended Max (min + economic order quantity)
• Current vs Recommended Variance

Filters: Warehouse, Category, Supplier, Variance Threshold

Tips:

• Update min/max settings quarterly based on recommendations
• Adjust for seasonal patterns
• Consider supplier lead time variability in safety stock

Stock Variance Report (Report 153)

Purpose: Identifies items with significant variances between expected and actual quantities, highlighting potential issues.

Use For:

• Shrinkage detection
• Data integrity verification
• Cycle count prioritization
• Process issue identification

Key Columns:

• Item ID and Description
• Expected Quantity
• Actual Quantity
• Variance
• Variance %
• Last Count Date
• Value Impact

Filters: Warehouse, Variance Threshold (%), Category, Last Count Age

Tips:

• Prioritize high-value variances for investigation
• Use for targeted cycle count planning
• Identify recurring variance patterns

Related Topics

• Cycle Counts - Physical inventory verification and count workflows
• Reports - How to find, run, and customize reports
• Receiving Stock - Inventory receipt workflows affecting stock levels
• Issuing Stock - Inventory issue workflows reducing stock
• Items - Item master data and attributes
• Warehouses and Locations - Warehouse and location setup
• Purchasing Reports - Reports for purchase orders and supplier analysis
• Shipping Reports - Reports for shipping orders and customer fulfillment