Tuhund ERP Blog
Rida Nabeela Qazi
Rida Nabeela Qazi
19/05/2026 02:11 PM

E112: Stock Report

The Stock Report provides a live inventory availability, stock monitoring and inventory traceability workspace within TUHUND.

The report is designed to help organisations monitor current inventory availability, analyse stock distribution across stores and warehouses, track serial and batch-level inventory movement and manage operational stock visibility in real time. In addition to inventory visibility, the report also supports configurable stock warning thresholds, warehouse-level tracking, barcode operations and operational inventory actions.

The report can be accessed through:

Inventory → Stock → [Select Branch]


 

Purpose of the Report

The report is used to monitor available stock, analyse inventory distribution, track reserved and booked inventory and evaluate live inventory availability across operational stores, warehouses and inventory locations.

It is commonly used by inventory teams, warehouse managers, procurement teams, operations personnel and management staff for stock monitoring, inventory control, warehouse visibility and inventory traceability operations.


 

Report Interface

The report interface contains the following sections:

Section

Description

Category Selector

Filters inventory categories

Show Selector

Filters inventory visibility and stock condition

Store Selector

Filters stores, warehouses and inventory locations

Sort By Selector

Defines stock sorting configuration

A–Z / Z–A

Controls sorting order

Value Selector

Filters valuation visibility

Base On Selector

Defines stock calculation basis

Brand Selector

Filters inventory by brand

Images Selector

Controls product image loading

Conversion Selector

Controls currency conversion

Search Box

Searches inventory records

Report Grid

Displays live inventory availability

Utility Buttons

Opens related inventory utilities and reports

Export Button

Exports report data

The report supports live inventory visibility across multiple operational inventory structures including sales stores, warehouses, bonded warehouses, stock-in-transit locations, internal reserve locations and virtual inventory locations.

Specific store locations may also be selected individually for focused inventory analysis.


 

Inventory Visibility and Filtering Options

The Show selector supports multiple inventory visibility modes including:

  • Show All

  • All Products

  • All Spares & Accessories

  • Booked Stock

  • In Stock Items

  • Out Of Stock Items

  • Below Warning Levels

These options allow users to analyse inventory based on stock availability, inventory category and low-stock conditions.

The Base On selector supports:

  • Available Stock

  • Total Stock

  • Booked Stock

Available Stock represents currently usable inventory after reserved or booked quantities are deducted from total inventory.

Booked Stock represents inventory reserved for operational or sales activity.

Total Stock represents overall inventory quantity regardless of reservation status.

The Value selector supports valuation-based filtering including zero, low, moderate and high-value inventory visibility.

The report also supports:

  • brand filtering,

  • category filtering,

  • currency conversion,

  • product image visibility,

  • and inventory search functionality.

Where product images exist within the system, the Images selector can dynamically load associated product visuals within the report.


 

Sorting and Stock Prioritisation

The Sort By selector supports:

  • Warning Level

  • Product Name

  • Product Model

  • Available Quantity

  • Value

Warning Level sorting prioritises products based on configured stock warning severity and low-stock conditions.

This allows organisations to quickly identify inventory items requiring replenishment or operational attention.


 

Report Structure

The report is displayed as a structured live inventory availability grid where each row represents a product, inventory item, serial entry or batch-level inventory record.

Depending on the selected configuration, the report may display:

  • Product Information

  • Brand

  • Model

  • Product Attributes

  • Available Quantity

  • Reserved / Booked Quantity

  • Inventory Value

  • Cost Information

  • Warning Indicators

  • Store Availability

  • Warehouse Status

  • Serial Information

  • Batch Information

  • Expiry or Life-Period Information

The report supports page-level and store-level totals for quantities, values and costing information.

Displayed inventory values dynamically change depending on whether calculations are based on available stock, total stock or booked stock.

The report provides live operational inventory visibility rather than historical snapshot reporting.


 

Drilldown Behaviour

The report supports detailed item-level drilldown functionality.

Clicking a product identifier opens the Item-Level Inventory Traceability View for the selected inventory item.

The traceability view displays:

  • serial-level inventory records,

  • batch information,

  • input and output transaction references,

  • quantity balances,

  • valuation details,

  • warehouse location visibility,

  • availability status,

  • denomination information,

  • and inventory movement traceability.

Input and output transaction references such as purchase records, GRNs, invoices or operational records are displayed within the traceability view. Clicking these references copies the corresponding transaction identifier to the clipboard.

The traceability report also supports:

  • serial-controlled inventory,

  • batch-controlled inventory,

  • barcode inventory,

  • denomination tracking,

  • warehouse bin and rack tracking,

  • expiry tracking,

  • and multi-location inventory visibility.

Item-Level Inventory Traceability View

The Item-Level Inventory Traceability View provides detailed operational visibility for the selected inventory item.

Each row within the traceability grid represents a serial entry, batch entry or inventory record instance and may display:

  • serial number,

  • batch information,

  • warehouse/store location,

  • rack or row location,

  • quantity balances,

  • input and output references,

  • expiry or life-period information,

  • availability status,

  • and inventory valuation information.

