Inventory Product Sales Report

Product Sales Report (ID: INV103)

1. Introduction

This report provides a detailed analysis of product sales within the TUHUND ERP system for Cumberland Trading. It explains how to access the product sales report, use available filters and dropdowns, and interpret the results for sales tracking and financial decision-making.

2. Accessing the Product Sales Report Page

To access the Product Sales Report Page in the TUHUND ERP system:

• Log in to the TUHUND ERP portal.
• Navigate to Inventory > Reports > Product .
• The product sales report page will display all recorded sales transactions, including product names, brands, models, sales quantities, and projected sales.
• Use the filters and dropdown menus to refine and analyze specific sales records.

3. Understanding Filters & Dropdowns

The Product Sales Report includes multiple filters to narrow down sales records based on specific criteria.

3.1 Filters Available

Filter Name	Description	Purpose
Show	Selects which sales transactions to display (All Records, Only Products, Only Spares & Accessories)	Helps filter sales records
Sort By	Sorts transactions by Quantity Sold, Product Name, Brand, Model	Organizes data for better analysis
Order (Ascending/Descending)	Defines sorting order (A-Z, Z-A)	Controls how data is displayed
Date Range (Dropdown)	Filters records based on transaction dates	Analyzes time-based sales trends
Entire Organization	Use this filter to view stock register of specific organisation or branch	To analyze specific branch or organisation stock data

3.2 Dropdown Elements & Their Functions

Show (Sales Type Filter)

This dropdown allows users to filter product sales based on type:

• All Records – Displays all sales transactions.
• Only Products – Filters standard product sales.
• Only Spares & Accessories – Displays sales of spare parts and accessories.

Sort By Dropdown

Users can sort sales transactions based on:

• Quantity Sold – Arranges records by the number of units sold.
• Product Name – Organizes transactions alphabetically by product.
• Brand – Groups records by product brand.
• Model – Sorts transactions 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.

Brands Dropdown

Use this dropdown to select specific brands or to display all brands sales reports together.

Branches Dropdown

use this dropdown to choose branch specific sales inventory report or combine all branches and see the result together.

4. Understanding the Results Table & Data Comparison

After applying filters, the Product Sales Report displays sales data in a structured table.

4.1 Columns in the Results Table

Column Name	Description	Comparison Basis
Brand	Product brand name	Analyzes sales based on brands
Model	Model or SKU of the product	Groups products by type
Product Name	Description of the product	Identifies sold items
Quantity In	Quantity added to inventory	Tracks incoming stock
Quantity Out	Quantity sold from inventory	Tracks outgoing stock
Projected In	Expected future stock additions	Estimates future inventory
Projected Out	Estimated future sales	Helps predict sales trends

5. Best Practices for Effective Use

• Regularly update filters to analyze sales trends accurately.
• Sort by "Quantity Out" to track best-selling items and prevent stockouts.
• Check "Projected Sales" to anticipate demand and restock accordingly.
• Use date filters to detect seasonal sales fluctuations.
• Ensure that "Quantity In" matches purchase records for inventory accuracy.

6. Common Issues & Solutions

Issue	Solution
Sudden drop in sales figures	Check for seasonal trends or market changes.
Sales not updating correctly	Ensure proper data entry and system updates.
High projected sales but low stock	Plan for inventory replenishment to meet demand.
Unexpected sales spikes	Investigate promotions, discounts, or external factors.

• Review sales reports regularly for market trends.
• Cross-check stock records with actual sales data for accuracy.
• Monitor projected sales to ensure timely inventory replenishment.
• Investigate significant fluctuations in sales for strategic planning.