Is there a way to display

{item.locationquantityavailable}

in a transaction search where there is a location filter and dynamically returns only the quantity in the selected location filter?

I'm pretty sure you need to put item.inventorylocation as a filter to have it work.

If you want to have a location's quantity to show up in one column, and another location's quantity to show up in a second column, you can do a formula(number) using a Case formula. I don't have the field names in front of me, but it would go something like this CASE When {inventory.location} = "Phoenix" THEN {location.quantity.available} END. The inventory might be an internal ID, so you could replace "Phoenix" with your location ID (1,2,3, etc).

I used this formula in my transaction saved search to determine the qty of any item in any location. Just modify and repeat for each qty needed: CASE WHEN {location} = {item.inventorylocation} THEN {item.locationquantityonhand} else 0 END My Criteria: Item: Type = Is Any Of - Inventory Item, Assembly/Bill of Materials, Kit/Package Location = Is Not - unassigned - Item: Inactive = Is False I use 'Item Fields' as the Filter for Item. Hope it helps.