Archive for category: News

When William Lawson, Richard Lawson, and John Cerullo founded Lawson Software in Minneapolis in 1975 they probably had no idea it would serve customers for nearly 1/2 a century. It has been a very impressive run that has created entire communities along the way. Whether you have been a user, an implementer, or somehow otherwise involved in the ecosystem, you have no doubt felt like you have been part of a community. As a consultant who started out with the Summit Group back in 1999 and later worked directly for Lawson software I have spent nearly every workday of the past 22 years working with Lawson. It is bittersweet therefore to be talking about this subject of decommissioning this brilliant application. With more and more customers migrating to CloudSuite applications and other ERP systems over the next few years, it makes sense now more than ever to begin planning the proper way to decommission the Lawson application.

Follow this step-by-step guide to set up a Lawson deljobhst recurring job. This will keep your Lawson print/job directories clean.

1. Login to LID (elevated admin rights required)
   
2. Go to jobdef and create a new deljobhst job
3. Down arrow to Form ID >> F4
4. Type >> F4 >> Universe >> Enter
5. Data Area/ID >> F4 >> JOBSCHED >> Enter
6. Down arrow to deljobhst >> Enter
   
7. F6 >> A. Step Parameter
   
8. Type the parameter letters you want without a dash, for this example we are just deleting old %LAWDIR%\print directory files using the r parameter and for any files > 400 days old
   
9. To Date must be in the above format of: ‘curdate’ – NumberOfDays
   1. When the job runs on schedule, files greater than and equal to the date 400 days ago from current date will be deleted.
   2. 400 day example: Todays date is 6/7/2021 so print files as created on 5/3/2021 and older will be deleted.
10. Press Enter to save jobdef and go to recdef in LID
11. Create a new recdef entry and select the job you just created under Job Name. Select all other parameters as you normally would.
12. Example below: This job will run daily at 1:33pm starting 6/7/2021
    

That’s it and good luck.

It is pretty common for a Lawson recurring job to error out and continually run for hours and days. This can build up in the waiting screen of the job scheduler (jobschd). To clean it up can be repetitive when it doesn’t have to be.

1. Login to LID
2. Go to the job scheduler by typing the jobschd command
3. F7 >> A. to show all user jobs
   • In our example we have 7 jobs, but this method works for hundreds of jobs.
4. On the top most job that you want to delete press the HOME key to “mark” the job. Notice the black arrow on the very left
   
5. Now scroll down or even page down to the bottom most record >> Press the END key. Notice all jobs from the top to bottom have the black arrow on the left, indicating these are selected.
   
6. Now press F9 (Delete) to remove these jobs. Press enter to confirm.
   • NOTE: if there are dozens or hundreds of jobs, you may need to hold Enter to continuosly delete them.

Hope this was helpful!

LBI Smart Notifications are reports that are sent directly to users for reviewing vs a user logging into LBI to manually view a report. In this section we will first start off with an Intro to creating a Smart Notification. See Part 1 titled: “Creating an LBI Smart Notification Series – Creating an InfoSet (Part 1)”

1. Login into LBI (admin permission required) >> go to Tools >> Select Smart Notification
2. In Smart Notification, select Notifications at the top
   • If you have none, it’ll say No Selections (see screenshot), else you’ll notice a list of existing Notifications
     
3. To create a new Smart Note, click Add
   
   
4. Smart Notification Wizard will pop-up and starts at step 1 (Select Facts)
   
   • The Facts section is where you would connect the dataset (or InfoSet) to the notification (this can also be a document among varios other types of data).
   • An InfoSet is most commonly an SQL query or stored Proc that gathers data from a database.
5. For this example, we will assume you have an InfoSet already created. View your InfoSets by clicking Search
   
   
6. For our example we will be selecting the MonlthyVariance InfoSet and then select Range
   
7. At the bottom of the next page choose Select >> Add >> Ok at the very bottom
   
   
8. At the bottom under My Selections you should now see your InfoSet for step 1
   
9. Now click Next or select step 2 Conditions
   • Conditions can be added with the Add button. This lets you tailor the data to your liking. This can also be done on the InfoSet side when writing a query or stored proc.
10. Click Next again or select step 3 Delivery
    • Delivery typically is done through the Device tab which are setup email addresses in Smart Notes (See article titled “How to setup a LBI smart note delivery device”)
    • The Bursting tab is the alternate method. In the Bursting tab select the InfoSet, and the column to burst on which is typically a list of email addresses.
    • Schedule tab is similar to Device, except on a schedule which can be set elsewhere for the Notification.
11. Click Next again or select Step 4 Related Info
    • Related Info lets you link other LBI reports, shared documents, deploy in a pre-made formatted template among other customizations. This may be covered in more depth in a future article.
12. Click Next again or select Step 5 Save
    • This is where you Name, describe, set Home Page Group for your Notification.
    • You can also Preview, set Status, and add additional Permissions if needed.
13. Click Save New Item to create your new notification and view it in the Notifications Tab.

Hope this was helpful! Good luck!