Skip to content
Inventory

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.

GroupInventory
Periodas at one date
FiltersCategory and Warehouse
Columns9

Columns

ColumnKindTotalled
Product or servicetext—
# Reftext—
Warehousetext—
Categorytext—
QuantityquantityYes
Purchase priceamount—
Priceamount—
Value at costamountYes
Value at priceamountYes

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# RefWarehouseCategoryQuantityPurchase pricePriceValue at costValue at price
Advisory and management servicesSERVICE——00.000.000.000.00
Total00.000.00

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.