Issue reports track inventory consumption, stock allocation, usage patterns, and material movement out of your warehouses. These reports support audit compliance, usage analysis, allocation tracking, and inventory control for items leaving your system through customer shipments, work orders, adjustments, and transfers.
Access: Reports → Type: Issue Reports (Type 15)
Understanding Issue Reporting
Issue reports provide visibility into how inventory leaves your system, why it left, and where it went. Unlike receiving reports that track incoming inventory, issue reports focus on consumption, shipments, and stock reductions.
Audit Trail Reports answer “What inventory was issued, when, and by whom?” with complete transaction histories including user activity, timestamps, reason codes, and serial number tracking for compliance and accountability.
Hot Movers Reports answer “Which items are being consumed most frequently?” by analyzing usage velocity, issue frequency, and consumption patterns to optimize purchasing, identify demand trends, and improve stock availability.
Allocation Reports answer “What stock is committed to orders?” showing reserved inventory for shipping orders, work orders, and customer commitments to prevent over-selling and manage availability.
Negative Adjustment Reports answer “Why did inventory decrease?” by categorizing write-offs, damaged goods, samples, shrinkage, and other stock reductions with reason code analysis for loss prevention and inventory accuracy.
Report Features
All issue reports include:
- Multi-warehouse support: View individual warehouses or consolidated consumption across locations
- Real-time data: Reports reflect current system state and recent transactions
- Date range filtering: Analyze specific time periods for trending and variance analysis
- Reason code tracking: Filter by adjustment codes (damaged, sample, customer shipment, etc.)
- User accountability: Track which users performed issues and when
- Serial number detail: Drill down to individual serialized items for asset tracking
- Export capabilities: Excel, CSV, PDF for external analysis and compliance documentation
- Customization: Modify columns, grouping, sorting, and totals (Admin Option 165 required)
Common Filters
| Filter | Purpose | Available In |
|---|
| Date Range | Limit to specific issue period | Most reports |
| Warehouse | Single warehouse or all locations | Most reports |
| Reason Code | Filter by negative adjustment type | History and audit reports |
| User | Show issues by specific user | Audit trail reports |
| Item | Focus on specific part numbers | History and velocity reports |
| Customer | Issues to specific customer | Allocation and shipment reports |
| Job | Filter by job assignment | Work order issue reports |
| Serial Number | Track specific serialized assets | Audit trail reports |
| Category | Filter by product category | Hot movers and analysis reports |
Issue History and Audit Reports
These reports provide complete transaction histories for compliance, audit trails, and accountability tracking of all inventory consumption.
Audit Trail Report
Purpose: Comprehensive transaction log showing all issue activity with user accountability, timestamps, and complete transaction details.
Use For:
- Compliance audits and regulatory reporting
- User activity tracking and accountability
- Transaction verification and dispute resolution
- Investigating inventory discrepancies
- Security reviews and access audits
- Historical reconstruction of inventory movements
Key Columns:
- Transaction ID and Date/Time (UTC)
- User Name and User ID
- Item ID and Description
- Quantity Issued
- Location (from)
- Reason Code (negative adjustment type)
- Customer or Job assignment
- Serial Number (for tracked items)
- Warehouse
- Reference Number
- Notes and Comments
Variations:
- Date Range: Filter to specific audit periods (month-end, quarter-end, fiscal year)
- User Focus: Track individual user activity for performance or compliance reviews
- Item Focus: Complete issue history for specific part numbers
- Serial Number: Track complete life cycle of serialized assets
Filters: Date Range (required), Warehouse, User, Item, Serial Number, Reason Code, Customer, Job
Tips:
- Use narrow date ranges for faster performance on high-volume systems
- Export to Excel for external audit documentation
- Combine with receiving audit trail for complete inventory movement tracking
- Sort by user and date for performance reviews and shift analysis
- Filter by reason code to analyze write-offs, damaged goods, or sample distribution
Compliance Notes:
- All timestamps stored in UTC for global accuracy
- Transactions cannot be deleted, only reversed with audit trail
- User accountability tracked at transaction level
- Serial number tracking provides asset-level traceability
- Reference numbers link to source documents (SO, WO, etc.)
Issue History Report
Purpose: Summary view of issued inventory organized by item, date, or customer for usage analysis and consumption tracking.
Use For:
- Historical usage analysis and trend identification
- Customer consumption patterns and sales analysis
- Inventory planning and reorder point calculation
- Cost of goods sold (COGS) verification
- Usage variance investigation
- Seasonal demand pattern recognition
Key Columns:
- Item ID and Description
- Issue Date
- Quantity Issued
- Unit Cost (average or FIFO)
- Extended Cost
- Customer Name
- Job Number
- Warehouse
- Reason Code
- Location
Grouping Options:
- By Item: See total consumption per part number over time
- By Date: Daily, weekly, or monthly issue summaries
- By Customer: Customer-specific usage for billing or analysis
- By Job: Job costing and project material tracking
- By Warehouse: Location-specific consumption patterns
Filters: Date Range (required), Item, Warehouse, Customer, Job, Category, Reason Code
Tips:
- Group by item and sum quantities to calculate average monthly usage
- Compare periods (last month vs. this month) to identify trends
- Filter by customer to analyze account-specific consumption for contract pricing
- Use extended cost totals for financial reporting and COGS analysis
- Export grouped data to pivot tables for deeper analysis
Analysis Patterns:
- Reorder Points: Calculate average daily/weekly usage to set min/max levels
- Customer Trends: Identify growing/declining accounts by comparing periods
- Seasonal Planning: Year-over-year comparison to forecast seasonal demand
- Cost Trends: Track cost changes over time when prices fluctuate
- Variance Analysis: Compare budgeted vs. actual usage for job costing
Hot Movers and Velocity Reports
These reports identify fast-moving inventory, usage patterns, and demand trends to optimize purchasing and stock availability.
Hot Movers Report
Purpose: Ranks items by issue frequency and volume to identify your fastest-moving stock and highest-demand products.
Use For:
- Identifying top-selling or most-consumed items
- Optimizing warehouse layouts (place fast movers near shipping)
- Setting cycle count priorities (count hot movers more frequently)
- Negotiating volume pricing with suppliers for high-volume items
- Planning safety stock levels for critical fast-moving parts
- Marketing analysis for promotional planning
Key Columns:
- Item ID and Description
- Total Quantity Issued
- Number of Transactions
- Average Issue Quantity per Transaction
- Last Issue Date
- Category and Supplier
- Current On-Hand Quantity
- Days Since Last Issue
- Velocity Ranking
Ranking Methods:
- By Quantity: Total units issued (absolute volume)
- By Transaction Count: Issue frequency (how often issued)
- By Value: Total extended cost of issues (revenue impact)
- By Velocity: Turnover rate (issues per day/week)
Filters: Date Range (required), Warehouse, Category, Supplier, Top N (e.g., Top 25, Top 100)
Tips:
- Use 90-day rolling windows to capture current trends without seasonal distortion
- Combine transaction count with total quantity to find consistent high-volume items vs. one-time bulk issues
- Cross-reference with on-hand quantities to ensure adequate stock of hot movers
- Use days-since-last-issue to identify items transitioning from hot to slow movers
- Filter by category to find hot movers within product lines
Operational Applications:
- Warehouse Layout: Move hot movers to easily accessible pick locations near packing stations
- Cycle Counting: Count high-velocity items more frequently (weekly vs. quarterly)
- Safety Stock: Maintain higher minimums for items with high transaction frequency
- Supplier Negotiations: Leverage high volume for better pricing or consignment terms
- Inventory Investment: Focus working capital on items with proven demand
Warning Signs:
- Hot movers with low on-hand: Risk of stockouts
- Hot movers with zero on-hand: Active stockout requiring immediate action
- Declining velocity: May indicate market changes or product obsolescence
- Single customer driving velocity: Risk if customer leaves
Negative Adjustments Report
Purpose: Analyzes all inventory reductions not tied to customer shipments or work orders, categorized by reason code for loss prevention and accuracy analysis.
Use For:
- Tracking damaged goods, write-offs, and shrinkage
- Monitoring sample distribution and promotional giveaways
- Identifying patterns in inventory loss or waste
- Variance analysis and adjustment trending
- Physical inventory discrepancy tracking
- Compliance reporting for tax and audit purposes
Key Columns:
- Item ID and Description
- Adjustment Date
- Quantity Adjusted
- Reason Code and Description
- User Who Made Adjustment
- Warehouse and Location
- Unit Cost and Extended Cost
- Reference Number
- Notes/Comments
Common Reason Codes:
- Damaged Goods: Defective or damaged inventory written off
- Sample: Demo units, samples given to prospects
- Shrinkage: Unexplained loss or theft
- Obsolete: Discontinued items removed from active stock
- Physical Inventory: Cycle count or physical count adjustments
- Expired: Dated materials past expiration
- Return to Vendor: Items returned to supplier (RMA)
- Custom Codes: Organization-specific adjustment reasons
Grouping Options:
- By Reason Code: Summarize total adjustments by type
- By Item: Identify items with frequent adjustments
- By User: Track adjustment activity for accountability
- By Date: Trend analysis over time
- By Warehouse: Location-specific loss patterns
Filters: Date Range (required), Reason Code, Item, Warehouse, User, Category
Tips:
- Review monthly to identify unusual adjustment patterns requiring investigation
- Group by reason code to quantify shrinkage, damage, and waste costs
- Filter by user if adjustments require supervisor approval to verify compliance
- Track damaged goods by supplier to address quality issues
- Compare adjustment costs across warehouses to identify control gaps
Analysis Patterns:
- Loss Prevention: High shrinkage in specific locations may indicate theft or control issues
- Quality Issues: Frequent damaged goods adjustments for specific items suggest supplier or handling problems
- Process Improvement: High physical inventory adjustments indicate counting accuracy issues
- Cost Recovery: Track return-to-vendor adjustments for credit verification
- Compliance: Document sample distribution for tax reporting
Red Flags:
- Increasing shrinkage over time
- Large adjustments without notes/documentation
- Frequent adjustments by single user (possible fraud indicator)
- Damaged goods clustering around specific items or suppliers
- Adjustments concentrated in specific locations
Allocation and Commitment Reports
These reports show inventory reserved for orders and commitments to prevent over-selling and manage stock availability.
Allocation Report
Purpose: Shows inventory committed to specific shipping orders, work orders, or customer requirements but not yet issued.
Use For:
- Verifying available-to-promise quantities for new orders
- Managing customer expectations on ship dates
- Identifying slow-moving allocated stock for order follow-up
- Preventing double allocation and overselling
- Planning warehouse picking schedules
- Investigating discrepancies between on-hand and available quantities
Key Columns:
- Item ID and Description
- Allocated Quantity
- Order Number and Type (SO, WO)
- Customer Name
- Order Date and Required Date
- Days Allocated (age)
- Warehouse and Location
- Order Status
- On-Hand vs. Available
Use Cases:
- Available-to-Promise: Subtract allocated from on-hand to determine what’s truly available for new orders
- Aged Allocations: Find orders with long-standing allocations that may need follow-up
- Customer Service: Answer “when will my order ship?” questions
- Warehouse Operations: Prioritize picking for aged allocations or rush orders
Filters: Warehouse, Item, Customer, Order Type, Date Range, Days Allocated (age threshold)
Tips:
- Sort by days allocated to find stale orders requiring customer contact
- Filter by item when investigating “why is available quantity so low?”
- Cross-reference with shipping schedule to plan warehouse workload
- Use customer filter to prepare for account review meetings
- Look for allocations exceeding on-hand (backorder situations)
Common Issues:
- Ghost Allocations: Orders allocated but not progressing to shipment (may need cancellation)
- Over Allocation: Allocated quantity exceeds on-hand (indicates backorder or error)
- Mismatched Locations: Allocated to wrong warehouse or unavailable location
- Aged Allocations: Orders sitting for extended periods without shipment
Inventory Operations
- Issue Stock - How to issue inventory (shipping orders, work orders, direct adjustments)
- Cycle Counting - Physical inventory verification and variance analysis
Order Management
Other Report Categories
Administration