We are trying to create a report that has all the information that the Current Inventory Snapshot has, but with the inventory location as a column on the left, not as headers. Does anyone know how to create this? I tried creating a report from Quantity On Hand, but unable to get all the fields that shows on Inventory Snapshot.
Any help would be appreciated. We have it in a saved search but need it in a report to export as an excel web query.