May 2023 Minimize
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
“I realized when you look at your mother, you are looking at the purest love you will ever know.” -- Mitch Albom
Trending Topics
How to link REQ # to PO# in Lawson Tables
We have a report to run for a specific company and cost center. The report needs to contain REQ# and PO#. Which table(s) will obtain this information? Is there a current PO table that contains REQ# ? We've tried REQLINE AND PORECLINE along with REQHEADER but are unable to link to get a PO#. 
Best way to run reports in Lawson
What is the best way to run a report in Lawson? other than Add-ins?
Company switching Banks for Direct Deposit
Our company is switching banks for Direct Deposit. We are trying to do the setup for the new bank, and we are running into some difficulty. The record on the BANKACCT table looks fine, but PRSYSTEM has a new record for the new bank that is missing the Process Level, and some columns have value that are starkly different from the old records. What are we doing wrong? What should the right order of the set-up be? Any help would be greatly appreciated.
Special spend as a % of total spend?
We recently had a presentation by a vendor who analyzed our PO History and showed a large percentage of our spend was due to items ordered as a special. This was somewhat concerning but I could see justification for it in a way (most of the specials were rare, high-cost items, such as a certain size screw, plates, etc.). I was wondering, could anyone kind of give me a ballpark of what your % special spend is compared to overall spend?
Worthwhile Reading
CFO Priorities This Year: Rethinking the Finance Function
Evaluating finance function strategy scope and design is currently the top priority for chief financial officers, followed by planning and sequencing finance transformation activities.
Information Week, March 21, 2023
What an IT career will look like in 5 years
By 2028, IT pros will be versed in collaborating with AI colleagues while flexing business acumen on dispersed skills-based cross-functional teams, with an eye toward the next gig, IT futurists say.
CIO, March 16. 2022
How to Prepare Your IT Organization for a Possible Recession
The jury is still out on whether or not the global economy is headed toward a recession, yet it's never too early to begin developing a contingency plan.
Information Week, March 8, 2023
Thanks for your continued support of the LawsonGuru Letter and

John Henley
Decision Analytics
© Copyright 2022, Decision Analytics. All rights reserved.

Please share The LawsonGuru Letter in whole or in part as long as copyright and attribution are always included. 

Lawson® is a registered trademark of Lawson Software, Inc.
The LawsonGuru Letter is neither affiliated with nor sponsored by Lawson Software, Inc.  
Lawson Software, Inc. is not responsible for the content of this information.