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 1695 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 2860 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 1337 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 1382 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 2862 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 2549 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 372 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.

1345678910Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Anthony Etzel
/ Categories: Tales from the Road

New Definition of Insanity: Collect data the same old way

Just because you've always done it this way doesn't mean it's the best way. The old way of doing things may get the job done, but is the job being performed efficiently, accurately, and on a timely basis?

Are you stuck in manual?

People resist change. There is an element of fear behind change: having to learn something new. Sometimes it’s just that you’re comfortable with how things are done, and you don’t see the need to make any changes. Think about this: as time goes on, different methods have been established to improve how things are done. Let’s take for example drilling a hole into a piece of wood. The old way would have been with a manual hand ratchet and drill bit. The new way is with a power drill. Because the new way required less effort than the old way, the new way was adopted and the old way was done away with. The goal was to drill a hole. With the manual method, the hole may not have been drilled straight and the number of holes drilled in one hour would have been significantly less than the number of the holes drilled with the power drill. So, then, are you stuck in manual?


Time-Saving Tools do help – everything

In manufacturing today, changes are always being made. New computer systems are installed, new software applications are implemented.  CAD systems are used, and a variety of other time-saving tools have been adopted into the design engineering arena. On the production floor, the new equipment has been installed that is more efficient and allows products to be produced faster. Technology is rapidly changing. Manufacturing equipment often times are controlled with computer-assisted programs. This would eliminate the need for someone to manually set up the equipment. Think of the many ways your business could benefit by reducing the time it takes to perform critical tasks.

The Problem with: “We’ve-always-done-it-this-way” kind of thinking

In the warehouse, the use of barcodes and handheld laser scanners has been adopted, eliminating the need to handwrite and record inventory transactions. But what about what goes on with regard to how information is collected and communicated to the shop floor?

It appears as though the old methods of making copies of drawings, copies of shop packets, and manual labor tickets continue to be the norm. The reason is that we’ve always done it this way. Perhaps supervisors and managers feel as though they have better control of managing the paper trail. However, with any paper-based system, you are subject to errors. You rely upon your employee properly following the paperwork and filling out what activities have been completed along with the duration of time it took to complete those activities. How accurate is the time that is recorded? The time recorded is usually the employee’s best guess, or what they believe the standard amount of time should be. Labor tickets are subject to error first through the legibility of the handwriting. Second, the labor tickets would be keyed in to the system and errors can happen with data entry. Have you thought about the cost to your organization to fix errors?  

…One time a manufacturer thought they had their labor costs under control until one day the labor activity for a routine job almost tripled. By the time they discovered this, it was too late, and the entire job ran with significant labor overages. The problem could have been addressed with a simple task to watch and record the production activity in a real-time mode. They needed an automated way to monitor activity before a small problem turned into a big cost and a loss for the job.
 

Poor performance indicators make for poor outcomes

Companies today continue to tolerate and accept how labor and production information is recorded. The reliability of that information is questionable. In addition to collecting labor and production information, there are many other pieces of information manually recorded from the shop floor. A critical element of information for productivity throughput would be to examine how much time the work center or machine was actually up and running. Downtime is another critical element of data that is usually manually recorded along with a reason identifying what caused production to stop. If this information is not provided on a timely and accurate basis, then what good is it anyway? Forms are filled out, data may or may not be keyed to a spreadsheet, the forms are sorted and filed, but is anybody really looking at the information that was recorded? Think about the amount of time it takes to manage the manual collection of information from your shop floor. What would real-time access to data mean to your organization?

Benefits:

1.  Real-Time Production Visibility

2.  Reduced Paperwork Load

3.  Downtime and Scrap Visibility

4.  WIP Inventory Visibility

5.  Improve Efficiency, Capacity Utilization


How to get technology that will preserve your sanity

There are easier and more efficient ways to manage shop floor information. One of the best ways to communicate and report information from the shop floor is by utilizing a Manufacturing Execution System (MES). Manufacturing Execution Systems provide a paperless approach to the information required on the shop floor. Factory workers can check a screen for instructions, review drawings, and perhaps even watch a video. The factory worker just touches the screen to indicate the job that is being worked on. It is easy to report what was produced, what was scrapped, and how much downtime may have occurred.

Back to “we have always done it this way”…

I know of many manufacturing companies where the employees maintain a logbook of all of their activities in the event they are challenged on any of the time that they have submitted. With an MES solution, the logbooks can be done away with, and employees can maintain and see an electronic log showing their transactions. Transaction history can be made available showing activities as far back as you want to show. Once a factory worker fully understands how easy it is to use an MES solution, they will never want to go back to the old way of using paper and pencil again. Your organization can now take advantage of the “new way” and become more efficient as a result.
 

6 powerful steps to win with automation:

1. Eliminate paper shop packet and distribution of the paperwork to the shop floor.     

2. Eliminate manual (paper-based) recording activities and the need to key in the transactions.

3. Easy electronic scheduling by sequence and changing job priorities.

4. Evaluate differences using actual times compared to standards.

5. Improve data accuracy and eliminate the need to chase and fix errors.

6. Practice Real-Time data reporting to monitor efficiencies and identify problems as they occur.


Think about just the cost of paper, ink, and the man-hours to distribute, collect, and key in data. Often times this alone is sufficient justification for an MES solution.

What could these changes mean to your business? Still not sure? Contact expert “Smart People” to help you put real numbers to this to find out just how big of an impact this could have on your business.  Find “Smart People” here.
 

About the author:

Anthony is a recognized industry expert in manufacturing processes and operational improvements. His thirty-plus years of experience encompass a broad spectrum of industry sectors: Automotive, Pharmaceutical, Medical Equipment Manufacturing, Aerospace Manufacturing, Food and Beverage, and General Manufacturing. He is uniquely qualified to quickly and accurately identify the potential improvements in efficiency in both discrete and process manufacturing operations, and identify those specific areas that could most benefit from process improvement.

 Link with Anthony

Print
91301 Rate this article:
5.0
Anthony Etzel

Anthony EtzelAnthony Etzel

Other posts by Anthony Etzel

Contact author

x

Categories