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.

Using Lawson and Big Data to Improve outcomes and reduce Employee Attrition

During this 50 minute webinar, hear from Big Data experts how your Lawson (and other data) can be used to improve outcomes and reduce employee attrition. The webinar will cover other big data related topics as well and there will be industry examples to suit all audiences. Some of the topics covered include:

What is Big Data?
    + How does it differ from BI?
    + How does it apply to your Lawson data?
    + What is possible? Examples and use cases
    + How and where to begin?


Upcoming Events May 2018

Mark your calendars for these upcoming user meetings for May 2018.


Canadian Lawson User Exchange Meeting

Hosted by: Canadian Lawson User Group (CLUE)
hen: Friday, May 4, 2018
Time: 8:00 AM – 5:00 PM CST

**Event registration fees for the first two attendees from any member company is included in your annual membership fee.   Additional attendees are welcome to participate at a cost of $25 per person.   Please bring payment to registration.**

For questions or concerns about your event registration, please contact

View/Register Here



NELUG 2018 Spring Virtual Meeting

Hosted by: Northeast Lawson User Group (NELUG)

Please Save the Date

NELUG 2018 Spring Virtual Meeting

Wednesday May 16th, 2018

12:00PM to 6:00PM (US/Eastern)

Topics of interest to all Infor Lawson areas will be offered during this special event.

No travel, No hotel fees & No conference fees.

Participate in this conference without leaving your office.

The agenda & other details will be available in the near future.

Current NELUG Board:

View/Register Here



MRLUG Spring 2018 Meeting

When: Thursday May 17th. 2018
Where: Infor Headquarters
641 Avenue of the Americas
New York, NY 10011
Agenda: As of March 20, 2018
Cost: Low price of $89

Please Note: There are limited seats for this meeting.. Also, due to security no walk in registrations will be accepted and registration will close on May 15th, 2018

Hotel Information Click Here

View/Register Here



ROMLUG May 18, 2018 – Comfort Suites, Highlands Ranch

Hosted by: Rocky Mountain Lawson User Group – Tentative Agenda
Where: 7060 East County Line Rd. Highlands Ranch (Comfort Suites – DTC
When: Friday, May 18th, 2018

Tentative Agenda

8:00 – 8:30 – Breakfast/ Introductions

8:30 – 9:30 – Cendien –

9:30 – 10:05 – INFOR Update – Carol Tyler

10:05 – 11:05 – Team Absolute (Kelsey)

11:10 – 11:55 – Session 1: LandMark Security – Del Dehn

12:00 – 1:00 – Lunch and Networking

1:05 – 2:00 – Session 2: Configuration Console – Del Dehn

2:15 – 3:00 – Board Elections

3:00 – 4:00 – LGUG Update & Winter Showcase Highlights

4:00 – 4:10 – Wrap up and Dismiss

Thank you to the following companies: Bails, Cendien, Kinsey, TEAMabsolute

View/Register Here



TNLUG Spring 2018 Meeting

Hosted by: Tennessee Lawson User Group
Friday May 18, 2018
Where: Dollar General
100 Mission Ridge
Goodlettsville, TN 37072
Cost: This meeting is free to users to attend. Special thanks to Dollar General and to our sponsors for making this happen.

AGENDA as of April 25th

View/Register Here

Nogalis Webinar: Using Lawson and Big Data to Improve outcomes and reduce Employee Attrition (May 3rd, 11 AM PST)

During this 50 minute webinar, hear from Big Data experts how your Lawson (and other data) can be used to improve outcomes and reduce employee attrition. The webinar will cover other big data related topics as well and there will be industry examples to suit all audiences. Some of the topics covered include:

What is Big Data?
+ How does it differ from BI?
+ How does it apply to your Lawson data?
+ What is possible? Examples and use cases
+ How and where to begin?


We use anymeeting for our webinars. The application sometimes asks you to install a plugin. In order to be ready on time. Please give yourself an additional 10 minutes before the webinar begins.

When: Thursday May 3, 2018

11:00 AM to 12:00 PM PST

This webinar is free to attend. Register Now