My logistics team is inquiring if there is a better possible way to report on location level on hand quantity AND location level quantity available for all SKUs? We can review this detail by the item record itself and can see location on hand on the Physical Inventory Worksheet but cannot see location quantity available level data on that report nor at an aggregated SKU level. Any advice? I can’t seem to find a better option yet

@C W I've done this in a saved search using a criteria formula. case when ({inventorylocation.internalid} = 2) then {locationquantityonhand} else null end replacing the 2 in this with the actual internal ID of that location

@Marissa Nolan thanks I’ll try it out and let you know, think {locationquantityavailable} is the one they are looking for

I mistyped! Its a results formula not a criteria.

This might also be possible using the new analytics worksheet and pivot tab without having to hardcode a column for each location

@michoel I haven't had luck with it there, but I'll be honest that I didn't have the time to really fiddle with it.

@Marissa Nolan I think the saved search route is the solution here, thanks so very much for the help this is exactly what I needed