Stock Query

Query warehouse inventory by location.

Stock Query Guide

1. The stock table shows on-hand qty by warehouse, location, LOT, and item (tb_stock).
2. Filter by warehouse or item code using the sidebar; click a row to expand LOT details.
3. Use Adjust Stock in the sidebar to correct discrepancies — requires a reason code.
4. Recalculate Stock recomputes on-hand quantities from all confirmed transactions.
5. Use the Copilot tab to query stock levels, low-stock alerts, or location fill rates.