Stock Levels
Inventory → Stock Levels (/inventory/stock) answers "how many do we have,
and where?". It shows the quantity of every item in every bin, grouped three
different ways, and it is also where you load your starting quantities when you
first begin using the system.
A green Live badge next to the title means the page is connected for live updates: when anyone receives, moves or issues stock, the figures refresh on their own. A grey Offline badge means live updates are not arriving — refresh the page to see the latest.
When to use this page
- Checking stock before promising goods to a customer.
- Seeing what is in a particular warehouse, zone or bin.
- Finding items that are out of stock, below safety stock or due for reorder.
- Giving one warehouse different safety stock or reorder levels from the rest.
- Loading opening stock on your first day.
- Writing off damaged, expired or lost goods.
Before you begin
| You need | For |
|---|---|
inventory.stock.view | Opening the page. |
inventory.stock.manage | New Transaction. |
inventory.stock.import | Import opening stock. |
inventory.writeoffs.manage | Write off. |
inventory.items.manage | The Levels button on the Stock Status tab. |
The Warehouse Manager role has all of these. The Write down button, which
lowers the value of stock rather than its quantity, needs
inventory.writedowns.manage and is a finance task — you will not see it.
You need warehouses and bins (Warehouses) and items (Item Catalog) before there is anything to show.
Understanding the page
The header holds Import opening stock, Write off, and a warehouse selector (All Warehouses or one warehouse) that applies to all three tabs.
By Item
A standard grid (Working with lists) with one row per item per bin:
| Column | Meaning |
|---|---|
| SKU, Item | The item. |
| Warehouse, Zone, Bin | Where it is. |
| Qty | How many are in that bin. |
| Reorder At | The item's reorder point. |
| Status | Low stock when the quantity is at or below the reorder point, otherwise OK. |
By Location
Pick a single warehouse in the header first. Stock is then shown zone by zone in collapsible sections, so you can see what each part of the building holds.
Stock Status
The most useful view for planning. One row per item per warehouse, with the figures that decide whether you need to act:
| Column | Meaning |
|---|---|
| On hand | Physically in the warehouse. |
| Promised | Already promised to customers on approved sales orders that have not shipped yet. |
| Available | On hand minus promised — what you can still sell or move. |
| On order | Ordered from suppliers and not yet received. |
| Safety | The safety stock level for this warehouse. |
| Reorder at | The reorder point for this warehouse. |
| Below safety | How many units you are short of safety stock, if any. |
| Status | Out, Below safety, Reorder, Over max or OK. |
An own levels badge on a row means this warehouse has its own levels instead of the item's.
Filter buttons across the top narrow the list, each with a count: Needs attention (Out + Below safety + Reorder — the default), Out, Below safety, Reorder, Over max and All. The search box filters by item or SKU.
Open Stock Status with Needs attention selected. Red rows (Out, Below safety) need stock now — transfer it in or chase the supplier. Orange rows (Reorder) are your purchase list.
Set levels for one warehouse
An item has one safety stock, reorder point and reorder quantity, set in the Item Catalog. When a warehouse needs different numbers — a busy branch that sells more, say — give it its own.
- Open the Stock Status tab and find the item's row for that warehouse.
- Select Levels. A dialog opens titled with the item and warehouse.
- Fill in any of: Safety stock, Reorder point, Reorder quantity, Minimum, Maximum (more than this is overstock), Lead time (days) (how long a replenishment takes) and Minimum order quantity (the supplier's smallest order). Whole numbers, 0 or more.
- Leave a field blank to keep using the item's own level for it.
- Select Save levels. You see "Warehouse levels saved" and the row gains the own levels badge.
To go back to the item's levels entirely, open the dialog and select Use item levels.
Record a quick stock movement
New Transaction (on the By Item grid) opens the same New Stock Transaction form as the Transactions page. Use it for one-off receipts, issues and corrections that have no other document.
Load opening stock
When you start using the system, your shelves already hold stock. Loading it from a spreadsheet records each quantity and its cost in one go.
- Make sure every item exists in the Item Catalog (and is Active), and every warehouse and bin exists.
- Select Import opening stock.
- Download the Excel template (or CSV template). Its columns are SKU, Warehouse, Bin, Quantity, Unit Cost, Lot No, Expiry Date and Notes. Common alternative headings such as "Item Code", "Qty" or "Location" are also understood.
- Fill in one row per item, bin and lot. Leave Unit Cost blank to use the item's current cost (you will see a note saying which).
- Set the Opening date in the dialog — the date the quantities were true.
- Choose file. The system checks every row before anything is saved and shows a summary: how many rows, how many with problems (red) and how many with notes (orange), with the reason for each in the Check column.
- Fix any problems in your spreadsheet and Choose another file until there are none.
- Select Load opening stock.
The whole file loads, or nothing does — you never end up with half a file in the ledger. Each row becomes an Opening movement visible in Transactions.
Checks you might see:
| Message | Meaning |
|---|---|
| No item has SKU … / … is Inactive, not Active | Add or activate the item first. |
| No warehouse is named … / … has no bin … | Names must match exactly what is on the Warehouses page. |
| You can't record stock in … | You need Entry access to that warehouse. |
| … is tracked by serial number | Serial items cannot be loaded from a file; record them one by one with New Transaction. |
| … is tracked by lot; give the lot number | Fill in Lot No for lot-tracked items. |
| Same item, bin and lot as row N | Combine the two rows. |
| The bin already holds N; the opening quantity is added to it | A note, not an error: the bin already had stock. |
| Inventory is closed through … | The opening date falls in a closed period. Choose a later date. |
| This file was already loaded | The same file cannot be loaded twice. |
Write off stock
Use a write-off when goods are damaged, expired, stolen or otherwise lost.
- Select Write off.
- Choose the Item (only items in stock are offered) and the Bin (only bins you have Entry access to).
- Enter the Quantity — a whole number, 1 or more.
- Choose a Reason from the Write-off Reasons list in Inventory Settings.
- Add Notes if helpful, then select Write off.
You see "Stock written off". The quantity leaves the bin at the item's average cost and its value is charged to inventory losses.
Like every stock movement, a write-off is permanent. If you made a mistake, record a correcting movement (for example a Stock IN with a note explaining why) rather than looking for an undo.
Common issues
| Problem | What to check |
|---|---|
| A warehouse is missing from the selector | Warehouse Access may be limiting what you see. |
| By Location shows "Select a warehouse above" | Pick one warehouse in the header. |
| Available is lower than On hand | Approved sales orders have promised some of it. |
| The Levels button is missing | You need inventory.items.manage. |
| "Levels must be whole numbers, 0 or more" | Remove decimals and negative numbers. |
Related pages
- Transactions — every movement behind these quantities.
- Stock Lookup — the quick, phone-friendly version of this page.
- Inventory Alerts — be emailed when items go low.
- Purchase Requisitions — replenishing what is low.