Product Average Cost Report

Report Overview

The Product Average Cost Report provides a detailed view of inventory movement for each product over a selected period. It shows the opening balance before the period (quantities and values), followed by total inward and outward movements, ending with the net balance at the end of the period.

This report is used to verify inventory accuracy, track product movement, analyze costs, and identify any discrepancies in stock balances.

How to Access the Report

1. Go to the Reports menu.
2. Click on Store Reports.
3. Select Product Average Cost.

You can apply the following filters before displaying the report:

• Date Range (From – To): Select the period for which you want to view inventory movements.
  • Default: Last 28 days
  • You can manually select the start and end dates.
• Product: Select one or more products to view their movements only (search by name or product code).
  • If not selected, all products will be included.
• Warehouse: Select one or more warehouses to view their movements only.
  • If not selected, all warehouses will be included.
• Category: Select one or more categories to filter products.
  • If not selected, all categories will be included.
• Branch: Select one or more branches to filter products.
  • If not selected, all branches will be included.

After adjusting the filters, click Show Report to update the results.

You can switch between:

• Summary View: Displays totals per product.
• Detailed View: Displays each transaction separately.

You can print the report using Print, or export it via Export to:

• CSV
• Excel
• PDF

Report Columns

The table displays product movements divided into key sections as follows:

• Code: The product’s unique identifier.
• Barcode: The product barcode.
• Name: The product name.

Before

• Quantity: Product quantity in stock before the selected period.
• Amount: Financial value of the stock before the selected period.

Inward

• Quantity: Total quantities added to inventory during the period.
• Amount: Financial value of the inward quantities.

Outward

• Quantity: Total quantities issued from inventory during the period.
• Amount: Financial value of the outward quantities.

Net

• Quantity: Remaining quantity after inward and outward movements.
• Amount: Net financial value of inventory at the end of the period.

At the bottom of the table, a Totals Row is displayed, summarizing all values across all products for the selected period.