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

The Far-Reaching Impact of Disconnected Data

Kathy Barthelt 0 1822 Article rating: 5.0

Disconnected data doesn’t just slow you down—it creates bottlenecks across your entire business. When your ERP isn’t connected to the systems you rely on, every department feels it.

How Disconnected Data Hurts Your Organization

  • Operations: Spreadsheets and manual order entry waste valuable time.
  • Finance: Budgets, POs, and invoices stuck in silos cause delays and errors.
  • Technology: Teams burn hours exporting data to stay “up to date.”
  • Executives: No single source of truth makes it hard to see the big picture.

A recent study found that 61% of companies face project delays from slow data integration, while employees waste the equivalent of 19 workdays per year moving data between systems. That’s lost productivity you can’t afford.

Why ERP Integration Matters
Your ERP is the heart of your operations. Connecting it to the rest of your business tools unlocks:

  • Real-time data access → no more outdated spreadsheets.
  • Improved communication → one source of truth for every team.
  • Higher productivity → eliminate duplicate entry and manual reporting.
  • Smarter supply chains → better visibility, fewer delays.
  • Sales enablement → reps get live pricing, inventory, and customer data.


Simplify Integration with Infor ION...

Infor LN & Baan Tips & Tricks for OPERATIONS: Subcontracting Overview

Kathy Barthelt 0 3163 Article rating: 5.0

Companies can decide to involve a subcontractor and subcontract part of their activities. The subcontractor carries out the work and returns the products to your company.

In Infor LN, subcontracting is considered as purchasing labor from a third party. Therefore, if a manufacturer wants to subcontract work, he must generate a purchase order to start the subcontracting process. These are the types of subcontracting:

  • Subcontracting with material flow
    • Operation subcontracting: For operation subcontracting, a part of the production process (one or more operations) is subcontracted.
    • Item subcontracting: For item subcontracting, an item's entire production process is subcontracted. Therefore, it is always used with material flow support.
  • Subcontracting without material flow: The simplest form of subcontracting is to generate a subcontracting purchase order to record the operations outsourced to a subcontractor. The subcontracting purchase order only represents the administrative handling of the subcontracting process. When the subcontracted item is received back from the subcontractor, you must close the subcontracting purchase order, which initiates the production process.
  • Unplanned subcontracting: Unplanned subcontracting is applicable when you subcontract after generating a production order. For unplanned subcontracting, a purchase order is generated from the production order and the material supply lines are populated by Shop Floor Control.
  • Service subcontracting: For service subcontracting, work on an item to be maintained or repaired is subcontracted. This work entails the entire repair process, or only a part of it. Service subcontracting can be used with or without material flow support.

To start the subcontracting process, a purchase order is required.

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

Kathy Barthelt 0 1449 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 1511 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 3189 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 2882 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 440 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.

124678910Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan Tip: Latest Porting Set – All Versions of Infor LN & Baan

Are you on the latest porting set for your version of Baan / Infor LN? Check here to be sure:

VERSIONS: Infor LN, Infor Baan ERP 5.0c, Infor Baan IVc4

