The Inv Status column on the Inventory list tells you, at a glance, which items need attention. It's worked out from your stock numbers and the reorder points you set for each item.
How it's worked out
Brahmin Solutions takes the stock you'll have once open orders ship and open purchase orders arrive:
On hand − Allocated + Expected
Then it compares that number with the item's minimum and maximum:
Status | When |
Out | The number is below zero. Orders need more than you have and have coming in |
Low | The number is below the item's minimum |
Excess | The number is above the item's maximum (only when a maximum is set) |
Healthy | Anything else |
Three real examples
Item | Calculation | Min / Max | Status |
Stoneware dripper | 48 on hand − 42 allocated = 6 | Min 12 | Low |
Cold brew concentrate | 96 − 12 + 48 expected = 132 | Max 96 | Excess |
A new item | 0 on hand − 2 allocated = −2 | — | Out |
The cold brew is a useful one. On hand is exactly at its maximum, but a purchase order for 48 more is already confirmed, so it reads Excess. That's a cue to check whether the purchase order is still needed.
Items with no reorder points
If an item has no minimum or maximum, both count as zero. So it shows Healthy as long as you aren't short, and Out only when orders need more than you have. It never shows Low or Excess.
To get Low warnings, set a minimum for the item.
