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]
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.
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.
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.
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.
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.
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.
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.
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 |
|
|
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.
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.
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.
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.
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 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.
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.
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.
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.