Stock reports and item history
You will be able to: Pick the right stock report for a question; Read On Hand, MAvg Cost and Value; Trace a quantity back to its documents with the movement report.
- Read not done yet
- Watched not done yet
- Self-check: not taken not done yet
- Lesson complete not done yet
Stock reports are read-only. They add up every stock movement posted so far. Different questions need different reports.
Show transcript
1. Open Reports and the Inventory tab 2. Open the Stock report (stock balance and valuation) 3. Press Run: quantity and value of every item 4. Scroll to read the value of the stock 5. Open the Stock Ledger / Movement report 6. Open the Reorder Report
| Question | Report |
|---|---|
| What do I hold now and what is it worth? | Stock Balance and Valuation |
| What was the stock on a past date, and what moved in a period? | Stock Balance, Period Movement |
| Why did this quantity change? | Stock Ledger / Movement |
| What should I buy? | Reorder Report |
| Which items are below minimum, over maximum or negative? | Stock Status |
| What expires soon? | Batch Expiry |
| What sells fast or slowly? | Slow / Fast Movers |
Stock Balance and Valuation
Each row is one item in one warehouse: On Hand in the base unit, MAvg Cost, and Value. Items with no quantity and no value are left out. The report has no date; it shows the position now. The Value heading says AED but the figures are in your company's base currency. Read the Value total, not the On Hand total, because quantities of different items do not add up in a meaningful way. For FIFO and LIFO items, Value follows the method and can differ from On Hand times MAvg Cost.
Period Movement
For each item and warehouse: Opening Qty, Inward, Outward and Closing Qty, plus Closing Value. Opening plus Inward less Outward equals Closing. To value your stock on a past date, set the period so To is that date and read Closing Value on the TOTAL row. A movement counts on its document date, so a late document with an earlier date changes the earlier period.
Stock Ledger / Movement and item history
This is the item history. Each row is one movement from one document line, with Date, Doc No, Type (SI sales invoice, GRN, PI, PR, STN transfer, ADJ adjustment, OST opening stock and so on), warehouse, In, Out, Value change and Status. Turn on Balance Qty, Balance Value and MAvg After with the Columns button to see the running position. A cancelled or amended document keeps its original rows and gets rows marked REVERSAL. Click a row to jump to the list of that kind of document; search the document number there.
Try it in the demo
- Open demo.zeyto.app/demo-app/ and sign in with the public demo user (admin, password demoAdmin123).
- Open Reports, Stock Balance and Valuation and press Run.
- Open Stock Balance, Period Movement and set a period; read Opening, Inward, Outward and Closing.
- Open Stock Ledger / Movement, type an item code and turn on Balance Qty.
- Open the Reorder Report and the Stock Status report.
Public demo company, sign in as admin / demoAdmin123. Data refreshes nightly.
- Pick the report for the question: now, past date, history, buying list, exceptions.
- Read the Value total rather than the On Hand total.
- Cancelled documents leave REVERSAL rows, not gaps.
- Movement type and document type narrow the ledger report.
Check yourself
1 question on this lesson. Not timed, not the exam, and you can try again. Score 60% or more, and read the lesson, to complete it.