Skip to content
Inventory

Stock movements

Where a product's stock came from and where it went, document by document.

What it shows

Every stock movement dated in the period, in every warehouse or the one chosen, up to 5,000 lines: the document's Reference and its User, From supplier for goods that came on a bill, purchase order, purchase return or goods-in, To customer for goods that left on a sale or sales order (Walk-in when no one was named), Movement (received, sale, return, adjustment, count, waste, transfer and so on), Quantity (negative when it left), Unit cost and Value = Quantity × Unit cost. In the cloud workspace a note column stands where the desktop shows Movement.

How it ties to the books

A product's Quantity over its whole history adds up to what Products by category shows on hand, as long as the 5,000-line limit is not reached; the report has no totals row.

GroupInventory
Periodtakes a date range
FiltersWarehouse
Columns11

Columns

ColumnKindTotalled
Datedate—
Warehousetext—
Producttext—
Referencetext—
Usertext—
From suppliertext—
To customertext—
Movementtext—
Quantityquantity—
Unit costamount—
Valueamount—

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 5,000 rows.

DateWarehouseProductReferenceUserFrom supplierTo customerMovementQuantityUnit costValue
2026-09-16Main warehouseدقيق أبيضPUR-2026-000001مستخدم تجريبيمطاحن ومؤن الخليج (تجريبي)—Received4002.20880.00
2026-09-16Main warehouseسكرPUR-2026-000001مستخدم تجريبيمطاحن ومؤن الخليج (تجريبي)—Received804.00320.00
2026-09-16Main warehouseزبدةPUR-2026-000001مستخدم تجريبيمطاحن ومؤن الخليج (تجريبي)—Received5028.001400.00
2026-09-16Main warehouseبيضPUR-2026-000001مستخدم تجريبيمطاحن ومؤن الخليج (تجريبي)—Received6000.60360.00
2026-09-16Main warehouseخميرةPUR-2026-000001مستخدم تجريبيمطاحن ومؤن الخليج (تجريبي)—Received825.00200.00
2026-09-16Main warehouseحليبPUR-2026-000001مستخدم تجريبيمطاحن ومؤن الخليج (تجريبي)—Received606.00360.00
2026-09-16Main warehouseعجوة تمرPUR-2026-000001مستخدم تجريبيمطاحن ومؤن الخليج (تجريبي)—Received3018.00540.00
2026-09-16Main warehouseجبنPUR-2026-000001مستخدم تجريبيمطاحن ومؤن الخليج (تجريبي)—Received4032.001280.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.