How to get a list of specific program codes and screen descriptions in Lawson

There are two common ways to get a list of program forms and their description from Lawson. One is through LID and another is through a database application like SQL Management Studio.


Method 1: The database application method requires your user to have at least database read access to the PROD or TEST Lawson database.

  1. Login to the PROD or TEST database through your database app (using SQL Management Studio for this example).
  2. Expand the PROD or TEST GEN database and expand the Tables folder:
  3. Scroll to the dbo.SCREEN table >> Right-click >> Select Top 1000 Rows
  4. For those not familiar with SQL, simply remove the TOP 1000 portion from the code to return all records in this table.

Change from this:

To this:

  1. Now click the Execute button:
  2. Select all returned records at the bottom by clicking the top left box:
  3. Right-click same box >> Copy with Headers
  4. Paste into Excel and filter as needed:


Method 2: The LID method is simpler if you have access to Lawson Interface Desktop

  1. Login into LID, your user will need access to rngdbdump
  2. Change directory to a safe directory to dump a file into.
  3. Type this command: rngdbdump -ct gen SCREEN > SCREEN.csv
    1. This command will dump out the SCREEN database table into a csv file in your current directory
  4. Go to that directory and open the csv file in Excel, filter down on the forms you want to view.

Good luck!


Program Error “netexpress not found”

In a new install of Lawson, we recently had an issue running forms (inquire, previous, add, etc).  The program would hang and eventually show an IOS error message.  The job log said that lacobrts failed due to a timeout, but latm.log presented a more detailed error.

Thu Jun 17 18:55:55 2021: latm (jeeStartComponent): netexpress not found

Thu Jun 17 18:59:21 2021: latm: Monitoring turned on

Thu Jun 17 19:01:16 2021: Timeout on opening application, removing application

Thu Jun 17 19:01:16 2021: Pid=-1, Program Code=CU01  DataArea/DataID PROD       

Thu Jun 17 19:01:16 2021: Possible causes: Insufficient NetExpress licenses or

Thu Jun 17 19:01:16 2021:      not enough database users configured in ladb.cfg.

Thu Jun 17 19:01:16 2021: latm (PrcTPCrash): Received death notification of lacobrts, Uid=-1, Pid=-1

Thu Jun 17 19:01:16 2021:                  Program Code = CU01 , DataArea/DataID = PROD         

Thu Jun 17 19:01:16 2021: ERROR:    Exited with error code 0


The Microfocus COBOL licenses were definitely not an issue, so we started trying to track down the “netexpress not found” error.  Running “echo %COBDIR%” in LID revealed that the COBDIR environment variable was not pointing to the correct location.

This variable is set by the system, and is not something you can override in the Windows system environment variables.  After some troubleshooting, we discovered that the Lawson system value “LAUNCHER” was not correct.  We ran the command LaMgmtCmd -r <envname>, which showed the LAUNCHER value as “NetExpress”.  We compared this to another (healthy) environment that showed the LAUNCHER value as “run.exe”.

Some of these values can be modified using laconfig, but this specific value had to be updated using the update option on the LaMgmtCmd command.  First, we created an XML file with all the values (including the correct launcher), then ran LaMgmtCmd -u <envname> <filename>.

After the update, we rebooted the system, and ran lamgmtcmd -r <envname> to validate.

The value was correct, and we were able to start using the forms again.

Condition not found errors in blddbdict

When running the blddbdict command after a patch or after using metaloadtable, the blddbdict command may fail with “condition not found” messages.  If this is the case, run the following commands to resolve the issue:


setnotused <prodline>

blddbdict <prodline>


How To Choose A Managed Service Provider For Public Sector

Maintenance Service Plans (MSP)s provide managed services to deploy the basic infrastructure and application services. Subscription terms for managed services vary from month to month and can be paid upfront or monthly. Sources: 4


