One way to get this information is to go into Adagio Inventory and printing Physical Inventory Worksheets selecting "All items from Inventory list" for all locations including qty on hand and creating an export file. Then I can open each location's worksheet in excel and copy the quantity from each and combine them to one spreadsheet. This is a bit tiring but it works.

I was hoping to use Gridview more for inventory control but this location issue seems to keep coming up and prevents me from accomplishing the output I need.

One workaround that helps somewhat is for example a Gridview that have that shows us items that we have orders for but no stock in our warehouse. Before we order it, maybe we should see if one of our other branches is sitting on the stock we need? So I created another gridview called locations and linked it so when you double click on any item you need to order you can quickly see if there's stock at another warehouse.