The Product Sales Reports provide a consolidated product-level inventory movement and sales analysis view across products, brands and branches.
The report is designed to help organisations analyse inventory inflow, outflow and projected movement quantities for products and accessories while supporting comparative inventory performance analysis across brands and operational units.
The report can be accessed through:
Inventory → Reports → Products
Purpose of the Report
The report is used to analyse product movement trends, monitor inventory inflow and outflow quantities and evaluate projected inventory movement across products and brands.
It is commonly used by inventory teams, warehouse managers, operations teams and management personnel for inventory movement monitoring and product-level stock analysis.
Report Interface
The report interface contains the following sections:
|
Section |
Description |
|
Entity Selection |
Filters report by organisation, company or branch |
|
Show Selector |
Filters products and accessories |
|
Branch View Selector |
Controls branch grouping |
|
Brand Selector |
Filters report by brand |
|
Sort By Selector |
Defines sorting configuration |
|
A–Z / Z–A |
Controls sorting order |
|
Period Selector |
Defines reporting period |
|
Report Grid |
Displays product movement data |
|
Utility Buttons |
Opens related inventory reports |
|
Export Button |
Exports report data |
The ENTIRE ORGANIZATION selector functions similarly to other reports and allows users to generate product movement reports across accessible organisations, companies or branches.
Filtering and Sorting Options
The Show selector supports All Records, Products, Spares & Accessories
The branch selector supports Combine Branches and Split By Branch, allowing users to either consolidate inventory movement across branches or analyse branch-level inventory movement separately.
The Sort By selector supports Quantity Out, Quantity In, Net Movement, Product Name, Brand, Model
These options allow users to analyse inventory movement trends using different operational perspectives.
Report Structure
The report is displayed as a structured product movement analysis grid.
Each row represents a product or inventory item and may include Brand, Model, Product Name, Quantity In, Quantity Out, Projected In, Projected Out
Quantity In and Quantity Out represent inventory inflow and outflow quantities for the selected reporting period.
Projected In and Projected Out display forecasted or projected inventory movement quantities based on system calculations and operational inventory planning.
The report also supports page-level quantity totals for the displayed records.
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.
|
Utility |
Description |
|
Margin Analysis |
Opens the Margin Analysis Report |
|
Aging Analysis |
Opens the Aging Analysis Report |
Export Functionality
The Export button exports the currently displayed product sales data in Microsoft Excel (.xlsx) format.
The exported report reflects the selected filters, branch configuration, sorting structure and reporting period.
Data Representation
The report supports product-level inventory movement analysis, projected inventory visibility and comparative stock movement tracking across brands and branches.
Displayed information varies depending on the selected filters, branch configuration, sorting structure and reporting period. Where no data exists, corresponding fields may remain empty or display zero values.
Summary
The Product Sales Reports provide a consolidated product-level inventory movement and sales analysis view within TUHUND.
By combining inventory inflow and outflow visibility, projected movement analysis, branch-based grouping and configurable sorting functionality, the report enables organisations to analyse product movement trends, monitor inventory activity and evaluate stock performance across products, brands and operational units.
