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

6 Ways Disconnected Data is Harming Your Business

Yikes!

Crossroads RMC 0 4349 Article rating: 5.0

Disconnected data – What is it?

no​ The spreadsheet that your warehouse manager has off to the side to track his inventory levels and expected shipments from your key suppliers.

no The email orders from your dealer portal waiting to be manually keyed into your ERP. 

Disconnected data is a set of information stored separately from the main system that is used to run your business (your ERP system). The data is valuable and lack of visibility to that data creates problems throughout the organization. Far more than you realize.

A 2023 study by enterprise automation provider Snaplogic and Vanson Bourne researchers showed the following:

Avoid Being a Quitter: How Crossroads RMC Can Help You Achieve Your Goals

Unlocking Success Infor LX/BPCS & Infor LN and Baan

Crossroads RMC 0 4677 Article rating: .2

Avoid Being a Quitter

As the calendar flips to January 1st, it marks the beginning of a new year filled with fresh opportunities and resolutions. It's that time when many of us set ambitious goals for ourselves, both personally and professionally. But, how often do these aspirations fizzle out before we even hit the second Friday of the year? It's so common that they even call it "Quitter's Day." However, it's not too late to stay on track and realize your ambitions. In this article, we'll focus on the professional side of goal-setting and how Crossroads RMC can be your ally in achieving manufacturing excellence.

Step 1: Make Your Goals Bite-Sized

Infor LX & BPCS Tip: System i Workspace AnyWhere information and Important Support Dates for IBM and Microsoft Products

George Moroses 0 4316 Article rating: 2.5

System i Workspace AnyWhere is a web application framework that provides a common user interface for Infor’s IBM i products.

*** We strongly recommend that you subscribe to this KB to receive automatic notification when it is updated ***

Latest Updates
System i Workspace AnyWhere - Feature Pack 22 is now available - see the Update History section below (as of January 4, 2024)

Infor LX / BPCS & Infor LN / Baan Tip: Time for the Notorious TRIO: Manual -  Physical -  Inventory

Crossroads RMC 0 6884 Article rating: 2.5

While it might be accurate (and I emphasize "might"), is a Manual Physical Inventory the optimal approach? Best practices unequivocally say otherwise!

A superior alternative is the adoption of Cycle Counting. Why choose Cycle Counting over a complete physical inventory? This method zeroes in on a selected stock range, allowing concurrent execution with a company's regular operations. Cycle Counts offers a streamlined approach to inventory management, minimizing disruptions to processes related to stock receipt, consumption, or dispatch.

The dreaded "freeze" is no longer a necessity, sparing your staff from extended holiday hours, and ensuring accurate inventory counts throughout the year! Crossroads RMC is poised to assist you in implementing Cycle Counting efficiently and effortlessly.

Contact us today to kickstart this transformative process at 800.762.2077.

Infor LX & BPCS Year-End Close Checklist

George Moroses 0 4772 Article rating: 5.0

As the year draws to a close, the hustle and bustle of year-end activities can sometimes lead to overlooking critical tasks within your Infor ERP system. Ensuring a proper year-end close is essential for setting the stage for success in the coming year. Here is a comprehensive checklist to guide you through the process:

Year-End Close Process Objectives:

Infor LX/BPCS Tip What are the differences between INV810 and INV015 for Cycle Counting updates?

George Moroses 0 6228 Article rating: 5.0

INV810 only deletes the sequence number from the ILI of the item so it is not selected again for counting and does not delete the ICY record.

The ICY Cycle Count sequential history file increases in size with each new cycle count session. Running INV015 will purge all the old ICY records up to the date entered on the set-up screen ‘Enter Cycle Count Ending Date’ field. Physically deleting the old ICY files.

In most cases, when you complete the cycle count posting and run the reports, you can reconcile the data as required. After you reconcile the data for a specific day (or group of days), you can run INV015 to purge the data for that day (or group of days).

RSS
124678910Last

Theme picker

Tips:  LX | BPCS | M3

Did you know that you can set up one-time vendors in LX? One Time Vendor (1,A): Specify Y to indicate that this vendor is a one-time vendor. Otherwise, could you specify N. The system removes a one-time vendor's information from the Vendor Master file after all transactions are reconciled. If this vendor already exists as a one-time vendor, you can specify N to change the vendor to a regular vendor.

Determining whether to use Master Production Schedule (MPS) planning or Material Requirements Planning (MRP) planning for items in Infor LX and BPCS involves understanding the nature of the items and their demand characteristics.

Master Scheduled Items typically encompass finished goods or service items. These items receive their requirements either from Independent demand, Dependent demand, or a combination of both...

124678910Last

Theme picker

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

George MorosesGeorge Moroses

Other posts by George Moroses

Theme picker

Contact author

x

Categories