# Bugs with Inventory Quantity by Location report

**URL:** <https://forum.manager.io/t/bugs-with-inventory-quantity-by-location-report/28450>\
**Category:** Uncategorized\
**Created:** [May 28, 2020, 4:05pm UTC](https://forum.manager.io/t/bugs-with-inventory-quantity-by-location-report/28450 "2020-05-28T16:05:53Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**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:** [May 28, 2020, 4:05pm UTC](https://forum.manager.io/t/bugs-with-inventory-quantity-by-location-report/28450/1 "2020-05-28T16:05:53Z")

</div>

In version 20.5.90, there are serious errors in this report. Here is a sample report:

 ![Screen Shot 2020-05-28 at 9.56.07 AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/6/6/6645a3a3b21dd88741429196016ea72b76b967da.png)

But only 2 inventory locations are defined:

 ![Screen Shot 2020-05-28 at 9.56.07 AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/6/6/6645a3a3b21dd88741429196016ea72b76b967da.png)

The one now named _North warehouse (edited)_ was previously named _North warehouse_. Editing the name did not change it on the report, it added the new name. But no transactions have been entered since editing the name.

Further, drill-downs are erroneous. Clicking the _12_ for the table lamp in the north warehouse produces the following, irrespective of which general ledger engine is enabled:

![Screen Shot 2020-05-28 at 10.00.44 AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/e/6/e68cd65829b4e3922e2862ebe9538c98619f11ba.png)

Clicking the _5_ for the north warehouse (edited) produces exactly the same thing.

Clicking on _10_ for the lamp kit produces an empty screen, as do all other quantities under the north warehouse column:

![Screen Shot 2020-05-28 at 10.04.27 AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/d/7/d701317b374d3b86e85f749fec308484eac2da1b.png)

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [May 29, 2020, 12:09am UTC](https://forum.manager.io/t/bugs-with-inventory-quantity-by-location-report/28450/2 "2020-05-29T00:09:56Z")

</div>

Should be fixed in the latest version (20.5.93)

---

<div class="post-metadata">

**Author:** ![HKB](https://avatars.discourse-cdn.com/v4/letter/h/ccd318/32.png) [@HKB](https://forum.manager.io/u/HKB)\
**Post date:** [June 29, 2020, 8:59pm UTC](https://forum.manager.io/t/bugs-with-inventory-quantity-by-location-report/28450/3 "2020-06-29T20:59:09Z")

</div>

Manager Desktop version 20.7.54  
Inventory quantity by location report is not incorporating impact of production orders in entirety i.e. the impact of finished good is not reflected. We have 2 different warehouses where manufacturing takes place. Raw material is received via “Goods Receipts” in respective warehouses where finished goods are produced via “Production Order”. The finished goods are then transferred to central warehouse from where they are sold. Attaching output of said report. Had drilled down in the negative balances and it reflects inventory transfers to Central warehouse. Let me know if you need further details.

 ![Capture](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/6/f/6fde655f7901b46f291840b86ac7cfa5c35f41fd.png)

---

<div class="post-metadata">

**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:** [June 29, 2020, 9:20pm UTC](https://forum.manager.io/t/bugs-with-inventory-quantity-by-location-report/28450/4 "2020-06-29T21:20:33Z")

</div>

Do you have production orders with insufficient quantities? Read the Guide: [Understand insufficient quantity on a production order | Manager](https://www.manager.io/guides/29016). If quantities are insufficient, the production order is not transferred into _Inventory on hand_. Subsequent inventory transfers would be of quantities not yet owned from accounting perspective.

This more rigorous treatment of production orders was introduced about a week ago.

---

<div class="post-metadata">

**Author:** ![HKB](https://avatars.discourse-cdn.com/v4/letter/h/ccd318/32.png) [@HKB](https://forum.manager.io/u/HKB)\
**Post date:** [June 29, 2020, 9:46pm UTC](https://forum.manager.io/t/bugs-with-inventory-quantity-by-location-report/28450/5 "2020-06-29T21:46:33Z")

</div>

@Tut all production orders are complete. I have rechecked them, none is marked with insufficient quantity. Our production process is T+1 i.e. If raw material is received on 8 June then production will be done on 9 June and finished item will be transferred to central warehouse on 10 June. The same date order is reflected in goods receipts and purchase invoice, production order and inventory transfer respectively.

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [June 29, 2020, 9:53pm UTC](https://forum.manager.io/t/bugs-with-inventory-quantity-by-location-report/28450/7 "2020-06-29T21:53:40Z")

</div>

I’m able to reproduce the issue. It’s a bug with the report. Fixing now

---

<div class="post-metadata">

**Author:** ![HKB](https://avatars.discourse-cdn.com/v4/letter/h/ccd318/32.png) [@HKB](https://forum.manager.io/u/HKB)\
**Post date:** [June 29, 2020, 9:55pm UTC](https://forum.manager.io/t/bugs-with-inventory-quantity-by-location-report/28450/8 "2020-06-29T21:55:40Z")

</div>

Many thanks @lubos

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [June 29, 2020, 9:59pm UTC](https://forum.manager.io/t/bugs-with-inventory-quantity-by-location-report/28450/9 "2020-06-29T21:59:22Z")

</div>

@HKB could you check the latest version (20.7.55) ? Both reports `Inventory Quantity by Location` and `Inventory Quantity Summary` were affected because they didn’t consider new production order implementation. They do now.

---

<div class="post-metadata">

**Author:** ![HKB](https://avatars.discourse-cdn.com/v4/letter/h/ccd318/32.png) [@HKB](https://forum.manager.io/u/HKB)\
**Post date:** [June 30, 2020, 5:18am UTC](https://forum.manager.io/t/bugs-with-inventory-quantity-by-location-report/28450/10 "2020-06-30T05:18:53Z")

</div>

@lubos it is working fine now…thanks a lot for your prompt response.

---

<div class="post-metadata">

**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:55pm UTC](https://forum.manager.io/t/bugs-with-inventory-quantity-by-location-report/28450/11 "2023-01-18T14:55:01Z")

</div>


