I need a search or report that can provide the quantities sold for individual items that are components of Kit Items.
For example, if Kit A consists of items A, B, C, and D, I would like to know, for a given month, how many units of each component item were sold through Kit A.
Additionally, some inventory items are used in multiple Kit Items. Therefore, I need a way to identify the quantity sold per component item, ideally with visibility into the Kit Item(s) through which the sale occurred.
Could you advise whether there is an existing NetSuite search/report that can provide this information, or if a custom saved search would be required?