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 Warehouse Management > Reports menu, select Open Locations Report to display the Open Locations Report screen.
Note: If prompted, log on to the character-based system.
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 5 or less items is included in the report.
Note: The system uses the lowest unit of measure when searching for this amount.
Note: You can enter negative quantities in this field to run the report for locations with negative on-hand quantities.
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.
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 Statuses |
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.
See Also: