# Filtering on inventory quantity by location report **URL:** \ **Category:** Uncategorized\ **Created:** [September 23, 2019, 9:07am UTC](https://forum.manager.io/t/filtering-on-inventory-quantity-by-location-report/24409 "2019-09-23T09:07:00Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![roger3820](https://avatars.discourse-cdn.com/v4/letter/r/838e76/32.png) [@roger3820](https://forum.manager.io/u/roger3820)\ **Post date:** [September 23, 2019, 9:07am UTC](https://forum.manager.io/t/filtering-on-inventory-quantity-by-location-report/24409/1 "2019-09-23T09:07:00Z")
is it possible to have filtering in the inventory quantity by location report, like base on codes, or group of items, this is to trim down inventory on hand reconciliation, most of the time, there are group of items that needs to be reconciled more often, e.g. im selling eggs, and it has sizes, like small, medium, large, extra large, jumbo, there are time in the store, my sales clerks, sells it not in their respective sizes, undersizing or oversizing it…making me most of the time reconciling it, it would be helpful if i could quickly look on the records or summary without printing all the summary of the items on hand. ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [September 23, 2019, 12:42pm UTC](https://forum.manager.io/t/filtering-on-inventory-quantity-by-location-report/24409/2 "2019-09-23T12:42:27Z")
Why not just look in the Inventory Items tab for the quantity of the desired item? You can search and sort according to codes, item names, descriptions, custom field content, etc. ---
**Author:** ![San\_Thida\_Myo\_Latt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/san_thida_myo_latt/32/16513_2.png) [@San\_Thida\_Myo\_Latt](https://forum.manager.io/u/San_Thida_Myo_Latt)\ **Post date:** [January 10, 2020, 7:15am UTC](https://forum.manager.io/t/filtering-on-inventory-quantity-by-location-report/24409/3 "2020-01-10T07:15:15Z")
I am agree to have filter on “Inventory Quantity by Location report”. We had 1000 + items, we don’t want to show cost to staff. But they need to know qty on hand, so that if Manager can allow user to filter by location and item code or description will be very effective for user. ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [January 10, 2020, 12:35pm UTC](https://forum.manager.io/t/filtering-on-inventory-quantity-by-location-report/24409/4 "2020-01-10T12:35:33Z")
@San_Thida_Myo_Latt, that is what the Inventory Quantity by Location report already does. Quantities for each item are divided by location. If you use item codes, those are shown. The report cannot filter by description because that field is not part of the report. ---
**Author:** ![Genti\_Ge](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/genti_ge/32/14096_2.png) [@Genti\_Ge](https://forum.manager.io/u/Genti_Ge)\ **Post date:** [January 10, 2020, 2:13pm UTC](https://forum.manager.io/t/filtering-on-inventory-quantity-by-location-report/24409/5 "2020-01-10T14:13:38Z")
they can use report and use search Ctrl+F (windows) to find the item they need so they dont have to scroll the list of 1000+ items just for looking if there is qty available if they need to filter items for further reporting export to excel then filter there i belive this there simple enough solutions ---
**Author:** ![San\_Thida\_Myo\_Latt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/san_thida_myo_latt/32/16513_2.png) [@San\_Thida\_Myo\_Latt](https://forum.manager.io/u/San_Thida_Myo_Latt)\ **Post date:** [January 11, 2020, 3:58am UTC](https://forum.manager.io/t/filtering-on-inventory-quantity-by-location-report/24409/6 "2020-01-11T03:58:27Z")
yes, thanks for your solution, I know that we can do that way but it will not be convenience for all user I just want to advise to improve Manager like other software ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/6/f646dbd04c736375c1e451332918f682af2760ce.png) ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [January 18, 2023, 2:57pm UTC](https://forum.manager.io/t/filtering-on-inventory-quantity-by-location-report/24409/7 "2023-01-18T14:57:46Z")