Archive for category: Frontpage Article

You are here: / / Frontpage Article

Excel Lawson Workbook Macro Template Buttons Not Working

, ,

If your Lawson Addins or Macro Workbook buttons stopped working all of a sudden in Excel then this guide is for you.

 

First let’s make sure this issue is only occurring to your PC. If this is a wide spread issue among all users, it’s likely a Lawson Addins or Excel version issue. I would refer to the addins compatibility matrix provided by Infor.

 

If this is only occurring to a specific user. Then it’s likely a display issue, follow the steps below.

 

  1. Go to start and type “Change Resolution of the display” and select that option:
  2. Click on the monitor that is set as your “Main display”
  3. Scroll down under Scale and Layout and set the size of Text, App etc. to 100%
  4. Once your main display is set to 100%, your Re-open your Excel Lawson Macro Workbook and see if the button is functioning correctly.
  5. IMPORTANT: If another external monitor scale and layout settings are above 100%, it will also break the excel workbook spreadsheet when the application is being viewed from that monitor (so it dynamically changes when you move apps between monitors).

 

Infor OS 503 Service Error (111)

, ,

If you receive a 503 Service Error (111) after an Infor OS install or update, it is possible that the SAML configuration was not properly deployed.  Another symptom of this issue is if the Grid-XiPlatform application doesn’t show up under Applications in the InforOSManager.

To resolve this issue, try to redeploy the Core SAML.  Log into the InforOSManager and click on the main Infor OS instance.  Click the button “Redeploy Core SAML”.  Once it is successfully deployed, click the Save button.  Then, reboot the server.

To validate, make sure that the Grid-XiPlatiform application is available in InforOSManager.  Now, the grid home page should load.

 

ISS: Server Communication Failed when trying to add a user

, ,

Problem:

You may come across this issue in Infor Security Services (ISS): “Server communication failed when trying to add a user.” This usually means that ISS did not respond to your command. Any attempts to add a user yield the following error message: “Server Communication Failed.”

 

Resolution:
There is a simple solution to this command error. Since it is seemingly a minor technical error, all you need to do is Reboot the LMK server. This will re-establish the connection between Lawson System Foundation (LSF) and LMK. The ISS should respond to your command now and you can proceed to add a new user.

Advantages to Hosting ERP in the Cloud

, ,

In recent years, the popularity of cloud computing has grown exponentially. With businesses moving their applications and data to the cloud, there has been a significant shift from on-premise deployment to cloud-based deployment. Enterprise Resource Planning (ERP) systems are no exception to this trend. More and more businesses are moving their ERP systems to the cloud. In this blog post, we will discuss the advantages of hosting your ERP in a cloud environment over an on-premise environment.

 

Scalability

One of the biggest advantages of hosting your ERP system in the cloud is scalability. With cloud-based ERP, you can easily scale up or down based on your changing business needs. Whether you need to add more resources, users, or functionality, cloud-based ERP systems make it easy to scale up or down without any disruption to your business operations. This scalability feature is particularly beneficial for small to medium-sized businesses that are experiencing rapid growth.

 

Cost-effective

Another significant advantage of hosting your ERP in the cloud is cost-effectiveness. Cloud-based ERP eliminates the need for significant upfront investment in hardware, software, and infrastructure. With cloud-based ERP, you only pay for what you use, making it a cost-effective option for businesses of all sizes. Additionally, cloud-based ERP systems require less maintenance and support, reducing the overall cost of ownership.

 

Improved Security

Security is always a concern when it comes to hosting sensitive business data. Cloud-based ERP systems typically provide better security features than on-premise systems. Cloud providers often have dedicated teams of security experts who work to ensure that their infrastructure is secure. They also provide regular software updates and patches, ensuring that your ERP system is always up-to-date and protected against the latest threats.

 

Accessibility

Cloud-based ERP systems provide users with the flexibility to access the system from anywhere, anytime, using any device with an internet connection. This feature is particularly beneficial for businesses with remote teams or employees working from different locations. With cloud-based ERP, users can access the system from anywhere, making it easy to collaborate and stay connected.

 

Better Disaster Recovery

Disaster recovery is another area where cloud-based ERP systems outperform on-premise systems. Cloud providers typically have redundant systems and data centers, ensuring that your ERP system is always available, even in the event of a disaster. Cloud-based ERP systems also provide automatic backup and recovery, reducing the risk of data loss.

 

In conclusion, hosting your ERP in a cloud environment offers several advantages over an on-premise environment. Scalability, cost-effectiveness, improved security, accessibility, and better disaster recovery are just a few of the many benefits of moving your ERP system to the cloud. If you’re considering moving your ERP system to the cloud, make sure to choose a reputable cloud provider and consult with an experienced ERP consultant to ensure a successful migration.

Resolving Batch release or delete in progress when trying to release a batch in Lawson

, ,

Problem:  “Batch release or delete in progress” indicates that a process is attempting to maintain the batch in question.

 

Potential cause: Portal program AP25 or AP26 was previously aborted or if an AP125 or AP126 job went into needs recovery.

 

Resolution:

If there isn’t a batch process currently running and there isn’t a job in recovery (AP125 or AP126), then the database record associated to the batch being maintained needs to be deleted from the APMONITOR (DBAPMON) table.

 

The record will have a Run Prog value of “APREL”. If there are multiple records where “APREL” exists in the Run Prog value, then the other fields (Pay Group, Company, Auth Code, Batch Num, etc.) could be used to identify which record needs to be deleted.

 

Alternately, all records may be removed where the Run Prog value is “APREL” as no records with that data should exist if AP125, AP126, AP25, AP26 are not currently active (or in needs recovery if a batch process).

 

Important Note: While maintaining the APMONITOR data for “APREL” related records, other records (ones where the Run Prog value is not “APREL”) should not be removed as those control other aspects of the pay cycle processing and doing so may result in corrupt data.

 

To maintain the data, inquire on the desired records via Infor application AP94 ‘Apmonitor’ and delete the record(s) where Run Program value equals ‘APREL’.

 

Make sure you check with Infor or your Lawson MSP consultants to see if this is required based on the environment version you’re running.  Good luck!

 

How to dump Lawson recurring jobs from a user or system user

, ,

Dumping Lawson jobs can often be confusing with the many different flags. Recuring jobs get a little more confusing but don’t be discouraged! There is an easy wat to know how to dump your Lawson recurring jobs from a user or system user. Follow the simple steps below:

 

First, log in to Lawson Interface Desktop and switch the to the directory you wish to dump the job file

 

Let’s say I want to dump all recurring jobs from user joesmoe.

 

Type the below command into LID:

jobdump -d -o RecurJob -v UserName joesmoe joesmoe _recjobs.txt

 

Locate the joesmoe _recjobs.txt file and that’s it! Good luck!

Migrating Infor Lawson v10 Applications to Windows Server 2019

, ,

Infor has announced that their mainline support for Lawson will continue through 2030, and extended support for Windows Server 2012 is ending this October! Are you ready? Join us for some tips to make your migration to Windows Server 2019 as smooth as possible.

 

 

Get Started Today!

Don’t wait!  Contact us to get a quote on your server migration now!

An accompanying article for this webinar can be found here