Depending on the size of your business and its needs, you can outsource a single service to a third party (MSP) or opt for an integrated and comprehensive range of services. An MSP is a third-party partner that companies, executives and business leaders provide for certain parts of their business, such as the cloud, IT, projects and support. Using an MSP to manage certain parts of the business can be a cost-effective alternative. Sources: 4, 5


You need MSPs who have the flexibility to take on additional projects and services as needed, and the ability to guide you in looking at new technologies. When selecting the MSP, you should assess your company’s compatibility with the MSP in matters such as compliance, service level agreements and data protection. Sources: 2, 9


Your MSP should be able to explain security practices of your data center and tell you how data is stored and which external providers use it. The right MSP will want to find out if you need certain features and specifications to manage your workload. You will also want to know if you need certain resources from your cloud provider. Sources: 3, 9


Managed services are now one of the fastest growing sectors of the enterprise technology landscape. Many companies are beginning to turn to MSPs for help. Accountancy firms, law firms, professional service organizations and small and medium-sized enterprises of all shapes, areas and markets are increasingly turning to MSPs for IT security, data management, 24 / 7 system monitoring and a variety of IT services for businesses. Sources: 3, 9


MSPs give your company flexibility and access to a dedicated, qualified IT team and their internal resources. MSPs have economies of scale on their side, which allows them to charge less for basic IT services and offer a wider range of expertise. Sources: 6, 9


Choosing the right MSP can give your internal IT team the most valuable time and reduce stress for business owners by establishing a clear SLA on how to handle and escalate issues. An MSP can manage your cloud on demand and ensure that your other critical IT infrastructure works smoothly. Sources: 6


If your company chooses the wrong MSP, you will be left with inexplicable downtime, reputation damage and dissatisfied customers. Cloud Managed Service Providers you select do not have the skills and experience required for this task, and the time and money you invest in them is a waste of time. Sources: 6, 7


For a tech-savvy company, assessing a managed service can be a complicated and challenging undertaking. There are many factors to consider when deciding to hire an MSP to meet your MSP needs, from vendor prices to contract terms. The expertise of your MSP can affect the efficiency, availability and outcome of your business and help you stay ahead of your competitors. Sources: 4, 7

To make the right decision about an MSP you must ask dozens of questions. Before entrusting your data to an MSP, ask about the challenges they have overcome in the past. Sources: 10

You want a provider who has demonstrated competence and interest in managing standards and workload in emergencies, complex problems and mission-critical systems. A managed service provider should be able to provide support in situations where it is not possible to use it. Sources: 2, 10


This means that MSPs should support a variety of virtual machine deployments, a variety of network connections and understand the specifics of working with different cloud service providers. Managed cloud service providers can serve a combination of MSPs and cloud service providers and should be equipped to manage hybrid cloud deployments. Sources: 2


An MSP is an outsourcing company that is responsible for defining and establishing day-to-day management of services for its customers. The central principle of the MSP model is that the provider-customer relationship is based on a contract that is secured by a Service Level Agreement (SLA). Applied to MSPs, the definition varies and changes depending on the service offered. Sources: 2, 4, 8

It is a strategic method of improving business operations that is common among large corporations, small and medium-sized enterprises, non-profit organizations and governments. An MSP can handle a myriad of operational tasks that are crucial to the success of a company, both for non-customers and for customers. This allows a company to leverage the skills and experience of an MSP while avoiding the direct costs of managing the program itself. Sources: 8


Deciding who to trust with the entire scope of your business can be daunting. In the modern age, companies live and die from the quality of technology and thus from the IT team that supports them. Sources: 0


This makes it all the more important to select the right MSP for your needs, qualifications and experience in order to take your company to a new level. In the information age, here are some tips and advice to help IT executives select a managed service provider and how to make the most of it. These tips will help boost your confidence and ensure that when you are looking for an MSP consultant for your business or IT, you get the best value for your money. Sources: 0, 1


