I am trying to calcualte the total amount of an item sold per month. These items are sold as inventory items, part of assemblies and .... here is were it gets tricky, that assembly is also part of a kit/package. How can I, in a search capture all sales of the inventory item no matter where the item is sold. The assembly and inventory items I get easy but the portion that is sold in the kits i cannot seem to capture. Here is my current search
| Type | is any of Inventory Item, Kit/Package, Assembly/Bill of Materials | |
| Transaction : Type | is any of Item Fulfillment, Invoice | |
| Transaction : Status | is any of Item Fulfillment:Shipped, Invoice:Paid In Full, Invoice:Open | |
| Transaction : Date | is within 9/28/2015 and 9/28/2015 | |
| | | |
| | |