What you'll do: read the results of a stock count: which products were counted, which are still missing from the count, where the shelf had more or less than the system, and the money value of the difference.
Before you start:
- Your package must include the stock count module, and your role needs inventorymanagement.view.
- You need a stock count session with saved rows. See Start a stock count and Count items and approve the stock count.
Open the session reports
Section titled “Open the session reports”Open Inventory & Products → Products → Stock Count.
Open the actions of the session and choose Reports. You can do this at any time: while counting, before approval or after the session is closed.
1 Actions · 2 Reports The Inventory reports page has two lists:
- Counted products: every row saved in this session;
- Not yet counted: stocked products of the branch that nobody has counted yet, with their Available quantity. Use it to find shelves you missed.
1 Increase report · 2 Decrease report · 3 Export CSV · 4 Counted products · 5 Not yet counted
Read the variance (differences)
Section titled “Read the variance (differences)”Press Increase report to see products where you counted more than the system had, or Decrease report for products where you counted less.
Each line shows the Product, SKU, Current quantity (in the system when the session started), New quantity (what you counted) and the Difference.
Press Back to reports to return.
To work on the figures in Excel, press Export CSV. The file has one row per counted product with Qty before, Counted qty, Variance, Reason, Notes, Unit cost and Variance value.
Value of the difference and comparing counts
Section titled “Value of the difference and comparing counts”Two more report pages exist, but there is no button for them yet. Open them by typing the address in the browser, after your Hala address:
- Financial impact:
/stockcount/reports/<session number>/valuation/view(the session number is the # shown in the list). It shows Total loss value, Total gain value and Net value, and the value of the difference for each product. - Compare inventory sessions:
/stockcount/reports/comparison. Choose the Branch, then Session A and Session B (two sessions of the same branch) and press Compare. You see the loss value of each session, the Shrinkage rate per day between them, and the Differences (B − A) in Total loss value, Lost units and Counted lines difference.