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 Moves IBM i Products to New 'Compass' Group

IT Jungle: April 27, 2022 by Alex Woodie

George Moroses 0 21708 Article rating: 5.0

Infor is taking a new approach to managing many of its IBM i-based ERP systems and supporting the customers that rely on them to run their businesses. Called Compass, the new group is tasked with revitalizing Infor’s relationships with IBM i customers by catering to their unique needs, according to the company.

Infor created the Compass group about 10 months ago,...

Read full IT Jungle Article> https://www.itjungle.com/2022/04/27/infor-moves-ibm-i-products-to-new-compass-group/

Infor LX & BPCS Tip: Configurable Ledger (CLD) Benefits

George Moroses 0 30960 Article rating: 5.0

Did you know CLD provides you with the following benefits?

▪ You can journalize and post-transaction data from any third-party application or Infor LX subsystem to the Configurable Ledger (CLD).

▪ You can generate multiple journal entries across different charts of accounts, ledgers, and books within the CLD from one transaction line.

▪ You can automatically post transaction amounts across different books using an appropriate exchange rate between the batch transaction currency and target book currency.

▪ You can use validation reports to identify validation errors within the files that contain batch transaction data and then you can make any necessary corrections before resubmission.

▪ You can use standard CEA grouping and summarization options for journals created during Batch Transaction Processing.

▪ You can interface GLD journal entries into CEA for the BPCD version of Infor LX. This allows data to be interfaced into CEA without changing the way data is processed through Infor LX subsystems.

Digital Transformation & Your ERP

70% of global executives said the pandemic will accelerate their digital transformation pace

Crossroads RMC 0 21820 Article rating: 5.0

Transformation: (definition)  A thorough and dramatic change.

We all dream about it….how can we transform ourselves into something better…something more desirable? Maybe it is our appearance that we want to improve, maybe it is our physical strength and stamina, or maybe it is our mental toughness.

Have we thought about transformation when it comes to our businesses? More specifically, our ERP systems that are the lifeblood of our businesses?

When it comes to this type of transformation, we’re talking about a digital transformation. This means taking...

What are your production orders telling you?

Infor LX | BPCS | Infor LN | Baan

Crossroads RMC 0 18825 Article rating: 5.0

MEASURE WHAT YOU WANT TO IMPROVE!

Six simple words, but put together they convey a powerful concept that can transform manufacturing companies. It’s a basic concept that’s hard to argue with: Collect data, see where the data leads you, and make changes that have a positive impact on the data. Repeat often.

If your company is manufacturing a product, you’re...

Infor LX & BPCS Tip: MPS Planned vs. MRP Planned

George Moroses 0 22457 Article rating: 5.0

What items should be MPS planned, and what items should be MRP planned?
Master Scheduled Items are those items that are finished goods, or service items, that receive their requirements either specifically from Independent demand, or both Dependent and Independent demand.

  • Independent Demand is demand that cannot be calculated from higher-level demand in the product structure, and therefore must be either a forecast or an actual customer order (Finished Goods or Service parts sold to customers).
  • Dependent demand is derived from higher-level demand in the product structure. Dependent demand includes components, raw materials, and sub-assemblies. (these are not normally Master Scheduled Items).
  • Service Parts may have both independent demand from forecast and/or customer orders, as well as dependent demand from higher-level demand if that item is also used in other sub-assemblies or products.
  • Cumulative Lead Time is a concept used in Master Production Scheduling (MPS) that combines the “fixed” lead time, and the “variable” lead time needed to produce the product. It is the longest path through a given Bill-of-material. Based on the MPS setup options, Infor LX (ERP LX) will calculate the cumulative lead time (also called “the Critical Path”) for you (use the “indented BOM” display in BOM300 and find the item with the longest lead time “L/T”). Note: You may have to use Action 21, Line Detail, to see the “L/T” lead time for each item.

Infor LN & Baan Finance Tip: MPS Planned vs. MRP Planned

Kathy Barthelt 0 61372 Article rating: 5.0

What items should be MPS planned, and what items should be MRP planned…

Master Scheduled Items are those items that are finished goods, or service items, that receive their requirements either specifically from Independent demand, or both Dependent and Independent demand.

  • Independent Demand is...

Crossroads RMC Welcomes Robert Brown!

Crossroads RMC 0 18725 Article rating: 5.0

Crossroads RMC Welcomes Robert Brown, as a Sr. Business Consultant!
Bob brings 30+ years of shop floor and project management skills to Crossroad RMC. He is a self-starter that has progressively mastered the Manufacturing, Supply Chain, and Finance modules within Infor LX. Bob will get started with EDI/ECM set up for new trading partners and within the Supply Chain ranks. Bob is a great addition to the Crossroads RMC team, and we look forward to his leadership expertise on implementations and upgrades in the near future.

You can benefit from a business process review only if...

Infor LX | BPCS | Infor LN | Baan

Crossroads RMC 0 21994 Article rating: 5.0

Did you implement your ERP system 5 years ago… or maybe 20 years ago? At the time, it was like a brand new car… sleek, fast, top-of-the-line, and fuel-efficient. And although it may have needed a few minor “adjustments”, overall you were very pleased. Fast forward to today. Does it still have that new car smell? Does it run as efficiently as it used to? Do you know how to fix a problem when it occurs?

While ERP systems are certainly designed to last, over time, your business changes, your customers’ needs change, employees change and you are left with a system that may run “fine”, but you certainly don’t feel the same way about it as you did when it was brand new.

So the good news is that you CAN restore that “new car smell” with a utilization review, or business process review.

What is a Utilization or Business Process Review and Why Do I Need One?
Simply put, a business process review is an...

First3334353638404142Last

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

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author

x

Categories