# Inventory Qty Movement doesn't show the right result **URL:** \ **Category:** Uncategorized\ **Created:** [June 2, 2020, 9:54am UTC](https://forum.manager.io/t/inventory-qty-movement-doesnt-show-the-right-result/28527 "2020-06-02T09:54:33Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![jerry\_tombokan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/jerry_tombokan/32/19847_2.png) [@jerry\_tombokan](https://forum.manager.io/u/jerry_tombokan)\ **Post date:** [June 2, 2020, 9:54am UTC](https://forum.manager.io/t/inventory-qty-movement-doesnt-show-the-right-result/28527/1 "2020-06-02T09:54:33Z")
I’ve been using this report and print it at the end of every month Please take a look at the following image of the report for May 2020 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/a/2/a2a8a5a35d2474c91229f8a80bfcf5c1bc0b66bc.png) The adjustment qty of Product D doesn’t show the correct number (the actual adjustment qty should only -1.8) . The closing balance shows the correct number ---
**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 2, 2020, 10:04am UTC](https://forum.manager.io/t/inventory-qty-movement-doesnt-show-the-right-result/28527/2 "2020-06-02T10:04:38Z")
I’m moving this to the bugs category but only because this report doesn’t allow to drill-down. When drilling-down is implemented you can review how the figure was calculated and it will be easier to figure out what’s wrong. ---
**Author:** ![jerry\_tombokan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/jerry_tombokan/32/19847_2.png) [@jerry\_tombokan](https://forum.manager.io/u/jerry_tombokan)\ **Post date:** [June 2, 2020, 10:21am UTC](https://forum.manager.io/t/inventory-qty-movement-doesnt-show-the-right-result/28527/3 "2020-06-02T10:21:17Z")
> [@lubos](#): > > When drilling-down is implemented you can review how the figure was calculated and it will be easier to figure out what’s wrong Thank you @lubos Yes, that’ll certainly would make it easier for us to see how the numbers are calculated ---
**Author:** ![Isabelle\_Rousseau](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/isabelle_rousseau/32/24506_2.png) [@Isabelle\_Rousseau](https://forum.manager.io/u/Isabelle_Rousseau)\ **Post date:** [June 2, 2020, 5:00pm UTC](https://forum.manager.io/t/inventory-qty-movement-doesnt-show-the-right-result/28527/4 "2020-06-02T17:00:15Z")
same probleme like me ---
**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 2, 2020, 9:09pm UTC](https://forum.manager.io/t/inventory-qty-movement-doesnt-show-the-right-result/28527/5 "2020-06-02T21:09:05Z")
The latest version (20.6.27) allows drill-down into the report so check it again if this issue persists. ---
**Author:** ![jerry\_tombokan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/jerry_tombokan/32/19847_2.png) [@jerry\_tombokan](https://forum.manager.io/u/jerry_tombokan)\ **Post date:** [June 3, 2020, 1:10am UTC](https://forum.manager.io/t/inventory-qty-movement-doesnt-show-the-right-result/28527/6 "2020-06-03T01:10:27Z")
Now the report looks different. Please keep as it was; Add back the adjustments column and put the credit/debit notes and inventory write-off in adjustments. Credit/debit notes are refunds and should be reported separate from actual purchases/sales. Previously transactions from credit notes, debit notes and inventory write-offs went to adjustments (gain/loss). Now I see from the drill-down, debit notes are in purchases. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/3/23ac71b220125bd5b4d23f7636a5deedcac8cf80.png) ---
**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 3, 2020, 1:16am UTC](https://forum.manager.io/t/inventory-qty-movement-doesnt-show-the-right-result/28527/7 "2020-06-03T01:16:10Z")
The reason why I didn’t like adjustments colum is because it was too generic. How about having `Debit Notes` and `Credit Notes` as separate columns. Wouldn’t that be even better? ---
**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 3, 2020, 1:54am UTC](https://forum.manager.io/t/inventory-qty-movement-doesnt-show-the-right-result/28527/8 "2020-06-03T01:54:30Z")
Where are journal entries? ---
**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 3, 2020, 2:09am UTC](https://forum.manager.io/t/inventory-qty-movement-doesnt-show-the-right-result/28527/9 "2020-06-03T02:09:31Z")
The report automatically shows only columns which are actually used. If you have no journal entries interacting with inventory items, the column won’t show. ---
**Author:** ![jerry\_tombokan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/jerry_tombokan/32/19847_2.png) [@jerry\_tombokan](https://forum.manager.io/u/jerry_tombokan)\ **Post date:** [June 3, 2020, 3:48am UTC](https://forum.manager.io/t/inventory-qty-movement-doesnt-show-the-right-result/28527/10 "2020-06-03T03:48:56Z")
> [@lubos](#): > > How about having `Debit Notes` and `Credit Notes` as separate columns. Wouldn’t that be even better? Yes @lubos it would work for us ---
**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 3, 2020, 7:21am UTC](https://forum.manager.io/t/inventory-qty-movement-doesnt-show-the-right-result/28527/11 "2020-06-03T07:21:48Z")
The version 20.6.36 shows credit notes and debit notes separately. ---
**Author:** ![jerry\_tombokan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/jerry_tombokan/32/19847_2.png) [@jerry\_tombokan](https://forum.manager.io/u/jerry_tombokan)\ **Post date:** [June 3, 2020, 10:37am UTC](https://forum.manager.io/t/inventory-qty-movement-doesnt-show-the-right-result/28527/12 "2020-06-03T10:37:25Z")
The report looks good now. Thanks @lubos ---
**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/inventory-qty-movement-doesnt-show-the-right-result/28527/13 "2023-01-18T14:55:23Z")
Closed on January 18, 2023, 2:55pm UTC