# Sales By Item Summary Fields

The Sales By Item Summary report provides businesses with valuable insights into their sales performance, profitability, and inventory management, enabling them to make informed decisions to optimize their operations and maximize profitability.

#### Sales By Item Summary Fields

<table><thead><tr><th width="168">Field</th><th>Description</th></tr></thead><tbody><tr><td>Item</td><td>This field displays the unique identifier of the item or service sold.</td></tr><tr><td>Description</td><td>This field shows the description of the item or service sold, offering additional details to help identify the product.</td></tr><tr><td>UPC</td><td>This field captures the UPC (Universal Product Code) associated with the item.</td></tr><tr><td>Brand</td><td>This field indicates the brand of the item being sold.</td></tr><tr><td>Qty</td><td>The quantity sold field shows the number of units of each item or service that have been sold during the specified period.</td></tr><tr><td>Sales</td><td>The sales field represents the sales amount for which the item or service was sold during the specified period.</td></tr><tr><td>% Sales</td><td>This field shows the percentage of total sales that each item or service contributes to. It helps to identify the items that are driving the majority of sales.</td></tr><tr><td>Average price</td><td>This field shows the average price of the item or service.</td></tr><tr><td>COGS</td><td>This field represents the direct costs associated with producing or purchasing the items sold.</td></tr><tr><td>Avg COGS</td><td>This field calculates the average cost of goods sold for each item or service by dividing the total cost of goods sold by the quantity sold.</td></tr><tr><td>Gross Margin</td><td>This field represents the difference between the total sales amount and the cost of goods sold for each item or service (<em><strong>Gross Margin = Sales amount-COGS amount</strong></em>). It indicates the profitability of selling each item or service.</td></tr><tr><td>Gross Margin %</td><td>This field expresses the gross margin as a percentage of sales, showing the profitability of each item or service relative to its sales revenue. </td></tr></tbody></table>

### Sales By Item Detail

The Sales By Item Summary report allows you to further view the details of the item sales by clicking on the specific values or columns within the report. On clicking any value, you will be redirected to the "Sales By Item Detail" report which displays a detailed report regarding the sale or return of the item. These details include the transaction type, the invoice or credit memo number, item number, item quantity sold or returned, etc.&#x20;

#### Sales By Item Detail Fields

<table><thead><tr><th width="225">Field</th><th>Description</th></tr></thead><tbody><tr><td>Txn Type</td><td>This field indicates the type of transaction associated with the item (Invoice or Credit Memo).</td></tr><tr><td>Date</td><td>This field captures the date of the transaction.</td></tr><tr><td>Ref No</td><td>This field shows the unique reference number assigned to the transaction for tracking purposes. For example, invoice number or credit memo number.</td></tr><tr><td>REF_2</td><td>This field may contain additional reference information related to the transaction, such as sales order number.</td></tr><tr><td>Item</td><td>This field specifies the unique identifier of the item or service that the transaction pertains to.</td></tr><tr><td>Entity</td><td>This field shows the entity (e.g., customer, vendor) involved in the transaction.</td></tr><tr><td>Qty</td><td>This field shows the quantity of the item sold or returned in the transaction.</td></tr><tr><td>Sales Price</td><td>This field shows the price at which each unit of the item was sold.</td></tr><tr><td>Sales</td><td>This field displays the total sales amount of the transaction (Qty * Sales Price).</td></tr><tr><td>Running Balance</td><td>This field shows the cumulative balance of sales or quantity for each item, updating with each new transaction entry.</td></tr></tbody></table>

Furthermore, within this detailed view, you can delve into individual transactions by clicking on any value. This action takes you to the "Journal Detail" view, where you can see the journal entry details associated with the transaction.

In the journal view, you can examine the Debit and Credit entries linked to that particular transaction, enabling a detailed analysis of financial data and transactional activities.


---

# 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/sales-by-item-summary-fields.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.