@Clay Roper Yes we have enabled advanced Bin, but do not currently use it in locations (the locations have bin management turned off) we do plan to use in future.

Gotcha. Our team ended up getting our current item stock levels by essentially recalculating it from inventory affecting transactions. We use serial numbers, bins, and advanced bin / numbered inventory. We summed

inventoryassignment.quantity

for rows joined to transaction lines which impact inventory. Using inventoryassignment gave us the ability to filter on specific statuses, so I'd imagine it would also give you the ability to group by status to get a current snapshot. I say this so you know what one person's approach is - my fervent hope is that there's actually a better way to go about doing it, as this query must involve every transaction line since the beginning of time and seems like a silly way to do things long term. We went with this approach since our spelunking in the Analytics browser didn't turn up any other tables or combinations of tables that gave us what we were looking for -- specifically in terms of current stock quantities for items including serial number data and factoring in inventory status

I agree that approach might work. I do have a support case open with oracle, no response yet. I will advise if/when I get an answer.