Lawson Add-ins Script Error

, ,

Problem: User is trying to login to Lawson add-ins and receives a Script Error, blocking them from entering their credentials.

  1. Update the users add-ins version MOA32bit or MOA64bit installer depending on version of Excel. See compatibility matrix for add-ins on Infors Concierge website.
  2. Make sure the user is on the latest internet explorer version: https://www.microsoft.com/en-us/download/internet-explorer.aspx (Microsoft is planning on leaving support for IE on 6/15/2022 so it is recommended to update the users operating system).

Temporary workaround: Copy the users username and click Yes on the dialog error and quickly paste in the username. Do the same thing for the password.

NOTE: As of posting this article, this info may still be relevant but likely will be resolved through updating the users PC to the latest Windows OS as well as a later version of add-ins and Microsoft Excel.

 

Jøtul Heats up its Future with Infor Cloud ERP

Infor recently announced an agreement with one of Europe’s largest fireplace suppliers, Jøtul. The company supplies the markets through one of the most far-reaching global networks in the industry, consisting of its own sales companies and distributors. Per the press release, Infor’s Consulting Services will assist Jøtul in upgrading its current enterprise resource planning (ERP) solution to Infor M3 CloudSuite, which is a standardized industrial manufacturing solution. Further, Infor M3 CloudSuite, powered by Amazon Web Services (AWS), is updated monthly for customers and has a dedicated team to ensure strict requirements for IT security and uptime. The solution is expected to be live in January 2023.

 

For Full Article, Click Here

LBI Install Errors

, ,

Here is a simple solution for common LBI Install Errors.

 

Problem:

During an LBI install you get this error regarding a trigger name not the same collation as refencing column.

 

Resolution:

Run this query

IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[EJS_SIMPROP_TRIGGERS]’) and

                OBJECTPROPERTY(id, N’IsUserTable’) = 1)

                CREATE TABLE [dbo].[EJS_SIMPROP_TRIGGERS]

                                ( [SCHED_NAME] NVARCHAR(120) NOT NULL,

                                [TRIGGER_NAME] NVARCHAR(130) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

                                [TRIGGER_GROUP] NVARCHAR(160) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

                                [STR_PROP_1] NVARCHAR(512) NULL,

                                [STR_PROP_2] NVARCHAR(512) NULL,

                                [STR_PROP_3] NVARCHAR(512) NULL,

                                [INT_PROP_1] INT NULL,

                                [INT_PROP_2] INT NULL,

                                [LONG_PROP_1] BIGINT NULL,

                                [LONG_PROP_2] BIGINT NULL,

                                [DEC_PROP_1] NUMERIC(13,4) NULL,

                                [DEC_PROP_2] NUMERIC(13,4) NULL,

                                [BOOL_PROP_1] NVARCHAR(2) NULL,

                                [BOOL_PROP_2] NVARCHAR(2) NULL,

                                CONSTRAINT PK_EJS_SIMPROP_TRIG PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),

                                CONSTRAINT FK_EJS_SIMPROP_TRIG FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)

                                REFERENCES EJS_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP));

 

 

Start your install over and the same error should not repeat.

 

Top 9 Technology Trends In The Next 5 Years

With the economy ever changing, so is technology and the demand for innovation and ongoing development. Nate Nead, CEO & Managing Member of the strategic consulting firm Nead, LLC, shares his insight on readwrite.com of the top trends in technology that we should watch out for in the next 5 years.

  • Expansion Of The Metaverse – “We have been reading a great deal about the software development of the Metaverse and what the new Facebook initiative could look like in a few years. While it isn’t yet possible to live in the Metaverse, we think in five years, it will possible to fully immerse yourself there.”
  • Edge Computing – “Edge computing brings computer processes and data storage closer to organizations and reduces response times and lowers the amount of bandwidth used.
  • Drones – “Right now, drones are mainly used only by videographers and photographers. But soon, drones will be cheap enough that a lot of people will want to own them. And with improved technology, they will be able to be flown for many hours at a time without a recharge.”
  • Blockchain – “Many of us only think about blockchain technology in terms of cryptocurrencies such as Ethereum and Bitcoin. However, blockchain offers many types of security that are beneficial in other areas.”
  • Artificial Intelligence (AI) – “Artificial intelligence will grow by leaps and bounds in the next few years. We think one area that will expand rapidly for AI is healthcare. With the development of artificial neural networks and advanced deep learning, medical professionals will be able to do intellectual tasks a lot faster. “
  • Cloud Computing – “Cloud computing will only get bigger in the coming years as more organizations large and small put their data in the cloud and stop relying on local servers. We can expect a large transition to cloud computing in the next five years in many organizations, businesses, and industries.”
  • Robotic Process Automation (RPA) – “RPA, like machine learning and AI, is another emerging technology that will automate many jobs. RPA involves the use of software to automate routine business processes including processing technologies, interpreting applications, manipulating data, and even answering texts and emails. RPA will essentially automate common tasks that people once did by hand.”
  • 5G – “No list of emerging tech trends is ever complete without talking about 5G. This is the new generation standard in mobile comms that offers faster speeds and reduced latency. This is great news because so many of us use our phones all the time to live our busy lives.”
  • Quantum Computing – “Quantum computing is a type of computing that uses quantum principles including quantum entanglement and superposition. This intriguing trend in technology is also part of preventing the spread of viruses and developing new vaccines. These things are possible with quantum computing because of the ease of monitoring, querying, and acting on data, no matter the source.”

 

For Full Article, Click Here

Colombian Pet Food Specialist Italcol Selects Infor CloudSuite WMS to Improve Inventory Efficiency and Customer Satisfaction

Pet food manufacturer Italcol, Colombian recently selected Infor CloudSuite™ WMS (warehouse management system) as its software to improve the company’s inventory control. Per the press release, the warehouse management system will help increase service quality, enhance resources, process information in real time for better decision making, and improve productivity indicators. Implementation is being conducted by Cerca Technology, Infor’s channel partner specializing in improving supply chain processes. With three main goals in mind, Italcol’s aim is to lead the pet food market in the region. The Infor WMS project will strive to fix inventory accuracy, improve staff productivity, and increase customer satisfaction, with faster delivery times, increasing accuracy, offering more visibility in real time for customers, including kitting and product life cycle management.

 

For Full Article, Click Here

AS400-Job in waiting queue

, ,

This is a helpful guide for AS400 to view an examine log for a Job in waiting queue. Follow the simple steps below.

 

Login to Green Screen

Type in wrksplf “username”

Hit F11 to get date and time

Find QPJOBLOG for the user and enter a 5 on the OPT column and enter

The examine log shown below

Jernia Making a Home in the ERP Cloud with Infor and Columbus

Jernia AS, a holding, marketing and distribution company for household items, kitchen equipment, hardware, tools, paint, grills, and interiors, recently decided to work with Infor and its partner Columbus Norway to replace an old enterprise resource planning (ERP) system with Infor Cloudsuite Distribution Enterprise, a standardized industry solution for retail trade. Established in Norwary in 1951, Jernia expects the new ERP platform to contribute to better and more efficient collaboration throughout the group. Infor CloudSuite Distribution Enterprise includes a user-friendly interface, and is constantly updated with new and relevant functionality as well as more integrated processes across various functions in the company. Additionally, Infor has a strong focus on automating and streamlining business processes using AI.

 

For Full Article, Click Here

Getting the version of important Lawson interfaces

, ,

Interface versions are important when debugging an issue.  This way you can check whether or not a patch exists that addresses the issue or if Infor is assisting you with the problem and needs a starting point.

 

Some of the most common ones needed are:

  • Lawson System Foundation (ILSF)
  • Security Jar files (secLS)
  • Infor Landmark (ILMRK)
  • Distributed Security Package (DSP)

 

Its quite simple as long as you have access to LID, Infor Security Services (cloud) and Landmark Command Line (cloud) access.

 

Starting with LID:

  • For Lawson System Foundation (ILSF) version run command: univver lawsec.jar
  • For Security Jar files (secLS), change directory to %GENDIR%/java/thirdparty and run this command: univver secLS.jar
  • For Distributed Security Package (DSP), change directory to %LAWDIR%/lss/system
    • Type command: lashow install.log
    • This will display the inside of the file, you can copy the version or export as needed.

Infor Security Services (ISS):

  • Click the lower case “i” on the upper right-hand corner of the page

Landmark Command Line (ILMRK):

  • Simply type univver -V

 

It is recommended to run monthly health checks to get versioning a long with analyzing server health and logs. Organizations with a single Lawson professional are sometimes spread thin and overwhelmed.

 

These organizations often hire a Lawson consultant team who offer managed services at a fixed monthly rate. These Lawson teams have a wider range of expertise and knowledge and are ideal for larger organizations but also are great for smaller ones that don’t need a dedicated Lawson employee on-site.

 

3 forces shaping the evolution of ERP

The digital transformation in the business in the past few years have given most enterprises a lot to think about, but with little time to make decisions. Shifts to working from home, data analysis and arching, and rethinking supply chain and  logistics are some things companies have had to consider greatly. The challenges of the past two years “are tipping the scales toward speedier adoption of next-generation ERP systems,” noted a report published by Boston Consulting Group. “It will be virtually impossible to use traditional ERP to manage the anticipated huge growth in e-commerce and the need for flexibility and speed.” There is a push towards more automation and flexibility in many industries because of this new shift in the workplace. An article on CIO by Joe McKendrick shares how 3 forces have influenced and shaped the evolution of ERP – where things are falling short, and where enterprises are looking today.

Workforce shifts. The COVID-19 pandemic essentially forced many companies to move from an on-prem to a cloud-based ERP while the world was on lockdown. Since then, we’ve seen a larger number of hybrid and remote workers, this being the new “normal” in the workplace.

Analytics. Next-gen ERP platforms drive on analytics, and companies see real-time transparency of their sales, inventory, financials, and production volumes, according to the Boston Consulting Group. “Powerful data-driven analytics enables more agile decisions, such as adjustments to the supply chain to improve resilience. Robust e-commerce capabilities help companies better engage with online customers before and after a sale.”

Supply chains. McKendrick notes, “Unprecedented and ongoing supply chain disruptions underscore the need for greater visibility, more predictable lead times, alternative supply sources, and faster response to disruptions. A survey from FiveTran and Dimensional Data found that 86% of executives seek access to real-time data through their ERP systems. However, only 23% said such capabilities exist within their current ERP systems and 99% reported they are unable to access the information they need.”

 

For Full Article, Click Here

Frontier Co-op Manages Business Process Risk with Infor Governance Risk and Compliance

Infor recently announced that leading American food manufacturer Frontier Co-op has implemented Infor Governance Risk and Compliance (GRC) to manage business process risk. An Infor customer for three years. Frontier Co-op swapped out their legacy enterprise resource planning (ERP) solution for Infor CloudSuite Food & Beverage in 2019. Per the press release, working with the tech giant allowed Frontier Co-op to implement Infor GRC in less than three months and has seen 10% less demand for IT support. Additionally, Infor GRC provides Frontier Co-op out-of-box risk and compliance software, enabling finance, audit, and IT users to share a common platform to monitor controls for Infor CloudSuite Food & Beverage.

 

For Full Article, Click Here