# Infor XA Item Master Field Worksheet

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

## Short answer

An editable worksheet for walking through XA item master fields, deciding what to keep, clean or map, and who owns each decision.

## Category

erp-migration

## Erp

Infor XA

## Industry

Discrete Manufacturing

## Audience

- Data steward
- ERP project lead
- Materials manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Field or concept

**Key:** field

**Type:** text

#### Example XA value

**Key:** xa_value

**Type:** text

#### Records affected

**Key:** records

**Type:** number

#### Action

**Key:** action

**Type:** select

**Options:**

- Keep as is
- Clean
- Map to new value
- Retire

#### Owner

**Key:** owner

**Type:** text

#### Minutes per record

**Key:** minutes

**Type:** number

#### Effort (hours)

**Key:** hours

**Type:** number

**Expr:** records * minutes / 60

**Format:** decimal

**Rows:**

**Field:** Item number

**Xa value:** AB-100-22

**Records:** 18000

**Action:** Clean

**Owner:** Materials

**Minutes:** 0.5

**Field:** Item description

**Xa value:** BRKT MTG STL 1/8

**Records:** 18000

**Action:** Clean

**Owner:** Engineering

**Minutes:** 0.4

**Field:** Item class

**Xa value:** FG, RM, SA

**Records:** 18000

**Action:** Map to new value

**Owner:** Finance

**Minutes:** 0.1

**Field:** Unit of measure

**Xa value:** EA, FT, LB

**Records:** 18000

**Action:** Map to new value

**Owner:** Materials

**Minutes:** 0.1

**Field:** Make or buy code

**Xa value:** M or B

**Records:** 18000

**Action:** Keep as is

**Owner:** Planning

**Minutes:** 0

**Field:** Standard cost

**Xa value:** 12.4300

**Records:** 9000

**Action:** Clean

**Owner:** Cost accounting

**Minutes:** 0.6

**Field:** Lead time

**Xa value:** 14

**Records:** 9000

**Action:** Clean

**Owner:** Planning

**Minutes:** 0.5

**Field:** Obsolete or no activity items

**Xa value:** No usage in 5 years

**Records:** 6000

**Action:** Retire

**Owner:** Materials

**Minutes:** 0.2

**Totals:**

#### Records touched (sum of rows)

**Key:** records

**Agg:** sum

**Format:** integer

#### Total effort (hours)

**Key:** hours

**Agg:** sum

**Format:** decimal

**Summary:**

#### Effort in working days (7.5 hours)

**Key:** days

**Expr:** sum_hours / 7.5

**Format:** decimal

**Primary:** true

**Notes:** Field names here are descriptive concepts, not exact XA file or column names, because they vary between releases and modifications. Replace the rows with the fields on your own item master and fill in minutes per record from a short sample.

## Content

**Intro:** Item master quality decides whether a migration or cleanup goes smoothly. This worksheet turns the review into a list of fields with an action, an owner and an effort estimate that rolls up into working days.

**Sections:**

#### How to use the worksheet

**Body:** Replace the sample rows with the real fields on your XA item master, including any user defined or added fields. For each one, enter a typical value, the number of records affected and choose an action: keep, clean, map to a new value or retire. Add an owner who can decide, and estimate minutes per record by timing a sample of ten. Effort per row calculates automatically and the summary converts the total to working days. Export to Excel to share and track.

#### Choosing the right action

**Body:** Keep means the value moves across unchanged. Clean means the value is right in concept but needs correction, such as inconsistent descriptions or wrong units. Map means the old code becomes a different code in the target, which is typical for item classes and units of measure. Retire means the record or value is dropped, such as items with no activity for years. Each action has a different cost and risk, so being explicit drives a realistic plan.

**Bullets:**

- Keep: no effort beyond load testing.
- Clean: manual or scripted correction.
- Map: build and test a translation table.
- Retire: agree rules with finance and quality.

#### Reading the effort number

**Body:** The effort total is an estimate of hands on data work, not project duration. A figure of a few dozen days spread across several owners is normal for a medium item master. If one row dominates, for example descriptions, consider scripted cleansing and sample based review instead of record by record edits. Always add time for review and for reloading after corrections, since a first load rarely passes cleanly.

#### Common mistakes

**Body:** Teams migrate every item that exists, including thousands that nobody has used for years, which inflates both effort and ongoing noise. Others forget user defined fields that carry real meaning, such as customer part numbers or compliance flags. Finally, mapping tables are agreed informally and never documented, so nobody can explain later why a class changed. Record each decision in the worksheet.

**Cta:** If your item master has too many records to review by hand, we can use AI to flag duplicates, inconsistent descriptions and likely obsolete items for your team to confirm.

**Faq:**

#### Are these exact XA field names?

**Answer:** No. They are descriptive concepts because file and field names differ between releases and customizations. Replace the rows with the actual fields from your own item master and any user defined fields you added.

#### How do I estimate minutes per record?

**Answer:** Time yourself or a colleague on a random sample of about ten records for each action, and use the average. Include time to look things up. Add a margin for review, since the first pass is faster than the second.

#### Should I migrate obsolete items?

**Answer:** Usually not as active items. Agree a rule, for example no transactions for several years and no open demand, and retire or archive those. Keep what you need for history, warranty or audit obligations, and document the rule.

#### Can I use this for tools other than XA?

**Answer:** Yes. The structure works for any item master review. Only the sample rows are XA flavored, so rename the fields to match your own system and the effort math still applies.

## Search terms

infor xa item master, mapics item master fields, xa item master cleanup, mapics data migration worksheet, item master data mapping template, xa item master excel, mapics item master review, item master migration checklist

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