Adding or Replacing Existing SSL CERTS Lawson (WINDOWS)

This is a PFX cert.

Start – This is being done on a Lawson LSF server.

  1. Drag the folder with the Cert onto the server you want to apply it to.
    1. Once you do that, make sure you check whether or not the server is running IIS. Typically by searching for IIS Manager or checking services.
  2. Double click the cert file that you dragged onto the server.
  3. Select Local machine:
  4. Specify the file you want to import (should default on the cert you just clicked to run) >> Next
  5. Enter the password for the cert and click next.
  6. Open command prompt as admin and type: start certlm.msc
  7. Under Personal >> Certificates, you should see the new cert you imported: The old one is below the one highlighted in red.
  8. Now go to IIS Manager, Sites >> select WebsiteName and then on right pane select bindings as shown below
  9. Select https binding and edit
  10. Select new cert and click ok
  11. Back in command prompt type: iisreset /restart
  12. Test and you’re done

When applying to Landmark server, we need to run the following commands below (Important to stop and start exactly as shown):

For Mingle in ISS Manager, we need to select the Sharepoint secure site and select bindings.

Upcoming Events February 2019

Winter meetings are beginning the Lawson User Group communities to kick off 2019!

MWLUG Winter 2019 Meeting

Hosted by: Midwest Lawson User Group
When: Thursday February 21st, 2019 from 8:00 to 3:30 (US/Central)
Location: HealthPartners 8170 33rd Avenue South Bloomington,MN 55044

Join the Midwest Lawson User Group for our 2019 Winter Meeting

There will be Special Interest Group (SIG) breakouts by functional area in the morning, then Technical, Human Capital Management, Enterprise Financial Management and Supply Chain Management breakout sessions in the afternoon.

Plenty of great prizes to award at the conclusion of the meeting!


Cap off your day by joining us for a networking reception following the meeting at HealthPartners. Please join us for a couple of hours of food and drink at JTs Food and Cocktails, located just 3 minutes from HealthPartners – across from the Mall of America (former location of RedRossa)!  All beverages and appetizers are provided… this is a perfect opportunity to avoid rush hour and spend some time networking.  Join your peers, vendors and Infor Lawson employees as we continue discussion on Infor Lawson in a relaxed, fun atmosphere.

Learn more how to Connect, Discover and Engage in the Digital Concourse Community, powered by WorkOutLoud

Hosted by: WorkOutLoud
When: Tuesday, February 19th, 2019 from 12:00 to 12:30 (US/Central)

The “GoToMeeting” link will be sent to all registered members the day before the webinar.

This is a free educational webinar to help you explore your community more and better understand the power you have to increase collaboration with your community peers.

Your Digital Concourse community keeps you informed on what is happening in your independent Infor community and provides the tools to connect and collaborate with others like you.

Learn How To…

  • Try the Forums to ask questions and receive answers from your peers
  • Follow user groups to stay up to date for best practices or announcements
  • Community search for people, groups and content
  • Connect with your peers or our successful Community Partners
  • Watch a educational videos to self educate and learn on your free time

If you know of a user community that would like to have the ability to do the same, please contact us today.

View/Register Here

What is ADFS?

There has been a lot of confusion in the Infor client community lately over what ADFS is and what the impact of implementing it will be on the organization as a whole.
Active Directory Federation Services (ADFS) is a Microsoft solution created to facilitate Single Sign-On. It provides user with authenticated access to applications like Lawson without the need to provide the password information to the application.
ADFS manages user authentication through a service hosted between the active directory and the target application. It grants access to application users by using Federated trust. The users can then authenticate their identity through Single Sign-On without having to do so on the application itself. The authentication process is usually as follows:
1) The user navigates to the Lawson URL
2) The unauthenticated user is re-directed to the ADFS service
3) The user signs into ADFS
4) ADFS service authenticates the user via the Active Directory
5) The user is then given an authentication claim (in the form of a cookie) by the ADFS
6) The user is forwarded to the Lawson application with the claim which either grants or denies access based on the federated trust service
Note: The Lawson Server never sees the password information which in the case of external applications (like a cloud implementation) is a lot more secure.
What are some drawbacks of implementing ADFS?
Although ADFS is a new requirement, it comes with a few small drawbacks that you should consider:
– The additional server license and maintenance – You will need an additional server (likely one per environment) to host ADFS
– ADFS is actually somewhat complex and this new skill set can create a new challenge for smaller clients who aren’t already using ADFS for other applications
– A standard ADFS installation is not all that secure and several steps should be taken to ensure good security. Microsoft provides these best practices recommendations:
There is also a great free e-book published by Microsoft about claims-based identity and access control:
To find out more about ADFS and how it can impact your organization, join our webinars or contact us.

