Skip to content
Sales

Product sales summary

Which individual sales made or lost money, product by product.

What it shows

One row per product line sold in the period, with its Document and Customer (Walk-in for a till sale to no named customer). Purchase price is the product's average cost on the shelf today, Sale price the line's unit price, and Profit the line's amount before tax less Quantity sold × that average cost. The supplier filter keeps the products that come from that supplier: on the desktop by their last bill or goods-in, in the cloud workspace by their card.

How it ties to the books

Its Profit total matches Sales by product's, give or take rounding, since both take the same lines at today's average cost. It is not the Net profit of the invoice reports, which take the cost the goods left the stock at.

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. A program’s document that sells no product, such as a claim, is in the sales by customer. A product’s supplier is the one its last bill came from; its cost is its average cost on the shelf.

GroupSales
Periodtakes a date range
FiltersSupplier
Columns8

Columns

ColumnKindTotalled
Producttext—
# Reftext—
Documenttext—
Quantity soldquantityYes
Purchase priceamount—
Sale priceamount—
ProfitamountYes
Customertext—

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 8 of 25 rows.

Product# RefDocumentQuantity soldPurchase priceSale priceProfitCustomer
Advisory and management servicesSERVICEPOS-2026-00000110.0013213.0011489.57مصنع الجودة للبلاستيك (تجريبي)
Advisory and management servicesSERVICEPOS-2026-00000210.008452.007349.57مؤسسة الإبداع للتسويق (تجريبي)
Advisory and management servicesSERVICEPOS-2026-00000310.0011430.009939.13شركة المستقبل للتجارة (تجريبي)
Advisory and management servicesSERVICEPOS-2026-00000410.0014838.0012902.61شركة الواحة اللوجستية (تجريبي)
Advisory and management servicesSERVICEPOS-2026-00000510.0016514.0014360.00مؤسسة الإبداع للتسويق (تجريبي)
Advisory and management servicesSERVICEPOS-2026-00000610.009595.008343.48مؤسسة البناء الحديث (تجريبي)
Advisory and management servicesSERVICEPOS-2026-00000710.0017331.0015070.43شركة النخبة للمقاولات (تجريبي)
Advisory and management servicesSERVICEPOS-2026-00000810.007974.006933.91مؤسسة الإبداع للتسويق (تجريبي)
Total25238941.75

Sample data, for illustration only.

Reports read with it

The 60 reportsJooDax

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.