# Stock summary report(custom) **URL:** https://forum.manager.io/t/stock-summary-report-custom/29958 **Category:** Uncategorized **Created:** [August 10, 2020, 9:02am UTC](https://forum.manager.io/t/stock-summary-report-custom/29958 "2020-08-10T09:02:05Z") **Posts on this page:** 8 **Page:** 1
### Author: ![meesam](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/meesam/32/43747_2.png) [@meesam](https://forum.manager.io/u/meesam) #### Post date: [August 10, 2020, 9:02am UTC](https://forum.manager.io/t/stock-summary-report-custom/29958/1 "2020-08-10T09:02:06Z")
Hello Managers, I create a report in custom reports for stock summary by custom field the problem is report shows double quantity of invoices how it fix .? Invoices total Qty is:- Dostea 175ml = 14 Dostea 112ml= 4 But it double see the report See the report and invoices below ![Screenshot_2020-08-10 IQBAL SONS — Sales Invoice — 290 — View](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/e/a/ea0284523d0f80307b83fb5c7bc18d8214d63996.png) ![Screenshot_2020-08-10 IQBAL SONS — Sales Invoice — 291 — View](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/2/5231a91190774b6174cf2b29e4f50ef9f66d6f1f.png) ![Screenshot_2020-08-10 IQBAL SONS — Custom Report — Edit](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/e/b/eb0b03c6276a8c2600a9526813ba3b7b654e7358.png) ![Screenshot_2020-08-10 IQBAL SONS — PICK LIST](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/a/2a14d95c49b78025b6112453400031fb273b73d2.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: [August 10, 2020, 9:07am UTC](https://forum.manager.io/t/stock-summary-report-custom/29958/2 "2020-08-10T09:07:37Z")
Do not use `Groups to collapse` checkbox until your custom reports show the right transactions. So first, uncheck `Groups to collapse` checkbox and then see what you get. ---
### Author: ![meesam](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/meesam/32/43747_2.png) [@meesam](https://forum.manager.io/u/meesam) #### Post date: [August 10, 2020, 9:14am UTC](https://forum.manager.io/t/stock-summary-report-custom/29958/3 "2020-08-10T09:14:17Z")
Thanks for your kind rply @lubos I try as you say please check this pics problem still ![IMG_20200810_141112](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/4/9/49ad559ab6ca9b5dc6ce506bb7a5f36b472aeb4a.jpeg) ---
### 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: [August 10, 2020, 9:15am UTC](https://forum.manager.io/t/stock-summary-report-custom/29958/4 "2020-08-10T09:15:31Z")
Add `Account` column to your `Select...` section so you can see what accounts are these quantities posted to. ---
### Author: ![meesam](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/meesam/32/43747_2.png) [@meesam](https://forum.manager.io/u/meesam) #### Post date: [August 10, 2020, 9:22am UTC](https://forum.manager.io/t/stock-summary-report-custom/29958/5 "2020-08-10T09:22:33Z")
Add account please check ![55](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/d/0/d0ab40f41af53f4b1c8c1ed212355926cf978a7e.png) ![IMG\_20200810\_141126|375x500] ![56](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/4/9479803a77593f493ff9b609a1a1cee8465b72c9.png) Still problem in quantity ---
### 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: [August 10, 2020, 9:30am UTC](https://forum.manager.io/t/stock-summary-report-custom/29958/6 "2020-08-10T09:30:32Z")
Now you see sales invoice makes two transactions for each inventory item. One to `Inventory on hand` account and the other one to `Inventory - sales` account. So you just need to filter out one of those two accounts. For example, if you want to see `Inventory on hand` transactions only, you can do something like… `Where... - Account - Name - Contains - Inventory on hand` This will eliminate `Inventory - sales` account transactions. ---
### Author: ![meesam](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/meesam/32/43747_2.png) [@meesam](https://forum.manager.io/u/meesam) #### Post date: [May 23, 2021, 9:33pm UTC](https://forum.manager.io/t/stock-summary-report-custom/29958/7 "2021-05-23T21:33:20Z")
@lubos got it thanks sir 👍 ---
### 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:46pm UTC](https://forum.manager.io/t/stock-summary-report-custom/29958/8 "2023-01-18T14:46:21Z")