# Inventory Kits in Custom Reports **URL:** \ **Category:** Uncategorized\ **Created:** [June 25, 2020, 6:30am UTC](https://forum.manager.io/t/inventory-kits-in-custom-reports/28962 "2020-06-25T06:30:13Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [June 25, 2020, 6:30am UTC](https://forum.manager.io/t/inventory-kits-in-custom-reports/28962/1 "2020-06-25T06:30:13Z")
Dear @lubos, I’m trying to extract sales related to an Inventory Item in Custom Reports. However, since they where done through Inventory Kits, I cannot see them. They are linked only to the Inventory Kits and not to Inventory Item. I think that since an Inventory Kit is linked to many Inventory Item through quantities they should be linked also in the query. Thanks ---
**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 26, 2020, 9:22pm UTC](https://forum.manager.io/t/inventory-kits-in-custom-reports/28962/2 "2020-06-26T21:22:21Z")
When it comes to selling inventory kit, it will be single general ledger transaction into income account. Manager cannot break it down into multiple transactions by inventory item because it cannot possibly know how much of sale amount to attribute to each inventory item. So you can get sales by item which are either inventory items or inventory kits. But I just realized `Item` field is not yet exposed. Would this solve the issue? ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [June 26, 2020, 9:31pm UTC](https://forum.manager.io/t/inventory-kits-in-custom-reports/28962/3 "2020-06-26T21:31:00Z")
Sorry but I cannot understand your proposal. Which Item field? ---
**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 26, 2020, 9:35pm UTC](https://forum.manager.io/t/inventory-kits-in-custom-reports/28962/4 "2020-06-26T21:35:02Z")
Can you show screenshot of your custom report definition instead? I will explain on your particular example. ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [June 26, 2020, 9:44pm UTC](https://forum.manager.io/t/inventory-kits-in-custom-reports/28962/5 "2020-06-26T21:44:54Z")
![Screenshot_20200626-234026](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/6/0/601d16479e10f964d46ea8977e7397252103ea3b.jpeg) I would like to see the permutation with all of the inventory items linked to this list but I understand perfectly that your queries are all linked to a single line of a transaction. ![Screenshot_20200626-234207](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/0/4/0490912e0a959e95eb89ee6839c74f248dcba93f.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:** [June 26, 2020, 9:48pm UTC](https://forum.manager.io/t/inventory-kits-in-custom-reports/28962/6 "2020-06-26T21:48:43Z")
Do you also sell inventory items or you sell inventory kits only? ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [June 26, 2020, 9:51pm UTC](https://forum.manager.io/t/inventory-kits-in-custom-reports/28962/7 "2020-06-26T21:51:30Z")
Only inventory kits ---
**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 26, 2020, 9:55pm UTC](https://forum.manager.io/t/inventory-kits-in-custom-reports/28962/8 "2020-06-26T21:55:08Z")
You don’t seem to be selecting any amount on your custom report. If you don’t care about the amount, then work with cost of goods sold transactions instead of sales transactions. Cost of goods sold transactions have both `Inventory Item` and `Inventory Kit` field filled in. This was actually fixed yesterday > [@Inventory kit items not showing under Inventory - cost](https://forum.manager.io/t/inventory-kit-items-not-showing-under-inventory-cost/28985): > > When an inventory kit is sold, the inventory items that make it up are not listed in drill-downs on the Inventory - cost account. In the example below, an inventory kit with 4 components was sold on sales invoice #2. But it is impossible to know which cost applies to which item: ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [June 26, 2020, 9:59pm UTC](https://forum.manager.io/t/inventory-kits-in-custom-reports/28962/9 "2020-06-26T21:59:39Z")
It works! Thanks a lot! ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [June 27, 2020, 7:20am UTC](https://forum.manager.io/t/inventory-kits-in-custom-reports/28962/10 "2020-06-27T07:20:45Z")
I also find out that, under custom reports, custom fields in the form of numbers are not summed in subtotals and dates, again in custom fields, are not formatted correctly following Preferences. Can I also ask why quantity is not shown in my new report? ![Screenshot_20200627-150116~2](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/3/83c28c5696617876e5b6e46250b7332a443dad73.jpeg) ---
**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/inventory-kits-in-custom-reports/28962/11 "2023-01-18T14:46:51Z")