Running the Open Locations Report

Use the Open Locations Report when you have limited space in your warehouse and need to find locations in which to put away new product. You can view the report, and then determine:

Locations which have product assigned but are not currently holding any actual inventory.
Several locations holding the same product, which you can consolidate to make room for the new product.
Locations that have not yet been assigned to product.

Note: Locations holding product with in-process records are not included in the generated report.

For a description of the report, see What the Report Shows at the end of the topic.

To run the Open Location Report:

From the Whse Mgt > Reports menu, select Open Locations Report to display the Open Locations Report screen.
In the Br/Tr/All field, enter the branch or territory for which you want to run the report. Enter All to run the report for all branches and territories.
In the Select By field, press F10 and select from the following options to determine the locations for which to run the report:

Option	Description
Zone	Runs the report for the indicated warehouse zone or zones. Enter a single zone, or use the Multi hot key to enter multiple zone.
Range	Runs the report for the indicated location ranges. Enter the starting and ending locations for the range.
Pick Group	Runs the report for the indicated pick group or groups. Enter a single pick group, or use the Multi hot key to enter multiple pick groups.

In the Stock Types field, press F10 and select the stock type for which to run the report. Use the Multi hot key to enter multiple stock types for which to run the report.

In the Location Status field, press F10 and select the location status for which to run the report. Use the Multi hot key to enter multiple location statuses for which to run the report.

In the On Hand <= field, enter a quantity that, if less than or equal to a location's amount, includes that location in the report.

For example, if you enter 5 in this field, then any location with five or less items is included in the report.

Note: The system uses the lowest unit of measure when searching for the entered quantity.

Note: You can enter negative quantities in this field to run the report for locations with negative on-hand quantities.

In the Sort By field, press F10 and select the sorting method to use on the report results:

By Location By Product By Location Status – The results are sorted by location first, then by product, then by location status.
By Location By Location Status – The results are sorted by location first and then by location status.
By Ascending On Hand By Location – The results are sorted in ascending on-hand quantity first and then by location.

In the Detail/Summary field, indicate if you want to run a detailed or a summary report.
Set options, if needed, and generate the report.

What the Report Shows

The Open Locations Report shows the following information:

Field/Column	Description
Branches	The branches or territories for which the report was run.
Warehouse Zone	The warehouse zone or zones for which the report was run if Zone was defined in the Select By field.
For Locations	The location range for which the report was run if Range was defined in the Select By field.
Pick Group	The pick group or groups for which the report was run if Pick Group was defined in the Select By field.
Stock Types	The stock types for which the report was run.
Location Statuses	The location statuses for which the report was run.
Sorted By	The sort by method defined for the report.
Location	The locations that met all defined criteria for the report. Note: Locations holding product with in-process records are not included in the generated report.
Product Description *	The product in the corresponding location.
Location Status	The location status for the corresponding location.
Stock Type	The stock type for the corresponding location.
On-Hand	The on-hand quantity in the location. Note: This quantity does not include quantity tied to in-process records.

* This data displays in detail mode only.