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

Field	Description
Item	This field displays the unique identifier of the item or service sold.
Description	This field shows the description of the item or service sold, offering additional details to help identify the product.
UPC	This field captures the UPC (Universal Product Code) associated with the item.
Brand	This field indicates the brand of the item being sold.
Qty	The quantity sold field shows the number of units of each item or service that have been sold during the specified period.
Sales	The sales field represents the sales amount for which the item or service was sold during the specified period.
% Sales	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.
Average price	This field shows the average price of the item or service.
COGS	This field represents the direct costs associated with producing or purchasing the items sold.
Avg COGS	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.
Gross Margin	This field represents the difference between the total sales amount and the cost of goods sold for each item or service (Gross Margin = Sales amount-COGS amount). It indicates the profitability of selling each item or service.
Gross Margin %	This field expresses the gross margin as a percentage of sales, showing the profitability of each item or service relative to its sales revenue.

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.

Sales By Item Detail Fields

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

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.