A stock number changes for a reason. A delivery goes out, a transfer comes in, a count corrects a mistake. When the Stock List does not match what you expect, you need the history. In Reyuko that history is Stock Movements. This lesson shows how to use it to find the cause, after you have read the numbers in Reading Stock.
Key takeaways
- Stock Movements lists each stock in and out, with its source document.
- Filter by location, date and module to narrow the list.
- The module filter has only six choices. Stock counts, returns, consignment and production are not among them, so search by document number.
- The Balance column is calculated on screen from the rows shown, so read it with the filters in mind.
- For a period audit across warehouses, use the Stock card report.
Where to look
Open Inventory > Stock Movements. The cards at the top show Total In, Total Out and Total Movement Value. The table columns are Date, Product, Source Document, Module, Unit, In, Out, Balance, Location and Unit Cost. From the Stock List, the History button on a selected product opens this page.
Filtering the list
The left panel lists All Locations and each location. Selecting a location shows only its own movements. Unlike the Stock List, a parent location does not include its child locations here.
The Filter panel has a search box, "Search product / document…", which matches product code, product name and source document. It also has a date range and a Module dropdown. The dropdown offers six choices, covering the purchase, sales, adjustment and transfer documents. The options show raw module codes, such as transfer or adjustment, not friendly names. Check your version for the exact codes.
Stock counts (Stock Opname), returns, consignment and production movements have no module choice of their own. To find one, clear the module filter and type its document number in the search box.
Reading the Balance
The Balance column is a running total per product, calculated from the rows on screen. With one location selected, it is that warehouse's running balance. With All Locations, it mixes all warehouses. The running total starts at the first row in the filtered list. If your date range starts after the first movement, the Balance starts at zero, not at the opening stock, so widen the range before you compare.
Illustration: Harbor Wholesale is a fictional business; numbers are examples. Harbor's Branch Warehouse, Item A, starts at zero:
| Date | Source Document | Module | In | Out | Balance |
|---|---|---|---|---|---|
| 3 Mar | Transfer from Main Warehouse | transfer | 50 | 50 | |
| 5 Mar | Delivery order | delivery | 20 | 30 | |
| 9 Mar | Adjustment, damaged goods | adjustment | 2 | 28 |
The last balance, 28, should match the Branch row on the Stock List. If it does not, a filter is probably hiding a row, or you are comparing with All Locations. Clear the filters, select the same location, and compare again. Transfers have their own quirks, covered in Transfer Pitfalls.
Audit with the Stock card
For a period check, open Inventory > Reports and choose Stock card. Select a product. The report covers all locations and shows the opening balance for the period, then In, Out, Balance and Cost. It is the better tool when you need a figure you can defend, rather than a running total on screen.
- Open Inventory > Stock Movements.
- In the left panel, click the location, for example Branch Warehouse.
- Open Filter, set the date range, and choose a module if you need one.
- In the search box, type the product code or the document number.
- Read In, Out and Balance from the top row down.
- Compare the last Balance with the Stock List row for that location.
If you filter by one module, you see only that module's movements. A count adjustment, return or consignment movement will not appear under it. Clear the module filter and search by document number instead.
Check yourself: why does the balance differ from the Stock List?
Usually a filter is hiding a row, or the Balance is for All Locations while the Stock List row is for one warehouse. Clear the filters, select the same location, and compare again. If the numbers still differ, check your version and use the Stock card report.
Reyuko