I’m trying to extract sales related to an Inventory Item in Custom Reports. However, since they where done through Inventory Kits, I cannot see them. They are linked only to the Inventory Kits and not to Inventory Item.
I think that since an Inventory Kit is linked to many Inventory Item through quantities they should be linked also in the query.
When it comes to selling inventory kit, it will be single general ledger transaction into income account. Manager cannot break it down into multiple transactions by inventory item because it cannot possibly know how much of sale amount to attribute to each inventory item.
So you can get sales by item which are either inventory items or inventory kits. But I just realized Item field is not yet exposed. Would this solve the issue?