It feels as if the term “managed service provider” (MSP) has existed since the dawn of computer technology. In short, a managed service provider is a company that outsources or manages parts of an organization through its platform. According to the 2017 IDC Application Services Survey, 30% of leaders outsource the management of their organizations’ infrastructure and application portfolios, which is expected to increase to 41% in the next five years. Sources: 1

Cited Sources


Legal Notice The text provided on this site is based on and the intellectual property of the cited sources and is not responsible for the content.

How To Choose A Vendor Management System

A vendor management system (VMS) is a suite of software that helps companies take over the entire vendor management process, from the first contact to the final conclusion of a deal or the establishment of a business relationship. Vendor management is a process that enables organizations to take appropriate measures to control costs, reduce potential risks associated with suppliers, ensure excellent service and derive long-term value from suppliers. Vendor management involves researching the best and most appropriate supplier sources, acquiring pricing information, assessing work quality, managing relationships (in some cases with multiple suppliers ), evaluating performance, establishing organizational standards and ensuring that payments are made on time. A supplier management system is an online or web-based tool that acts as a single node for all vendor-related activities within an organization or organization to ensure and improve efficiency and long-term growth in a cost-effective manner. Sources: 2, 6


With a modular approach, vendor management systems (VMS) have special modules or apps that handle processes such as vendor onboarding and vendor payments. Supplier management plays an important role in the operation of a supply chain, so there is a lot to consider when researching this type of software. It is the key to the success of procurement teams and the use of a good supplier management system offers advantages in this context. Sources: 2, 7


In this Buyers Guide, we explain the basics of vendor management software and what you need to know as a small business to make your software choices. Sources: 7

You should remember that the main objective of supplier management software is supplier engagement and maintenance as well as project management. However, many vendor management software systems offer much more, so you should carefully set your priorities when selecting a vendor management solution for your business. Sources: 0


When a company is looking for a new Vendor Management System (VMS), there are a variety of software solutions to choose from that appear to have similar functionality on the surface. Vendor management professionals would be well advised to devote more time to differentiating features such as native business intelligence (BI) and advanced workflow tools, with so much in common that leads to vendor sourcing to make the best buying decisions. It is curious that many vendor management software systems contain functions that could replace existing software solutions for your company. Sources: 0, 4


Next-generation VMS include BI capabilities such as the ability to analyze past performance, respond to business events in real time, and execute scenarios to identify future opportunities. The right vendor management software adapts to the existing legacy systems and increases the value of the operation. It streamlines your AP processes, creates self-service opportunities for vendors and facilitates communication. Sources: 4, 9


Choosing the right supplier management system is crucial to meet these growing requirements. By introducing appropriate supplier management, your organization benefits from a wider choice of suppliers, resulting in more choice and better costs. Let us examine some of the ways we need to look for when evaluating third-party providers and risk management solutions to make the implementation of your initiatives more cost-effective. Sources: 3, 6


The organization and management of vendor information such as financial contracts, insurance and certificates is crucial for effective third-party supervision. An efficient supplier management system ensures that the team works with suppliers in all functions and that there is complete transparency on important supplier details. Sources: 3, 10


A good supplier management system enables effective interactions between suppliers and their team leaders.  Supplier management systems are software that helps companies manage their workers, suppliers, contractors and consultants. A good supplier management system is a great way to keep suppliers in your corporate culture and work environment. Supplier management software can help companies find subcontractors, contingent workers, and human resources agencies that are able to help with sales orders, consolidate billing, and reporting. Sources: 5, 9


Vendor management is a term that describes the process by which companies manage their suppliers, also known as vendors. Vendor management solutions are a kind of Software-as-a-Service (SaaS) that enables companies to communicate and assign tasks to paid independent contractors and freelancers. Sellers are involved through communication channels that facilitate real-time communication between sellers and strengthen relationships between sellers. Sources: 5, 9


Centralized and simplified communication tools that provide a secure and reliable way to approve and take suppliers on board, maintain useful performance monitoring and deliver the right analytics and insights to make critical business decisions. From an enterprise perspective, an efficient supplier management process can help save time and money, ensure that your organization works with reliable suppliers, and ensure contract compliance when drafting contracts, invoicing, making payments, and much more. Sources: 10


The supplier management system you choose should be compatible with your company’s existing tech stack without compromising your company’s data. Contact your IT compliance team to ensure that the solutions you evaluate work with the technology you already use, and that you trust the provider to protect your information. Sources: 11


Let your IT team know that you are considering some software solutions, and ask if there is anything special you can require from the vendor, such as an API (Application Programming Interface) that allows two different applications to communicate and work together. Now that we have set out why you need a supplier management system, let us discuss how it works. The first rule of thumb is that there should never be more than one vendor management system. Sources: 11, 12


Today, marketplace organizations depend on vendors and other third parties for essential business functions, making the maintenance of an effective supplier management program both important and complex. However, efficient supplier management results in both time and money savings, as it provides a way of keeping track of all of the important dates that need attention – expiring insurance certificates, for example. Sources: 3, 8


In the past, multiple supplier schedules and subsequent payments had to be managed on paper but today many companies opt for the supply chain management software that automates labor-intensive tasks. Many of the tasks above were previously done on paper and tracked manually, but more and more companies are now looking for vendor management software solutions such as web applications and cloud-based solutions that can handle most tasks. Depending on how companies scale, their supplier management software should be scalable and can be integrated into existing software. Sources: 1, 8

Cited Sources


Legal Notice The text provided on this site is based on and the intellectual property of the cited sources and is not responsible for the content.


How To Choose A Managed Service Provider For Healthcare

Managed services are now one of the fastest growing sectors of the enterprise technology landscape. Many companies now turn to Managed Service Providers (MSPs) for help. MSPs have economies of scale on their side, allowing them to charge for basic IT services less and offer a wider range of expertise. Sources: 2, 9


In order to keep pace, optimize system performance and improve patient care, healthcare providers are increasingly working with MSPs. As managed IT services offer the right mix of security, scalability, reliability and flexibility needed to transform IT, healthcare organizations under pressure to maintain their own IT services on tight budgets are increasingly looking to these MSPs to manage some of their IT operations. Many healthcare providers take a “managed IT service” approach and work actively with these service providers. Sources: 7


If you do not have an IT department to manage your own technology, you can still benefit from hiring a (MSP). Whether you have your own IT department or not, companies are finding that they can save time and money and increase efficiency and effectiveness by signing contracts with an MSP to strengthen their existing IT staff.


Your business is special, your goals are important, your needs are important, and your MSP should treat you with the respect that your business deserves.  You should never feel like you’re just another number in a new customer book of IT managed services providers.


Once you have interviewed a managed service provider, you should consider whether it offers traditional managed services or next-generation managed services. This is especially true for managed service providers who end up with complete administrative access to your entire network. The offerings will vary, but with next-generation database managed services providers, you can place greater emphasis on accessing strategic partners who can help you accompany your data journey, taking into account the mentality that traditional database management service providers offer. Sources: 5, 10


Your MSP is your IT protector, intermediary and Sherpa, grouped into an IT service provider that supports your business to the extent that suits your specific needs. Your MSP gives you access to remote support staff, infrastructure management, health monitoring, scheduled on or off-site support.


Here are some tips and advice for the information age to help IT executives choose a managed service provider and get the best out of them. It feels as if the term “managed service provider” (MSP) has existed since the dawn of computer technology. In short, a managed service provider is a company that outsources or manages parts of an organization to its platform. Sources: 1

MSPs are growing in popularity: according to the 2017 IDC Application Services Survey, 30% of managers outsource the management of their organizations “infrastructure and application portfolios, rising to 41% in the next five years. Sources: 1

