Infor ERP Tips and Infor ERP News for Infor LX, BPCS, Infor ERP LX, Infor LN, Infor ERP LN, Baan, Infor M3, and Movex

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 7086 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 15653 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 7847 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 9063 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 15394 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.

First567810121314Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

David Dickson

Why Your Operation Doesn’t Stand a Chance in Hell of Going From Good to Great (and What to do About it)

You dream of building a manufacturing powerhouse.

An operation with loads of throughput, profit, and efficiency in every process to make your products the best quality you can make them.

You want to be as successful as the factories and companies they write about in books like Good to Great, changing your operation and even motivating and inspiring your teams to do so too.

But you know you haven’t got a chance in hell of seeing that kind of success unless you can truly change and make significant differences over the long haul.

Of course, the big question is How? Optimization is an elusive creature.

Sure, you get the occasional bump in numbers, but it’s not like consultants and writers are seeking you out to rave about your New, New Thing, or secret method for manufacturing nirvana.  

You worry that you’re not doing enough of those “bumps” in numbers consistently, but damned if you can figure out the magic formula.

But there is a way to do this pivot to success at the highest level, even if you’re a beginner, and even if you’ve tried before with limited progress.

It’s a game-changer, one that can take your operation from teetering on the brink of mediocrity to achieving the success you dream of.
 

The Real Reason Your Factory Floor is Operating at a Snail’s Pace

You know the feeling. You’re ready to try and implement creative ideas and plans to make things better. You know that bump in productivity and throughput was not an outlier and we can make that work consistently.  

The result of data-oriented feedback is miles better than the trumped-up, creative writing your hand-written reports show.   

You speak to colleagues at other operations like yours and try to figure out what they are doing differently. You may have even read about them in The Breakthrough Company. You may have clipped articles, shared blogs, and dug deep into Drucker, Peters, and Senge and read about the manufacturers they listed as “superior.”

Then you wonder how they do it?

The answer is they had a handle on their Manufacturing Optimization (M.O.) Score.

Knowing your M.O. is the master key to all doors leading to manufacturing greatness.

Simply stated, the better you understand your operation, the more you’ll know what to do to make things better and better. Constant, never-ending improvement is the goal. Without this kind of optimization, your operation’s chances to be great are deeply diminished. Think “snowball’s chance….”

But what if you’re not blessed with the market drivers or a “hit” product? Don’t worry, you can develop these greatness skills no matter who you serve, what you build, or how mature the business, but only if you ignore some of the most common advice about operational improvement.
 

The Problem with Popular Advice about Developing Greatness in Manufacturing

Pre -conventional wisdom says that to control your operation you should create a command and control approach to the factory floor, putting in layers and methods to organize things down to the last detail.  

Now, conventional wisdom says to let things loose to “flow” and creating accountability and standards-based performance for both man and machine. Output measures and quality levels are the new language of our current standards in operational efficiency and the applied management of it.

What if you actually try to maximize with Six Sigma or Kanban, using your ERP and Logistics as a tool? Two problems surface right away:

   1.  You spend way too much time obsessing about getting those processes “right.”

   2.  You end up concentrating on information that is suspect from the beginning.

Of course, if you are serious about improvement, you need a process and information, and sometimes bad data is the only information you have -- so you go with it.

Attention to the processes that make your operation better and the data that supports real insight is an important differentiator to success at the greatness level.

Instead of trying to improve the current plant operations, turn your attention to the things that are ripe for growth and dig deep into the potential found hidden there.
 

Where to Focus Your Attention if you Really Want to move from Good to Great  

Here’s the big idea…

You can only develop operational greatness in your manufacturing plant if you have a deep understanding of the real numbers, not theoretical “standards” or human reported histrionics.

That means understanding the people, process, and systems that already work at high levels and gleaning insights into those scores and numbers their output represents.

But what if you don’t know your M.O. score? Then you must play detective.

Follow the people, processes, and systems closely and notice what else is happening. Then, when data shows up directly, without filters or massaging, gather this up as it is the treasure trove of useful information about your operation you need.

Will this data deliver the exact methods and steps to greatness and growth? Probably not, but if you know your stuff, or have people around who do, you will likely find you have a lot in common with the great ones already, and they keep score too. Even if you have to rely on educated guesses in the beginning, the more details that emerge, the more you can reveal evidence instead of crystal-ball gazing.
 

How to Become a Master of Greatness by Stepping Inside Your Operation’s True Nature

The key to greatness is knowing exactly where you are now and where you want to be next. You cannot make the leap in one effort. You have to truly understand every aspect of the part you manage or the components to effectiveness and improvement.

The basis for this is not some collection of ideal business book strategies, or some manufacturing philosophy gone viral, but real, tested results with real data behind the outcomes.

If you know your Manufacturing Optimization score, you now have the controls to do something different. You hold the steering wheel to an engaged shop floor, machines that spit out good information, technology, and processes that deliver consistently and effectively.

This model of thinking is so effective that whole industries have sprouted up to support it: ERP, Data Collection, MES, and a slew of services to boot.

And here’s the kicker – the job is never done!

It’s tough, and each project takes a while to complete, but it’s one of the most valuable things you can undertake as a manufacturing operational manager.

But where do you find the information to figure out your M.O.?
 

Where to Find the Clues You Need to Become a Master of Greatness

Filling your score box with the treasure of which I speak requires a combination of educated speculation and careful research.

But start simple, write down some goals, plans, fears, and hurdles based upon your current understanding of your plant.

