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.
| Group | Inventory |
|---|---|
| Period | as at one date |
| Filters | Supplier |
| Columns | 6 |
Columns
| Column | Kind | Totalled |
|---|---|---|
| Ref | text | — |
| Product or service | text | — |
| Total quantity | quantity | Yes |
| Purchase price | amount | — |
| Average cost | amount | — |
| Value | 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 8 of 45 rows.
| Ref | Product or service | Total quantity | Purchase price | Average cost | Value |
|---|---|---|---|---|---|
| TEABAG | Tea bags | 481 | 0.25 | 0.25 | 120.25 |
| BEANS | Roasted specialty beans | 5760 | 0.08 | 0.08 | 460.80 |
| EGGS | بيض | 504 | 0.60 | 0.60 | 302.40 |
| ICE | Ice | 139700 | 0.00 | 0.00 | 69.85 |
| CHEESE | جبن | 23.5 | 32.00 | 32.00 | 752.00 |
| MILK | حليب | 44.2 | 6.00 | 6.00 | 265.20 |
| OAT | Oat milk | 9270 | 0.01 | 0.01 | 111.24 |
| ALMOND | Almond milk | 4620 | 0.01 | 0.01 | 64.68 |
| Total | 268035.5 | 10999.08 |
Sample data, for illustration only.
Reports read with it
- Products by supplierHow much of each supplier's goods is on the shelf, and what it would sell for.
- Products by categoryWhat the stock is worth at cost and at price, by category and warehouse.
- Purchases by productWhat was bought of each product, at what average price, set against what it stands at on the shelf.
- Bill ageingWhich suppliers have been waiting longest to be paid, to plan the payments.
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.