Stock Ledger
The Stock Ledger lists every stock entry, newest first. An entry is made for each row of a submitted stock movement, shipment or purchase receipt. Each line shows how much moved in or out, what it was worth, and the balance of that item at that location afterwards.
Use it to answer questions like "why is there only 3 kg of Gayo at Toko Dago?" or "what did this shipment cost?".
Open the report
In the sidebar, click Reports > Stock Ledger. The report is there only when inventory is on.
To jump to the entries of one document:
- Open a submitted stock movement, shipment or purchase receipt.
- Click View > Stock entries.
The report opens filtered on that document, with the dates set to the document's date. Right after you submit a stock document, the confirmation message also has a View stock entries link.

Read the columns
| Column | What it shows |
|---|---|
| Date, Item, Location | When, what and where |
| Batch, Serial Number | Shown when batches or serial numbers are on |
| Quantity | The change. Incoming is positive and green, outgoing is negative and red. |
| Balance Qty. | Stock of the item at the location after this entry. For an item with batches, the stock of that batch. |
| Incoming rate | For incoming stock, the rate it came in at. For outgoing stock, the FIFO cost it went out at. |
| Valuation Rate | Balance Value divided by Balance Qty. |
| Balance Value | Value of the stock at the location after this entry |
| Value Change | Change in stock value. Green is an increase, red a decrease. |
| Ref Name, Ref Type | The document that made the entry, for example SHPM-1012, and its type |
Only a Books Manager or System Manager sees the rate and value columns. Other users see quantities only.
A few patterns to recognise:
- A Material Transfer row gives two lines: one out of the source location and one into the destination, at the value the first one took out.
- An item with serial numbers gets one line per serial number, each with quantity 1.
- A shipment's value is its FIFO cost, which may differ from the rate on the shipment.
Filters
| Filter | Use |
|---|---|
| Ref Type | All (default), Stock Movements, Shipment or Purchase Receipt |
| Ref Name | One document. Choose a Ref Type first. |
| Item, Location | One item, one location |
| Batch, Serial Number | Shown when that feature is on |
| From Date, To Date | The period, both dates included. By default, the last year up to today. |
| Group By | Keep the lines of each Item, Location or Reference together |
| Ascending Order | Show the oldest entries first |
Finding a stock shortage
If a document is refused for lack of stock, filter on its item and location and turn on Ascending Order. Look down Balance Qty. for the point where the stock runs out, including entries dated after your document.
To export or print the report, see Reports. The export contains every line that matches the current filters.