LAST MODIFIED ON:
13th Jan, 2021: Updated with 9.3i porting set, see KB 2176336 for this version. Available from LN CE release 2021.01
9th Oct, 2020: Updated with 9.3h porting set, see KB 2158949 for this version. Available from LN CE release 2020.10
9th July, 2020: Updated with 9.3g porting set, see KB 2142625 for this version. Available from LN CE release 2020.07
10th April, 2020: Updated with 9.3f porting set, see KB 2125567 for this version. Available from LN CE release 2020.04
13th Jan, 2020: Updated with 9.3e porting set, see KB 2108810 for this version
11th Oct, 2019: Updated with 9.3d porting set, see KB 2093165 for this version
11th July, 2019: Updated with 9.3c porting set, see KB 2075437 for this version
13th March, 2019: Updated with 9.3b porting set, see KB 2051365 for this version
7th Dec, 2018: Updated with 9.3a porting set, see KB 2033165 for this version
6th Sept, 2018: Updated with 9.2b.01 porting set, see KB 2014729 for this version
8th June, 2018: Updated with 9.2b porting set, see KB 1997100 for this version
12th March, 2018: Updated with 9.2a.01 porting set, see KB 1972861 for this version
11th Dec, 2017: Updated with 9.2a porting set, see KB 1954406 for this version
8th Sept, 2017: Updated with 9.1c.01 porting set, see KB 1934704 for this version
10th June, 2017: Updated with 9.1c porting set, see KB 1915968 for this version
20th March, 2017: Updated with 9.1b.01 porting set, see KB 1897691 for this version
9th Dec, 2016: Updated with 9.1b porting set, see KB 1876613 for this version
22nd Sept, 2016: Updated with 9.1a.01 porting set, see KB 1856545 for this version
23rd June, 2016: Updated with 9.1a porting set, see KB 1836486 for this version
14th March, 2016: Updated with 9.0c.01 porting set, see KB 1700568 for this version
11th Dec, 2015: Updated with 9.0c porting set, see KB 1677286 for this version
17th Sept, 2015: Updated with 9.0b.01 porting set, see KB 1654371 for this version
19th June, 2015: Updated with 9.0b porting set, see KB 1630218 for this version
20th March, 2015: Updated with 9.0a.01 porting set, see KB 1605781 for this version
9th Jan, 2015: Updated with 8.9a.06 porting set, see KB 1586121 for this version, this is only 32 bit for windows and linux.
17th Nov, 2014: Updated with 9.0a porting set, see KB 1572748 for this version, 12 Dec 2014, new version for windows released.
26th Sept, 2014: Updated with 8.9a.05 porting set, see KB 1539050 for this version
11th July, 2014: Updated with 8.9a.04 porting set, see KB 1517147 for this version
5th April, 2014: Updated with 8.9a.03 porting set, see KB 1490061 for this version
10th Jan, 2014: Updated with 8.9a.02 porting set, see KB 1465391 for this version
4th Oct, 2013: Updated with 8.9a.01 porting set, see KB 1442188 for this version
19th July, 2013: Updated with 8.9a porting set, see KB 1422389 for this version
1st March, 2013: Updated with 8.8a.03 porting set, see KB 1381629 for this version
30th Nov, 2012: Updated with 8.8a.02 porting set, see KB 1356958 for this version
13th Sept, 2012: Updated with 8.8a.01 porting set, see KB 1181506 for this version
30th May, 2012: Updated with 8.8a porting set, see KB 1154144 for this version
19th Jan, 2012: Updated with 8.7b.01 porting set, see solution 1120445 for this version. This is the first version that can also be used for Infor BaanIV c
7th Oct, 2011: Updated with 8.7a.03 porting set, see solution 1062346 for this version
17th June, 2011: Updated with 8.7a.02 porting set, see solution 1025539 for this version
31st March, 2011: Updated with 8.7a.01 porting set, see solution 1007520 for this version
17th Jan, 2011: Updated with new version of 8.7a porting set
3rd Dec, 2010: Updated with 8.7a porting set, see solution 22945526 for this version
8th Oct, 2010: Updated with 8.6a.03 porting set, see solution 22899106 for this version
17th June, 2010: Updated with 8.6a.02 porting set, see solution 22899105 for this version
1st April, 2010: Updated with 8.6a.01 porting set, see solution 22899104 for this version
11th February, 2010: Updated with the 64-bit 8.6a porting set, see solution 22899103 for this version
1st Dec, 2009: Updated with new 8.6a porting set, see solution 22899103 for this version
1st Oct, 2009: Updated with new 8.5a.03 porting set, see solution 22899102 for this version
18th June, 2009: Updated with new 8.5a.02 porting set, see solution 22899101 for this version
19th March, 2009: Updated with new 8.5a.01 porting set, see solution 22899100 for this version
4th Dec, 2008: Updated with new 8.5a porting set, see solution 22899099 for this version
23th Oct, 2008: Updated with new 8.4c.02 porting set, see solution 22899098 for this version
23th July, 2008: Updated with new 8.4c.01 porting set, see solution 22899097 for this version
2nd July, 2008: Updated with new 8.4c porting set, see solution 22899096 for this version
13th March, 2008: Updated with new 8.4b porting set, see solution 22899095 for this version
24th Jan, 2008: Updated with new 8.4a.02 porting set, see solution 22899094 for this version
21st Dec, 2007: Updated with new 8.4a.01 porting set for Windows, see solution 22899093 for this version
31st Aug, 2007: Updated with new 8.4a.01 porting set, see solution 22899093 for this version
25th June, 2007: Updated with new 8.4a porting set, see solution 22899115 for this version
4th Jan, 2007: Updated with new 8.3a.01 porting set, see solution 22899114 for this version
20th Oct, 2006: Updated with new 8.3a porting set, see solution 22899113 for this version
23th Aug, 2006: Updated with new 8.2b porting set for windows, see solution 22899112 for this version
16th June, 2006: Updated with Porting set 8.2b: see solution 22899112 for this version
28th April, 2006: Updated with Porting set 7.6b_01: see solution 22899111 for this version
9th March, new version of 7.6b Porting set released, see solution below,(22899110)
6th Dec, 2005: Updated with Porting set 7.6b: see solution 22899110 for this version
15th June, 2005: Updated with Porting set 7.6a.02: see solution 22899109 for this version
27th April, 2005: Updated with Porting set 7.6a.01: see solution 22899108 for this version
4th Dec, 2004: Updated with Porting set 7.6a: see solution 22899107 for this version


SITUATION DESCRIPTION:
A porting set is a set of binaries, which are operating system dependent. It is the layer between the operating system and the application software. Infor regularly releases a new porting set. A bugfix number recognizes every modification made in the porting set.

Previous Article Infor LN & Baan Materials Tips: Serialized and Lot Controlled Items
Next Article Infor LN & Baan Tip: Performance Standard Cost
Print
66009 Rate this article:
4.5
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories