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

Learn how MES can benefit your company in 2020 by simply doing all of these things...

George Moroses 0 33134 Article rating: 5.0

Do your users have an easy way to do all of these things? If not, you should learn how MES could benefit your company in 2020!

  • Schedule work from a work center to a specific machine or work area.
  • Re-sequence work and split for better flexibility in scheduling shop floor activities.
  • Receive work schedules electronically as well as interacting with it by reporting transactional activity.
  • Electronically display drawings, process instructions, and quality instructions to eliminate (or minimize) the need for paper on the shop floor.
  • Pass shop floor transactional activity to dashboard displays as well as your ERP system.

Learn more about Crossroads MES>

Infor LX & BPCS Tip of the Week: What is EGLi?

George Moroses 0 40153 Article rating: 5.0

EGLi provides Infor LX Configurable Enterprise Accounting (CEA) functionality including Advanced Transaction Processing (ATP), a configurable ledger, and batch transaction processing in the IDF architecture.

EGLi is a complete replacement for CEA. Infor LX applications integrate with EGLi, and subsystem transactions generated in Infor LX are used to create journal entries in EGLi. The Infor LX integration system parameters allow you to specify whether CEA or EGLi is your primary financial product.

We recommend that you select CEA while you test the integration. The primary financial product flag and the CEA migration programs are designed to assist existing CEA clients with their implementation of EGLi. Journals are produced in both GL systems so you can verify that the data in both GL systems are the same. This integration includes migration programs that copy your existing CEA files to corresponding EGLi files. After you run the migration programs, EGLi should be configured and ready to use. If you are already running IDF via Ming.le or SiW, before you install EGLi, you will need to see the Ming.le integration guide for instructions on how to export EGLi tasks from IDF to SiW/Ming.le.

Learn More > Infor LX Integration Guide for Enterprise General Ledger

Infor LN & Baan Tip of the Week: Standalone Sessions in LN 10.7

Kathy Barthelt 0 110814 Article rating: 5.0

The standalone LN UI allows enhanced URL-parameter configuration. A single session can be started directly. Based on the URL, users can choose if the menu must be available and if the displayed set of records must be restricted.

This can be useful for self-service kiosks or simple full-screen clients.

Crossroads RMC Forms Strategic Partnership with CTN Global

Crossroads RMC 0 37882 Article rating: 5.0

Crossroads RMC is proud to announce a new partnership with CTN Global. CTN Global is a leading provider of ERP implementation services in Latin America and Infor’s 2019 Cloud Partner of the Year.

This partnership extends Crossroads RMC customer service and support to our Infor LN and Infor LX customers in Latin America. CTN Global has over 20 years of experience in the ERP space, and over 100 clients globally. CTN Global is headquartered in Columbia with other locations in the Iberian Peninsula and Venezuela.

Why should you look at OTTO? Let’s see what an OTTO customer has to say:

Anthony Etzel 0 31593 Article rating: 5.0

"When first introduced to OTTO, for on-time ordering, you could not prove to me that there was a better system out there than what we already had. Boy what a big wakeup call! Being in a very option intensive business and the economy in a very flat or negative state, OTTO is the BEST tool to quickly respond to a customer’s needs TODAY. When Millions of dollars are at stake each month, we have to be better prepared to meet the task at hand with fewer people. OTTO is really doing this for us!  What normally took us hours or days to identify several indented bill of material shortages now only takes a few moments with the OTTO program. What this really means is that, we do not have to wait for MRP to run each week to plan and reschedule orders. This can be done today!  What I’m really saying is that, we can advise Purchasing and Scheduling TODAY without waiting for TOMORROW.  We are now able to ship DOLLARS this month and satisfy our CUSTOMERS. Without OTTO in some cases, the Customer would have to wait until next month and potential revenue dollars lost for the month."  Gary Hawk, Planning Manager - construction equipment

Infor LX / BPCS Tip of the Week: Control Date Lead Times in LX

George Moroses 0 38836 Article rating: 5.0
  • Control Date Lead Times – LX provides five separate Control Date Lead Time fields so you can specify additional lead time values for Shop Orders, Purchase Orders and Planned and Firm Planned orders. Each Control Lead Time Date represents additional time (days) required at each step in the process that needs more time (Quarantine, Stabilize), that is to say, when a component is due, and when it can be used. (working with an aerospace  precision bearing manufacturer, I had to account for the QA requirement that no measurements could be taken until the parts had been “soaked” (stored) in an atmospheric controlled environment (72 degrees, and controlled humidity) for 24 hours. This requirement added one full day of lead time between each machining operation) The MPS/MRP Generation program, as well as programs that Shop Order Material Allocation records use the five control date lead times to adjust component required dates to function in the same way as the BOM Offset Lead Time.
     
  • All programs that create MRP Planned Orders, MRP Firm Planned Orders, Shop Orders, and Purchase Orders call the Control Date Calculation program (MRP515B) to establish all five control dates. A Control Lead Time Date is used to adjust the component Required Dates data in the Material Requirements file (KMR), based on planned orders for a parent, and the FMA Required Dates data, based on shop order release dates for a parent.
First5152535456585960Last

Tips:  LX | BPCS | M3

This enhancement provides additional views, additional order and line details, improved navigation, and additional capabilities to the IDF Customer Order Inquiry cards and to customer order-related business objects such as Allocations, Customer Invoices, Inventory Transaction History, Promotions, Drop Shipments.

Enhanced Order views based on user roles such as customer service, warehouse/logistics, salesperson/commission, data analysis/management reporting

  • Improved sort, select and filter capabilities
  • Enhanced navigation, data organization and data display
  • Improved customer service access to all transactions throughout the entire customer order life cycle – from quote to order, related invoices, and any RMAs, return orders, related credit memos
  • Improved grouping of related fields
  • New cards to present additional order and order line details
  • Consolidation of cards and card details when appropriate
  • Enhanced Display and Maintain capabilities for drillback to related customer, ship-to, item, carrier, terms, and other master file details
  • Improved display of dates, times and applicable time zones when Region Code time zone support is implemented
  • Multi language Description, Name and Address fields displayed in user’s language, if defined, else in base language

This enhancement provides search capabilities on segment value description in Segment Value List window (WINGSVD).

Segment Value List (WINGSVD):

  • Converted to a standard subfile
  • New action code 10=Search

This makes it easier to locate segment values when defining segment values in Model Account Builder or Alias definition. In addition, WINGSVD has been redesigned as a subfile to enable WebTop grid capabilities.

Last

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
47110 Rate this article:
5.0
George Moroses

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author

x

Categories