Please Wait a Moment
X

Infor LX Tips, Infor LN Tips, BPCS Tips, Baan Tips, Infor M3 Tips & Infor ERP News

Crossroads Connections

Infor ERP Tips & News from the Experts

Infor LX | Infor LN | BPCS | Baan | Infor M3

Infor LN & Baan Tips & Tricks for FINANCE: Set Up and Calculate Currency Differences

Kathy Barthelt 0 3911 Article rating: 5.0

To set up and calculate currency differences for foreign currencies:

  • Use the Company Parameters (tfgld0503m000) session to specify the profit and loss ledger accounts, 12 profit and loss dimensions, and transaction type for a posting exchange rate differences that is calculated using the FIFO method. To specify this data, use the Currency Diff. FIFO tab. The reports printed from the Print Company Parameters (tfgld0404m000) session, include the Currency Differences FIFO fields.
  • Use the Calculate Currency Differences (tfgld5201m000) session to calculate the currency differences resulting from transactions posted on accounts for which the field Currency Analysis in the session Chart of Accounts (tfgld0508m000) is set to Required.

Infor LN & Baan Tips & Tricks for TECHNOLOGY: Using the Data Access Layer (DAL)

Kathy Barthelt 0 4269 Article rating: 5.0

During an Exchange import, you can use all the functionality programmed into the Data Access Layer (DAL). If you use the DAL, Exchange carries out all the constraint checks, integrity checks, and side effects, for example, updates on other tables, that are programmed into the DAL. Database integrity is guaranteed automatically.

Using the DAL reduces the costs of interface development. You can use the DAL to import standard interfaces developed by Infor for partner products, as well as for specific interfaces built by customers, for example, to integrate LN with legacy systems. You can use the DAL in both single site and multisite environments.

The checks or additional actions specified in the DAL are carried out for each row that is imported. Database errors are logged in the same way for DAL and non-DAL import. DAL hook errors are also logged. You can specify whether the DAL property checks are or are not carried out.

If you specify the use of the DAL for a table relation for an import, the dal.new, dal.update, and dal.destroy functions are used instead of db.insert, db.update, and db.delete. You can choose to use DAL for particular tables and not for other tables, therefore, an import batch can contain both types of table relations simultaneously. The import through DAL works for both the import based on audit or indicators (inserts, updates, deletes), and the full import (inserts only).

DAL settings are run time aspects, which means you can change these aspects without having to regenerate the import program. DAL settings are also logged in the log table at batch line level, to enable you to find out what the DAL settings were when the import was run.

Important to realize is that an update through the DAL can result in a number of side effects. Actions performed by the DAL must not be carried out twice. For example, if the DAL updates the available to promise (ATP) quantity for an item when importing order data, the ATP quantity must not be updated in a condition script as well.

For this reason, you must not add any actions in condition scripts, or import additional data, that are already handled in the DAL.

Infor LX/BPCS Tips & Tricks for TECHNOLOGY: Add Last Maintained Audit Fields to SYS600

George Moroses 0 8300 Article rating: 5.0

LX has enhanced the SYS600 User Security Maintenance application by adding the ZXUP audit fields:

  • Last Maintained Date

  • Last Maintained Time

  • Last Maintained User

These fields are updated whenever a user or role is revised, deleted, or reactivated.

This enhancement provides standard audit tracking to identify who modified a User Security record and when. The audit fields can be used for ad hoc tracking, reporting, and analysis.

Infor LX/BPCS Tips & Tricks for OPERATIONS: Add Item Description to Inbound Delivery Lines

George Moroses 0 7718 Article rating: 5.0

The Inbound Delivery Line Detail panels have been enhanced to provide clearer item information and improved usability.

Key updates include:

  • Item Description added to the Inbound Delivery Lines Selection screen.

  • Increased number of lines displayed on the selection panel.

  • Multi-language support:

    • Item Description is shown in the user’s language (if available).

    • Defaults to the base language if a translation is not available.

  • On the PO Detail panel, the Item Description also supports multi-language display.

These enhancements give users more detailed item information on inbound deliveries, with Item Descriptions presented in their preferred language and more delivery lines visible at once.

Infor LX/BPCS Tips & Tricks for FINANCE: IDF Ledger Book Journal Line Analysis

George Moroses 0 1461 Article rating: 5.0

This enhancement introduces the IDF Ledger Book Journal Line Analysis business object, which displays reference information on summarized journal lines. To implement this enhancement, request and apply MR 81558.

