How to check current stock on hand

Stock-on-hand is the answer to 'how many do we have right now', warehouse by warehouse. HotelBee computes it live from every inventory event since the warehouse opened, so it's always current — no closing batch, no nightly job. Two screens show it. Pick based on whether you want a list (everything) or a deep-dive (one product).

View 1 — Products list (everything at a glance)

1. Go to POS → Products. The table shows every product.
2. Use the warehouse filter at the top to scope to one warehouse. The quantity column then shows that warehouse's level for each product.
3. Sort the quantity column ascending to surface the products closest to running out.
4. Filter by category (Beers, Wines, Cleaning Supplies) when you want a focused subset rather than the whole catalog.
5. Export the visible list to Excel/CSV when you need to share with the buyer or do offline analysis.

View 2 — Product page (deep-dive for one item)

1. Click a product name from the products list (or search for it directly).
2. Inventory section shows quantity per warehouse — Bar: 12, Main Store: 240, Pool Bar: 0. The total across warehouses is the property-wide stock for that product.
3. The audit trail (or movements list) below shows the history — every PO that brought stock in, every sale that took stock out, every transfer between warehouses. This is the answer to 'why does the bar say 12 when I expected 30'.

When to use which

• Products list = browsing, daily low-stock check, weekly buyer prep, monthly catalog audit.
• Product page = investigation. "This is what the system says for this one product, and here's how it got there." Use when a number doesn't match the shelf and you need to trace.

Reading the numbers honestly

• Negative quantity = something was sold or deducted that the system thinks you didn't have. Usually means a PO wasn't recorded, or stock was used before being received. Investigate, don't ignore.
• Round numbers everywhere = nobody has done a real count in a long time. The system is showing you book stock, not physical stock. Schedule a count.
• Sudden drop in stock-on-hand without a corresponding sale spike = check inventory deductions and adjustments for that period. Someone wrote off without flagging it.
• Slow-moving stock = the products list with quantity descending shows what you have too much of. Useful for promo / spoilage decisions.

Multi-warehouse properties

If you operate two or more warehouses (Main Store + Bar + Pool Bar), the products list defaults to a totalled view across all warehouses. Switch the warehouse filter to see one at a time. The product page always shows the per-warehouse breakdown — it's the cleanest place to compare distribution. When the bar is low and the main store is overflowing, that's a transfer, not a PO.

What this view doesn't show

• Cost. The quantity is what's there; cost-per-unit is on the product's own settings (and on each PO). For valuation, multiply quantity × cost.
• Pending POs. Stock that's ordered but not yet received doesn't count. The Inventory module's pending list shows those separately.
• Allocations. There's no concept of 'reserved for tomorrow's banquet' — what's shown is what's available.