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's Support Schedule for LX & BPCS

Anthony Etzel 0 63119 Article rating: 5.0

Infor recently announced their support schedule for all versions of BPCS/LX. Not sure what your company’s strategy should be moving forward?

Let us help you figure out the best path forward for YOUR company. Our goal is to put you on a path that ensures that you are supported and that your needs are met today and in the future without breaking the bank. Learn More>
 

Conversion of SiM Tasks for WFi Workflows

Anthony Etzel 0 69537 Article rating: 5.0

This enhancement simplifies access to LX programs that are available through System i Manager (SiM), as well as Workflow for System I (WFi). This provides an easy way to promote common WFi business processes from one LX environment (for example, test or environment) to another LX environment (for example, production). 

LX also provides a set of four-character task codes that can be used within SiM, System i Workspace (SiW), and WFi, for default programs in LX. These predefined LX task codes begin with 0,1,2,3, or 4. Users can specify task codes for their custom programs that are flagged as valid menu options in LX, but these task codes cannot begin with 0,1,2,3, or 4. Users can specify the task codes in Infor LX Object Master Maintenance, SYS625D. This enhancement provides simplified access to LX programs that are flagged as valid menu options in System i Manager and Workflow for System i environments. In SYS625D, The user can also specify task codes in SYS625D for customized programs that are flagged as valid menu options.

Does your existing data collection equipment and barcode label printers need some love and attention?

Kathy Barthelt 0 33851 Article rating: 5.0

Crossroads RMC knows that new equipment is not something that everyone can or wants to include in their budget. Sometimes you need to make due with what you have. We are proud to partner with a local company that repairs existing data collection equipment, and sells refurbished devices as well.

Want to bring a little life back into your equipment and extend their use? Contact us today to see if your data collection equipment can be given new life! 

Kathy Barthelt – VP Sales
Crossroads RMC
Phone: 1.630.955.1310, x113 | Cell: 1.630.408.7759
kbarthelt@crossroadsrmc.com

Do you have spreadsheets and separate databases that may or may not be tied to Baan/LN?

Kathy Barthelt 0 37671 Article rating: 5.0

Do you have spreadsheets and separate databases that you’re keeping on the side that may or may not be tied to Baan/LN?

-Do you wish they were integrated so that you didn’t have to manually go into each system to report on the data or look up information? 
-Are you running into problems because you don’t have exposure to all of the data that is critical to running your business?

Crossroads RMC has a team of integration experts who can create the integration you’ve been dreaming about… AND we have developed RMCconnector to allow for quick and easy translation data from your front end system into a format accepted by your back end ERP. 

Learn More

Baan/LN Tip: Saving Space in Your General Ledger

Kathy Barthelt 0 81155 Article rating: 5.0

Compressing Integration Transactions

One way to save space in your general ledger is to compress integration transactions. The transactions are combined into one ledger account number. However, the detail is still available in the integration transactions sessions.

The compression is seen after the transactions are finalized. 

Compression is established in the mapping scheme by checking the box under the columns “Compression of Debit/Credit Transactions". This can only be done in a mapping scheme that is not activated. 

BPCS/LX Tip: Backup and Save options

Anthony Etzel 0 57264 Article rating: No rating

Users are no longer limited to backing up or saving files to a tape or diskette.They can now use a Save File (SAVF) to save data and objects. LX programs that perform saves and/or backups were modernized to add a new SAVF option.  

There were numerous places in LX where users are prompted to save a file or library. These screens have options for tape or diskette. Diskette refers to the old 8” diskettes used on System/38. These devices are outdated and virtually obsolete. The current means of saving objects on the IBM i, is through the use of a Save File (SAVF). This compresses the data into a single object that can be saved and is easily transferred between systems.

These objects were modified and/or created for this enhancement:

  • Backup Simulation (FOR630C, FOR630D, FOR630FM, FOR640HT, and FOR630HT)
  • Month End Close (INV903D, INV903FM, INV901C, and INV903HT)
  • Purge YTH/Restore Archived Lots (INV912C, INV912D, INV912DHT, and INV912FM)
  • Purge and Save ITH records (INV932C, INV932D, INV932FM, and INV932HT)
  • Labor Ticket Save (SFC905D, SFC905FM, SFC901C, and SFC905HT)
  • Backup Infor LX Files (SYS700C, SYS700D, SYS700FM, and SYS700HT)
  • Backup Infor LX Programs (SYS710C, SYS710D, SYS710FM, and SYS710HT)
  • Backup Infor LX Source (SYS740C, SYS740D, SYS740FM, and SYS740HT)
  • Save File Name Selection (SYS912D, SYS912FM, and SYS912HT)


Benefit

Use the Backup Simulation to copy a simulation file to a SAVF or tape. Users may want to do this to transfer simulation data from one system to another, from site to site, or to save the data before permanently deleting it from the system.

Navistar goes global with Crossroads RMC!

Kathy Barthelt 0 27321 Article rating: 4.7

Navistar, a leading manufacturer of commercial trucks, buses, defense vehicles, and engines, has selected Crossroads RMC’s data collection middleware to use for their global data collection solution. Implementation began in late 2018 with Navistar’s Illinois facility and will be completed in all other divisions by the end of 2019.

Don’t Let Malware Destroy Your ERP System!

Crossroads RMC 0 24581 Article rating: 5.0

We just got a report that another one of our customers has been affected by malware. In this case it wiped out their ERP server. We are working with them to restore it an get everything up and running again. It is highly likely that this got into their network by an email attachment. This seemed like a good opportunity to remind everyone to be extremely careful with email attachments. Even if it appears to be from someone that you know, email “From” addresses can be forged.

Best practice is to save the attachment to a folder, and run a virus scan before opening or viewing the file.

First7879808183858687Last

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

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author

x

Categories