We are wanting to create reports that will allow us to understand as a percentage the available space in our warehouse. However currently there is no report that provides information on the number of locations currently use.
Idea to resolve Problem
Add a report that allows you to see how many locations are in use on a day by day biases.
As a workaround, until the report is developed, you could go to Warehouse - Manage Warehouses - 'Locations'. Then select all locations and use 'bulk actions' to export to CSV.
Use the formula =COUNTIF(L2:L100,"True")/COUNTA(L2:L100)*100 (Where "L2:L100" is your data range in the column headed "InUse".) The result should display the percentage of locations in use.
But this is obviously longwinded and a developed report, with options to filter by location type etc, would be a much better solution.
PS - for a quick view, add the AisleSummary and/or LocationSummary modules to your dashboard.
Thanks i will have a look at this workaround for now and see how this looks.
As a workaround, until the report is developed, you could go to Warehouse - Manage Warehouses - 'Locations'. Then select all locations and use 'bulk actions' to export to CSV.
Use the formula =COUNTIF(L2:L100,"True")/COUNTA(L2:L100)*100 (Where "L2:L100" is your data range in the column headed "InUse".) The result should display the percentage of locations in use.
But this is obviously longwinded and a developed report, with options to filter by location type etc, would be a much better solution.
PS - for a quick view, add the AisleSummary and/or LocationSummary modules to your dashboard.
Hope this helps