Use Warehouse Location Maintenance to maintain up-to-date location information, such as the date a product was last cycle counted at the location. You can update and view the following information for products stocked in the location from Warehouse Location Maintenance:
For additional tasks you can complete from Warehouse Location Maintenance, see More Options from the Warehouse Location Maintenance Screen.
You can use the Warehouse Location Maintenance screen to indicate what quantity and location type this location serves for each product. For example, for some products, the location may be the primary location. For other products, the same location may serve as that product's secondary, back-up location.
From the Whse Mgt > Warehouse Maintenance menu, select Warehouse Location Maintenance to display the Warehouse Location Maintenance screen.
Display all the products in a location.
Move your cursor to the product description whose quantity or location type you want to change.
In the T (Type) field, press F10 and select a new quantity type for the product:
Type |
Definition |
S |
S - Stock. Sellable product available for shipment. |
F |
F - Defective. Defective product, not available for shipment. |
O |
O - Over Shipment. Over shipment from the vendor. |
R |
R - Review. Product that needs reviewing or inspecting before it is sellable. |
L |
L - Display. Sellable product reserved for display, but available for shipment if specifically requested. |
T * |
T - Tagged. Product committed to the associated sales order, purchase order, transfer order, or inventory adjustment number listed in the Tag ID field. |
C * |
C - Consignment. Product that is a customer or vendor consignment. |
* You cannot manually assign these quantity types to products from Warehouse Location Maintenance.
In the S (Location Status) field, press F10 and select a new location type for the product:
Type |
Definition |
P |
Primary - Main stocking location for the product. |
S |
Secondary - Back up stocking location for the product when primary location is full. |
F |
Floating - Temporary stocking location for the product until supply in that location reaches zero quantity. |
R |
Remnant - Stocking location for material that contains less than the original amount. For example, half a spool of wire. |
Press Esc to save your changes.
The last count date indicates the last time you performed a cycle count for a product in a location. After you change the last count date for a product, the system updates the Product Activity Log by indicating that the product and location were counted.
From the Whse Mgt > Warehouse Maintenance menu, select Warehouse Location Maintenance to display the Warehouse Location Maintenance screen.
Display all the products in a location.
Move your cursor to the product description of the product whose last count date you want to change.
In the Last Count field, enter the month, day, and year the product was last counted at this location.
Press Esc to save your changes.
You can use the Warehouse Location Maintenance screen to set the minimum and maximum quantities of a product allowed at the location for replenishment.
From the Whse Mgt > Warehouse Maintenance menu, select Warehouse Location Maintenance to display the Warehouse Location Maintenance screen.
Display all the products in a location.
Use the Chng View hot key and select Replenish Min / Max to display the Replenish Min/Max view.
In the Min Qty field, enter the minimum number of this product to stock at location for replenishment purposes.
In the Max Qty field, enter the maximum number of this product to stock at this location for replenishment purposes.
Press Esc to save your changes.
Home locations define where products are to be stocked after handling, and they are used in combination with detail lot controls set up for products in Product Location Maintenance.
From the Whse Mgt > Warehouse Maintenance menu, select Warehouse Location Maintenance to display the Warehouse Location Maintenance screen.
Display all the products in a location.
Use the Chng View hot key and select Last Count / Home Location to display the Last Count/Home Location view.
In the Home Location field, change the listed home location, if necessary.
Press Esc to save your changes.
Pre-packaged quantities are set for products that are sold together, such as kits or a box of nails.
From the Whse Mgt > Warehouse Maintenance menu, select Warehouse Location Maintenance to display the Warehouse Location Maintenance screen.
Display all the products in a location.
Use the Chng View hot key and select Last Count / Pre-Package Quantities to display the Last Count/Pre-Package Quantities view.
In the Pre-Pack Qty field, enter the package quantity assigned for the product.
Press Esc to save your changes.
The tote identifies the physical basket or cart used to collect items from the warehouse. The picker is the person pulling product from the shelf to place in the basket.
From the Whse Mgt > Warehouse Maintenance menu, select Warehouse Location Maintenance to display the Warehouse Location Maintenance screen.
Display all the products in a location.
Use the Chng View hot key and select Tote / Picker to display the Tote/Picker view.
In the Tote field, enter the tote and picker you want to view.
Press Esc to save your changes.
The pick status identifies the pick priority for the location. For example, you may have two overflow locations for a product in your warehouse. You can assign a higher pick priority to the overflow location you want depleted first.
Note: The Pick Status field is only accessible in RF-enabled branches.
From the Whse Mgt > Warehouse Maintenance menu, select Warehouse Location Maintenance to display the Warehouse Location Maintenance screen.
Display all the products in a location.
Use the Chng View hot key and select Last Count / Pick Status to display the Last Count/Pick Status view.
In the PickStatus field, press F10 and select the pick order for the location.
Press Esc to save your changes.
The Expiration Date view displays the date the product in the warehouse location expires, if it is a perishable product.
If the Use Location Expiration Dates control maintenance record is set to Y, the system directs pickers to pick from locations with the earliest expiration date. For orders with quantities greater than the earliest expiration date location, the system directs the picker to start the process from the location with the earliest expiration date. Then, to pick from the location with the next earliest expiration date continuing on until the order is filled. If two locations have the same expiration date, the system directs pickers to the location with the greater quantity so that pickers only have to go to one location to pick the order.
Note: We recommend cycle counting a location before updating it's product expiration dates.
From the Whse Mgt > Warehouse Maintenance menu, select Warehouse Location Maintenance to display the Warehouse Location Maintenance screen.
Display all the products in a location.
Use the Chng View hot key and select Last Count / Expire Date to display the Last Count/Expire Date view.
In the Last Count field, enter the updated cycle count date.
In the Expire Date field, enter the expiration date.
Press Esc to save your changes.
The Received Date view displays the date the product was received into inventory. When a receiver receives products into inventory, the system stores the receive date in Warehouse Location Maintenance and in Product Location Maintenance.
If the Pick By Location Based On Received Date control maintenance record is set to Yes, the system directs pickers to pick from locations with the oldest receive date. If two locations have the same receive date, the system directs pickers to the location with the lowest quantity to clear out locations and to avoid having several locations with small quantities.
Note: We recommend cycle counting a location before updating it's product receive dates.
From the Whse Mgt > Warehouse Maintenance menu, select Warehouse Location Maintenance to display the Warehouse Location Maintenance screen.
Display all the products in a location.
Use the Chng View hot key and select Last Count / Receive Date to display the Last Count/Receive Date view.
In the Last Count field, enter the updated cycle count date.
In the Receive Dt field, enter the date the product was received in this location.
Press Esc to save your changes.
Use the Review Type and Original Type view to determine the location status for a review stock item. For example, a review stock type can mean that an item is in a review status due to a pending cycle count, or that the item is in the Return Goods Queue waiting to be reviewed before being returned to your inventory or to your vendor.
If you are using RF and the RF Make Short Pick A Review Status Location control maintenance record is set to Yes, when a pick causes a location shortage, the system queues the location for a cycle count and changes the quantity type in the location to a Review status.
From the Whse Mgt > Warehouse Maintenance menu, select Warehouse Location Maintenance to display the Warehouse Location Maintenance screen.
Display all the products in a location.
Use the Chng View hot key and select Last Count / Review Type / Original Type to display the following view-only fields:
Field |
Description |
Type |
The review status type for product locations assigned the Review quantity type. Cycle displays if the product location is queued for a cycle count. If a type does not display in this field for Review status line items, the product in the location is in the Return Goods Queue, waiting review for return to your inventory or to the vendor. |
Old |
The original quantity type for this product, such as Stock or Nonstock. When you either complete the cycle count for the location or review the product and remove it from the Return Goods Queue, the location returns to this status for the product. |
Press Esc to save your changes.
More Options from the Warehouse Location Maintenance Screen
The Warehouse Location Maintenance screen also offers these options.
Hot Key |
Function |
Fut Led |
Displays the Future Ledger screen. Use this screen to view a product's future activity, such as if the product is on a sales order scheduled for shipping next week. |
Hist Led |
Displays the History Ledger screen. Use this screen to view up-to-the-minute product inventory data for the selected product. |
Inv Inq |
Displays the Inventory Inquiry screen. Use this screen to view up-to-the-minute product inventory data for the selected product. |
View Tag |
Displays the purchase order, sales order, or return to which the product is attached. |
Serial # |
Displays the Detail Product Serial Queue screen. Use this screen to view all open and available serial numbers for the product. |
See Also: