AWRA OpsHub Search
Inventory · Min / max per warehouse

One item, a floor and a ceiling for every warehouse.

A branch that sells ten a week and one that sells ten a year should not share one reorder point. Give each warehouse its own minimum and maximum for an item: Reorder offers the item when that warehouse falls to its floor, suggests enough to fill it to its ceiling less what is already on order, and stock balancing reads the same floor.

Nothing changes until you set a level. A warehouse with no row of its own keeps using the item’s reorder point, so a workspace that never fills these in sees the same Reorder screen it always did.

Per item, per warehouseone row for each warehouse, beside what that warehouse holds
Floor and ceilingthe minimum triggers, the maximum is what a reorder fills up to
Measured unitslevels to three decimals for kilograms, litres and metres; whole numbers for pieces and cartons
Web, app and APIthe same table on the item page, in the mobile app and over the API
Item → Stock tab

Set the levels where you already look at the stock.

Open an item and go to its Stock tab. Under Min / max per warehouse there is a row for every warehouse in your workspace, showing what it holds, a minimum, a maximum and a status. Type the numbers, save, and they apply from the next time Reorder or stock balancing is opened.

Min / max per warehouse Replenishment
WarehouseOn handMinimumMaximumStatus
Kisumu Branch18.5 kg40120At or below minimum
Mombasa Depot255 kg50180Above maximum
Nairobi Main Store342.5 kg120400Within levels
Eldoret Site75 kg60e.g. 120Item reorder point
A greyed figure is the item’s reorder point, shown where the row is blank. Save levels
A blank row is a fallback, not a zero

Leave both boxes empty and that warehouse goes on using the item’s reorder point. Clear a row you filled earlier and its level is removed. Set only a minimum and the warehouse has a floor with no ceiling.

Levels follow the unit of measure

A kilogram, litre or metre item takes a level like 12.5. A pieces, boxes or cartons item refuses a fraction on save, so a whole-unit floor stays whole.

The ceiling cannot sit under the floor

A maximum below the minimum is refused with the row named, and so is a negative level. Only warehouses in your own workspace can be given one.

Blind counts stay blind

Someone restricted to blind counting sees the levels but not the quantities, and their status column reads Blind count. Changing a level needs the edit items permission.

What the levels drive

Three places read a warehouse’s own floor.

The level sits on the item, but the work it changes happens in procurement and in the warehouse. These are the screens that use it today.

Reorder, one warehouse at a time

On Procurement → Purchase Orders → Reorder, choose a warehouse under Stock in. Stock and open orders are then that warehouse’s alone, so a branch that is short shows up even when the company total looks fine.

  • The trigger is that warehouse’s minimum where it has one, else the item’s reorder point.
  • A warehouse that has never held the item is still offered once it has a floor, because nothing is below it.
  • Someone tied to one warehouse always sees that warehouse’s list and orders into it.

Stock balancing

Transfer suggestions compare the stock they find with the warehouse’s own minimum instead of the item’s single point, so a quiet site is no longer flagged short against a hub’s floor, and stock above a floor can be offered to a warehouse below its own.

The status on the item

Each warehouse row reads At or below minimum, Within levels, Above maximum, or Item reorder point where no row is set — the quickest way to see which branch is starving and which is sitting on more than it should.

Still on the item’s point

  • Low-stock alerts and reminders compare the item’s total stock with the item’s reorder point.
  • Reorder with no warehouse chosen works on workspace totals against the item’s reorder point.
  • The mobile Reorder screen lists workspace totals, or the warehouse a person is tied to.
How much Reorder suggests

Fill to the ceiling, less what is already on its way.

The suggested quantity is worked out from the warehouse you chose, and every figure on the row can be changed before an order is created. Goods already received against an order are not counted twice, and an order still owing goods counts until they arrive.

With a maximum

Kisumu Branch, chlorine granules

Below its 40 kg floor, so it is offered. It has a 120 kg ceiling, so the suggestion fills to that, and 25 kg already on an open order to Kisumu comes off.

Maximum120 kg
Held in Kisumu− 18.5 kg
Still to arrive− 25 kg
Suggested76.5 kg
Minimum only

Kisumu Branch, nitrile gloves

A floor of 10 cartons and no ceiling. With no reorder quantity on the item either, the target is twice the floor. Cartons are whole units, so any fraction is rounded up.

Twice the minimum20 cartons
Held in Kisumu− 3 cartons
Still to arrive− 0
Suggested17 cartons
Never held here

Nakuru, a branch opening this month

No stock has ever been there, but a floor of 30 kg and a ceiling of 90 kg were set for it. Zero is below the floor, so Nakuru gets its opening order on the first visit to Reorder.

Maximum90 kg
Held in Nakuru− 0 kg
Still to arrive− 0 kg
Suggested90 kg
1The warehouse’s maximumwhere one is set: fill up to it.
2The item’s reorder quantityon top of what is held, when there is no maximum.
3Twice the floorwhen there is neither, using the warehouse minimum.
4Less open ordersfor that warehouse; if enough is on its way, the suggestion is zero.
The item’s own point

The fallback keeps the number you typed.

Every warehouse without a level of its own leans on the item’s reorder point, so that number has to stay put. Each stock item’s reorder point is set by a switch on the item form, and the same switch is in the mobile app.

Automatic

Worked out again every night from demand: approved stock issues and adjustments plus till sales, less cancelled or voided sales and till returns, over the last 30 days.

average daily demand × lead time + safety stock, rounded up

An item with neither a lead time nor a safety stock keeps its current point instead of dropping to zero and falling off the Reorder screen.

Manual

The figure you typed is kept. Typing a new reorder point — on the web form, in the app, through the API, in an import or through item-master approval — switches the item to Manual on its own, so the nightly run never overwrites it. Switch it back to Automatic to hand it to the calculation again.

Warehouse levels are always yours. The nightly calculation only ever touches an item’s reorder point set to Automatic; a minimum or maximum you set for a warehouse is never recalculated.

Web, app and API

The same levels wherever someone edits them.

On the item page

The Stock tab table, with on-hand per warehouse, the fallback figure greyed into blank rows, and a status for each warehouse.

In the mobile app

The same table on the item’s detail screen, with the number keypad matched to the unit. It needs a connection to read or save, and says so when there is none.

Over the API

GET /api/items/{id}/warehouse-levels returns every warehouse with its level, on-hand and status; PUT saves them. Reading needs view items, saving needs edit items.

Minimum and maximum per warehouse — what ships today, and what we can add

What AWRA OpsHub does today

  • A minimum and an optional maximum per item per warehouse, edited on the item’s Stock tab, in the mobile app and over the API.
  • The item’s reorder point as the fallback for any warehouse with no level of its own, shown greyed into the blank row.
  • Validation on save: the maximum at least the minimum, no negative levels, and whole numbers for whole-unit items.
  • Levels to three decimals for measured units such as kilograms, litres and metres.
  • Reorder per warehouse, offering items at or below that warehouse’s minimum, including a warehouse that has never held the item.
  • A suggested quantity that fills to the warehouse maximum, else the item’s reorder quantity on top of what is held, else twice the minimum, less open orders for that warehouse.
  • Stock balancing judging understock and surplus against the warehouse’s own minimum.
  • A status per warehouse on the item: at or below minimum, within levels, above maximum, or on the item’s reorder point.
  • Manual reorder points kept through the nightly recalculation, with warehouse levels never recalculated.

More we can add to your workspace

  • Low-stock alerts per warehouse, so a branch manager hears about their own floor rather than the item total.
  • Levels per bin or location inside a warehouse, for pick faces and par levels on a single shelf.
  • Transfer suggestions that fill to the maximum, with surplus measured against the ceiling instead of the floor.
  • Warehouse levels calculated from each warehouse’s own demand, the way the item’s automatic reorder point is.
  • Bulk editing of levels from a spreadsheet import, for a catalogue across many branches at once.
  • A warehouse picker on the mobile Reorder screen, alongside the levels already editable in the app.

Where we point you to a specialist

  • We will not place an order because a warehouse fell below its floor. Reorder suggests; a person ticks the rows and presses the button.
  • We will not overwrite a level you set. The nightly recalculation is for item reorder points left on Automatic, and only those.
  • We will not pick your levels for you. How much a branch should hold is a decision about its customers, space and cash; the system holds each warehouse to the numbers you write down.

Low-stock alerts per warehouse and levels per bin are the two most organizations ask for first. Tell us how your branches replenish today and we will come back with a written spec, a timeline and a price.

Frequently asked questions

What happens in a warehouse where I set no level?
It keeps using the item’s reorder point, exactly as before. A level only changes things for the warehouse it is set on, so you can start with your busiest branch and leave the rest alone.
How does Reorder use a warehouse minimum and maximum?
Choose a warehouse under Stock in on the Reorder screen. An item is offered when that warehouse holds no more than its minimum, and the suggested quantity fills it to its maximum, less anything still to arrive on open orders for that warehouse.
What if a warehouse has a minimum but no maximum?
The suggestion is the item’s reorder quantity on top of what the warehouse holds, if the item has one, otherwise enough to bring the warehouse to twice its minimum.
Will a new branch with no stock be offered anything?
Yes, once you give it a minimum for the item. A warehouse with a floor and nothing on hand is below that floor, so Reorder offers it even though the warehouse has never held the item.
Can levels have decimals?
For measured units, yes: kilograms, litres, metres and the like take up to three decimals. Items counted in whole units, such as pieces, boxes and cartons, take whole numbers only, and suggestions for them are rounded up.
Does the nightly reorder point calculation change my warehouse levels?
No. It only recalculates an item’s reorder point that is set to Automatic. A reorder point you typed is Manual and kept, and warehouse levels are never recalculated.
Do low-stock alerts follow the warehouse level?
Not today. Low-stock alerts and reminders compare the item’s total stock with the item’s reorder point. Use Reorder with a warehouse chosen for branch-level replenishment; alerts per warehouse are something we can add to your workspace.
Can I edit levels from the mobile app or an integration?
Yes. The item’s detail screen in the app has the same table, and the API reads and saves levels at /api/items/{id}/warehouse-levels. Saving needs the edit items permission.

Help Center

Need a quick answer while you read?

Run inventory, procurement, assets, sales, and field work with approved AWRA guidance for setup, migration, integrations, security, pricing, and support.

Search all approved AWRA public help articles.

Open Help Center