Upcoming Events December 2018

It’s nearing the end of 2018 and the Infor Lawson Community has had quite the events! We’re finishing off the year with the final events in December below. Be sure to make some room for all the events happening next year. See you in 2019!


MRLUG Winter Single Day Meeting

Hosted by: Metropolitan Regional Lawson User Group
When: Wednesday, December 5th, 2018 from 8:00 to 3:30 (US/Eastern)
Location: Hilton Garden Inn Edison/Raritan Center 50 Raritan Center Parkway EdisonNew Jersey08837

Registration will Close on December 3rd!

Use this link for Vendors Vendor registration only

MRLUG Winter Single Day Meeting

December 5, 2018

Online registration $125.00 to attend (walkins accepted only with payment)

Click Here for the Agenda as of 11/26/2018

Version 10 sessions and discussions on how to get to version 11

Also we will provide a list of all the new version 10 reports and cloudsuite 11 reports. ACA and ADFS updates

We have to give away all of our inventory of previous gifts as our name will change next year so come and win a gift! towels umbrellas mugs swell bottles.

Hilton Garden Inn Edison

Rooms are available in a MRLUG block at $159 per night plus sales and occupancy taxes. Reservations are required to be completed prior to 11/15/18.

MRLUG Committee –

John Papas, Donnell Perkins, Maryellen O’Connor, Karen Sickler

Host a Session or Birds of a feather – John Papas

General questions: Donnell Perkins – 718 230-2126; Karen or any committee member

Questions about registration or the site – Loring Kaveney <>

Invoicing –  Maryellen.O’ –  Karen Sickler

Directions/Transportation – John Papas –

*Be sure to create a profile on our website to receive future notifications*

We are raffling off 2 Echo Shows and 2 echo spots. Plus many more…..



Great Lakes Winter 2018 Meeting

Hosted by: Great Lakes User Group
: Friday, December 7th, 2018 from 8:00 to 5:00 (US/Central)

Great Lakes Winter 2018 Meeting

We no longer have an annual membership fee so that each meeting will stand on its own/ You will only pay for those who actually attend each meeting. We hope this will make it even more accessible for others in your organization to attend.

The cost for this meeting is $75 per registered attendee. You can still come even if you haven’t pre-registered, but the cost for walk-ins will be $100 at the door.

Cancellation Policy: Full refund if done 10 days before the event.

Preferred Payment: Credit Card. Checks can be sent for this meeting if done in time to be received before the meeting.

Check instructions: Send checks to Great Lakes User Group Attn: Kim Diehl 741 Morton St Batavia, IL 60510. Please make checks payable to “Great Lakes User Group”.

View/Register Here



See you in 2019!

User sqlplus with Lawson (Tips and Tricks)

Most of customers have by now switched over to a Windows / SQL server environment, but we still have several customers who have stayed on Oracle for their Database needs. This mostly stems from having the Oracle skill set in-house as there is really no other advantage to staying on Oracle once you have moved over to Windows.

