Skip to content
Payables

Purchases by product

What was bought of each product, at what average price, set against what it stands at on the shelf.

What it shows

One row per product and user, from the product lines bought in the period: purchase bills and, on the desktop, the goods received at the till; the user is whoever entered the bill or received the goods. Amount is the lines' value before tax and Average price is Amount ÷ Quantity bought; Cost is Quantity bought at the product's average cost on the shelf today, so it parts from Amount when prices have moved.

How it ties to the books

Amount is only the product lines of what Purchases by supplier counts: a subcontractor's claim, a site's cost or a bill line with no product is there and not here.

From the purchase bills’ product lines and the goods received at the till, whichever program received them. A program’s document that buys no product, such as a subcontractor’s claim, is in the purchases by supplier. Cost is the item’s average cost on the shelf.

GroupPayables
Periodtakes a date range
FiltersSupplier and Category
Columns8

Columns

ColumnKindTotalled
Producttext—
Codetext—
Categorytext—
Usertext—
Quantity boughtquantityYes
AmountamountYes
Average priceamount—
CostamountYes

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

ProductCodeCategoryUserQuantity boughtAmountAverage priceCost
زبدةBUTTER—مستخدم تجريبي159.14454.8028.004454.80
جبنCHEESE—مستخدم تجريبي113.53632.0032.003632.00
Roasted specialty beansBEANS—مستخدم تجريبي357202857.600.082857.60
دقيق أبيضFLOUR—مستخدم تجريبي1193.62625.922.202625.92
Full-fat milkCAFE-MILK—مستخدم تجريبي2302201151.100.011151.10
شوكولاتةCHOC—مستخدم تجريبي25.41016.0040.001016.00
Clear cold cupCOLDCUP—مستخدم تجريبي2416966.400.40966.40
عجوة تمرDATES—مستخدم تجريبي52936.0018.00936.00
Total674595.831595.6731595.64

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.