MintSoft Ideas Portal
Add a new idea Subscribe
Status Not under consideration
Categories Reporting & Analytics
Created by Guest
Created on Feb 2, 2022

RELATED IDEAS

Location Usage Report

No description provided
Current Problem

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.
  • Attach files
      Drop here to upload
    • Guest
      Reply
      |       Feb 8, 2022

      Thanks i will have a look at this workaround for now and see how this looks.

    • Guest
      Reply
      |       Feb 4, 2022

      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