Skip to main content
Matrix42 Self-Service Help Center

Importing Material

Overview

Material records for the contract items are managed in Contracts application → Financial AccountingMaterial page:

materials_overview.png

In Contracts Management there is an option to import Materials using a standard template.

Material records import

To import Material:

  1. Go to Matrix42 Software Asset and Service Management → Contracts application.
  2. In the navigation area, click  Financial AccountingMaterial.
  3. On the toolbar, click Import Materials. The Quick Import wizard opens.
  4. Follow the instructions.

Quick import definition includes the same steps and data processing sequence as any other standard import definition. The main difference consists in the pre-defined source file structure and pre-configured mapping rules for the Quick Import definition.

Common rules to consider when editing the Import Template file:

  • Culture context of the data: when entering the text, consider the language specified in the quick import settings.
  • Not specified or ambiguous values: if no or more than one matching values are found, the value that is specified in the data source file is not saved to the system database.
  • Import processing details: a detailed report of the import processing stages is available in the Import Log Files section of the Administration application.

 Explanation of the Import Template 

All imported data can be modified manually in the user interface.

Field Name Explanation Maximum Character Length

Key

Required: alphanumeric string for logical identification of a material record. This information is a key field, which means that it is used by the import process to determine whether to create a data set or whether to update the existing, matching data set.

50

Name

Required: alphanumeric string for the name of a material record.

200

Group

Enter the key of the respective material group. The link to the material group is created automatically during the import. If more than one or no applicable material group is found, the value that is specified here is not saved.

 

Supplier

Short Name of the respective supplier known in the system as a Business Partner. The link to the supplier is created automatically during the import. If more than one or no applicable supplier is found, the value that is specified here is not saved.

 

Article Order Number

Alphanumeric article numbers or purchase order number that is used by the supplier.

200

Qty Unit

Name of the quantity unit in the placed order. Link to one of the quantity units that are available in the system is created by using the name. Supported by default options include:

  • Days (default)
  • Fractions
  • Hours
  • Kilogram
  • Kilometer
  • Kilowatt Hours
  • Meter
  • Months
  • Pieces
  • Units
  • Weeks

When entering text, consider the language set for the user interface. If more than one or no applicable quantity unit is found, the value that is specified here is not saved.

 

Unit Price

Numeric value for the unit price. To ensure correct entry for this value, consider the language set for the user interface (that is, if English is the set language, a decimal point should be used, not a comma).

11 characters before and 2 characters after the decimal point/comma

Currency Currency code of the unit price. For correct data import make sure that the entered currency is available the system. Alphanumeric, 3 characters
EAN The International Article Number, also known as European Article Number. Optionally, set EAN as a 12- or 13-digit product identification code.  
ECCN The Export Control Classification Number (ECCN) is a five-character alphanumeric key used in the Commerce Control List (CCL) to classify U.S. exports and determine whether an export license is needed from the Department of Commerce.   

Materials Import Example 

The given example is a filled out template imported for the English (United States) [es_US] culture context of the data:

materials_template.png

Successfully completed Materials Import results in the following records in the Contracts Financial Accounting section:

materials_imported.png

All Material records are imported with status Active.

  • Was this article helpful?