The Grouped Register Report provides a consolidated inventory movement and valuation view by grouping stock records based on products, brands or categories.

Unlike the Stock Register Report, which displays transaction-level movement entries, the Grouped Register Report presents summarized inventory quantities and valuation totals across grouped inventory structures.

The report is primarily used for inventory valuation analysis, grouped stock movement tracking and high-level inventory visibility.

The report can be accessed through:

Inventory → Reports → Grouped Register

---

 

Purpose of the Report

The report is used to analyse grouped inventory movement, monitor opening and closing stock balances and evaluate inventory valuation using value, cost or selling price representations.

It is commonly used by inventory teams, warehouse managers, finance teams and management personnel for inventory analysis and stock valuation review.

---

 

Report Interface

The report interface contains the following sections:

The ENTIRE ORGANIZATION selector functions similarly to other reports and allows users to generate grouped inventory reports across accessible organisations, companies or branches.

---

 

Grouping and Layout Options

The Group By selector allows users to group inventory data by:

• Product

• Brand

• Category

The Column Arrangement selector controls how grouped data is visually displayed and supports Separated and Mixed layouts.

The Base On selector determines the valuation basis used within the report and supports:

• Cost Price

• Selling Price

• Value

These options allow users to analyse inventory movement and stock balances using different costing and valuation structures.

---

 

Filtering Options

The Include selector supports:

• All Items

• Items With Changes

This allows users to either display all grouped inventory records or only records containing stock movement changes during the selected period.

The Show selector supports Show All, Products and Spares & Accessories.

Additional filtering is available through category filters, brand filters, search and date range selection.

---

 

Report Structure

The report displays grouped inventory movement and valuation summaries.

Depending on the selected configuration, the report displays grouped inventory information including product details, opening and closing balances, stock inflow and outflow quantities, and associated valuation figures. 

Opening and closing balances are derived dynamically from inventory movement transactions within the selected reporting period.

The report also supports grouped quantity totals across multiple measurement units such as Pcs, Nos, KG, gm, Sqm, CFT, roll and other inventory units depending on the displayed inventory records.

---

 

Drilldown Behaviour

The report supports item-level drilldown functionality.

Model names displayed within the report are clickable and open the detailed Stock Register view for the selected inventory item. Folder-style drilldown icons also open the same detailed inventory movement report.

The detailed drilldown view provides stock movement history, warehouse visibility, narration references, quantity tracking and valuation-related inventory information.

---

 

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.

---

 

Utility Reports and Integrated Navigation

The report includes utility buttons which provide access to related inventory reports.

The About Report section explains that opening and closing stock values are derived from stock movement activity and may not match profit and loss account balances. For financial closing balance reconciliation, users are directed to Closing Balances reports.

---

 

Export Functionality

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

The exported report reflects the selected grouping configuration, valuation basis, filters and reporting period.

---

 

Data Representation

The report supports grouped inventory movement analysis, stock valuation visibility, opening and closing stock analysis and inventory quantity tracking across multiple inventory measurement units.

Displayed information varies depending on the selected grouping method, valuation basis, filters and reporting period. Where no data exists, corresponding fields may remain empty or display zero values.

---

 

Summary

The Grouped Register Report provides a consolidated inventory movement and valuation overview within TUHUND.

By combining grouped inventory visibility, valuation analysis, configurable grouping structures, quantity tracking and integrated drilldown functionality, the report enables organisations to analyse stock movement trends, evaluate inventory balances and monitor inventory valuation across products, brands and categories.