We were doing some analysis looking at margins. There was a discrepancy in one items margins that got me looking at it more closely. This item is sold individually and it is also a component of 2 kits. We were only looking at October so the numbers are small, but I can imagine over the course of a year or more these would get out of hand. I looked at the units sold * unit price and came up with 27 units sold by revenue/unit price. This got me looking more in depth and thats when i noticed that during that timeframe we sold 4 of the kits that contain that item. I then looked at the cost side of the equation and noticed the cost was correct for selling 31 units at our cost. So this tells me the report is picking up the unit cost for the kit components but not the qty sold.
Any suggestions how to fix this. I need it to report the qty as sold under the individual components.