# Infor LN Item Unit Conversion Factor Worksheet

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

## Short answer

List generic and item-specific unit conversions for LN 10.x with inverse factors and a test quantity check, so the factors are right before anyone types them in.

## Category

infor-ln

## Erp

Infor LN

## Audience

- LN master data specialist
- LN functional consultant
- Inventory planner

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Item (blank = generic)

**Key:** item

**Type:** text

#### From unit

**Key:** from_unit

**Type:** text

#### To unit

**Key:** to_unit

**Type:** text

#### Factor (1 from = x to)

**Key:** factor

**Type:** number

#### Inverse (1 to = x from)

**Key:** inverse

**Type:** number

**Expr:** 1 / factor

**Format:** decimal

#### Test qty (from unit)

**Key:** test_qty

**Type:** number

#### Test qty in to unit

**Key:** test_result

**Type:** number

**Expr:** test_qty * factor

**Format:** decimal

#### Planned rounding

**Key:** rounding

**Type:** select

**Options:**

- None
- Up
- Down
- Nearest

#### Unit set

**Key:** unit_set

**Type:** text

#### Used in

**Key:** used_in

**Type:** select

**Options:**

- Sales
- Purchase
- Inventory
- All

#### Notes

**Key:** notes

**Type:** text

**Rows:**

**From unit:** box

**To unit:** pcs

**Factor:** 12

**Test qty:** 5

**Rounding:** None

**Unit set:** STD

**Used in:** All

**Notes:** Generic: every box holds 12

**From unit:** kg

**To unit:** g

**Factor:** 1000

**Test qty:** 2.5

**Rounding:** None

**Unit set:** STD

**Used in:** All

**Notes:** Generic weight conversion

**From unit:** plt

**To unit:** box

**Factor:** 40

**Test qty:** 3

**Rounding:** Down

**Unit set:** STD

**Used in:** Inventory

**Notes:** Standard pallet pattern

**Item:** FAB-ROLL-150

**From unit:** roll

**To unit:** m

**Factor:** 50

**Test qty:** 4

**Rounding:** None

**Unit set:** FABRIC

**Used in:** All

**Notes:** Item-specific: 50 m per roll

**Item:** FAB-ROLL-300

**From unit:** roll

**To unit:** m

**Factor:** 100

**Test qty:** 2

**Rounding:** None

**Unit set:** FABRIC

**Used in:** All

**Notes:** Overrides generic roll factor

**Item:** PNT-RAL9005

**From unit:** can

**To unit:** l

**Factor:** 5

**Test qty:** 10

**Rounding:** Up

**Unit set:** LIQUID

**Used in:** Purchase

**Notes:** Supplier sells 5 l cans

**Item:** CBL-H07RNF

**From unit:** drum

**To unit:** m

**Factor:** 500

**Test qty:** 1

**Rounding:** None

**Unit set:** CABLE

**Used in:** Sales

**Notes:** Check if drums vary in length

**Summary:**

#### Conversions listed

**Key:** rows

**Expr:** count

**Format:** integer

**Notes:** Inverse = 1 / factor. Test result = test quantity x factor. Unit codes here are examples; use the codes defined in your Units data. Generic factors apply to every item; an item-specific factor overrides the generic one for that item. Confirm the conversion factor session names and the unit set setup for your LN version in the LN help before entry.

## Content

**Intro:** This worksheet prepares unit conversion factors for Infor LN 10.x before they are entered: generic conversions that apply to all items and item-specific ones that override them. Each row computes the inverse and converts a test quantity so obvious mistakes show before the data reaches production.

**Sections:**

#### How to use it

**Body:** Leave the item blank for a generic conversion and fill it for an item-specific one. Enter the from unit, the to unit and the factor as how many to-units one from-unit equals. The inverse column shows the reverse direction, and the test columns convert a quantity you know the answer to, such as 5 boxes to 60 pieces. Record the planned rounding, the unit set the item uses, where the conversion matters (sales, purchase, inventory) and any notes. Export the sheet for review by purchasing, sales and warehouse before entry.

**Bullets:**

- Write factors in the direction you will enter them
- Check every item-specific row against a real package or label
- Keep the inventory unit of the item (tcibd001) in mind as the base

#### The method

**Body:** A conversion factor states quantity in to-unit = quantity in from-unit x factor. The inverse is 1 / factor, so 1 pc = 0.0833 box when 1 box = 12 pcs. LN converts between an item's inventory unit and the units used on orders, so a wrong factor shows up as wrong stock, wrong prices per unit and wrong planned quantities, not as an error message. Generic factors suit physical constants (kg to g) and company-wide packaging rules; item-specific factors suit anything that depends on the item, such as metres per roll or litres per can.

#### Worked example

**Body:** Two fabric items are sold by the roll and stocked in metres. FAB-ROLL-150 has 50 m per roll and FAB-ROLL-300 has 100 m, so each needs an item-specific factor: 4 rolls of the first convert to 200 m, 2 rolls of the second to 200 m. A single generic roll-to-metre factor would make one of them wrong. The paint row converts 10 cans to 50 litres with rounding up, which matches buying whole cans.

#### Common mistakes

**Body:** Entering the factor in the wrong direction (0.0833 instead of 12) is the classic error: 5 boxes would then convert to about 0.42 pieces instead of 60, a 144-fold quantity error. Others are a generic factor where items differ, a missing conversion that blocks an order line in an alternative unit, and changing a factor after transactions exist, which leaves historic quantities interpreted under the old rule. Agree conversions before go-live, test an order in each unit, and keep this sheet as the record.

**Cta:** If you want planners to ask LN about stock and orders in any unit in plain English, on your own servers, we can set that up.

**Faq:**

#### Where are conversion factors maintained in Infor LN?

**Answer:** LN has conversion factor sessions in the common item data for generic and item-specific factors. Session codes differ between versions and feature packs, so open the LN help for your version and search for conversion factors before entry rather than relying on a code from another release.

#### What is the difference between a generic and an item-specific conversion factor?

**Answer:** A generic factor applies to every item that uses those two units, such as kg to g. An item-specific factor applies to one item and takes precedence over the generic factor, which is needed when packaging differs by item, such as metres per roll.

#### How do I check a conversion factor is correct?

**Answer:** Convert a quantity you can physically verify, such as one sealed box or a full pallet, and compare. The worksheet's test columns do this per row. Then create a test order in the alternative unit in a test company and check the inventory quantity it produces.

#### Can I change a conversion factor after go-live?

**Answer:** You can, but existing transactions, open orders and stock history were calculated with the old factor. Plan the change at a quiet point, check open orders in that unit and document the date of the change so reports can be interpreted correctly.

## Search terms

conversion factor session in infor ln, infor ln conversion factors, ln item specific conversion factor, ln unit of measure conversion, ln unit set, ln inventory unit conversion

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