I asked this question on the suitescript channel and didn't get an answer. I suspect it might not be possible with saved searches. Perhaps it is possible with suiteql.
I need a count of the inventory broken down by bin and lot.
For example:
i.e item X
there are 20 in bin 17 of lot 42.
There are 13 in bin 17 of lot 43.
There are 12 in bin 18 of lot 42.
In total 20+13+12 = 45.
Is this achievable in suiteql.
Here is the saved search that does it for me (in the reply)