I am really struggling to get a correct saved search that lists the location quantity for each item. Because we use bins, I get multiple rows for items when I do an Item saved search, but I'm hoping to generate a list that has a single line for each item, with a column of each location's quantity. I've also tried doing an Inventory Detail or Inventory Balance saved search, but I can't seem to get the result grouped into multiple columns on the same line. Any tips?

I would suggest trying a Pivot Workbook. I think you can do that one line per item then multiple columns for the locations bin easier than saved search.