Key features include:

  • Ledger Book Journal Line Analysis

    • Provides analysis attribute details.

    • Has a 1-to-many relationship with Ledger Book Journal Line Source.

    • Default view: General.

  • Ledger Book Journal Line Source

    • Has a many-to-1 relationship with Ledger Book Journal Line Analysis.

    • Displays the Ledger Book Journal Line Analysis detail card.

This enhancement enables users to access detailed reference information on summarized journal lines, improving analysis and reporting capabilities.

Join Us at inPOWER 2025 – Discover What’s Next for LX/BPCS

Frank Petrasio 0 591 Article rating: 5.0

We’re thrilled to invite you to inPower 2025, taking place September 22 to 25, 2025!

This annual conference is the premier event for the LX/BPCS community, bringing together users, experts, and partners to explore the latest advancements, share best practices, and connect with peers who understand your ERP challenges and goals.

👉 Get all the event details here


Why You Should Attend

inPower 2025 is your chance to:

  • Learn from Infor experts and industry leaders.

  • Explore real-world success stories and new strategies.

  • Connect with peers in the LX/BPCS community.

  • Discover solutions that can transform your business operations.


Stop by the Crossroads RMC Booth!

First2345791011Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Infor LN & Baan Tip: The ABC’s & 123’s of Serialized Items
Kathy Barthelt
/ Categories: Infor LN & Baan Tips

Infor LN & Baan Tip: The ABC’s & 123’s of Serialized Items

A serialized item is a physical occurrence of a standard item that is given a unique lifetime serial number. This enables tracking of the individual item throughout its lifetime, for example, through the design, production, testing, installation, and maintenance phases. A serialized item can consist of other serialized components.

In Service, a serialized item can be a customer-specific or owner-specific installation. Installation groups are a group of installations/serialized items such as photocopiers, computers, air conditioners, forklifts, lathe machines, and even aircraft.

A serialized item is identified by both the item code and serial number. You can set up the mask used to generate the serial numbers so the serial number includes some fields of the item data, such as the item group and the manufacturer.

In a multi-company structure, the companies can share the serialized item data. All the service departments in the various companies can refer to the same serialized items.

The serialized item can originate from a sales order or a project. The details of a serialized item indicate their origin, for example, by using specific sets of serial numbers for items that originate from sales orders and from projects. Serialized items can also originate from an as-built structure or directly from the production bill of material in Manufacturing.

In Service, serialized items can start their respective life cycles in As-Built mode or As-Maintained mode. Each serialized item, with or without its installation group, can be covered by a service contract or a warranty.

The serialized item status

Serialized items can be status controlled. Each serialized item can have the following status:

  • Startup - The serial number has been assigned, but the item is not yet included in a service order or contract. You can only change the status to Active.
  • Active - The serialized item is part of a service order or contract. You can only change the status to Revision.
  • Revision - You can only change the status to Active.


Serial numbers

A unique serial number is assigned to every manufactured item or purchased item. The serial number is assigned to track the item in its life cycle. You can define a dummy serial number for an item. The dummy serial number is a temporary number and can be used to monitor the item until a permanent number is assigned. For each serialized item, you can define an alternative serial number for customer reference. You can use the alternative serial number to search for items when you register calls, create service order activities, or register parts lines for a maintenance sales order.


Serialized item groups

You can group serialized items by serialized item groups. A serialized item group is a group of serialized items with similar features. You can define the serialized item groups that you need, for example, to categorize the skills required for the maintenance of the items, or as a basis for enquiries and reporting. For example, you can select service engineers on the basis of their skills for a specific serialized item group.


Serialized items in physical breakdown structures

Serialized items are the building blocks of physical breakdown structures. A physical breakdown structure is the relationship definition of a set of serialized items with their underlying parts and assemblies. Some serialized items, such as a photocopier, have a simple structure whereas other serialized items such as a ship or an aircraft have a complex structure.

A top serialized item occurs at the highest level in the physical breakdown structure, while the underlying structure consists of assemblies that are either effective or outdated. Use the Tree View option to display a graphic view of the structure.

Each serialized item in the breakdown can be linked to a functional element, with a common function across the entire structure, and can be used to group serialized items based on the functional importance.

Previous Article Infor LN & Baan: Customizing Shipping Labels for All Customers
Next Article Infor LN & Baan Tip: Outbound Order Lines
Print
26458 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories