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

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

Kathy Barthelt 0 33195 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 36595 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 77711 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 55450 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 26653 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 23572 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.

Baan/LN Tip: Credit Control Parameters (ACR Parameters)

Kathy Barthelt 0 80067 Article rating: 5.0

In the Credit Control Parameters, you can indicate if the same letter will be sent for reminding and action taken if amounts are zero or negative. The reminder letters work in conjunction with overdue sales invoices and the “Reminder Diary Margin.” When an invoice has passed its due date plus a certain margin of days, LN generates a reminder advice for the invoice. 

Crossroads Welcomes Ridewell Corporation – MES for Infor LX

Anthony Etzel 0 27050 Article rating: 5.0

Crossroads RMC welcomes Ridewell Corporation as our newest client having selected Crossroads MES (Manufacturing Execution System) for their shop floor automation with integration to Infor LX. 

Ridewell engineers and manufactures air-ride, rubber-ride, steel spring and mechanical suspension systems for the truck, trailer, RV and bus industries. The company has served the transportation industry since 1967 and holds many active patents for exclusive features that provide for low maintenance and superior ride quality.

Ridewell’s objective was to eliminate shop floor paperwork and manual processes, obtain real time performance metrics, and achieve greater visibility over manufacturing operations. After carefully conducting their due diligence they selected Crossroads MES to address these challenges.

Crossroads Manufacturing Execution System connects your manufacturing plant to the rest of your enterprise by using touch screen PCs on the shop floor. Powered by IBM I Power Systems, Crossroads MES fills the gap that exists between your ERP system and your lean manufacturing initiatives by modernizing and transforming the ERP experience. It delivers paperless shop packets to your entire workforce, captures live manufacturing data, and then delivers real-time status to your Tablet or PC.

Key Features include:

  • Paperless Shop Floor                               
  • Labor and Machine Time
  • Production Reporting
  • Material Issue
  • Scrap Reporting
  • Scheduling
  • Capacity Load Balancing
  • Label Integration
  • Dashboard Analytics                    

Crossroads MES provides information that helps manufacturing decision makers understand how current conditions on the plant floor can be optimized to improve production output.

Crossroads RMC is proud to have Ridewell Corporation as a client and we look forward to working together to support their company growth and success.

First7071727375777879Last

Tips:  LX | BPCS | M3

Improves control over PO costing changes during invoice entry by replacing passive warnings with an intentional override action.

  • In ACP500D3 (Invoice Entry PO Costing), users previously could unintentionally accept changes by pressing ENTER, even when quantity to cost or amount to cost values had changed.

  • A new “F14 to Override” warning message replaces the old message:
    “Details have changed. Press enter again to accept data.”
    This ensures users acknowledge and confirm significant changes explicitly.

New System Parameter:

  • “Apply GRN Costing Tolerance for PO Costing” (optional):

    • Within tolerance: Displays the original message —
      “Details have changed. Press enter again to accept data.”

    • Outside tolerance: Triggers the new override requirement —
      “F14 to Override”

Benefits:

  • Enhances oversight and reduces unintentional cost acceptance.

  • Enables better control of PO costs when invoice details differ from expectations.

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

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author

x

Categories