SKU Warehouse Selection constraint can be added if there is a need to limit the number of warehouses from warehouse group which can serve a particular product group during period group.
To add SKU Warehouse Selection Constraint, click on the SKU Warehouse Selection constraint under constraint drop down in Data Dashboard. Then click on the add SKU Warehouse Selection constraint to add individual data or bulk data in respective tabs.
Table Description | |
Period Group | Period group from the period group table to be selected/added |
Warehouse Group | Select/Add a warehouse group from the warehouse group table. |
Product Group | Select/Add a product group from the product group table. |
Min | Add the desired minimum number of warehouses to be used for the selected product group during selected period group. |
Max | Add the desired maximum number of warehouses to be used for the selected product group during selected period group. |
Across Periods | Add “0” to apply the constraint to each period under the selected period group. Add “1” to apply the constraint to the entire period group, covering all periods collectively under the group. |
Status | 1 or 0 can be assigned for active or inactive status of constraint. |
Note | Any remarks/comments can be added in this column. |
The above constraint added will restrict the use of number of warehouses from all_warehouses group for product_1 during period_1 between 0 and 1.