Infor LN Item Unit Conversion Factor Worksheet
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.
| Item (blank = generic) | From unit | To unit | Factor (1 from = x to) | Inverse (1 to = x from) | Test qty (from unit) | Test qty in to unit | Planned rounding | Unit set | Used in | Notes | |
|---|---|---|---|---|---|---|---|---|---|---|---|
0.0833 | 60 | ||||||||||
0.001 | 2,500 | ||||||||||
0.025 | 120 | ||||||||||
0.02 | 200 | ||||||||||
0.01 | 200 | ||||||||||
0.2 | 50 | ||||||||||
0.002 | 500 |
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.
Get your conversions checked
Send the completed worksheet and we will check factor direction, item-specific overrides and the unit setup against your LN version.
Optional. The tool and every export work without this. No spam.
How to use it
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.
- 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
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
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
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.
Frequently Asked Questions
Where are conversion factors maintained in Infor LN?
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?
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?
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?
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.
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.
Related Tools
Baan to Infor LN Data Conversion Mapping Worksheet
Field-level mapping sheet for Baan or legacy data moving into Infor LN, with transform rules, owners and load status.
Infor LN & BaanInfor LN Logical Table Sharing Design Worksheet
Plan which LN tables a logical company reads from a physical company, including the reference tables that must be shared with them, before you touch Logical Tables.
Infor LN & BaanInfor LN Table Name and SQL Query Builder
Turn an LN logical table such as tcibd001 into the physical SQL table name with company suffix and a ready SELECT statement.
Infor LN & BaanInfor LN Session and Module Code Reference
Searchable list of the Infor LN / Baan package and module codes (tisfc, tdsls, whinh and others) with what each one covers.
More Infor LN & Baan tools
See all- Infor LN Production Order Status and Lifecycle Reference
- Infor LN 4GL Session Script Template
- Infor LN Company and Enterprise Unit Design Worksheet
- Infor LN DAL Hook Review Checklist
- Infor LN Warehousing Order Origins and Types Reference
- Infor LN Regression Test Effort Calculator
- Infor LN and Baan Customization Inventory Worksheet
- Infor LN User Role and Authorization Matrix Worksheet
- Infor LN Change Request Form Template
Keep exploring
Free tools
- Baan to Infor LN Data Conversion Mapping WorksheetField-level mapping sheet for Baan or legacy data moving into Infor LN, with transform rules, owners and load status.
- Infor LN Company and Enterprise Unit Design WorksheetPlan LN companies, enterprise units, sites and currencies row by row, with user and volume totals, and export to Excel.
- Infor LN EOQ Order Quantity CalculatorCalculate economic order quantity, orders per year and total annual cost, then use the result to set LN item ordering data.