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

We are proud to announce the launch of quarterly Lunch & Learn webinars for BPCS & LX!

Crossroads RMC 0 30455 Article rating: No rating
  • Have a question about your BPCS/LX system and don’t know where to turn?
  • Want information about the next release of the software?

Crossroads RMC consultants are here to help!

With 250+ BPCS/LX implementations and upgrades under our name, we are the largest BPCS/LX practice in the USA. Spend 30 minutes with us and hear straight-shooting consultants talk about best practices and real-life implementation experiences.
Watch Video Now


Topics: BPCS 4.0.05CD to LX conversion from a finance point-of-view

  • Understand the benefits of LX 
  • Navigate the transition path developed through client experiences
  • Learn about the capabilities of the Crossroads RMC, LX practice

BPCS/LX Tip of the Week: Inventory Period Balance Freeze

Anthony Etzel 0 32570 Article rating: No rating

This new feature provides the ability to freeze period-end balances at the end of a fiscal period.

This enhancement provides clients the ability to store the opening/ending on hand balance for each Inventory period at the Item (IIM), Warehouse/Item (IWI) and Lot/Location (ILI) levels.

This information can then be used for inventory tracking and valuation purposes, as well as other ad hoc financial and audit reporting requirements.

One key benefit is that tracking the opening/ending/period balance for each inventory period can give users insights into the levels of inventory for each item, item/warehouse and item/warehouse/lot/location combination.

Optimize Your Manufacturing Today!

Baan/LN Tip of the Week: Make Your ERP Work FOR You - Streamline Your Processes

Kathy Barthelt 0 77876 Article rating: No rating

Such lofty goals you had when you implemented your ERP system. It was going to be like pressing the “Easy Button”…  then it wasn’t.

What happened? In some cases, decisions were made to implement the system “just like we used to run our old system”. Great idea? Not so much. Your business changes, and your business software needs to change as well.

Are you using the ERP system, but everything seems cumbersome and takes more time than its worth? 

Ask yourself these questions:

  • Have you looked at streamlining your processes?
  • Can you automate a step or two and eliminate some manual keying?
  • Can you add barcoding to avoid keying in some information altogether?
  • How about automating the printing of some reports?

Now is the time to sit down and really review the steps required to complete the task and think out of the box a bit. Soon you can develop your own streamlined process to get the job done quickly and efficiently.

Optimize Your Manufacturing Today!

BPCS/LX Tip of the Week: Inventory Transactions

Anthony Etzel 0 40849 Article rating: No rating

You can define internal trade relationships between enterprise units or individual warehouses of the same logistic company for the transfer of material, labor, or other costs between warehouses, and to generate invoices for these without using sales orders and purchase orders. For example, you can use this to transfer goods between warehouses in different countries.

You can define warehouse surcharges, which are added to the actual costs of the goods either when the goods are issued from a warehouse or when the goods are received.

Optimize Your Manufacturing Today!

Baan/LN Tip of the Week: Multi-Company Warehousing

Kathy Barthelt 0 80607 Article rating: No rating

You can define internal trade relationships between enterprise units or individual warehouses of the same logistic company for the transfer of material, labor, or other costs between warehouses, and to generate invoices for these without using sales orders and purchase orders. For example, you can use this to transfer goods between warehouses in different countries.

You can define warehouse surcharges, which are added to the actual costs of the goods either when the goods are issued from a warehouse or when the goods are received.

Optimize Your Manufacturing Today!

Crossroads RMC and Kardex Remstar Partner to Provide Solution for L3 Electron on Infor LN

Crossroads RMC 0 33051 Article rating: 3.0

L3 Electron has selected Crossroads RMC to develop a connector from Kardex Remstar’s Power Pick Global software to Infor LN. Power Pick Global facilitates batch picking, allowing an operator to fill multiple orders at one time, increasing productivity significantly. Multi-user-picking provides the flexibility to easily add additional labor to further increase picking speeds when order volume is high. Optical indicators such as Pick-to-Light and Put-to-Light direct the operator to the exact location of the pick, increasing accuracy and reducing the number of picking errors. L3 Electron is a technology company specializing in the manufacture of microwave devices for ground-based, airborne and satellite communications and radar. Go live is scheduled for late Q3 of 2017.

BPCS/LX Tip of the Week: Operational Inefficiencies

Anthony Etzel 0 36417 Article rating: No rating

Two big sources of inefficiencies in manufacturing are paper and spreadsheets. I know that you love ‘em, but they are the cause of more problems than you probably realize. Think of how long it takes you to get paper based data into the hands of those who can do something valuable with the data.

  • Is the information captured correctly?
  • Can everyone access the information?
  • Is this an accurate representation of what’s going on across all operations?

Make your shop floor paperless and put systems in place that talk to one another and automatically pull and push data to and from your ERP so that you can look in one place for all the information you need to run your business effectively.

If you’re not doing this today, you might as well be burning money.
 
Optimize Your Manufacturing Today!

Baan/LN Tip of the Week: Operational Inefficiencies

Kathy Barthelt 0 79832 Article rating: No rating
Two big sources of inefficiencies in manufacturing are paper and spreadsheets. I know that you love ‘em, but they are the cause of more problems than you probably realize. Think of how long it takes you to get paper based data into the hands of those who can do something valuable with the data.
  • Is the information captured correctly?
  • Can everyone access the information?
  • Is this an accurate representation of what’s going on across all operations?

Make your shop floor paperless and put systems in place that talk to one another and automatically pull and push data to and from your ERP so that you can look in one place for all the information you need to run your business effectively.

If you’re not doing this today, you might as well be burning money.
 
Optimize Your Manufacturing Today!
First8283848587899091Last

Tips:  LX | BPCS | M3

Item Facility Master has a new attribute to define the override inspection days lead time CICP.ICINSD.

  • When an item facility has a defined override inspection days lead time, that value will be used instead of the system parameter inspection days lead time.

MRP exception report, MRP200B
Purchase planning report, PUR285B
Purchase order / Requisition maintenance, PUR500D3
Purchase order consolidation / release, PUR640B1
Vendor splits, PUR653B

This enhancement improved the subfile utilized in MRP320D Master Schedule Detail Inquiry -SCR001 by expanding the subfile with data rather than clearing the subfile as user pages. This change provides full support for the WebTop 4.8 Grid decorator.

This enhancement updated the approach used to populate the subfile to allow a deployed Webtop Grid to function correctly. There is no visible or user-impacted change to the way the program functions.

This enhancement provides improved functionality and full support of a Webtop grid applied to the subfile.

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

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author

x

Categories