The view supports live operational inventory tracking and warehouse-level inventory visibility.


 

Operational Inventory Actions

The Item-Level Inventory Traceability View includes operational inventory management actions.

Action

Description

Edit

Modifies serial or inventory identification information

Move

Changes inventory location or warehouse placement

Change

Updates operational inventory attributes

View

Opens inventory movement trail and transaction traceability

Print

Prints barcode labels using selected templates

The Move functionality supports location reassignment at item, batch, store or inventory-group level.

Location structures may include:

  • warehouse,

  • rack,

  • row,

  • shelf,

  • and bin-based positioning.

Store Change functionality supports inventory transfer between compatible warehouse or store structures where operationally permitted.


 

Inventory Movement Trail

The View action opens the Inventory Movement Trail for the selected inventory item.

The movement trail displays:

  • input transaction history,

  • output transaction history,

  • operational source references,

  • warehouse visibility,

  • quantity balances,

  • inventory value,

  • costing information,

  • and cumulative inventory movement details.

This functionality provides full operational inventory traceability across inventory lifecycle activities.


 

Additional Inventory Information

The More utility within the traceability view opens extended inventory information for the selected item.

The extended inventory view may include:

  • detailed product information,

  • category details,

  • brand and model information,

  • unit and dimension details,

  • inventory status,

  • stock warning thresholds,

  • historical inventory consumption,

  • and forecast visibility.

The History & Forecast section supports Daily, Weekly and Monthly forecasting modes for inventory consumption visibility and stock trend analysis.


 

Stock Warning Configuration

The report includes configurable inventory stock warning functionality through the Customize Warnings utility.

The stock warning system supports:

  • System Recommended Values

  • User Specified Values

  • Effective Values

Warning thresholds are grouped into escalation levels including:

  • Remind

  • Alert

  • Panic

  • High

These warning levels generally represent increasing stock urgency or replenishment priority levels.

System-recommended warning thresholds may be overridden using user-defined operational inventory thresholds.

Effective values represent the operationally active warning configuration currently applied to the inventory item.

The warning configuration system enables organisations to implement configurable low-stock monitoring and inventory replenishment visibility.


 

Utility Reports and Integrated Navigation

The report includes multiple utility buttons which provide access to related inventory utilities and operational reports.

Utility

Description

Add Product

Adds inventory items already configured in the master system

Customize Warnings

Opens stock warning configuration

Stock Breakup

Opens the Stock Breakup Report [E113]

Variants

Opens the Stock Variants Report [E114]

Closing Stock

Opens the Closing Stock Report

Export

Exports report data


 

Inventory Valuation and Costing Information

Inventory reports within the system may support multiple valuation and costing representations depending on the report type and configuration.

Value represents the exact inventory transaction value associated with the item movement.

Cost represents the inventory value along with additional operational expenses such as delivery charges, repair expenses, commissions or related operational costs.

Selling price represents the potential selling value calculated using configured costing structures and pricing sheets.


 

Export Functionality

The Export button exports the currently displayed inventory availability data in Microsoft Excel (.xlsx) format.

The exported report reflects the selected inventory filters, warehouse visibility, valuation configuration, stock basis and operational inventory structure.


 

Data Representation

The report supports:

  • live inventory visibility,

  • stock availability analysis,

  • warehouse-level inventory tracking,

  • serial and batch traceability,

  • barcode-supported inventory operations,

  • configurable stock monitoring,

  • inventory valuation visibility,

  • and operational inventory movement control.

Displayed information varies depending on the selected filters, inventory structure, warehouse visibility and operational stock configuration. Where no data exists, corresponding fields may remain empty or display zero values.


 

Summary

The Available Stock Report provides a consolidated live inventory visibility and operational stock management workspace within TUHUND.

By combining live stock availability visibility, configurable stock intelligence, serial and batch traceability, warehouse-level inventory tracking, operational inventory actions and inventory forecasting functionality, the report enables organisations to monitor inventory availability, control stock movement, analyse warehouse distribution and manage operational inventory activity across stores, warehouses and inventory locations.

 

Labels :

stock variants

,

variant inventory

,

parent-child products

,

size and color variants

,

apparel inventory

,

garment stock management

,

booked stock tracking

,

available stock visibility

,

inventory allocation

,

variant-wise stock analysis


Tuhund Logo
TUHUND®
Home About us Modules CRM HR SALES BI SERVICES MANAGEMENT INVENTORY MANAGEMENT ACCOUNTING AND FINANCE PROCUREMENT PROJECT MANAGEMENT ERP ADMINISTRATION DATA REPOSITORY API & SUB PORTALS Careers Community Blog
M Home Schedule Demo About us Community Blog
CRM HR SALES BI SERVICES MANAGEMENT INVENTORY MANAGEMENT ACCOUNTING AND FINANCE PROCUREMENT PROJECT MANAGEMENT ERP ADMINISTRATION DATA REPOSITORY API & SUB PORTALS Careers
API Documents
Request Demo