I'm seeking a way to generate aggregate product quantity sales reports.

Example 1:

Many of our products are sold in kits. For instance product A may be sold in Kit 1, and Kit 2 as well as individually. Kit 1 contains 1 A products, while Kit 2 contains 2 A products. If I sell 1x A products, 1x Kit 1 and 1x Kit 2, then my total sales or consumption of A is 4 units ( 1 + 1 + 2). I have been unable to accomplish this reporting in the sales module.

Example 2

I have the same problem for Manufacturing. For instance, I have 100 manufactured items that use the same screw, in different quantities, in each BOM. I have been unable to create a report that shows my consumption of that screw over a time period.

I can visit each product page, click the forecast tab, adjust the time range, hover the mouse of the start quantity and end quantity and subtract to get usage over a period. This isn't feasible for a large number of SKUs.

Does anyone know of a method to generate these types of report?

Thanks in advance!