Skip to content
Inventory

Supplier stock

What each supplier's goods on the shelf are worth, and whether the last price paid has moved away from the average.

What it shows

Every product with a supplier, or those of the supplier chosen: Ref, Total quantity on hand, Purchase price, Average cost and Value. On the desktop Purchase price is the unit cost on the last bill or goods-in, Average cost the product's average on the shelf (empty when none is held) and Value = quantity held × average cost; in the cloud workspace Purchase price is the cost on the product's card and Value the stock's recorded value.

How it ties to the books

Purchase price beside Average cost shows how far the last purchase is from what the stock stands at; Value comes from the same average cost as Value at cost in Products by category, for the products that have a supplier.

An item’s supplier is the one its last purchase bill came from, and its purchase price is that bill’s.

GroupInventory
Periodas at one date
FiltersSupplier
Columns6

Columns

ColumnKindTotalled
Reftext—
Product or servicetext—
Total quantityquantityYes
Purchase priceamount—
Average costamount—
ValueamountYes

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

RefProduct or serviceTotal quantityPurchase priceAverage costValue
TEABAGTea bags4810.250.25120.25
BEANSRoasted specialty beans57600.080.08460.80
EGGSبيض5040.600.60302.40
ICEIce1397000.000.0069.85
CHEESEجبن23.532.0032.00752.00
MILKحليب44.26.006.00265.20
OATOat milk92700.010.01111.24
ALMONDAlmond milk46200.010.0164.68
Total268035.510999.08

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.