report showing all locations, with or without stock in them

No description provided

Current Problem There currently is no single source or truth when it comes to locations and stock. We would like a single report that shows all the locations that exist in the warehouse. It should also show the SKU's and qtys if there is stock in them and also show the locations that are empty.
Idea to resolve Problem	Create a report, column A shows all the locations that exist in the warehouse. Column B shows the SKU (this will remain blank if there is no stock booked into that location), column C shows the qty of the SKU in that locations (again, will be blank if there is no stock in that location)

RELATED IDEAS