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

Crossroads RMC's Analytics Dashboard serves as the perfect complement to extend your MES solution

George Moroses 0 36410 Article rating: 5.0

Did you know our Analytics Dashboard serves as the perfect complement to extend your MES solution?

Need real-time information regarding what shop orders are active, which lines are down, and overall OEE? Want to display all of this data in easy to understand graphs and charts with drill-down capability?

Contact us today to find out how our Analytics Dashboard can provide all of the information you need in real-time.

  • MES Work Center Job Step Status
  • MES Work Center Machine Status
  • MES Shop Order Status
  • MES Order / Operation Status
  • MES Order / Parts Status
  • MES Badge Status

Contact George Moroses to learn more.

Infor and Crossroads RMC Partner to Drive Success at Ridewell

Anthony Etzel 0 37392 Article rating: 5.0

Earlier this year, Ridewell Corporation inked a deal with Infor to move their BPCS 4.05 CD system to Infor LX. As part of that deal, Crossroads RMC’s MES software was selected to provide shop floor automation. 

For the ERP upgrade, Infor reached out to Crossroads RMC to provide support for both Finance and Data Conversion due to our positive track record with 4.05 CD to LX migrations. Crossroads RMC has extensive migration experience and developed a methodology for converting legacy 4.05 CD GL into CEA. 

The process Crossroads RMC developed makes it cleaner, more manageable, and easy to embrace from the client perspective. Infor also engaged Crossroads RMC to provide technical support to manage the data conversion, utilizing the Infor utilities and converting Ridewell’s 4.05 CD data to standard LX.

IDF: Defining the Attributes for a New Object

Anthony Etzel 0 31074 Article rating: 5.0

Attributes are the fields you define in your System i file.

You can begin by building your attribute list in Integrator by synchronizing the object with the host. This process reads the file definition from the System i and builds your list of attributes. The synchronize process will automatically run and read the definitions for the first occurrence of this file name within the library list. You can repeat this process manually multiple times if you change the file definition on the host by using the ‘Synchronize with Host’ option. However, the synchronization process will not recognize changed field names.

Non on key field attributes: The integrator requires a unique key for each object. If the host file already has a key, the synchronization process will automatically identify fields as part of the key as well as add a sequence number to multiple key parts. If the file does not have a unique key, you must either create a keyed logical file or identify the key manually. Key fields are the default sort order for all list views for an object.

Why do you need OTTO? Let’s let our customers tell you…

George Moroses 0 26821 Article rating: 5.0

“Our priorities change daily. It’s important to manage the priorities instead of having someone here in the office constantly expediting. We don’t want to run MRP every day, that would just introduce nervousness, all plans and priorities are likely to change and the flood of recommendations would be unmanageable. We run MRP once a week and rely on OTTO to track the constantly shifting priorities day-to-day.”  
Production & Inventory Control Manager, Top U.S. Crane Manufacturer

Learn More About OTTO

Crossroads RMC is proud to announce the release of the following dashboard views that come STANDARD with the LX Analytics Dashboard

George Moroses 0 30584 Article rating: 5.0

Standard Analytics Dashboard Views: 

  • Sales Bookings (ECH)
  • Accounts Receivable (RAR)
  • Accounts Payable (APH)
  • Planned Orders (KFP)
  • Purchasing (HPH)
  • Shop Order Material (FMA)
  • Shop Order Operations (FOD)
  • CEA
  • Order Booking (ECS)
  • Labor History (FLT)
  • Sales History (SIH)
  • Material Status (IIM/ILI)

Click Here to Learn More

If you can't see everything that happens on your shop floor, you are at a competitive disadvantage

Anthony Etzel 0 32063 Article rating: 5.0

If you’re not able to see everything that happens on your shop floor in real-time, you’re at a HUGE competitive disadvantage! Your competitors are running MES. 

Crossroads MES software provides:

  • A user-friendly interface and an easy exchange of information between the shop floor users and your ERP database. 
  • Planners the ability to schedule work to a specific machine or work area. In addition, it allows for work to be re-sequenced and split for better flexibility in scheduling shop floor activities.
  • Factory workers with the ability to receive the work schedule electronically as well as interacting with it by reporting transactional activity.
  • The ability to electronically display Drawing, Process Instructions, and Quality Instructions so you can eliminate, or minimize, the need for some of the paper on the shop floor.
  • The ability to pass shop floor transactional activity to dashboard displays as well as the ERP system. 

Click here to learn more about Crossroads MES 

or Contact Anthony Etzel today to learn more.

Infor LN & Baan Tip of the Week: Job Groups in LN

Kathy Barthelt 0 85231 Article rating: 5.0

In a scenario where performing job A depends on the result of job B, it is hard to decide at what time job A must be scheduled, and how long job B runs. To handle dependent jobs, you can now create a job group. Use the Job Groups (ttaad5140m000) session to create a job group. A job group has a name, with the same characteristics as a job name, and a description. The Status and User of the job group are handled automatically.

After creating the job group, the jobs are added to the group, approximately in the order the jobs must be performed. The first job in the group (with the lowest Group Number) determines the handling of the whole job group, such as execution date and whether the job group is being repeated. If the job group is not repeating, the job group and all non-repeating jobs in the job group are deleted when the job group has run.

The dependencies of the jobs in the job group are also determined. A job in the job group can only depend on a job in the same job group with a lower job number.

You can use the specific options in the Job Groups (ttaad5140m000 andttams5640m000) sessions to change the status of the job group. The job group statuses have the same meaning as the status of the jobs and the same status changes are allowed.

Note: Job groups are only handled by the BSE service Job Scheduler Service.

A/P Payment Update in LX 8.3.4

Anthony Etzel 0 43690 Article rating: 5.0

A/P Payment Update in LX 8.3.4. ACP660B creates a file using a layout required by the bank; the file informs the bank to pay invoices. These conditions must be met to create the file:

  • FIM is an installed product in SYS821  ­
  • The user is authorized to FIM in SYS600 ­
  • The company is active in FIMCOMIT in SYS105  ­
  • The payment type is in BONPAYTP (SYS105)
First7273747577798081Last

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

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author

x

Categories