We need to understand how to get location status, (damaged, frozen, etc), into an inventory report. We haven't been able to find a table in the system that we can filter against thus far.
The Perpetual Inventory Log table is the place where you can view and filter on location status. I would recommend also filtering this table on Current Quantity > 0 as this table does include historical data.
I hope this helps, but let me know if you have any questions.