Home Reports Product Reports

Product Reports

Last updated on Apr 02, 2025

The “Products” report section provides comprehensive information about the production, storage, and sales of your products.

1. Product Inventory Value

This report shows the total value of all products in stock over your selected time period and frequency.

Available settings:

  • Time period

  • Frequency (daily, weekly, monthly, quarterly, yearly)

  • Storage location selection

  • Product categories

  • Include deleted products

  • Include planned operations

  • Display chart

  • Calculation method (at cost or at sales price)

2. Product Transaction History

Displays all operations with a specified product for a selected time period. For each transaction, you'll see:

  • Quantity

  • Stock level after the operation

  • Unit cost

  • Total cost

  • Running total cost

  • Unit price

  • Total price

  • Running total price

  • Status (actual or planned)

Available settings:

  • Product selection

  • Time period

  • Operation types

  • Storage location selection

  • Include planned operations

3. Product Turnover

Shows the total turnover (inflows and outflows) of products for the specified period.

Available settings:

  • Time period

  • Display type (quantity, cost, price)

  • Storage location selection

  • Product categories

  • Include planned operations

4. Product Inventory at Date

This report shows the quantity, unit cost, total cost, unit sales price, and total sales price of products on the selected date. The stock levels are shown as of the end of the day.

Available settings:

  • Date

  • Storage location selection

  • Product categories

  • Include planned operations

  • Only show items below minimum stock level

5. Product Turnover Rates

Demonstrates the inventory turnover rates of products for the selected period. It's calculated in two ways:

  • In days: Shows how many days the average inventory remains in stock before being sold (Days of Inventory on Hand)

  • In turns: Shows how many times the average inventory is completely sold and replaced during the selected period

Available settings:

  • Time period

  • Calculation method (in days or in turns)

  • Storage location selection

  • Product categories

  • Include planned operations

6. Products ABC Analysis

ABC analysis categorizes products into three groups by business importance:

  • A — high value (20% of items representing 80% of sales)

  • B — medium value (30% of items representing 15% of sales)

  • C — low value (50% of items representing 5% of sales)

Available settings:

  • Time period

  • Sort by (gross profit, sales revenue, or cost)

  • Include planned operations