# Inventory Profit Margin report bug when Inventory Kits are sold **URL:** \ **Category:** Uncategorized\ **Created:** [May 20, 2017, 12:06am UTC](https://forum.manager.io/t/inventory-profit-margin-report-bug-when-inventory-kits-are-sold/9631 "2017-05-20T00:06:00Z")\ **Posts on this page:** 13\ **Page:** 1
**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 20, 2017, 12:06am UTC](https://forum.manager.io/t/inventory-profit-margin-report-bug-when-inventory-kits-are-sold/9631/1 "2017-05-20T00:06:00Z")
The Inventory Profit Margin report is overstating sales when inventory kits are sold. For this example, I created an inventory kit with three items, selling for 55.99: ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/1/1feab4f3a37e471cf984d75788b0b0fd88c7660a.png) I then sold one kit. The Inventory Quantity Movement and Inventory Value Movement reports look fine, showing proper adjustments of the components’ quantities and values. But the Inventory Profit Margin report has a problem: ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/f/f16de74d4889e05d67331d32833453f844255830.png) The report above is for a time range that includes one sale of the inventory kit and no other inventory items. The Sales figure for each component of the kit lists the full sales price of the entire kit. In this case, total sales should have been 55.99. Total cost of sales is correct. Total Profit should have been 33.77 and total Margin 60.31%. Yet a P&L for the same time period is correct. It seems the Inventory Profit Margin report needs a method for apportioning sales among components of inventory kits. As things stand, the report distorts profitability for any period that includes kit sales by overstating the sales figures. The most obvious solution is to apportion sales to components based on their costs. But other options might exist. Or the margin report might report margin for the kit rather than include kit sales in component margins. ---
**Author:** ![abdulbari](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abdulbari/32/20703_2.png) [@abdulbari](https://forum.manager.io/u/abdulbari)\ **Post date:** [January 30, 2018, 8:00am UTC](https://forum.manager.io/t/inventory-profit-margin-report-bug-when-inventory-kits-are-sold/9631/4 "2018-01-30T08:00:28Z")
Dear @lubos could please kindly let us know. when this bug could be resolved ---
**Author:** ![bakerkanash](https://avatars.discourse-cdn.com/v4/letter/b/34f0e0/32.png) [@bakerkanash](https://forum.manager.io/u/bakerkanash)\ **Post date:** [March 23, 2018, 11:48pm UTC](https://forum.manager.io/t/inventory-profit-margin-report-bug-when-inventory-kits-are-sold/9631/5 "2018-03-23T23:48:38Z")
Hi all I am facing the same issue which is confusing for me Did any one got the answer for this ---
**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:** [March 24, 2018, 1:05am UTC](https://forum.manager.io/t/inventory-profit-margin-report-bug-when-inventory-kits-are-sold/9631/6 "2018-03-24T01:05:27Z")
> [@bakerkanash](#): > > Did any one got the answer for this Only @lubos can resolve this with a program change. ---
**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:** [March 24, 2018, 11:52pm UTC](https://forum.manager.io/t/inventory-profit-margin-report-bug-when-inventory-kits-are-sold/9631/7 "2018-03-24T23:52:41Z")
This bug will be fixed but as it stands now, it cannot be fixed right away. It turns out how general ledger engine has been developed, it cannot support this report if inventory kits are used. That is a good thing, it made me realize of some shortcomings I need to address but it is a bit longer process as quite a few design decisions I made long time ago have to be reverted and rewritten. I’m slowly chewing through it. After all, I don’t want to see bugs in the program myself. ---
**Author:** ![bakerkanash](https://avatars.discourse-cdn.com/v4/letter/b/34f0e0/32.png) [@bakerkanash](https://forum.manager.io/u/bakerkanash)\ **Post date:** [June 23, 2018, 10:45pm UTC](https://forum.manager.io/t/inventory-profit-margin-report-bug-when-inventory-kits-are-sold/9631/8 "2018-06-23T22:45:46Z")
Is there any update on this issue? ---
**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:** [October 6, 2018, 7:32am UTC](https://forum.manager.io/t/inventory-profit-margin-report-bug-when-inventory-kits-are-sold/9631/9 "2018-10-06T07:32:24Z")
The latest version (18.10.25) is fixing this issue by simply excluding sales of inventory kits. It turns out, calculating profit margin on sales of inventory kits is not as simple. Let me explain. You have 6 inventory items on hand at $30 each and make a sale of 9 inventory items for $50 each. Since you are 3 inventory items short, Manager will calculate profit margin as if you sold only 6 items. That is sale = $300 and cost of goods sold = $180. The reason why Manager does it this way is to make sure your cost of goods sold figures are not deflated when you sell more than you have on hand. For profit margin purposes, Manager will calculate your profit margin only on items where the cost price is known. Why is this approach tricky when it comes to inventory kits? Well… Let’s say you have a kit called `Notebook & Pencil` for $10 which consists of 1x Notebook and 1x Pencil. You sell the kit but you have no pencils on hand. Only notebooks. Since the cost of pencil is not known, Manager wouldn’t know how much of this $10 of sale should be attributed to notebook. There are several ideas I have to solve this issue but until then, so this bug doesn’t linger in Manager forever, inventory profit margin report will exclude sales of inventory kits for now. If you need inventory profit margin report for inventory kits, that will be new feature. ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [February 21, 2019, 6:05am UTC](https://forum.manager.io/t/inventory-profit-margin-report-bug-when-inventory-kits-are-sold/9631/10 "2019-02-21T06:05:36Z")
Dear @lubos, how about a separate report only stating how many inventory kits were sold with details of their composition and the buyers? A sort of sale by inventory kit without any margin. ---
**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, 11:16pm UTC](https://forum.manager.io/t/inventory-profit-margin-report-bug-when-inventory-kits-are-sold/9631/11 "2020-05-29T23:16:32Z")
The latest version (20.6.5) is finally fixing this issue. Inventory kits are now on the report as well. ---
**Author:** ![fahadalarab](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/fahadalarab/32/49040_2.png) [@fahadalarab](https://forum.manager.io/u/fahadalarab)\ **Post date:** [May 30, 2020, 8:00pm UTC](https://forum.manager.io/t/inventory-profit-margin-report-bug-when-inventory-kits-are-sold/9631/12 "2020-05-30T20:00:24Z")
Hey its great now. Just i checked in Inventory profit margin the sales amount of the Inventory kit is showing the full amound and profit is being subtracted from the full amount of kit instead as it should show only sales amount (minus tax amount) if we use tax inclusive sales invoice despite selecting tax same tax code as of inventory items of bill of materials in the inventory kit. ---
**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 30, 2020, 9:53pm UTC](https://forum.manager.io/t/inventory-profit-margin-report-bug-when-inventory-kits-are-sold/9631/13 "2020-05-30T21:53:02Z")
@fahadalarab you are correct. Fixed in the latest version (20.6.8) ---
**Author:** ![Abeiku](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abeiku/32/44970_2.png) [@Abeiku](https://forum.manager.io/u/Abeiku)\ **Post date:** [May 31, 2020, 8:10am UTC](https://forum.manager.io/t/inventory-profit-margin-report-bug-when-inventory-kits-are-sold/9631/14 "2020-05-31T08:10:07Z")
![Inventory PM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/9/893ac7dbeccaab9e7c74dce5b02203164cee80fa.jpeg) Tried to drill down into the profit margin. Windows 10 ---
**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-profit-margin-report-bug-when-inventory-kits-are-sold/9631/15 "2023-01-18T14:55:21Z")