Format Codes in Infor LN: Data Formats and Masks
format code infor ln
Also searched as
- infor ln display format domain
- infor ln number format mask
- infor ln date format code
Short answer
In Infor LN the way a number, date or code is displayed comes from the format attached to its domain, not from the table column. A format code or display mask (for example separators, decimals, leading zeros) is defined on the domain in the Tools data dictionary, and every field that uses the domain inherits it. Change formats on the domain, in development, and test affected sessions and reports.
Applies to: Infor LN 10.x and ERP LN 6.x; the Domains session is commonly ttadv4500m000, confirm in your release
How to define or change a format
- 1Identify the field and its domain in the data dictionary (the field definition names the domain).
- 2Open the Domains session in Tools (commonly ttadv4500m000, or search for domain).
- 3Check the domain's type, length and display format (mask), for example how many decimals and whether thousands separators show.
- 4Change the format on the domain only if every field using it should change; otherwise create a new domain for the new need.
- 5Convert and compile the affected dictionary objects as your change process requires, in a development VRC first.
- 6Test the sessions, forms and reports that use the domain, including exports.
- 7Transport the change through your normal release route.
Format versus storage
A display format changes how a value looks, not how it is stored. A quantity stored with four decimals can be shown with two, but the stored precision is set by the domain definition itself. Mixing these up leads to rounding questions that are really storage questions.
Changing the stored length or decimals of a domain is a structural change that needs table conversion. Changing only the display mask is lighter, but still touches every field on the domain.
Date, number and code formats
Dates follow the user or system date format and language settings, so two users can see different layouts for the same stored date. Numbers follow the decimal and thousands separators of the language setting. Code fields (such as item or order codes) use masks that control case and allowed characters.
If users complain about a layout, first check their language and user data before changing a domain.
Reports and exports
Report layouts can apply their own format on top of the domain. When a value looks right on screen but wrong in a report, check the report field's format property. For exports to Excel, prefer exporting raw values so the receiving tool applies its own format.
Keep a record of custom domains so upgrades do not overwrite or lose them.
Try it here, free
Infor 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.
Common pitfalls
- !Editing a shared domain to fix one field and altering every field that uses it.
- !Confusing display format with stored precision.
- !Changing domains directly in production instead of a development VRC.
- !Not retesting reports and exports after a format change.
How an ERP-grounded AI assistant handles this
Netray adds a private AI layer on top of the Infor LN you already run, including on-prem installs. ERPray answers questions in plain language over LN data read-only, shows the query it ran and respects LN roles, so a consultant can ask the question instead of hunting for the session. The model runs on your own GPUs, nothing leaves your network, and any write-back needs a human approval. Cloud-hosted LN works too, but the design is tuned for on-prem and air-gapped sites. For pure navigation questions, LN's own session search and help are often enough.
Frequently asked questions
What is a format code in Infor LN?
It is the display mask or format attached to a domain that decides how a number, date or code is shown. Fields using the domain inherit it.
Can I change the format for just one field?
Not on a shared domain without affecting others. Give the field its own domain, or format it in the report or form layer.
Why do dates look different for different users?
Date layout follows the user's language and regional settings. Check the user data before changing the domain.
Does changing the format convert stored data?
A display-only change does not alter stored values. Changing length or decimals is structural and needs a table conversion.
Related
Infor LN Report Designer: How to Build and Personalize Reports
Infor LN reports are designed in LN Studio's report designer, where a report is defined by its input fields, data selection through the session's tables and a layout of sections. To personalize a standard report, copy it into your customer VRC and edit the copy, never the standard object, so upgrades do not overwrite your work.
How-toConversion Factor Session in Infor LN: Setup and Common Errors
Infor LN converts between units using conversion factors, either general factors between units of the same physical dimension or item-specific factors that override them. When an item is bought in one unit and stocked in another, LN needs a factor for that pair. A missing factor is the usual cause of a conversion error on purchase orders, receipts or sales lines.
AdvancedInfor LN Process Variables: Meaning, Setting and Inspecting
Every Infor LN session runs inside a bshell process that carries environment variables (such as BSE, the installation root) and in-memory process variables used by the 4GL code. Developers read and set process variables from code, commonly with the 4GL calls get.var and put.var, and inspect environment values from the shell or bshell startup options. Check how your version exposes them before relying on one.
AdvancedInfor LN Text Table: How Text Fields Are Stored
In Infor LN, long text on records such as items, orders and customers is not stored in the business table itself. The record holds a text number, and the text lines live in the text table (tttxt010, per company), keyed by text number and language. To read text with SQL join on that number; to copy it, use the standard text copy functions rather than raw inserts.
Error fixInfor LN bshell Process Stuck at 100% CPU: How to Diagnose and Fix It
A bshell process pinned at 100% CPU on the Infor LN application server almost always means one session is stuck in a 4GL loop, scanning an unindexed table, or waiting on a database lock. End the session from the Sessions Monitor first, then kill the OS process only if that fails, and check for a blocking database transaction before assuming it is a bug.
Error fixInfor LN Not Authorized to Run This Session: How to Fix It
Infor LN refuses to open a session with a not authorized message when the logged-in user's assigned role does not include that session, or when the session is blocked for the company they are logged into. Grant the session through Common > Authorization Management > Roles, or check the user's role and company context, and the session opens on retry. In most cases this is a permissions configuration issue, not a bug.
AI for ERPAI for Infor LN: Sessions, BODs, and Engineer-to-Order Work
Add grounded AI to Infor LN 10.x or CloudSuite: natural-language answers over sessions and BODs, agents for project and engineer-to-order work, on-prem options.
Stuck on Infor LN?
Talk to engineers who work inside Infor LN every week, and who build private AI that answers these questions from your own ERP data.
Keep exploring
Free tools
- Infor LN Session and Module Code ReferenceSearchable list of the Infor LN / Baan package and module codes (tisfc, tdsls, whinh and others) with what each one covers.
- Infor LN and Baan Customization Inventory WorksheetEditable worksheet to list every Baan or LN customization with type, owner, effort and a retire, keep or replace decision.
- Infor LN Change Request Form TemplateFill-in change request form for LN and Baan changes, covering scope, impact, testing, rollback and sign-off.
ERP fixes and how-tos
- Infor LN Date Format: User, Language, Reports and IntegrationsHow date formats work in Infor LN: user and language settings, Web UI locale, reports, and how to handle date conversion in integrations and BODs.
- Cannot Find Session Info in Baan and Infor LN: Causes and FixFix the cannot find session info error in Baan and Infor LN: session missing from the VRC or runtime dictionary, package mismatch, and how to reconvert.
- Infor LN General Table Maintenance: Finding and Editing Tables SafelyWhere general table maintenance sits in Infor LN, how to find the right session for a table, and how to change table data safely, no direct DB edits.
Guides
- Infor LN Domain Structure Design: Architecture GuideDesign robust Infor LN domain structures including data dictionary domains, table relationships, key definitions, and index strategies for BAAN/LN development.
- Infor LN Domain Administration GuideAdminister Infor LN domains effectively. Domain architecture, user management, environment configuration, and system maintenance best practices.
- BAAN 5 to Infor LN Complete Migration GuideMigrate from BAAN 5 to Infor LN comprehensively. 4GL analysis, data transformation, business process mapping, and organizational change management.
Integrations
- How to build an MCP server for Infor LNHow to build a Model Context Protocol server for Infor LN: which read-only tools to expose, auth through ION API, stdio versus HTTP, permission scoping and audit.
- How to add WhatsApp to Infor LNHow to connect WhatsApp to Infor LN: ION BODs and APIs, template messages, opt-in rules, supplier confirmations and order status, including on-prem LN setups.