Skip to content

How do I view and correct an item’s stock?

Each item’s record has a Stock tab with its stock in a specific warehouse. That is where you see the quantities and can correct them by hand. Correcting by hand is the exception: normally documents move the quantities.

What do I need before I start?

You need the item created and at least one active warehouse. The Stock tab always works on one warehouse: the one you choose at the top.

If the item doesn’t yet have stock in that warehouse, the record shows everything at zero and the row is created when you save.

How do I do it?

  1. Go to Warehouse and click Items.
  2. Find the item and open it.
  3. Go to the Stock tab.
  4. Choose the Warehouse in the selector at the top. Until you choose one you will see ‘Select a warehouse to view and edit its stock.’
  5. Change the fields you need.
  6. Click Save changes in the record header.

The whole item is saved and, with it, the stock of the warehouse you were viewing.

If you work with several warehouses, the tab also shows Stock by warehouse: one row per warehouse with its stock, what is available and what is pending receipt and delivery. Click a row to choose that warehouse and view or correct its stock below.

What does each field mean?

The Stock section has what defines today’s quantity:

The Stock movements section holds running totals and commitments: Total purchases, Total sales, Other stock movements, To be received, To be delivered and Pending transfer.

The ERP moves almost all of them on its own:

If you are coming from an earlier version, these three running totals start counting from the update. What was invoiced before isn’t gone back over, so they start with whatever had been typed by hand and are reliable from then on. For earlier figures, the right data is in the stock movement history.

What happens if I correct the stock by hand?

The quantity changes immediately, but no stock movement is recorded. The item’s history keeps no record that there was a correction or of who made it.

That is why a manual correction is for getting started (loading the opening stock) or for fixing a one-off mismatch, not as the usual way to move stock. Usually a document moves it: a sale takes it down, a purchase takes it up.

Current stock can’t be left negative when you save by hand. If you try, you will see Stock can’t be negative.

Why won’t it let me change this item’s stock?

Because the item has traceability by batch or by serial number. In that case the ERP blocks manual editing with this message:

The item has batch/serial number traceability: its stock is changed with stock-in or stock-out documents, not from the item record.

The reason is legal, not technical. A manual adjustment has no batch or serial number and leaves no stock movement, so it would break the traceability chain you have to be able to show in an inspection. In those items, quantities always come in and go out with a document.

The other fields on the tab (minimum, reserved, running totals) can still be edited.

How do I see the breakdown by sizes and colours?

If the item has variants, Size breakdown appears below the two sections. Click View detail by size and a grid opens with one row per size and one column per colour.

Each cell shows the stock of that combination and, in brackets, what is pending (to be delivered as negative, to be received as positive). Combinations that don’t exist yet show as ‘—’.

This grid is read-only. The figures above are the item’s total in that warehouse: the ones in the grid break it down, they aren’t added to it.

If something goes wrong

What you seeWhat has happenedWhat to do
‘Select a warehouse to view and edit its stock.’The item has no warehouse of its own and there is no default one the ERP can work out either: this happens when you have several active warehouses and none is marked as preferredChoose one in the Warehouse selector. To have it filled in automatically next time, set the default warehouse in the warehouse settings
‘The item has batch/serial number traceability…’The item is tracked by batch or serial numberMove the quantities with a stock-in or stock-out document
‘Stock can’t be negative.’You have typed a quantity below zeroType zero or more
‘The variant adjustment would leave the base item’s total stock negative’You lowered the size by more than the item’s total hasCheck the item’s total before lowering the size
Available doesn’t match Current stockThere is a quantity in ReservedThis is correct: reserved stock doesn’t count as available
The Stock movements running totals don’t match what was invoicedThey only count from when the ERP was updated: earlier figures aren’t gone back overThe right data for older figures is in the stock movement history (stock report or traceability)
Total sales is at zero and you have soldYou are looking at another warehouse: the running totals are for the item + warehouse pair, not for the whole itemChange warehouse in the tab’s selector

See also: Add a warehouse · Move stock between warehouses · Work with batches and expiry dates

More about Warehouse