Skip to main content

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 needFor
inventory.stock.viewOpening the page.
inventory.stock.manageNew Transaction.
inventory.stock.importImport opening stock.
inventory.writeoffs.manageWrite off.
inventory.items.manageThe 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:

ColumnMeaning
SKU, ItemThe item.
Warehouse, Zone, BinWhere it is.
QtyHow many are in that bin.
Reorder AtThe item's reorder point.
StatusLow 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:

ColumnMeaning
On handPhysically in the warehouse.
PromisedAlready promised to customers on approved sales orders that have not shipped yet.
AvailableOn hand minus promised — what you can still sell or move.
On orderOrdered from suppliers and not yet received.
SafetyThe safety stock level for this warehouse.
Reorder atThe reorder point for this warehouse.
Below safetyHow many units you are short of safety stock, if any.
StatusOut, 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.

Start your day here

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.

  1. Open the Stock Status tab and find the item's row for that warehouse.
  2. Select Levels. A dialog opens titled with the item and warehouse.
  3. 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.
  4. Leave a field blank to keep using the item's own level for it.
  5. 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.

  1. Make sure every item exists in the Item Catalog (and is Active), and every warehouse and bin exists.
  2. Select Import opening stock.
  3. 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.
  4. 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).
  5. Set the Opening date in the dialog — the date the quantities were true.
  6. 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.
  7. Fix any problems in your spreadsheet and Choose another file until there are none.
  8. 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:

MessageMeaning
No item has SKU … / … is Inactive, not ActiveAdd 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 numberSerial items cannot be loaded from a file; record them one by one with New Transaction.
… is tracked by lot; give the lot numberFill in Lot No for lot-tracked items.
Same item, bin and lot as row NCombine the two rows.
The bin already holds N; the opening quantity is added to itA 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 loadedThe same file cannot be loaded twice.

Write off stock​

Use a write-off when goods are damaged, expired, stolen or otherwise lost.

  1. Select Write off.
  2. Choose the Item (only items in stock are offered) and the Bin (only bins you have Entry access to).
  3. Enter the Quantity — a whole number, 1 or more.
  4. Choose a Reason from the Write-off Reasons list in Inventory Settings.
  5. 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.

A write-off cannot be edited

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​

ProblemWhat to check
A warehouse is missing from the selectorWarehouse 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 handApproved sales orders have promised some of it.
The Levels button is missingYou need inventory.items.manage.
"Levels must be whole numbers, 0 or more"Remove decimals and negative numbers.