Products by category
What the stock is worth at cost and at price, by category and warehouse.
What it shows
Every active product and service with its Warehouse (its own, else the default; an item kept out of stock, such as a service, shows none), Category, Quantity in the chosen warehouse or in all, Purchase price, Price, Value at cost and Value at price = Quantity × Price. On the desktop Purchase price is the product's one average cost across all warehouses and Value at cost = Quantity × that cost; in the cloud workspace Purchase price is the cost on the product's card and Value at cost the stock's recorded value.
How it ties to the books
Across all warehouses, the Value at cost total should come close to the inventory account in the Balance sheet; a journal entry made straight to that account moves the books and not this report.
Cost is the item’s average cost on the shelf.
| Group | Inventory |
|---|---|
| Period | as at one date |
| Filters | Category and Warehouse |
| Columns | 9 |
Columns
| Column | Kind | Totalled |
|---|---|---|
| Product or service | text | — |
| # Ref | text | — |
| Warehouse | text | — |
| Category | text | — |
| Quantity | quantity | Yes |
| Purchase price | amount | — |
| Price | amount | — |
| Value at cost | amount | Yes |
| Value at price | amount | Yes |
A sample from the demo data
Drawn by the program’s report engine on the demo company, null to 28 October 2026, in SAR. The first 1 of 1 rows.
| Product or service | # Ref | Warehouse | Category | Quantity | Purchase price | Price | Value at cost | Value at price |
|---|---|---|---|---|---|---|---|---|
| Advisory and management services | SERVICE | — | — | 0 | 0.00 | 0.00 | 0.00 | 0.00 |
| Total | 0 | 0.00 | 0.00 |
Sample data, for illustration only.
Reports read with it
- Product price listWhat the stock on hand would bring in at today's prices, and the price list itself.
- Supplier stockWhat each supplier's goods on the shelf are worth, and whether the last price paid has moved away from the average.
- Stock movementsWhere a product's stock came from and where it went, document by document.
- Balance sheetWhat the business owns and owes on a given day, and what is left for its owners.
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.