Define Alternate Unit of Measure

This document explains how you set and define an alternate unit of measure for an item. The alternative can be based on quantity, price or supplementary Intrastat. An unlimited number of alternate units of measure may be defined for each item.

Outcome

Alternate units of measure with a specified conversion factor, as well as conversion method for conversions to a basic unit of measure, will be set and defined.

When the transaction is executed in measures other than those defined as basic units of measure, the alternate unit of measure can be used for conversion purposes in the purchasing, sales and manufacturing processes.

The alternate unit of measure is saved in the MITAUN table (in 'Item. Connect Alternate U/M' (MMS015)).

The conversion between basic and alternate unit of measure is saved in the MITUCV table (CRS051).

Before you start

  • An item must have been created in 'Item. Open' (MMS001).
  • The 'Alternate Unit of Measure in Use' parameter must have been set to alternative 1 or 2 on 'Item. Open' (MMS001/E).
  • Units of Measure must have been set in 'Unit of Measure. Open' (CRS050).

Parameters to Set

Program ID/Panel Field The field indicates …

(MMS015/B)

Type

…the type of alternate unit of measure. The valid alternatives are:

1 = Alternate quantity U/M

2 = Alternate price U/M

3 = Supplementary Intrastat U/M.

(MMS015/E)

Conversion factor

...a factor that is used for conversion from alternate U/M to basic U/M. You may enter a factor with up to 9 decimal places. The factor is used for either multiplication or division, depending on the conversion form that is selected. See "Conversion form".

(MMS015/E)

Conversion form

...how the conversion factor is used when converting from an alternate U/M to a basic U/M.

The valid alternatives are:

1 = Convert to the basic U/M by multiplying the

alternate U/M by the conversion factor.

2 = Convert to the basic U/M by dividing the

alternate U/M by the conversion factor.

Note: For a purchase price U/M, the opposite conversion relation is valid. Thus, 1=division and 2=multiplication.

Conversion is always done directly between the units of measure to ensure that the factors are treated the same.

Example:

The following applies for a metal plate that measures 3

square meters and weighs 1.5 kilograms:

Basic U/M = pieces

Purchase U/M = square meters

Purchase price U/M = kilograms

Set the conversion rate between the purchase U/M and basic

U/M to 3 with factor type 2 (or set the conversion factor

to 0.33333 with factor type 1.)

Set the conversion rate between the purchase price U/M and

basic U/M to 1.5 with factor type 2 (or set the conversion

factor to 0.66667 with factor type 1.)

(MMS015/E)

Order multiple

…the purchase order multiple quantity in the basic unit of measure (U/M). It is used in order to avoid the need to break up packages, etc.

The order multiple can be specified per item/warehouse or per item/supplier. Also, it is possible to specify a unique order multiple for each alternate U/M. When alternate U/Ms are used for purchasing, the order multiple is not checked per item/warehouse.

When an order is planned or created, a check is made to ensure that the order quantity is divisible by the order multiple without any remainder. A check is also made during lot sizing (calculation of the order quantity).

(MMS015/E)

Price adjustment factors

...how much the price for each alternative U/M should be adjusted in relation to the price for each basic U/M.

Example:

An item is stored in the basic U/M PCE (piece) and has a

price per U/M of 30. An alternative stock U/M is defined as

WHP (wholesale package) including 12 basic units of measure. On sale in wholesale packages, the price is 15 percent lower than on sale in the basic U/M. This results in a price adjustment factor of 0.85 and the price of each wholesale package is calculated: 12*30.00*0.85=306.

(MMS015/E)

Standard unit of measure PO, CO, MO, Product engineering, Statistics

...a code indicating whether or not the alternative U/M is the standard purchase U/M for a specific order type.

The valid alternatives are:

0 = No

1 = Yes.

If a standard purchase U/M is not defined, the basic U/M of the item will be used as the purchase U/M.

An alternate U/M that is set as standard for purchase orders is suggested as default in the transaction.

Standard purchase U/M is used when purchase U/M is not entered at purchase order entry.

If standard purchase U/M is not defined, the basic U/M of the item will be used as purchase U/M.

Follow These Steps

  1. Start (MMS015).
  2. On the B panel, specify the Item, 'Alternate type' and 'Unit of measure' fields. Click New or Option 1.
  3. On the E panel, specify the 'Conversion factor' field, the 'Conversion method' field and any other necessary data. See the description of parameters above.
  4. Press F3 to end the setting.

Using API

The API MMS015MI transactions can be used to add, update, get, list and delete items' alternate units of measure.