The Stock List tells you how much of each product you hold, and where. For a wholesaler with two or three warehouses, the number you need is often not the one on the first line you see. This lesson explains how to read the list and how to find a total across warehouses.
Key takeaways
- The Stock List has one row for each product at each location. It has no total row per product.
- Available is On Hand minus Reserved.
- Unit Cost is one cost per product, shared by all locations.
- Status (Safe, Low, Out) is judged per row, against the Min Stock you set for the product.
- For a total across warehouses, add the rows yourself or use the Stock card report.
What one row means
Open Inventory > Stock List. Each row is one product at one location. The default columns are SKU, Product, Category, Location, On Hand, Reserved, Available, Min Stock and Status.
Illustration: Harbor Wholesale is a fictional business; numbers are examples. Harbor Wholesale has two warehouses, Main Warehouse (the default location) and Branch Warehouse. Item A has 70 units at Main and 30 at Branch, and a Min Stock of 40. The Stock List shows two rows:
| Product | Location | On Hand | Min Stock | Status |
|---|---|---|---|---|
| Item A | Main Warehouse | 70 | 40 | Safe |
| Item A | Branch Warehouse | 30 | 40 | Low |
Unit Cost and Stock Value are not table columns. Open a row to see them in the detail panel: Item A's Unit Cost is 200, so its Stock Value is 14,000 at Main and 6,000 at Branch.
The list does not add these together. Item A's total, 100 units worth 20,000, is something you work out yourself.
Filtering by location
The left panel shows All Locations and your location tree. Click a location to show only that warehouse. If it has child locations, such as a rack inside a warehouse, the filter includes them. To see why a number changed, use Stock Movements.
The Filter button offers a search box, a status dropdown (All, Safe, Low, Out), a category dropdown, and the check box Hide zero stock. The cards at the top (Total SKU, Stock Value, Low Stock, Out of Stock) are calculated from the rows on screen after filtering. Total SKU counts distinct products, so Item A in two warehouses counts once. Read the other cards with the row structure in mind.
Status, cost and reserved stock
Out means On Hand is zero or less. Low means On Hand is below Min Stock. Anything else is Safe. Min Stock is one number per product, not per warehouse. If Item A's Min Stock is 40, the Main row (70) shows Safe and the Branch row (30) shows Low, although the total of 100 is well above 40.
The dashboard's Stock Alerts widget adds up all locations before it compares with Min Stock. It can show Item A as fine while the Branch row shows Low.
Unit Cost is the running cost of the product, not of the warehouse, so the list does not show a price difference between warehouses. Reserved is stock tied to sales orders that are not yet delivered. Available is On Hand minus Reserved.
Getting a total across warehouses
Two practical methods:
- Add the rows for the product yourself, as in the table above.
- Open Inventory > Reports and choose Stock card. Select the product. The report has no location filter, so it covers all warehouses. It shows the opening balance for the period, In, Out, Balance and Cost.
- Open Inventory > Stock List and leave All Locations selected to see each product once per warehouse.
- Click Branch Warehouse in the left panel to see only that warehouse.
- Click a row to read On Hand, Reserved, Available, Min Stock, Unit Cost and Stock Value in the detail panel.
- Open Filter and tick Hide zero stock to hide empty rows.
- For one product across all warehouses, open Inventory > Reports and choose Stock card.
A Low or Out status belongs to one row. Before you order, check the total and the other warehouse. A transfer from a warehouse with spare stock may cover the gap. See Transferring Stock Between Warehouses.
Check yourself: what does a Low status mean?
Low means the On Hand in that row is below the product's Min Stock. Because the rule works per row, check the total and the other warehouse before you assume you are short overall.
Reyuko