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 Tip: How to deal with data growth of your ERP system…

Spending time on managing ERP data can deliver huge benefits, not just in reducing storage costs, but also in improving the experience of business users. Proactively managing application data also helps accelerate key business processes which has a positive impact on customers, suppliers, and partners. Use these solutions to reduce the data growth and disk storage used on your system:

• Use database compression. See Infor LN Data compression (B0050 US) for more information.
• Using the varchar data type for string fields reduces the size of the database. Tables must be recreated for the varchar conversion. See solution 22923520 for the latest porting set.
• Regular archiving history data will have a very positive effect on performance. The database growth will be limited and inserts in large tables will be faster. See the Infor LN User Guide for Archiving (U9352 US) for more information.

Previous Article Check-Ups are important… Including Infor LN & Baan ERP Check-Ups!
Next Article Infor LX & BPCS Tip: Transaction History – Did you know?
Print
120595 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

Please solve captcha
x

Tips:  LX | BPCS | M3

  • Are you tracking downtime? Is it done manually, or with some type of automation or application that gathers information in real-time, or is it based upon history?
  • If you are measuring team effectiveness by shift, you know there are significant differences between them. Have you figured out why?

One of our automotive customers was experiencing significant inefficiencies and difficulties with their receiving operations. After analyzing their operation, we discovered a disconnect between how they were tracking their incoming goods and what their ERP system thought was on hand.

This disconnect created time-consuming 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 solution, receiving and moving material was quicker, more accurate and efficient. This enabled the addition of another assembly line, increasing production volume – without adding staff.

Optimize Your Manufacturing Today!

I’m not talking “Modus Operandi,” which is a fancy way to say: “what’s your plan to get stuff done”.  I’m talking about Manufacturing Optimization. 

It is all about efficiency, and by that I mean doing more with less. Less labor, less time, less materials, while still delivering a high quality product on time.

The Three Secrets to Improving your MO

1. Identify the key metrics
You need benchmark data so you know what realistic goals are, then track them and publish your performance along with a brief comment from time to time on how things are trending and how you compare with others, particularly your primary competitors. The best thing about this is that it is a system that develops a life of its own.

2. Measure it
Automatically, people start to think about improving things. Then the fun part, stuff begins to improve by itself. Once in place, the system just hums along and the benefits appear, because it has motivated people to think about it, and figure out what they can do to make it better.

3. Communicate it
So if you publish gross profit numbers, explain to people how what they do affects the numbers. Employees tend to start to modify their behavior as a result, and look more critically at whether a given purchase is even necessary.

FirstLast

Tips: LN | Baan

Categories