# Sales By Item Summary

The Sales By Item Summary report provides a comprehensive overview of how many items have been sold and returned within a designated timeframe. This report includes essential details such as item name, description, UPC (Universal Product Code), brand, quantity sold, sales amount, average cost, sales percentage, gross margin percentage, and more. This report is essential for analyzing which products are performing well, inventory management, and strategic planning for future sales.

### Key Features of the Sales By Item Summary Report

1. **Gross Margin Percentage:** The report calculates the gross margin for each item. This provides businesses with a clear understanding of their profitability.
2. **Performance Evaluation:** Businesses can use this report to evaluate the performance of individual items and identify top-selling products.
3. **Performance Trend Over Period:** This report allows you to check the number of items sold and returned over different periods of time, such as "This Month", "This Week", "This Calendar Year", etc. to analyze which items are being sold the most.
4. **Inventory Management:** By understanding which items are selling well, businesses can optimize their inventory levels, ensuring they have sufficient stock of high-demand items while minimizing excess inventory of slow-moving products.
5. **Pricing Strategy:** The report helps businesses analyze the effectiveness of their pricing strategies and make adjustments to maximize profitability.
6. **Profitability Analysis:** By calculating the average cost and gross margin percentage for each item, businesses can assess their overall profitability and identify areas for improvement.

The Sales By Item Summary report is a tool for businesses to analyze their sales performance over a specific period. 

{% hint style="info" %}
To access this report, go to **Menu > Reports > Sales > Sales By Item Summary**
{% endhint %}

Upon selecting this option, you will be prompted to select a template. Select the "Sales By Item Summar" template and click "Print Preview" to view the report. 

### Filtering the Sales By Item Summary Report

XoroERP provides the option to view the "Sales By Item Summary" report for different periods, making it easier for businesses to see how many items were sold in a certain timeframe. This overview will guide you through customizing the report view to better suit your analytical needs.

**Time Period Selection**

To begin filtering the report:

1. Navigate to the "Range" section located on the right-hand side of the interface.
2. Select the appropriate time period for your analysis and click **"Preview"** to refresh the report data.
   * The initial default setting is **"This Fiscal Year-To-Date"**. Additional timeframes are available, including:
     * Today
     * This Month-To-Date
     * This Calendar Year
     * Last Week
     * And others.
3. For a more tailored analysis, select the **"Custom"** option, set the "DateFrom" and "DateTo" fields at the top of this section, and click **"Preview"** to generate a report for the customized period.

**Selecting the Store**

After setting the time frame, you can select the store for which you want to check the sales data. This feature comes in handy when you want to see how many items are sold from a particular store. Select the store from the available options and click on "Preview" to check the report tailored to the selected store.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.xorosoft.com/xoroerp-1/reports/sales/sales-by-item-summary.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.