July 2018 Minimize
LawsonGuru Letter
July 2018
Thought-Provoking Commentary for the Lawson Software Community

Welcome to the latest issue of The LawsonGuru Letter, a free newsletter providing provocative commentary on issues important to the Lawson Software community. The LawsonGuru Letter is published by--and is solely the opinion of--John Henley of Decision Analytics.
Quote of the Issue
"The man who reads nothing at all is better educated than the man who reads nothing but newspapers."
-- Thomas Jefferson
In This Issue
Mass Upload New Hires into GHR
We are looking to mass upload new hires into GHR. Has anyone done this? I am thinking we need to create a process flow to upload from files submitted to us. Probably should have separate files for Employee, EmployeeContact, EmployeeAddress, WorkAssignment. Is anyone else doing this? Should we be looking at something other than process flow? Any tables that I am missing and should consider? Read more
Mfg # to Lawson #
How do I look up to see if a Lawson # exists when given the manufacturer number without running a full item master report? Read more
Company Match on DC Plans
We decided for 2018 that we would start showing the company match on DC plans on our biweekly employee checks/vouchers. So, we set it all up nicely except we missed the maximum dollar amount on the company match on BN19.3. And, therefore, we missed the Balance Type & Balance Amount populating on the PR14. We also found several instances of the same PR14 record for the match (same effective date, deduction, and no end date). We discovered all of this when we had some bonuses paid out at the beginning of March and people went over the max company match...or didn't have the company match made at all. So, we went for four pay periods before we noticed we had a problem. We've attempted to fix but ended up doing a TON of manual work to ensure yesterday's payroll processing calculated everyone correctly. Needless to say, we don't want to do that again so I'm reaching out for help Read more
Identifying Nested Groups in HR55
Does anyone have a simple way to identify when nested groups exist within an HR55.3 definition? I want to run a simple SQL query to ID when one group is part of the definition of another group in order to identify how many iterations of the HR155 would need to be run to capture changes made to the nested group. Read more
Worthwhile Reading
How to lead a virtual team: 5 keys for success
You've got the tools, you've navigated the logistical hurdles, but you still may not be leading your remote team in the most effective way possible. Here's how to get virtual teams right.
CIO, May 31, 2018
Read more

How to Be the Global IT Executive
IT managers who can adapt their personal styles to the needs of local cultures and employees are best positioned to succeed in the global arena.
Information Week, May 31, 2018
Read more

Emory Healthcare to launch technology innovation hub
Atlanta's Emory Healthcare is launching an innovation hub to develop, test and implement technology solutions designed to minimize cost burdens for both patients and providers, while improving health outcomes.
Information Management, May 29, 2018
Read more
Thanks for your continued support of the LawsonGuru Letter and LawsonGuru.com.


John Henley
Decision Analytics