# Infor M3 Item Master Upload Worksheet (MMS001 and MMS200MI Load Template)

> Source: https://netray.co/tools/infor-m3-item-master-upload-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Collect and validate item master data for an M3 load, with status checks and a ready-to-export Excel or CSV layout.

## Category

infor-cloudsuite

## Erp

Infor M3

## Audience

- M3 data migration consultant
- Master data analyst
- M3 functional consultant

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### ITNO Item number

**Key:** itno

**Type:** text

#### ITDS Name

**Key:** itds

**Type:** text

#### FUDS Description

**Key:** fuds

**Type:** text

#### ITTY Item type

**Key:** itty

**Type:** text

#### ITGR Item group

**Key:** itgr

**Type:** text

#### UNMS Basic unit

**Key:** unms

**Type:** select

**Options:**

- PCS
- KG
- M
- L
- BOX

#### RESP Responsible

**Key:** resp

**Type:** text

#### Std unit cost

**Key:** cost

**Type:** number

**Format:** currency

#### Opening qty

**Key:** qty

**Type:** number

#### Opening value

**Key:** value

**Type:** number

**Expr:** cost * qty

**Format:** currency

#### Load status

**Key:** ready

**Type:** select

**Options:**

- Draft
- Reviewed
- Approved
- Loaded

**Rows:**

**Itno:** A-1001

**Itds:** Hex bolt M8x40

**Fuds:** Hex bolt M8x40 zinc plated

**Itty:** RAW

**Itgr:** FAST

**Unms:** PCS

**Resp:** PLN01

**Cost:** 0.12

**Qty:** 25000

**Ready:** Reviewed

**Itno:** A-1002

**Itds:** Bracket left

**Fuds:** Bracket left, 3 mm steel

**Itty:** FIN

**Itgr:** ASSY

**Unms:** PCS

**Resp:** PLN02

**Cost:** 14.8

**Qty:** 320

**Ready:** Draft

**Itno:** A-1003

**Itds:** Cutting oil

**Fuds:** Cutting oil 20 L drum

**Itty:** CON

**Itgr:** CHEM

**Unms:** L

**Resp:** PLN01

**Cost:** 3.4

**Qty:** 800

**Ready:** Approved

**Itno:** A-1004

**Itds:** Cable 2x1.5

**Fuds:** Cable 2x1.5 mm2 black

**Itty:** RAW

**Itgr:** ELEC

**Unms:** M

**Resp:** PLN03

**Cost:** 0.85

**Qty:** 5000

**Ready:** Draft

**Totals:**

#### Total opening value

**Key:** value

**Agg:** sum

**Format:** currency

#### Items in file

**Key:** itno

**Agg:** count

**Format:** integer

**Summary:**

#### Average value per item

**Key:** avg_value

**Expr:** sum_value / count

**Format:** currency

**Notes:** Field codes follow the usual M3 item fields (ITNO, ITDS, FUDS, ITTY, ITGR, UNMS, RESP). The item types, groups and responsible codes in the sample rows are examples; they must exist in your own settings before a load. Mandatory fields and loading transactions (for example in MMS200MI) vary by version, so validate with a small batch in a test tenant first.

## Content

**Intro:** Item master loads fail on small things: duplicate item numbers, an item group that does not exist, a unit that was never created. This worksheet gives you a clean grid with M3 field codes, a status column and an opening value check so the file is reviewed before it touches M3.

**Sections:**

#### How to use the worksheet

**Body:** Replace the sample rows with your items. Keep one row per item and use the load status column to track Draft, Reviewed, Approved and Loaded, so a partial load can be resumed. Fill in opening quantity and standard cost if you are also loading balances and the value column will calculate. Export to Excel or CSV and map the columns to your loading tool, such as MMS001 import or MMS200MI calls.

#### What to validate before loading

**Body:** Check each value against the settings it points to. Item type, item group, unit of measure and responsible must exist in the corresponding M3 settings programs. Check item number format and length rules from your numbering convention, and make sure descriptions are not truncated by the field length. Duplicates are the most common cause of rejected rows.

**Bullets:**

- No duplicate ITNO values, including different case
- Every ITTY, ITGR and UNMS exists in M3 settings
- Names within field length limits
- Opening value equals cost times quantity and ties to the finance cut-over

#### Common mistakes

**Body:** Loading items first and warehouse data later is fine, but forgetting the warehouse connection (MMS002) leaves items that cannot be used in orders. Another mistake is loading cost through the item and again through a costing program, which doubles setup. Run a pilot of ten items through the whole flow, including a customer order and a purchase receipt, before you load thousands.

**Cta:** For large item clean-ups and duplicate detection before an M3 migration, Netray can run an assisted review over your source data on your own infrastructure.

**Faq:**

#### Which M3 fields are mandatory for an item?

**Answer:** It depends on the version and on settings, but item number, name, item type, item group and basic unit are normally needed. Run a test load in a non-production tenant and read the error messages to learn exactly what your setup demands.

#### Can I load through MMS001 and through an API?

**Answer:** Yes. Many projects use the standard import functions or the item MI program. The API route gives row-level error messages that are easy to log and retry, which helps on large loads.

#### How do I load warehouse data?

**Answer:** After items exist, connect them to warehouses in the item warehouse program and set planning parameters. The worksheet only covers basic item data, so create a second sheet for warehouse level fields.

#### Does this file get uploaded anywhere?

**Answer:** No. All editing happens in your browser and nothing is sent to Netray. Export the file and load it yourself.

## Search terms

M3 item master upload, MMS001 upload template, MMS200MI AddItem, M3 item load excel, M3 data migration item, Infor M3 item creation template, M3 mass item upload

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json