Skip to content

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:

  1. Open a submitted stock movement, shipment or purchase receipt.
  2. 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.

Stock Ledger filtered on item Kopi Arabika Gayo, with incoming quantities in green, outgoing quantities in red, and the Balance Qty. column

Read the columns ​

ColumnWhat it shows
Date, Item, LocationWhen, what and where
Batch, Serial NumberShown when batches or serial numbers are on
QuantityThe 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 rateFor incoming stock, the rate it came in at. For outgoing stock, the FIFO cost it went out at.
Valuation RateBalance Value divided by Balance Qty.
Balance ValueValue of the stock at the location after this entry
Value ChangeChange in stock value. Green is an increase, red a decrease.
Ref Name, Ref TypeThe 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 ​

FilterUse
Ref TypeAll (default), Stock Movements, Shipment or Purchase Receipt
Ref NameOne document. Choose a Ref Type first.
Item, LocationOne item, one location
Batch, Serial NumberShown when that feature is on
From Date, To DateThe period, both dates included. By default, the last year up to today.
Group ByKeep the lines of each Item, Location or Reference together
Ascending OrderShow 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.