When you move product from one location to another, such as from the warehouse to the sales floor, use Product Location Maintenance to track the reallocation. For example, reallocate product if a salesperson on the showroom floor has just sold the last item of a product and needs to replenish that item on the floor.
Adjust product quantity if, for example, the system indicates that 15 items are on Shelf A, but only 10 items are actually on Shelf A. Add this product to the next cycle count to reverify the product's quantity.
Note: The system deducts any outgoing inprocess quantities from the location onhand quantities displayed.
Always make adjustments in Product Location Maintenance so that your inventory counts stay accurate and current. If you create new locations in Product Location Maintenance, be sure to save the new location.
You cannot increase tagged quantities using Product Location Maintenance. To increase tagged quantities in locations, either use the RF Move Product functionality to move additional quantity into the location or increase the sales order quantity for the tagged item to generate a pick request. If you perform any other update to a location holding tagged product, the system copies the update to the purchase or transfer order on which the product was originally received.
Through the PRD.LOCATION.MAINT authorization key, you are assigned one of three levels of authority for changing product locations:
Level 1 authority is view-only mode. You cannot make changes.
Level 2 authority allows reallocation of product between locations, without changing the total on-hand quantity. Users with level 2 authority cannot adjust customer consignment quantities. However, level 2 authorized users can move quantities between same vendor consignment locations.
Level 3 authority allows reallocation of the product and adjustment of the total on-hand product quantity.
Use Warehouse Location Maintenance to view all the products in a warehouse location.
This topic discusses how to update product quantities in the following circumstances:
To change product quantities with Level 2 authority:
From the Warehouse Management menu, select Product Location Maintenance to display the Product Location Maintenance window.
In the Branch field, enter or select the branch or territory for which you want to view product location information.
In the Product field, enter or select the product name or ID for the product for which you want to view location information.
The system displays the product's locations and on-hand quantities. In addition, use the ChangeView menu to change the columns displayed.
In the Location column, identify the location from which you are moving the product.
Note: If you perform any update to a location holding tagged product, the system copies the update to the purchase or transfer order on which the product was originally received.
In the On-Hand column next to the location from which you are moving product, enter the new on-hand quantity.
For example, if the original quantity in the location was 100 and you move 20 items from the location, enter 80 in the On-Hand field for the location.
Note: If the
In the On-Hand field next to the location to which you are moving product, add the number of items that you are moving to that location to the existing quantity.
For example, if you are moving 20 items to a location with 40 items, enter 60.
To change product quantities with Level 3 authority:
From the Warehouse Management menu, select Product Location Maintenance to display the Product Location Maintenance window.
In the Branch field, enter or select the branch or territory for which you want to view product location information.
In the Product field, enter or select the product name or ID for the product on which you want to view location information.
The system displays the product's locations and on-hand quantities. In addition, use the ChangeView menu to change the columns displayed.
In the Location column, identify the location from which you are moving the product or adjusting the product quantity.
Note: If you perform any update to a location holding tagged product, the system copies the update to the purchase or transfer order on which the product was originally received.
In the On-Hand column next to the location from which you are moving product, enter the number of items that remain in that location.
For example, if the original quantity in the location was 100 and you move 20 items from the location, enter 80 in the On-Hand field for the location.
Note: If you are moving the quantity from a different location, identify where you are moving product in the Location field.
In the On-Hand column next to the location to which you are moving product, add the number of items that you are moving to that location to the existing quantity.
For example, if you are moving 20 items to a location with 40 items, enter 60.
Note: If the
Add the product to the next cycle count to make sure your inventory stays accurate.
To change product quantities by editing the purchase order:
From the Purchase menu, select Stock Receipt Entry to display the Initial Order Entry window.
In the Branch field, enter the branch or territory at which the purchase order originated.
In the Vendor/Order #, enter or select the vendor or order that you want to receive.
Click OK to display the purchase order.
Place the cursor on the line item you are receiving.
From the Line Item menu, select Schedule to display the Line Item Scheduling window.
Select the received date for which you want to change the product location.
From the Edit menu, select Split Locations display the Split Locations window.
In the Location field, enter the new location for the product.
In the Qty field, enter the number of the item you are relocating.
Repeat steps 9 and 10 for additional locations for this product.
Save the split locations information and return to the Line Item Scheduling window.
See Also:
Automatically Assigning Lot Numbers
Displaying Warehouse Locations for Products