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.
Jøtul Heats up its Future with Infor Cloud ERP
NewsInfor 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
Weekly Patch Notification: July 9, 2022
Articles, Frontpage Article, PatchesLBI Install Errors
Articles, Frontpage Article, NewsHere 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
NewsWith 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.
For Full Article, Click Here
Colombian Pet Food Specialist Italcol Selects Infor CloudSuite WMS to Improve Inventory Efficiency and Customer Satisfaction
NewsPet 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
Articles, Frontpage Article, NewsThis 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
NewsJernia 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
Weekly Patch Notification: July 2, 2022
Articles, Frontpage Article, PatchesGetting the version of important Lawson interfaces
Articles, Frontpage Article, NewsInterface 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:
Its quite simple as long as you have access to LID, Infor Security Services (cloud) and Landmark Command Line (cloud) access.
Starting with LID:
Infor Security Services (ISS):
Landmark Command Line (ILMRK):
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
NewsThe 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