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.


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:

Before you start

Examples for how to use (MMS057)

Follow these steps

  1. Start 'Item. Connect Location Type' (MMS057).

  2. Specify the information in the fields belonging to Automatic Allocation Settings.

Program ID/ Panel


The field indicates …


Sorting order

… how to display information on the panel by selecting an sorting order. There are three valid alternatives.


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.


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.


Location type

… a group of locations based on characteristics (size etc.).


Item no.

… an item number for group type 1 and a distribution group technology for group type 2.


Group type

… the group type that the group key refers to.

The valid alternatives are:

1 = Item number (MMS200)

2 = Distribution group technology (MMS043).


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.


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.


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.


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.


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.

Related topics