So we have created a Inventory Aging report of sorts. Not the most perfect, but it is based off of what my company has created in the past. We are taking the quantity on hand and subtracting out item receipts from Purchase orders and if it is an assembly item taking quantity on hand and subtracting out builds. It then throws it into buckets. So it is based off of suite answer #75940.
https://netsuite.custhelp.com/app/answers/detail/a_id/75940/kw/inventory%20aging
So at least I don't think we can do an item search that joins to transactions.