Stock Card Report & Inventory Analysis
Overview
The Stock Card Report and Inventory Analysis provide detailed product-level transaction history and comprehensive analytical insights. These powerful reporting tools enable you to track individual product movements, analyze performance metrics, and make data-driven inventory decisions through both detailed transaction records and visual analytical dashboards.
Navigation
To access these reports:
Stock Card Report:
1. Click Inventory in the left sidebar menu
2. Click Reports → Stock Card
3. Or use direct URL: https://main.smartb.co/action?name=report_stock_card
Stock Balance Analysis:
1. Click Inventory in the left sidebar menu
2. Click Reports → Stock Balance Analysis
3. Or use direct URL: https://main.smartb.co/action?name=stock_balance_pivot
Stock Card Report Features
Report Parameters
Date Range Selection: - From - Start date for transaction history (required) - To - End date for transaction history (required) - Flexible date selection for any period - Support for historical analysis
Product and Location Filters: - Product Category - Filter by specific categories - Product - Select individual products for analysis - Location - Filter by warehouse locations - UoM - Filter by unit of measure - Lot/Serial Number - Track specific lots or serials - Invoice - Filter by invoice references
Display Options: - Show Pending - Include draft and pending transactions - Show Secondary Qty - Display alternative unit quantities - Hide Zero Lines - Exclude transactions with zero quantities - Hide Cost - Exclude cost information from display
Report Content
The Stock Card Report provides chronological transaction history including:
| Column | Description |
|---|---|
| Date | Transaction date and time |
| Document | Source document reference |
| Transaction Type | Receipt, Issue, Transfer, or Adjustment |
| Quantity In | Inbound quantity movements |
| Quantity Out | Outbound quantity movements |
| Balance | Running inventory balance |
| Cost Price | Unit cost at transaction time |
| Total Value | Extended transaction value |
| Location | Storage location |
| Lot/Serial | Traceability information |
| Reference | External reference numbers |
Stock Balance Analysis Features
Interactive Dashboard
Dynamic Filtering: - Search - Quick search across all data - Load Config - Load saved report configurations - Save Config - Save current settings for reuse - Add Field - Include additional data fields - Refresh - Update data in real-time - Export XLS - Export analysis to Excel
Analytical Tools: - Print - Generate formatted reports - Pivot Tables - Dynamic data analysis - Sum Functions - Aggregate calculations - Field Grouping - Organize data by categories - Visual Charts - Graphical representations
Available Analysis Fields
Product Information: - Product Code and Name - Product Category - Master Product Code and Name - UoM (Unit of Measure)
Quantity and Cost Data: - Physical Qty (actual on-hand inventory) - Virtual Qty (available less reserved) - Min Qty and Max Qty (threshold levels) - Cost Amount (total inventory value)
Location Details: - Location Code and Name - Lot/Serial Number tracking - Container assignments
Common Use Cases
Product Transaction History
Stock Card Analysis: 1. Select specific product for investigation 2. Set date range for analysis period 3. Include all locations for complete view 4. Enable lot tracking if applicable 5. Generate detailed transaction history
Investigation Process:
- Review chronological transaction sequence
- Identify unusual patterns or discrepancies
- Validate transaction accuracy and timing
- Document findings and corrective actions
Inventory Performance Analysis
Stock Balance Dashboard: 1. Configure pivot table for analysis 2. Group by product category or location 3. Add quantity and value metrics 4. Apply date filters for period analysis 5. Generate performance insights
Performance Metrics: - Inventory turnover rates - Stock level optimization - Location performance comparison - Category profitability analysis
ABC Analysis and Classification
Product Ranking: 1. Use pivot table to group products 2. Sort by cost amount or volume 3. Calculate percentage contributions 4. Classify products into ABC categories 5. Develop differentiated management strategies
Analysis Categories:
- A items: High value, tight control
- B items: Moderate value, moderate control
- C items: Low value, simple control
- Strategic importance classification
Slow-Moving Stock Identification
Aging Analysis: 1. Filter by date ranges for aging periods 2. Group products by movement frequency 3. Identify products with no recent activity 4. Calculate carrying costs and obsolescence risk 5. Develop disposition strategies
Action Planning: - Markdown and liquidation strategies - Product discontinuation decisions - Supplier performance evaluation - Procurement optimization
Advanced Analysis Features
Pivot Table Capabilities
Data Grouping: - Multi-level hierarchical grouping - Dynamic field selection - Custom aggregation functions - Interactive filtering and drilling
Calculation Options: - Sum, average, count functions - Percentage calculations - Running totals and balances - Custom formula creation
Visual Analytics
Chart Generation: - Bar charts for comparison analysis - Line charts for trend analysis - Pie charts for composition analysis - Scatter plots for correlation analysis
Dashboard Creation: - Multi-chart dashboards - Interactive filtering - Real-time data updates - Mobile-responsive design
Export and Integration
Excel Integration: - Formatted Excel exports - Pivot table preservation - Chart and graph exports - Template-based reporting
Data Integration: - API access for external systems - Automated report delivery - Business intelligence feeds - Custom dashboard creation
Best Practices
Report Configuration
- Specific Criteria - Use precise filters to focus analysis
- Appropriate Periods - Select relevant time frames
- Complete Data - Ensure all required transactions are included
- Regular Updates - Refresh data regularly for accuracy
Data Analysis
- Pattern Recognition - Look for trends and anomalies
- Comparative Analysis - Compare across periods and categories
- Root Cause Analysis - Investigate underlying causes
- Action Orientation - Focus on actionable insights
Performance Optimization
- Filter Usage - Apply filters to improve performance
- Scheduled Processing - Run large reports during off-peak hours
- Data Archiving - Archive old data to improve speed
- Index Optimization - Ensure proper database indexing
Troubleshooting
Report Generation Issues
Missing Data: - Verify date range includes relevant transactions - Check product and location filters - Ensure user has proper access permissions - Validate transaction posting status
Performance Problems: - Narrow date ranges for large datasets - Apply specific product or location filters - Schedule reports during low-usage periods - Consider data archiving strategies
Analysis Accuracy
Data Validation: - Cross-reference with other reports - Verify calculation methods - Check for data entry errors - Validate system configuration
Reconciliation: - Compare with physical counts - Verify against financial records - Check transaction completeness - Investigate variance causes
Related Functions
- Stock Balance - Current inventory positions
- Stock Movements - Transaction details
- Stock Summary Report - Comprehensive reporting
- Inventory Dashboard - Real-time overview
- Stock Count - Physical verification
Tips
- Regular Analysis - Establish routine analysis schedules
- Template Creation - Save common configurations for reuse
- Trend Monitoring - Track key metrics over time
- Exception Focus - Concentrate on outliers and anomalies
- Action Plans - Convert analysis into operational improvements