# Bin wise Report
Opening, inward, outward and closing stock for each warehouse bin over a selected period. Expand each bin to see the items it holds, with optional value columns.
> Availability note. This report is currently turned off in the standard build — its menu entry is disabled. If you do not see Bin wise Report under Inventory Reports, it has not been enabled for your account. Contact support to enable bin-level reporting.
Overview
Go to Inventory → Inventory Reports → Bin wise Report.
Report title in ERP: Bin Wise Inventory Report
What it shows. One row per warehouse bin (Inventory Bin) with the Opening, In, Out and Closing quantity for the selected date range. Turn on Show Items to expand each bin into its items, and Show Value to add value columns under each stage.
When to use it. Use in warehouses that track stock by bin, to verify bin contents, and to follow movement in and out of a bin during a period.
Screenshot pending — Bin Wise Inventory Report list view.
Use Cases
- Warehouse supervisor — How much stock sits in each bin and what moved during the period? Review In, Out and Closing per bin.
- Store keeper — Which items are stored in a particular bin? Turn on Show Items to expand.
- Inventory controller — What is the valued balance held in each bin? Turn on Show Value.
- Auditor — Do physical bin contents match the system? Use this report during bin-level stock checks.
Filters
Date range and Item Group. Advanced Filter: Item, Item Type, Center, Brand, Item Group.
Columns
| **Column** | **Description** |
|------------|-----------------|
| Inventory Bin | Warehouse bin name. |
| Item | Item name (shown when Show Items is on). |
| Opening | Quantity (and value) at the start of the period. |
| In | Quantity (and value) received during the period. |
| Out | Quantity (and value) issued during the period. |
| Closing | Quantity (and value) at the end of the period. |
When Show Value is on, the Opening, In, Out and Closing stages each show a Qty and Value sub-column.
Actions
- Generate — run the report for the selected filters
- Export — export the report to Excel
- Print — print the report
- More — toggle Show Items, Show Value, and Show Zero Lines
- Advanced Filter — open additional filter fields
- clear — reset active advanced filters
FAQ
What is an Inventory Bin?
A bin is a precise storage location within a warehouse (such as an aisle, rack, shelf or bin). Bins are set up under Aisle, Rack, Shelves, Bins.
How do I see the items inside a bin?
Choose Show Items from the More menu to expand each bin.
How do I add value columns?
Select Show Value from the More menu.
I don't store stock by bin — is this report useful?
This report only has data when items are stored against bins. If you don't use bins, use the Centre wise Report instead.
Why is my report empty?
Bin tracking may be disabled, or no stock is recorded against bins at the filtered center.
Why does a bin not appear in filters?
Bin lists may include only bins that currently hold stock for the selected item and center.
Where are bins configured?
Under Aisle, Rack, Shelves & Bins and item line fields in Inventory Settings.