Often when there are troubles with connecting to the application, it is relevant to test the connection the database from the server itself. Of course there are several ways to do this, but test fastest way is to do so directly from the command prompt in LID as it doesn’t require any additional setup or software. But it is easy to forget how this is done so we decided to write this quick article to document this very simple syntax.
The utility we’re going to use is called sqlplus and it should already installed on your LSF application server. Simply login to the server using LID and on the command prompt type in the following command:
sqlplus <username>/<password>@dbserverName
If you have the correct username and password, and the server is responding, you will get a SQL> prompt on which you can run any query you want. Here’s an example:
However if you type in the incorrect username:
And finally, if you have the incorrect server name or the server is not responding, the prompt will be suspended for several seconds and you will see the following message:
A few small notes about using sqlplus:
  • Be sure to use a semicolon to end your statements. Otherwise the application doesn’t know when to run your query.
  • Make sure the environment variable %ORACLE_HOME% is set correctly. ($ORACLE_HOME on Unix):
  • To exit sqlplus user the “quit” command
  • The SQL buffer contains the last statement you ran, and you can run the previous query again by simply typing “RUN”  and hitting enter.
  • User the LIST command to see a list of your most recently executed SQL commands.
  • “HELP INDEX” shows a list of possible commands
  • To launch a sql script simply put the “@” symbol in front of the file name and execute it. like: @script.sql or even @/path/to/script.sql
  • You can have a multi-line sql statement.
  • The “SHOW USER” command prints the name of the Oracle user you’re logged in as
  • The “SHOW ALL” command prints all the current settings to the screen.

Upcoming Events November 2018

Mark your calendars – there’s a whole lot of events this month in the Lawson User Group Community!


Infor Mid-Atlantic User Group Fall Members Meeting

Hosted by: Infor Mid-Atlantic User Group
When: Friday, November 2nd, 2018 from 9:00 to 3:30 (US/Eastern)


9:00am – 10:00am Registration

10:00am – 10:15am Opening Remarks/Vendor introductions

10:15am – 11:00am

General Session 1:
Infor Concierge – Your one place for all things Infor – Toni Kennedy, Director Client Experience, Infor. Remote session. Join this session to learn about an exciting new tool that will become your one place to go for everything Infor. The all-new Infor Concierge Portal is individually tailored for each customer, proactively delivering everything you need to know about your Infor services and solutions. You’ll have access to updates on support incidents, quick view and voting on product enhancements, dates for recommended classes, information on product-specific education classes and webinars, details on upgrades needed for the products you own, and much more. Designed in conjunction with the Infor Customer Experience Board, the Infor Concierge Portal will make it easier for you to find answers and help maximize the value of your Infor investment.

11:00am – 11:15am Break: Networking with Vendors

11:15am – 12:00pm

General Session 2:
Birst: Next Generation BI and Analytics now on Infor – David Lomelin, Solution Consultant, Infor. In Person/Live session. Meet Birst, the analyst top-ranked Cloud BI & Analytics platform, whose patented technology is helping businesses become more data driven. Learn how leading companies are using Birst’s groundbreaking Networked BI approach to leapfrog competitors and drive real business results. This session will include an overview of how Birst integrates with Infor products.

12:00pm – 12:45pm Lunch

12:45pm – 1:00pm Door Prize Drawings

1:00pm – 2:30pm Concurrent Breakout Presentations:

Finance Breakout:
Procure-to-Pay Automation Powered by MHC and Infor FSM – Kyle Hartung, Account Executive, MHC. MHC Software augments Infor CloudSuite Financials & Supply Management (CloudSuite FSM) procure-to-pay automation processes to improve visibility, streamline processing and promote effective communication across departments, customers and vendors. Attend this session to learn how MHC Software, the automation solution provider with the most live Infor CloudSuite FSM implementations, can help your organization maximize your level of procure-to-pay automation with Infor CloudSuite FSM. In this session, we will demonstrate the benefits of ERP-integrated procure-to-pay (P2P) solutions, including accounts payable (AP) invoice automation powered by Optical Character Recognition (OCR) technology and how MHC’s solutions augment functionality across the P2P cycle for CloudSuite FSM customers.

Inforum Debrief and 2019 Strategy Session: Cindy Zeni