For example, no matter what you make, your shop floor is probably gathering data poorly. People rarely take the time to report well and often take shortcuts in this part of the process. They probably worry that if you are measuring the data, you are measuring them and there are consequences to output measures that report less than optimal throughput. These are high-level fears that get in the way of true performance superiority. Drill into people management too. It is a must.

Think about what failure or mediocrity means specifically to your team. Things can look bleak if the scores are low in the beginning, so we shy away from even looking at them. People can work hard and yet never get to greatness. They can fail at one task or attempt and then sell you short on future outcomes because “what’s the point?” They fail to grow because they don’t believe it’s possible.

The Aberdeen Group Analysts created Insight Reports and have a great article about this very topic. We based our Infographic for M.O. score management using some of its main points: Operational Risk Management: Building a Framework to Identify, Assess, and Remediate
 

Three basic points emerge so that you can build and track your M.O. Score:

   1.  Measure Downtime

   2.  Track Effectiveness

   3.  Score the Margins

Think how each of these measures is found in your operation, and how failing to track them could be the source for why you have yet moved from good to great.

For example, if you are tracking downtime, is this done manually, or are you using some time of automation or application to gather this information in real-time, or based upon history?

If you are measuring team effectiveness by shift, you know there are significant differences between them. Have you bothered to figure out why?

In one case, an automotive customer of ours was experiencing significant inefficiencies and difficulties with their receiving operations. They hired us to help them analyze their operation, and we discovered a disconnect between how they were tracking their incoming goods and what their ERP system thought was on hand. This disconnect created numerous time-consuming manual steps to process incoming material and determine where the material was needed. The manual process slowed production, caused additional staffing needs, and hindered their ability to effectively get needed material to the assembly line. They chose to implement our data collection solution to automate the process. Since implementing the software, receiving and moving material was quicker, more accurate, and efficient. This enabled the addition of another assembly line which increased production volume – all without the need to add staff.

Many manufacturing managers have a strong desire to leave a legacy. So in my “Leave a legacy” advice, I include becoming known for doing great work, moving the operation forward towards greatness if not gaining actual greatness in kind.

Changing the operation can be done more easily if you have the tools, the measures, and the goals in place to know where you stand now and for when you arrive. It helps to achieve real measures forward as compared to a set of known good peer levels and grades.

Once you’ve made a start on tracking M.O. by using this method, you can start to flesh it out with data from the real world.
 

3 Simple Ways to Gain Access to M.O. Score Data

1)  Observe and take notes
Watch the interaction between people in your operation. Post numbers that are real. Gather the data that is true and ignore the data that is manipulated and based upon false histrionics.

2)  Listen to the shop floor and the smart people you hire to interpret what you hear
Not enough can be said about the art of authentic listening skills and the ability to find insights into moving from good to great that can be gathered from those who are doing the tasks, breaking things, fixing them, and really trying to make it all work better.  

Don’t be afraid to bring in an outside perspective and help to interpret the information you gather or to help you set up the measures and scores you wish to keep. The partners you pick are invaluable if used well and allowed to be an integral part of the team.

3)  Go right ahead and do what’s best
A lot can be said about fear in the workplace. Often a place is still wrapped up in the old pre-conventional world of command and control. Or more often than not, there is simply no budget for expanding the conventional approach to data collection and other “advanced” schools of thought.  

That should not stop you.  

Many free, easy, and clear data points can be built starting with our Crossroads RMC's M.O. Score infographic.  

The first steps are the hardest to begin but in many ways the easiest to accomplish.
  

Do You Want an Operation That’s Thriving or Just Barely Surviving?

It’s not magic. Even though we like to believe we're all completely unique individuals and our work challenges are ours alone, many have gone before and used tools, techniques, and talents to go from being ordinary to being truly great.

Follow this process and you’ll see that the closer you get to your M.O. score and what it really means the “hidden” secrets will reveal themselves simply and easily. The reactions you’ll elicit from stakeholders and the entire team will guide your next steps.  

A cheering squad will form as you achieve each step along the way and report movement towards the outcomes you see as critical to success and that will help you leave that legacy, indeed.

And you’ll know you’re on the right track when you get comments like this:

  •  “Thank you so much; this is perfect timing for this!”
  •  “This is exactly what we need around here.”
  •  “How’d you think to track this in this way?”
  •  “We’ve been hoping to improve, but just didn’t know how.”

So revisit the M.O. score tracking method often. Toss out your old notes and start over again. Each time, you come up with new perspectives, more information, and more ideas and insights into how to collect, connect and communicate data and process to be truly good to great.

You don’t have to settle for an operation that’s met with modest enthusiasm and lukewarm achievements. M.O. tracking data points might be learned in school but it is in the operation and on the shop floor that this world lives.

So put this M.O. score idea in your manager’s toolkit – this is as important as your MBA, Engineering School Certificate, and your years of, manufacturing experience, and by doing this it might make all the difference. You’ll understand your operation so well that they’ll wonder if you are some kind of wunderkind. When will they write stories about our operation?

So grab some paper and get started. Your greatness awaits.

Question Number One: Compared to the truly great what is my current grade on my M.O. Score?
 

About the author:

David Dickson is an itinerant generalist; his path to partner and CFO of Crossroads RMC has had its twists and turns. His first twist occurred when an employer needed a business system and picked him because he had three semesters of computer programming in engineering school -- an “expert” born. Somewhere along the line, he helped to build and sell a company, which he bought back a couple of years later. Add in another acquisition, a merger, and about 30 years in manufacturing systems in various roles, and you might get a sense from where his real expertise might arise.

 

Print
114158 Rate this article:
5.0
David Dickson

David DicksonDavid Dickson

Other posts by David Dickson

Contact author

x

Categories