Define Item-related Data

This document explains how you connect related data to an item. Related data include alternate units of measure, related items that can replace an out-of-stock item, languages for external documents, and alias numbers that allow you to identify an item by something other than the item number.

Outcome

The following data will be defined and connected to the item:

  • Alternate unit of measure.

    'Item. Connect Alternate U/M' (MMS015) is stored in the (MITUCV) table.

  • Related items.

    'Item. Define Relations' (MMS020) is stored in the (MITALT) table.

  • Alias number.

    'Item. Connect Alias Number' (MMS025) is stored in the (MITPOP) table.

  • Names and language.

    'Item. Enter Names/Language' (MMS030) is stored in the (MITLAD) table.

This setting is used for purchasing, sales and manufacturing.

Before You Start

Note: There is no natural internal order for executing these activities.

Workflow

  1. Define Alternate Unit of Measure in (MMS015)

    The purpose of an alternate unit of measure is flexibility in the unit of measure and selection of the most appropriate unit for a specific order. For example, you may have set the main standard unit of measure to pieces. If a customer wants to buy a large quantity of the item, it is more practical to sell in kilograms as a unit of measure.

    The purpose of an alternate unit of measure is flexibility in the unit of measure and selection of the most appropriate unit for a specific order. For example, you may have set the main standard unit of measure to pieces. If a customer wants to buy a large quantity of the item, it is more practical to sell in kilograms as a unit of measure.

  2. Define Related Items in (MMS020)

    By defining related items, you make it possible to meet distribution or customer orders even if you do not have the required item in stock.

    In 'Item. Define relations' (MMS020) you define the items to be related. You also define replacement type, such as whether an item is interchangeable with another item, and if there are restrictions to be defined.

  3. Define Alias Number for Items in (MMS025)

    The alias number allows you to identify an item by something else than the item's number. Alias numbers can include manufacturer's number, customer number, EAN number and so on.

    In 'Item. Connect Alias Number' (MMS025) you define both an alias number and what item the alias number is to be used for.

  4. Define Names and Languages for External Documents in (MMS030)

    Defining names and languages for external documents is used if, for example, you have customer documents that are to be printed for a foreign customer in a foreign language. Note: This language cannot be used for internal use.

    In 'Item. Enter Names/Languages' (MMS030) you define a language code and a name to be printed on the document.