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.

If you are managing cuttable products, use the Allow Cuts Less Than Minimum Remnant Cut Quantity control maintenance record to indicate if you want to allocate to remnant locations with a quantity that is less than the minimum allowed as set in the Product Maintenance Additional Inventory Parameters. If not set, the system allocates to remnant locations greater or equal the minimum.

To assign a product a remnant location status:

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 where the product is located.
In the Product field, enter or select the product for which you want to assign a remnant status and 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 Location Status column, type R to indicate the location is for a remnant.
Save your changes and exit the window.