Building a .cbl for Infor

, ,

There are times that Infor support will ask for a .cbl of a program in your Lawson system.

 

When working with Infor Lawson systems, you may encounter situations where Infor support requests a .cbl file for a specific program. This is because .cbl files contain the source code for programs written in COBOL, a language commonly used in business software like Lawson.

Why Infor Support Might Ask for a .cbl file:

  • Troubleshooting Program Errors: If a Lawson program is not functioning correctly, providing the .cbl file allows Infor support to examine the source code to identify and diagnose the issue.
  • Investigating Program Behavior: The .cbl file helps Infor support understand the program’s logic and how it processes data, which can be crucial for resolving unexpected behavior or performance problems.
  • Analyzing Customizations

 

Resolution :

At the command prompt, type bldsh productline system code program

Example: bldsh test IC IC130

This will create a .cbl in your LAWDIR/productline/xxsrc directory.

Lawson Comments & Attachments

, ,

Many Lawson screens have comment buttons that open a drill-around screen with different comment types.  If you have ever wished to query these comments for reporting or other user interfaces, you may have noticed that they are difficult to find.  Infor has “hidden” them in tables with the “L_H” prefix.  This is the “header” for the comment.  If there are any details that spill over the available characters in the commend, there will also be a record in the corresponding L_D table.  The naming convention is “L_HXXX” or “L_DXXX” where “XXX” is the prefix of the table that feeds screen where you add the comments.  For instance, Requisition Header comments can be found in “L_HRQH” and “L_DRQH”.  Join the comments to your main record using the “L_INDEX” column in the parent table.

How to remove the Infor Logo from your Lawson Business Intelligence dashboard

, ,
  1. Login into LBI
  2. Click ‘Display Dashboard’ link under Tools -> Services -> FS Service module.
  3. Click New Property Button and type ‘showBanner’ then click ok.
    1. Important: type showBanner exactly as shown (case sensitive)

  4. Type NO to hide the banner (if showBanner property is not present, default is YES)
  5. Click Update at the top and refresh the page to see changes.

 

Before:

After:

If you found this article helpful, Nogalis offers managed services and technical resources to assist with customizing and maintaining your Lawson Business Intelligence dashboard. Whether it’s tasks like removing logos or other system configurations, our team provides the support you need. Contact us to learn more about our managed service offerings and how we can assist with your Lawson system needs.

Updating GLMonitor

, ,

Sometimes the following error on GL may occur: Resolving “Cannot run this program while GL190 is running” error when trying to release journal entries in GL40.1

You may run into this error at some point in GL40.1 or GL45.1:

Fortunately, there’s an easy fix to this. First login to Lawson portal and search GLMONITOR:

In GLMONITOR, type in GL190 and hit Inquire, if you get results and notice the run time, the process is in fact still running and causing the issue with GL40:

Go to job scheduler by opening LID and typing in jobschd >> F7 + A to select all users >> Then W to go to waiting screen.

Look for any GL190 jobs running and verify the User Name is the same one in GLMONITOR when inquiring on GL190 program. Check the error and if its safe to recover, recover it and let the job complete.

 

Go back to GLMonitor and inquire on GL190 to verify the job is no longer running:

Go to GL40.1 and release your Journal Entries.  Good luck!

 

Resolving the “Operator Not Authorized to Change Unit Cost” error

, ,

This is one of those Lawson errors that could waste a morning of work looking through the Infor knowledge base, analyzing/changing security, and or reviewing logs.

 

So, you’re on PO20.1 and want to make a change to a PO entry and get this error:

To resolve this is actually incredibly simple and can be changed on PO04.1 at the bottom of the Buyer Information Tab (your settings may be different based on your needs):

If you happen to get a similar issue for a requisition cost change “Requester not authorized to change unit cost”, simply go to RQ04 and allow unit cost override for the specific requester (your settings may be different based on your needs):

If you found this article helpful, Nogalis offers expert managed services to resolve Lawson errors like this quickly and efficiently. Our offerings include troubleshooting technical issues, streamlining processes, and providing functional finance resource assistance. Whether it’s addressing security settings, resolving errors, or enhancing workflows, our managed services ensure your finance operations run smoothly without the need for a full-time, in-house team. Contact us to learn how we can simplify and optimize your Lawson experience.

Update SQL Tables after Data Refresh

, ,

When you perform a data refresh in your SQL database, such as reloading data into tables, you may need to take steps to ensure dependent objects and overall database performance are optimized. Follow these steps to Update your SQL Tables after a Lawson Data Refresh.

First, open up the properties for the DB that was just refreshed and you can see that the DB tables have the PROD name.

 

Next, run the following SQL query for the TEST DB:

ALTER DATABASE INFORLAWTEST10 MODIFY FILEGROUP INFORLAWPROD10_DATA NAME = INFORLAWTEST10_DATA

ALTER DATABASE INFORLAWTEST10 MODIFY FILEGROUP INFORLAWPROD10_INDEX NAME = INFORLAWTEST10_INDEX

You’ve now updates your SQL tables post-refresh.

Limiting Access to External EMSS

, ,

Many of our clients would like to lock down their external websites to EMSS (Employee and Manager Self-Service) only, because it is a security risk to allow super users to access Human Resources (HR) & Financials from the web.  The official word is that this cannot be done in Lawson.  However, Nogalis has devised a method to remove the search box and all but the desired bookmarks from the external Lawson website (See a sample screenshots below).  If you would like to have this done at your organization, Nogalis is happy to help. Please contact us today!

Internal Lawson Site

External Lawson Site

Lawson Expense Management XM User Profile Getting Overwritten

, ,

Problem: An XM User Profile is getting overwritten.

 

  1. Login to XM and view the user profile in XM (Admin rights required):
  2. Locate and view your user:
  3. View the Administration Log and figure out who or what process might be changing this:
  4. In this case we see the HRBkg process modifying this user. This can be bringing data in for your organizations HR application (Workday etc.).

 

You can consult Infor further to get more information on the process updating your XM Users (assuming it’s not a completely custom process). Nogalis also offers a team of managed service professionals to help support processes like Expense Management among other applications. We also support custom processes unlike Infor. Visit us at our contact page for more information: https://www.nogalis.com/support/

 

Lawson Expense Management – Re-Routing an Expense Report in XM App

, ,

Problem:
An Expense Report needs to be re-routed immediately for someone else to approve ASAP. Follow these steps to quickly solve this issue.

 

Solution:

1. First, log in to Mingle and Open the Infor XM App under the Applications section.

 

2. Go to Admin >> Tools Document Management (note: admin permissions required)

 

3. Next, search your expense report and Edit it:

 

4. At the bottom left, remove any existing users and add the user you want to approve, then click Save at the top right of the screen:

 

The user you add will now see the Expense Report and will be able to process it.