Inventory Stock Register Report- Home

Stock Register Report [Home](ID: INV101)

1. Introduction

This report provides an overview of inventory stock movements in the TUHUND ERP system . It explains how to navigate the stock register, use filters for efficient search, and interpret stock data.

2. Accessing the Stock Register Page

To access the Stock Register Page in the TUHUND ERP system:

1. Log in to the TUHUND ERP portal.
2. Navigate to Inventory > Reports > Stock Register.
3. The stock register page will display all recorded inventory transactions, including purchases, sales, production, and stock movements.
4. Use the filters and dropdowns to refine your search for specific records.

3. Understanding Filters & Dropdowns

The Stock Register includes multiple filters to narrow down inventory records based on specific criteria.

3.1 Filters Available

Filter Name	Description	Purpose
Show	Selects which stock movements to display (All, Stock In, Stock Out)	Helps filter stock movements
Sort By	Sorts transactions by Date, Brand, Product, etc.	Organizes data for easy analysis
Order (Ascending/Descending)	Defines sorting order (Newest First, Oldest First)	Controls how data is displayed
Results Per Page	Defines how many records appear per page (50, 100, 500, etc.)	Adjusts data load for readability
Search Bar	Allows searching by product name, serial number, or transaction ID	Quickly finds specific stock records
ENTIRE ORGANISATION	Use this filter to view stock register of specific organisation or branch	To analyze specific branch or organisation stock data
Date Range (From – To)	Filters records based on transaction dates	Analyzes time-based inventory trends

3.2 Dropdown Elements & Their Functions

Show (Transaction Type Filter)

This dropdown allows users to filter inventory movements based on type:

• Show All → Displays all stock transactions.
• Stock In → Filters purchases, production entries, and stock adjustments increasing inventory.
• Stock Out → Displays sales, consumption, and production-related stock usage.

Sort By Dropdown

Users can sort inventory transactions based on:

• Transaction Date → Organizes records chronologically.
• Item Index (Serial #) → Groups items by serial number.
• Brand Name → Filters records by product brand.
• Product Name → Organizes transactions by product description.

Order Dropdown

This controls the sorting order of records:

• Ascending (A-Z or Oldest First) → Displays transactions from the earliest date.
• Descending (Z-A or Newest First) → Displays recent transactions first.

Results Per Page Dropdown

Users can set how many records appear on a page:

• 50, 100, 250, 500, 1000 (for large datasets).

Recommendation: If handling large data, selecting 1000+ records per page may improve analysis but may slow down page loading.

4. Understanding the Results Table & Data Comparison

After applying filters, the Stock Register displays inventory data in a structured table.

4.1 Columns in the Results Table

Column Name	Description	Comparison Basis
Date	Date of stock transaction	Compares stock movement trends
Item Index (Serial #)	Unique stock reference number	Tracks individual items
Brand	Product brand name	Analyzes stock based on brands
Model	Model or SKU of the product	Groups products by type
Product Name	Description of the product	Identifies stock items
Attributes	Product details (size, color, etc.)	Compares variations of items
Narration	Additional transaction notes (supplier, invoice, job order, etc.)	Tracks order history
Type	Type of stock movement (Sale, Purchase, Production, Return, etc.)	Categorizes inventory transactions
Stock In	Quantity added to inventory	Tracks incoming stock
Stock Out	Quantity removed from inventory	Tracks outgoing stock

4.2 Data Comparison & Inventory Insights

• High "Stock Out" but low "Stock In" may indicate inventory depletion.
• Frequent "Sales Returns" suggest product quality issues or customer complaints.
• Unusual "Production" entries may indicate stock adjustments or internal manufacturing.

Example Analysis:

Date	Product Name	Type	Stock In	Stock Out
22/02/2024	JBI T-SHIRT	Sale	-	10
29/02/2024	Fabric Cutting Machine	Purchase	3	-
07/03/2024	1000 Ltr	Moved to Production	-	1

• Stock added via "Purchase" must align with sales and production needs.
• Items "Moved to Production" should be cross-checked with finished goods inventory.

 

5. Best Practices for Effective Use

• Regularly update filters to analyze stock movements accurately.
• Sort by "Stock Out" to track high-selling items and prevent shortages.
• Check "Sales Returns" to identify defective products and supplier issues.
• Use date filters to detect seasonal stock fluctuations.
• Ensure that "Stock In" matches purchase invoices to prevent discrepancies.

6. Common Issues & Solutions

Issue	Solution
Sudden drop in stock levels	Check for large sales, stock losses, or production use.
Stock not updated after purchase	Ensure proper GRN (Goods Receipt Note) entry.
Sales return increasing	Investigate product quality or customer complaints.
Production records not matching stock movement	Verify raw material consumption logs.

Best practices: By implementing these best practices, organizations can enhance their inventory management efficiency and financial control.

1. Review stock register reports regularly for anomalies.
2. Cross-check purchase records with stock additions for accuracy.
3. Monitor stock consumption in production to optimize raw material usage.
4. Investigate high return rates to improve product quality.