Assigning Products a Remnant Location Status

The system automatically assigns a pick location for products on sales orders according to the warehouse locations defined in Product location Maintenance for the product. You may however, decide to change the location status for a product to identify it is a remnant.

For example, your purchasing agent purchased and received two spools of wire containing 500 feet each into two separate warehouse locations: W1 (Primary location) and W2 (Secondary location). A sales agent takes an order for 450 feet of wire. The system assigns the pick location for the product to W2, the secondary location, thus leaving 50 feet of wire at W2. Your company may consider any wire length less than 100 feet to be a remnant that gets bundled and moved to a remnant location in your warehouse.

When selling lot controlled products, the system first looks at remnant locations to determine if it can fill an order with the quantity in that location. If the order quantity is less than the remnant, the system assigns the remnant as the pick location.

For example, if you assign the remaining 50 feet of wire at W2 to a remnant location, and your sales agent now takes an order for 40 feet of wire, the system assigns W2 as the pick location for the product because the amount in the remnant location can fill the entire order quantity. However, if your sales agent takes an order for 55 feet instead of 40 feet, the system assigns W1 as the pick location, because the remnant quantity of 50 feet at W2 does not fill the order quantity.

Note: The remnant location status is typically used for lot controlled products, such as wire and tile.

To assign a product a remnant location status:

From the Whse Mgt menu, select Product Location Maintenance to display the Product Location Maintenance screen.
In the Branch field, enter the branch or territory where the product is located.
In the Product field, enter the product for which you want to assign a remnant status.
Press Enter to display all the locations for the product at the indicated branch.
Place your cursor on the location you want to change to a remnant.
In the S field, type R to indicate the location is for a remnant.
Press Esc to save your changes.