Database-managed service providers, also known as MSPs, manage the technical infrastructure, databases and systems of customers. The services offered by an MSP include managed infrastructure, data and cybersecurity. As technology changes, database management service providers must have a wide range of resources at their disposal to develop their services and software to provide their customers with the best possible service. Sources: 10


In response, US hospitals may consider using services from an MSP as an MSP can help your institution recruit experienced clinical talent, simplify your work process and get an invoice from one contact. Many will present you with a list of services they can offer you at a price. Sources: 3, 6


Choosing the right MSP is not as simple as comparing the list of services they provide and going with the provider with the lowest cost. Gain an understanding of the MSPs of your organizations by evaluating your IT environment. Your MSP is more likely to see you as a partner, and your success will depend in part on you. Sources: 0, 6


A potential MSPs scope of business may not be as laser-focused as a top-tier MSP, and they may not deliver the focused attention and dedication your business deserves. An effective managed service provider is one that explores more information about your business, your needs, your challenges and your goals. An MSP needs to know who you are and where you want to go, from monitoring your technology to expanding your business. Sources: 0


Cited Sources

Troubleshooting WebSphere Plug-ins GSK Error – Part 1

When attempting to access Lawson applications hosted in WebSphere, you may encounter a 500 service error that gives very little details. If there are no exceptions in any of the LAWDIR/system or WAS systemout.log, go you should also check the http_plugin.log in WAS/plugins/logs/<web_server>. If you discover GSK error message, this indicates that there is something wrong with your certificates or IBM security.

The error message will typically look like this:

[Thu Apr 01 09:47:45 2021] 00002574 000025a8 – ERROR: lib_stream: openStream: Failed in r_gsk_secure_soc_init: GSK_ERROR_BAD_CERT(gsk rc = 414) PARTNER CERTIFICATE,OU=certs,O=company,L=anywhere,ST=California,C=US, Serial=2d:7b:d0:29:00:08:00:00:5e:22

[Thu Apr 01 09:47:45 2021] 00002574 000025a8 – ERROR: ws_common: websphereGetStream: Could not open stream

[Thu Apr 01 09:47:45 2021] 00002574 000025a8 – ERROR: lib_stream: openStream: Failed in r_gsk_secure_soc_init: GSK_ERROR_BAD_CERT(gsk rc = 414) PARTNER CERTIFICATE,OU=certs,O=company,L=anywhere,ST=California,C=US, Serial=2d:7b:d0:29:00:08:00:00:5e:22

This can mean that the web server certificate is expired or invalid or not matching the certificate on the trust or key stores. Another thing to try is to set “AutoSecurity=false” on the Web Server plug-in custom properties.

To do this, go to Web Servers > <web server> > Plug-in Properties > Custom properties. Create a new property. The Name is AutoSecurity and the value is “false”. Save the configuration, then generate and propagate the plugins. Make sure that the plugins xml file has the new “AutoSecurity” setting in it. Bounce the WWW Publishing services for the change to take effect and test your application again.


Lawson Archive Procurement Module Demo

Access your historical Lawson data through an intuitive light-weight web interface and stop maintaining old servers and applications! In this webinar we’ll demo our procurement module and answer any questions you might have. You can access recordings of HCM and Financials demo on



What to do if your MSCM install values are incorrect

When you are doing an MSCM install or update, and you “fat finger” one of the values in the wizard, it can be a real headache. In this example below, the installer defined the wrong port for the WAS connection information. The install wizard threw a java exception during the install. The install.log file indicated an issue connecting to WAS, which led to the wsadmin.traceout file, which showed the culprit as the invalid port.

To rectify this issue, you may need to update the value in two places. The first place you will definitely need to fix the value is in the install.cfg file. This is located at C:/lawson/mscm/<instance name>. The only thing you aren’t going to be able to change here is encrypted passwords. If you have mistyped a password, you will need to uninstall or revert to a backup.

The other place you may need to update the value is in the MSCM properties files. Check for the value in, mscm.ios.peroperties, or and fix it there.

Now, restart your install and you should be golden!