Closing Stock Report (ID : INV107)
1. Introduction
This report provides a detailed analysis of the closing stock within the TUHUND ERP system for Cumberland Trading. It explains how to access the closing stock report, use available filters and dropdowns, and interpret the results for inventory assessment and financial tracking.
2. Accessing the Closing Stock Report Page
To access the Closing Stock Report Page in the TUHUND ERP system:
- Log in to the TUHUND ERP portal.
- Navigate to Inventory > Reports > Closing Stock.
- The closing stock report page will display product-wise stock details, including current quantities, valuation, and financial impact.
- Use the filters and dropdown menus to refine and analyze specific stock records.
3. Understanding Filters & Dropdowns
The Closing Stock Report includes multiple filters to refine records based on specific criteria.
3.1 Filters Available
|
Filter Name |
Description |
Purpose |
|---|---|---|
|
Entire Organization |
Use this filter to view stock register of specific organisation or branch |
To analyze specific branch or organisation stock data |
|
Show |
Filters records based on stock status (All, In Stock, Low Stock, Out of Stock) |
Helps segment stock data |
|
Sort By |
Sorts transactions by Quantity, Value, Product Name, Brand, Model |
Organizes data for better analysis |
|
Order (Ascending/Descending) |
Defines sorting order (A-Z, Z-A) |
Controls data presentation |
|
Search Bar |
Allows searching by product name, ID, or category |
Quickly finds specific stock records |
|
Date Range |
Filters records based on transaction dates |
Analyzes time-based stock changes |
|
Vendor |
Allow us to view the closing stock according to different vendors |
To filter closing stock report based on vendor |
|
All Categories |
Helps us choose specific category of product or all product or any brand specific product. |
Filter out products based on brand or their cateogry |
3.2 Dropdown Elements & Their Functions
Sort By Dropdown
Users can sort closing stock records based on:
- Quantity – Arranges records by the number of units in stock.
- Value – Sorts records by total stock valuation.
- Product Name – Organizes transactions alphabetically by product.
- Brand – Groups records by product brand.
- Model – Sorts records based on product model.
Order Dropdown
This controls the sorting order of records:
- Ascending (A-Z or Lowest First) – Displays transactions in increasing order.
- Descending (Z-A or Highest First) – Displays transactions in decreasing order.
Recommendation: If handling large data, sorting by Value helps identify high-impact stock items.
4. Understanding the Results Table & Data Comparison
After applying filters, the Closing Stock Report displays inventory data in a structured table.
4.1 Columns in the Results Table
|
Column Name |
Description |
Comparison Basis |
|---|---|---|
|
Product ID |
Unique identifier for the product |
Tracks individual products |
|
Product Name |
Description of the product |
Identifies stock items |
|
Quantity Available |
Number of units currently in stock |
Measures stock availability |
|
Quantity Reserved |
Stock allocated for existing orders |
Prevents over-commitment |
|
Quantity Free |
Available stock excluding reserved items |
Identifies sellable inventory |
|
Stock Value |
Total value of available stock |
Evaluates financial impact |
|
Stock Age (Days) |
Number of days stock has been held |
Assesses turnover efficiency |
5. Common Issues & Solutions
|
Issue |
Solution |
|---|---|
|
Frequent stock shortages |
Improve demand forecasting and restocking cycles. |
|
Overstocking of slow-moving products |
Optimize stock levels and introduce promotions. |
|
High holding costs |
Reduce inventory of low-turnover items. |
|
Inaccurate stock levels |
Conduct regular stock audits and system updates. |
