This article gives you an overview of the Quick Stock Balance report which delivers real-time visibility into stock quantity and value for any item across warehouses.
A lightweight report that shows:
✔ Current stock quantity
✔ Inventory value
✔ Warehouse-specific availability
Key Advantages:
No report generation needed – Get answers in 2 clicks
Date-filtering – Check historical stock positions
Audit-ready – Verify physical counts against system records instantly
Perfect for:
Pre-transaction stock checks
Spot audits
Year-end inventory reconciliation
Navigation Path:
Home > Stock > Tools > Quick Stock Balance
Select an Item (by name, code, or barcode scan)
Choose a Warehouse
View real-time:
Available Quantity
Total Stock Value
Date Selection: Check stock status on any past/future date
Multi-Warehouse: Compare availability across locations
Click 'Stock Balance Report' to:
Open the full report pre-filtered with your selections
Access additional data like batch/serial numbers
Scenario: Physical count shows 150 units, but system says 142.
Solution:
Current system quantity
Recent adjustments via date filters
Before processing:
Sales Invoices → Confirm stock availability
Purchase Returns → Validate original receipt quantities
Check source warehouse availability
Verify destination warehouse capacity
Identify the last good count date by testing historical dates.
Quickly pull inventory values for month-end accruals.