Sales by product
Which products sell, at what average price and margin, and who sold them.
What it shows
One row per product and user, from the product lines that left in the period: the till (a return taken off), sales orders past quote by the day they were confirmed and, on the desktop, invoices written by hand with product lines; an invoice raised from an order counts once, with its order. Amount is the lines' value before tax, Average price is Amount ÷ Quantity sold, and Profit is Amount less Quantity sold at the product's average cost on the shelf today.
How it ties to the books
Amount is not the same as Subtotal less Discount in Sales by customer: a program's document that sells no product and an invoice line with no product are left out here, while a sales order counts once it is confirmed, even before it is invoiced. Its Profit total matches Product sales summary's, give or take rounding, since both take today's average cost.
From the till whichever program rang it up (a return taken off the sale), confirmed sales orders and invoices written by hand with product lines; an invoice raised from an order counts once, with its order. A program’s document that sells no product, such as a claim, is in the sales by customer. A product sold by more than one user gets a row each, and its profit is at its average cost on the shelf.
| Group | Sales |
|---|---|
| Period | takes a date range |
| Filters | Category, Supplier and User |
| Columns | 8 |
Columns
| Column | Kind | Totalled |
|---|---|---|
| Product | text | — |
| Code | text | — |
| Category | text | — |
| User | text | — |
| Quantity sold | quantity | Yes |
| Amount | amount | Yes |
| Average price | amount | — |
| Profit | amount | Yes |
A sample from the demo data
Drawn by the program’s report engine on the demo company, 30 July 2026 to 28 October 2026, in SAR. The first 1 of 1 rows.
| Product | Code | Category | User | Quantity sold | Amount | Average price | Profit |
|---|---|---|---|---|---|---|---|
| Advisory and management services | SERVICE | — | محاسب تجريبي | 25 | 238941.75 | 9557.67 | 238941.75 |
| Total | 25 | 238941.75 | 238941.75 |
Sample data, for illustration only.
Reports read with it
- Product sales summaryWhich individual sales made or lost money, product by product.
- Products sold by supplierHow much of each supplier's goods the business sells, line by line.
- Sales by customerWhich customers bought the most in a period, before and after tax and discount, and how much of it has been paid.
- Purchases by productWhat was bought of each product, at what average price, set against what it stands at on the shelf.
- Products by categoryWhat the stock is worth at cost and at price, by category and warehouse.
Sources
The definition and the sample come from the program’s report library (books/reports.rs) on the demo data; the explanation from its engine.