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

ION News: Crossroads RMC uses the ION process to deliver data to/from LX 8.3.5

George Moroses 0 32533 Article rating: 5.0

Crossroads RMC is currently working with a customer in the food and beverage industry to develop 18 inbound and outbound customized BOD messages using the ION process to deliver data to/from LX 8.3.5.

All of the messages will be using the standard OAGIS (Open Applications Group Integration Specification) BOD Message. The OAGIS is a widely accepted standard within the industry which specifies a standard way of passing data in and out of applications using an XML format. 

Some of the BOD Messages that we will be processing are:

  • Item Master
  • Purchase Order
  • Receipts
  • Accounts Payable Invoices
  • Vendor information
  • Notifications messages

This project kicks off in February 2020 with milestone deliveries throughout the year.

How Do I Determine If MES Is Right For My Business?

George Moroses 0 36101 Article rating: 5.0

There are certain key questions that must be answered to determine whether or not an MES system would benefit your organization: 

  • How do you analyze OEE?
  • Is there an opportunity to reduce WIP inventory, indirect labor, downtime, waste or scrap?
  • What is the cost and impact of producing and distributing shop paper including drawings and work instructions?
  • Would you like to go paperless on your shop floor?
  • How are your continuous improvement initiatives tied to your ERP?
  • Is Management requesting real time production status reporting via dashboards or drilldown reports?
  • What different “islands of automation” exist on your shop floor?

The answers to each of these questions could have a significant impact on the profitability of your business. Want to quantify your results? Contact George Moroses today to schedule your FREE MES ROI Analysis.

Consulting News: How comprehensive is the Crossroads RMC ERP business audit & how does it work?

George Moroses 0 43157 Article rating: 5.0

Our Infor LX Practice just finished a Supply Chain and Manufacturing audit for one of our customers. During that engagement, several areas of the business were identified that could benefit from additional training and consulting support. 

Areas of significance were:

  • Purchasing
  • Customer Service
  • Billing
  • Inventory
  • Costing
  • Bills of Materials and Routings
  • Material Requirements Planning
  • Shop Floor Control

Several manual procedures and “tribal knowledge” systems were discovered. The evaluation was done by two consultants who spent time with key users during two onsite visits. The next step in the process will involve working with the client to prioritize the list of items identified and develop a strategic plan focused on growth and efficiency.

Infor LX & BPCS Tip of the Week: Order processing enhancement – LX 8.4

George Moroses 0 62275 Article rating: 5.0

Restrict Over-shipments to Customers

  • System parameter option controls when over shipments are allowed

Options to:

  • Continue current process with warning message
  • Give error message
  • Automatically correct to quantity available for shipment
     
  • Option to revise the order quantity so that pricing, promotions, credit checking load planning and other processes reflect the actual quantity
  • Allows better control of exceptions for over shipments
  • Ensures that pricing, promotions are correctly based on actual order quantity

About 65% of the world’s population are visual learners. This extends into the ERP software realm, too.

Infor LN & Baan

Kathy Barthelt 0 79839 Article rating: 5.0

Graphical representation makes complex concepts—like the intricacies of an ERP system—more universal, relatable and easy to understand.

ERP dashboards gather and visualize critical metrics from across the organization, offering insight into the performance, outlook and interconnectivity of business processes.

By setting up ERP dashboards that illustrate key metrics and compellingly communicate operational performance, key stakeholders will have a clear picture of the health of the business—and make better, more informed business decisions as a result.

The Crossroads Analytics Dashboard has preconfigured views for all of the following:

 Infor LN & Baan
  • Accounts Payable
  • Accounts Receivable
  • Journal
  • Booked Sales
  • Invoiced Sales
  • Production
  • Receipts
  • Purchase Orders
  • Inventory

To learn more visit our Analytic Dashboard webpage.

Data Collection: Are you able to perform a full cycle count of your inventory in one day?

Kathy Barthelt 0 41029 Article rating: 5.0

Cycle Counting Benefits:

  • Overall increased inventory accuracy
  • Increased accuracy of count
  • Ability to review and approve count before direct update of Baan / Infor LN tables
  • Elimination of unnecessary re-orders of items with current inventory
  • Greater ability to satisfy customer orders due to greater visibility to accurate inventory levels
  • Direct labor cost savings – less staff required for count
  • Increased productivity during count

Some of our customers counts used to take weeks. They can now complete a count of their entire inventory in one day. One of our LN customers just told us that they recently wrapped up a cycle count using our software and said it was the first time ever that they completed a count without one complaint or mistake!

Contact us today to learn more - 800.762.2077

Integration News: Crossroads RMC has developed an integration from Baan IV to Modula OnePick for Grindmaster Corporation

Kathy Barthelt 0 35721 Article rating: 5.0

One Pick is a Modula Lift automatic vertical warehouse with a special picking bay equipped to provide expedited picking and a high level of pick accuracy. With this system, Grindmaster is able to save floor space, store items safely, automate inventory management, track items, save picking time and prevent picking errors. Go live for this solution is expected in Q1 2020.

First4950515254565758Last

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

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author

x

Categories