Create Location Type Table (MMS057)
This settings document explains and exemplifies how to define different allocation tables that will be used to allocate to location type. This is done in 'Item. Connect Stock Location Type' (MMS057).
In (MMS057) you can also set up tables that will be used for system directed goods receiving and put away to location type. This is described in the document Basic Settings for System-Directed Put-Away.
Outcome
The location type table determines allocation according to location type.
The location type table is stored in the MITWLT file.
Rules that can determined per location type:
- Minimum quantity allocation
- Sequencing of location type searching
- Normal quantity determines the multiple used for allocation
- Remaining quantity: Used so certain quantity breaks only get allocated from their designated location type, even if it means waiting for more stock to arrive.
- Allocate to empty: Allocate only if the allocation will empty this balance ID's location.
- Exclude some order types: Do not allocate from certain location types for certain order types.
Before you start
- Location types are defined.
- Basic settings for auto allocation must be done. See Basic Settings for Automatic Allocation.
Examples for how to use (MMS057)
-
Minimum quantity
Required quantity directs allocation to search certain location types according to this field.
Allocation:
- Try to allocate full pallets from location type P2.
- If there is remaining quantity to be allocated, try to allocate all of it in a location from location type P2.
- If there is still remaining quantity to be allocated, try to allocate from locations with type P1.
Min Qty
Seq
Locn Type
Normal Qty
Max Qty
Rem Qty Ctl
Use for
Put-away
Alloc Empty
Exclude Ord Type
0
10
P1
120
130
no
no
no
24
10
P2
120
120
no
yes
yes
120
10
P2
120
120
no
no
no*
* This also means that only multiples are allocated.
-
Sequencing of location type searching
Enables a sequenced search among location types.
Allocation will first take place from drive-in pallet locations (DR), then from single pallet locations (P2).
Min Qty
Seq
Locn Type
Normal Qty
Max Qty
Rem Qty Ctl
Use for
Put-away
Alloc Empty
Exclude Ord Type
0
10
P1
120
130
no
no
no
24
10
P2
120
120
no
yes
yes
120
10
P2
120
120
no
no
no
120
20
DR
480
480
no
yes
no
-
Normal quantity determines the multiple used for allocation
Normal quantity determines the multiple used for put away and allocation.
Maximum quantity determines the percentage filled (if the fill-rate calculation is activated).
Fill rate is used when checking capacity during put away.
Min Qty
Seq
Locn Type
Normal Qty
Max Qty
Rem Qty Ctl
Use for
Put-away
Alloc Empty
Exclude Ord Type
0
10
P1
120
130
no
no
no
24
10
P2
120
120
no
yes
yes
120
10
P2
120
120
no
no
no
120
20
DR
120
480
no
yes
no
-
Remaining quantity
Certain quantity breaks only get allocated from their designated location type—even if it means waiting for more stock to arrive.
This can mean, for example, that if a full pallet is ordered, it will not be shipped as two halves.
-
Allocate to empty: Allocate only if it will empty the location for this balance ID
Allocate only if it will empty the location for this balance ID, MMS057/E.
-
Exclude certain order types
Do not allocate from certain location types for certain order types, that is never allocate replenishments from a picking location.
Follow these steps
-
Start 'Item. Connect Location Type' (MMS057).
-
Specify the information in the fields belonging to Automatic Allocation Settings.
|
Program ID/ Panel |
Field |
The field indicates … |
|---|---|---|
|
(MMS057/B) |
Sorting order |
… how to display information on the panel by selecting an sorting order. There are three valid alternatives. |
|
(MMS057/B) |
Sequence number |
… the sequence number that can be used if you want to have more than one entry for the same key and minimum quantity. The sequence number will, under these circumstances, determine the sequence in which entries in this table are used. |
|
(MMS057/B) |
Minimum storage quantity |
… the minimum permitted quantity that may be put away in a location that belongs to the specified location type. This quantity is used as the quantity key when determining which stock location type to use in both put-away and allocation. If this quantity is 0, then multiples will be ignored during the allocation process, meaning that quantities other than multiples of the normal quantity may be allocated. |
|
(MMS057/B) |
Location type |
… a group of locations based on characteristics (size etc.). |
|
(MMS057/B) |
Item no. |
… an item number for group type 1 and a distribution group technology for group type 2. |
|
(MMS057/B) |
Group type |
… the group type that the group key refers to. The valid alternatives are: 1 = Item number (MMS200) 2 = Distribution group technology (MMS043). |
|
(MMS057/E) |
Normal storage quantity |
… the quantity that is the recommended storage quantity for this location type. If the minimum quantity is not 0 and the 'Allocate to empty' field is 0 (deactivated), then only multiples of this quantity will be allocated. |
|
(MMS057/E) |
Remaining quantity allocation control |
… how to allocate the remaining quantity if the location type is already fully allocated. The valid alternatives are: 0 = Try to allocate remaining quantity to next location type. 1 = Do not try to allocate remaining quantity to next location type. See the example in the field help. |
|
(MMS057/E) |
Use at put away |
… whether this table entry can be used for finding location types using quantity multiples for put-away. Regardless of the selected value for this field, all records will be considered during allocation if you are using allocation method 2. |
|
(MMS057/E) |
Allocate to empty location |
… whether balance IDs found during allocation should only be allocated if they will empty the location of the balance ID. The valid alternatives are: 0 = No, allocate in any event 1 = Yes, allocate only if balance IDs will empty the location. The field indicates also whether, when using this item-location connection entry, stock can only be allocated from a location of this location type if the allocation will be for more than or equal to the total quantity of the balance ID. If this flag is on, then allocation will ignore multiples, that is, less than multiple quantities can be allocated. |
|
(MMS057/E) |
Exclude reference order category |
… the specific order type which is prevented from using this item-location connection entry. The following alternatives are valid: 1 = Manufacturing order 2 = Purchase order 3 = Customer order 4 = Requisition order 5 = Distribution order 6 = Work order 7 = Service order 8 = Project order 9 = Claim order. This could be used, for example, to prevent customer orders from being picked from certain location types. |