HR Breakout:
The Future of HCM Reporting & Analytics – Mary Pat Brennan, Principal-Development, Infor. Reports seldom give you the answer you need, in the time you need it. Find out how the linkage of data with CloudSuite HCM can directly improve development, enhance performance, manage effective and engaged teams, and directly increase your bottom line.

Inforum Debrief and 2019 Strategy Session: Deedre Day

Technical Breakout:
CloudSuite Financials & Supply Management – Hans Mueller, Senior Product Manager, Infor. Remote session. We will discuss the upgrade options, tooling and methodologies available to existing Lawson customers to adopt CloudSuite Financials & Supply Management 11 (and Global HR/TM 11). We will cover release status, deployment options, upgrade options and how they differ from previous Lawson upgrades, and implementation methodologies and considerations.

Inforum Debrief and 2019 Strategy Session: Kofi Anim



TNLUG Fall 2018 Meeting

The meeting is scheduled for Tuesday, October 30th in Columbus at the DoubleTree by Hilton Columbus/Worthington.

Hosted by: Tennessee Lawson User Group
: Friday, November 2nd, 2018 from 7:30 to 4:00 (US/Central)
Location: HCA Healthcare
2515 Park Plaza
Building 2
Nashville, TN 37203

This meeting is free to users to attend. Special thanks to HCA Healthcare and to our sponsors for making this happen.


Click Here to view the Agenda.

Hotel List

Click Here to dowload the list of nearyby hotels.

View/Register Here



Keystone Fall Meeting

Hosted by: Keystone Lawson User Group
: Wednesday, November 14th, 2018 from 8:00 to 5:00 (US/Central)
Location: Holiday Inn
604 Station Road
Grantville, PA 17028


This year’s Keystone Lawson User Group Fall Meeting will take place on November 14th, starting at 8am, 604 Station Rd, Grantville, PA 17028. Join us for a day packed with informative sessions for only $35.00.  This is going to be a great opportunity mix with your colleagues and friends for education, networking, and fun.

The Keystone Lawson User Group Mission

The Keystone Lawson Users Group (KLUG) is an independent member-led group that provides a forum to collaborate with other Infor/Lawson users and subject matter experts. KLUG partners with Infor/Lawson as well as industry leaders in consulting and technology solutions to educate, inspire and implement solutions to common business problems. Meetings are held bi-annually and provide members with insight into hot and trending products, tools and technology related to the Infor/Lawson systems.

Main Contact:

Bill Spolitback
IT Manager, Enterprise Systems
Penn State Health

View/Register Here



MWLUG Fall 2018 Meeting

Hosted by: Midwest Lawson User Group
: Thursday, November 15th, 2018 from 8:00 to 5:00 (US/Central)
Location: HealthPartners
8170 33rd Avenue South

MWLUG Fall 2018 Meeting
HealthPartners in Bloomington on Thursday, November 15th!

Join the Midwest Lawson User Group for our 2018 Fall Meeting

There will be Special Interest Group (SIG) breakouts by functional area in the morning, then Technical, Human Capital Management, Enterprise Financial Management and Supply Chain Management breakout sessions in the afternoon.

Plenty of great prizes to award at the conclusion of the meeting!


Cap off your day by joining us for a networking reception following the meeting at HealthPartners. Join your peers, vendors and Infor Lawson employees as we continue discussion on Infor Lawson in a relaxed, fun atmosphere.

View/Register Here



Georgia Alabama Fall Meeting

Hosted by: Georgia Alabama Lawson User Group
: Friday, November 16th, 2018 from 8:30 to 3:00 (US/Central)
Location: 665 Duluth Highway, Lawrenceville, GA 30046

Registration is NOW Open

Georgia Alabama Summer Meeting, November 16th, 2018

665 Duluth Highway, Lawrenceville, GA 30046

Free to Attend

Vendors – Please contact Kim Walker, if your company is interested in sponsoring for this meeting.

View/Register Here

Upcoming Events October 2018

