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

Crenlo and Crossroads RMC Go International

Crossroads RMC 0 19324 Article rating: No rating

Crenlo, A leading manufacturer of cab and enclosure products to protect people and electronics, has partnered with Crossroads RMC to deliver a shop floor (MES lite) solution to their facilities in the US and Brazil. Crenlo was looking for a way to ensure that each production run was complete and accurate, and their overall production efficiencies were measurable. Crossroads RMC developed a complete solution to deliver detailed proprietary work instructions to each workstation, configure production lines to fit the work to be completed, perform downtime tracking with alerts and provide web based pivot reports to view entire assemblies, compare actual to expected, view inspection failures and analyze trends week to week, month to month and year to year. This solution will be fully integrated with Crenlo’s Baan IV ERP system.

Nice-Pak Products Drives Purchasing Power With Crossroads

Crossroads RMC 0 38030 Article rating: No rating

Nice-Pak Products, a leading manufacturer in the wet wipes industry, has selected Crossroads RMC to evaluate the purchasing processes within their facilities in Indiana. During this evaluation, Crossroads RMC will determine the best path for streamlining purchasing operations and develop a standardized approach that can be shared within other locations of Nice-Pak utilizing Infor LX.

International Wire Selects Crossroads RMC For Their High Performance Conductor Division

Crossroads RMC 0 33329 Article rating: No rating

International Wire Group, Inc. headquartered in Camden, New York is the largest bare copper wire and copper wire products manufacturer in the United States. Crossroads has been selected to evaluate the manufacturing processes within the High Performance Conductor Division of International Wire, with locations in South Carolina and Georgia. During this evaluation, Crossroads will determine the best path for streamlining the shop floor which will include data collection and labor reporting. International currently utilizes Infor LX and will be evaluating Crossroads’ MES solution as part of this project.

BPCS/LX TIP OF THE WEEK: INVENTORY TRANSFERS

Anthony Etzel 0 53486 Article rating: No rating

Misplaced inventory… this happens all the time, but it CAN be avoided.

As part of an employee’s initial training, they should be taught the importance of proper inventory handling. This training should occur even if inventory handling is not their job! Employees need to know how the actions (or lack thereof) of one individual affects the rest of the company and the system used to run your business. Proper inventory management is the responsibility of ALL employees. 

Optimize Your Manufacturing Today!

Baan/LN Tip of the Week: Inventory Transfers

Kathy Barthelt 0 89014 Article rating: No rating

Misplaced inventory… this happens all the time, but it CAN be avoided.

As part of an employee’s initial training, they should be taught the importance of proper inventory handling. This training should occur even if inventory handling is not their job! Employees need to know how the actions (or lack thereof) of one individual affects the rest of the company and the system used to run your business. Proper inventory management is the responsibility of ALL employees. 

Optimize Your Manufacturing Today!

Tip of the Week: Finding the Cause of Waste

Crossroads RMC 0 63897 Article rating: No rating

If a particular machine in your shop breaks down a lot, and you are seeing lots of scrap on every job, maybe it is time to look at what is going on. Is there truly a problem with the machine? If so, get it fixed, or move production to another line. Maybe it is a problem with how the machine operator has been trained, or maybe it is due to poor quality materials that are being used as components on a given job. Until you dig in to find the root cause, you can’t fix the problem.  

Optimize Your Manufacturing Today!

Tip of the Week: Gain Efficiency & Save Money - Evaluate Your Production Lines

Anthony Etzel 0 50085 Article rating: 5.0

When is the last time you took a hard look at your production lines?

  • How are we moving product through our facility?
  • Do we have work instructions / drawings available where needed?
  • Do we have frequently used inventory available at the line?
  • Where are the bottlenecks?
  • Are processes automated, where possible?

Taking a hard look at your processes and procedures may reveal some interesting results. Don’t assume that everyone is doing things the same way. Some may be superstars, and others may need some mentoring. Some processes may be outdated and costing you time and money, while others are extremely efficient. One area of the business may benefit from how others operate. Take the time to review and analyze your findings. Your company may benefit greatly as a result.

Optimize Your Manufacturing Today!

Tip of the Week: Gain Efficiency & Save Money - Evaluate Your Production Lines

Kathy Barthelt 0 79499 Article rating: No rating

When is the last time you took a hard look at your production lines?

  • How are we moving product through our facility?
  • Do we have work instructions / drawings available where needed?
  • Do we have frequently used inventory available at the line?
  • Where are the bottlenecks?
  • Are processes automated, where possible?

Taking a hard look at your processes and procedures may reveal some interesting results. Don’t assume that everyone is doing things the same way. Some may be superstars, and others may need some mentoring. Some processes may be outdated and costing you time and money, while others are extremely efficient. One area of the business may benefit from how others operate. Take the time to review and analyze your findings. Your company may benefit greatly as a result.

Optimize Your Manufacturing Today!

First8485868789919293Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

George Moroses

Infor LX & BPCS Tip: PowerLink

PowerLink is a Windows-based client for end-users within the Infor Development Framework (IDF). PowerLink allows exports/imports from/to the ERP database, but how much do you really know about it? Here is some helpful information about PowerLink.​

Why does PowerLink sometimes fail to export all records?
There's not a finite amount of records that PowerLink can export. However, PowerLink export was never intended to handle large volumes of data. It was designed as a quick snapshot of a fairly small subset and a simple view of the user's PowerLink card. 

What is the maximum amount of data that can be exported?
The maximum number of records is only limited by the system resource like memory, etc. When the system runs out of resources, an OutOfMemory error should occur. In previous testings, we have exported +1 million records, although the size of records differs greatly between business objects, the total size of the data could be an issue. For larger volumes of data, customers should investigate other tools such as the iSeries Access "Data Transfer from iSeries Server" feature to download directly to Excel.

How do I know if the size of the data is an issue?
1. When exporting to an external file (text, HTML) then importing to Excel: You can easily check the output (text, HTML) to see if the intermediate output has all the records. This can be done by visual inspection or through the use of column totals. Simply compare between the output and what you see in PowerLink. If the exported file has all the records, then the problem is definitely Excel.
2. When exporting to clipboard, then copy/paste to Excel: There is a clipboard export size limit that is controlled through client preferences. Check the exported data in the clipboard, and see if it contains all the records or only partial records due to the size limitation set in client preferences. If limited, change the client preferences using Customize from the Main browser > Preferences > Miscellaneous tab > Limit Clipboard Export, and try the export again. If the clipboard has all the records the problem is in Excel, which we don't have jurisdiction over.

Suggestions for improving the export process. 

  1. Reduce the number of columns seen in the view. This will serve to reduce the data being exported and may increase the number of records that can be exported. 
     
  2. Reduce the complexity of the view. If the view has one column that lives on a related object, then it has to build SQL behind the scenes to get that related record. If all of the columns come from a single business object, then the processing will be significantly faster.
     
  3. Export to HTML, which can be opened directly by Excel, Access, and many other programs. This reduces the processing of the export formatting because PowerLink needs only to put begin and end tags around each data element. This will also preserve column alignment when Excel or other programs open the file.
     
  4. Unless you are exporting a fairly small volume of data, export to a file, not clipboard. Clipboard is held in memory until the entire view is read, and records are written to the file as they are retrieved.
     

 Also see KB 1357068 for more information about testing your view.

Print
55768 Rate this article:
5.0
George Moroses

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author

x

Categories