It’s Fall and the Infor Lawson Community is getting ready for the last quarter of the year with user meetings. Mark your calendars!


KMLUG Fall Virtual Meeting

Hosted by: Kansas Missouri Lawson User Group
When: Thursday, October 18th, 2018 from 12:00 to 1:00 (US/Central)

Save the Date for the KMLUG Fall Virtual Meeting
Don’t delay, register today for the upcoming KS/MO Virtual User Group Meeting on Thursday, October 18.


Lawson Mid-America User Group meeting

The meeting is scheduled for Tuesday, October 30th in Columbus at the DoubleTree by Hilton Columbus/Worthington.

When: Tuesday, October 30th, 2018 from 8:00 to 5:00 (US/Central)
Location: Columbus, OH
DoubleTree by Hilton, Columbus/Worthington
175 Hutchinson Ave
Columbus, OH 43235

AGENDA as of September 25th, 2018

Hotel Web Site:

Rooms are available for $128.08 per night tax included.

Cost to Attend: $25.00

View/Register Here

How to test your SOAP Web Service calls using Postman

If you have worked with Web Services you can appreciate the ability to test your web service calls quickly and efficiently without a lot of programming. This is exactly what Postman was meant for. When you’re building SOAP service calls with IPA it can really make your life a lot easier if you have this particular skill and tool.
The secret sauce here is how you form the actual request. Just follow these steps:
  1. Set the method to POST
  2. Paste your URL in the “Enter request URL” field.
  3. Click the “Params” button and enter any parameters you may have. If you’re using IPA you probably don’t have any parameters to enter here and they’re all included in the body of your request.
  4. Click the Authorization tab and enter your authorization information. If you have user / password this is likely “Basic Authentication”
  5. Click the “Body” tab.
    • Select “raw”
    • From the drop-down on the right select “XML (text/xml)”
    • Paste your entire soap envelope into the body text area
  6. Click Send
That should do it. You’l be able to see the status code (200 OK as shown below) and the time it takes to make the call (570 ms below)
Then in the body of your response you can see what the request returns which is pretty great to see if you’re trying to get a feel for what you’re dealing with.

Upcoming Events June 2018

The Infor Community is kicking off the summer with exciting user meetings for June 2018. Check them out below!


SWUG Lawson User Group Mega Meeting

Hosted by: Southwest Lawson User Group
When: June 14 – June 15 2018
Where: Grapevine Convention Center
1209 South Main Street
Grapevine, TX 76051

Join Infor employees, certified business partners, vendors and hundreds of your colleagues from companies across the southwest for a two days of learning, sharing, networking and fun.

The Southwest Lawson User Group Mega Meeting will be held at the Grapevine Convention Center, Grapevine, Texas.

Agenda: As of May 1st

If your company is not a member become one today:

More details to follow


View/Register Here



Georgia Alabama Summer Meeting

Hosted by: Georgia Alabama Lawson User Group
When: Friday, June 22, 2018
Where: 665 Duluth Highway, Lawrenceville, GA 30046

Georgia Alabama Summer Meeting, June 22, 2018

Infor Clients and Employees – Please register to help us accordingly plan and pay the $15 meal fee.

Vendors –  Please contact Kim Walker, if your company is interested in sponsoring for this meeting.

If you would like to print the agenda, please select this link here.

View/Register Here



16th Annual MWLUG Summer Conference

Hosted by: Midwest Lawson User Group
Wednesday June 27th and Thursday June 28th, 2018 featuring an IPA Symposium on Tuesday June 26th
Where: St. Olaf College
1520 St. Olaf Ave
Northfield, MN 55057

View/Register Here

How to Secure a User’s Lawson Report Writer Access

Common Problem: User XXXXXX does not have update authority for folder XXXXX

This is an error you may run into when a user doesn’t have report writer permissions to add to a folder.

To resolve this, follow the example below:


This will take you to RW03.1 (you can also go directly to RW03.1 if you know the user class name)


Once you have the user class selected, set FC to A, add your users ID, set flags and press change. If list is full, press Page Down key.