I saw an answer to this question on another board a few years ago.. but now I need to revisit it. I want to run a daily HR155 job and the History Date is a required field. If I set up the job in jobdef and then recdef I will need to hand key in a static History Date. How can I set it up so that for each day I run the job (scheduled through recdef) the job parameter screen will dynamically pick up the current system date and use that for the History Date I know this question's been...

My client is on Lawson Environment 8.0.3 and Application 8.0.3 MSP10. There are about 150 users created in Lawson. I want to know out of 150 users, how many of them have logged on to Lawson in the last 90 days.&160; Is there a way to find this out in Lawson &160; The client is using Portal and RD30 records exist for the users.&160; I&160;tried accesing SIRDIDHDR table in LOGAN&160;productline. This gives me the userid and date /time of creation of the user id. I am interested in the las...

We are in the process to migrate form several system to Lawson.  Can any body give me a clue of how to get the Entity-Relationship Diagram for version 9. Thanks, David.

I am trying to dump data, in a .csv file for a single customer out of ARCUSTOMER and ARCOMMENTS. What is the correct syntax if the dataid is prod9 and the key fields are company=1 and customer=4059 So far I can get it on screen but I need it in a .csv file. I have rngdbdump -c arcustomer -v company=1 customer=4059. Where do I put the name of the file I want to dump to Thanks in advance for any help.  

My company recently upgraded to Lawson 10. We used to be able to use Don Peterson's 9.3 upload template, and some users used add-ins to upload JE headers (GL40.2) and detail (GL40.1) separately (having to find the JE in the portal in between those two steps), but the old add-ins had to be replaced and the upload template relied on the old ones. So I wrote some VBA code to create a new JE upload template. It uploads the header and detail in one step, retrieving the JE and detail line 's in th...

Trying to upgrade OS for Lawson to Windows Server 2012 R2.  Microsoft SUA was deprecated in that OS release.  Is is possible to use Lawson Unix Utilities on Server 2012 R2, or are we forced to switch to using MKS Toolkit

All,   As a part of our migration activities, we will be re-installing Lawson S3 & Landmark on new servers.   Perl is a pre-requisitive software which has to be installed before we start wilt LCT.   Please advise if Perl (active Perl) is a free software OR do we need to purchase licenses.   Rgds,   Vijay

I am running Lawson 10 and running a GL240.  Once the report is completed, I convert it to a CSV file through the print manager and when I open the CSV file, about a third of the way down, the files seems to get corrupted.  Data is missing, shifted, etc.  There are about 6000 rows returned so I know I'm not reaching the row limit of Excel 2010.  Is there another simple way to convert it to a csv without it getting corrupted or is this a bug   Thank you in advance!! P...

I am running Lawson 10.  When I go into LID and enter usergrpdef to enter a User Group Definition, I add the group to the first screen successfully and then assign myself to that group.  Now I need to add the same group to a group name called ALL (All Lawson Users).  I go to the very bottom of the screen and enter the name of the group (the same name I entered in the previous screen) but I get the following error:  User Group Is Recursive Within Another Assigned User Group ...

We are running Lawson 10.  I have a task to delete a user from the Rich Client.  When I do, I receive the following error:   Cannot Delete: At Least One Associated Metrics Exists   I am assuming that there is a work unit that is waiting to be approved by this user but I cannot seem to be able to find it.  Is there a way to find out what's tied to the user so I can delete that and then the user from the Rich Client  Maybe someone can supply me a workflow or sql ...

We are in the beginning stages of upgrading to Lawson V10. Does anyone have or know of a demo site for Lawson HR/Payroll and/or ESS/MSS. I am looking for a generic demo site to give users an idea of what V10 will look like.

In the past we have set our PRTRCSV globally set the attributes for the PRTRCSV file so that job will recognize the file to have no headers and a ccyymmdd date format.  Can someone point us in the right direction  We can't remember how to do it.   Thanks.

I am looking for ideas on creating hot backup of lawson system. We are on LSF 901, AIX 6.1. For database we are doing hot backup using RMAN. But we still have to shut down application and database each night to get a clean backup of application. Now we are seeking new backup strategy in the hope of implementing hot backup of the entiire lawson system without shutting down on a daily basis. It would be highly appreciated if you could share your experience and knowledge on this. Thank yo...

We recently moved to the cloud and went from unix server to now windows server hosted by infor. Our old print commands used to work with lp but now we can only use laprint and limited to 50 character print commands. I'm not interested in writing a batch but I am curious how others are printing double sided using the laprint command. KB1194913 shows the command but it doesn't work for us in LID. If you are currently printing double sided using Lawson quick print (and on Windows platform) can you...

Hi, I am in a bit of predicament and am unsure where to go for help.  My company uses Lawson 7.2.1 on an IBM I AS/400. Our users connect via a Windows Desktop App Called Lawson Insight 7.2.1.  We are being pushed to get rid of the Citrix server hosting the desktop app as it's out of support with Microsoft, but Lawson is not compatible with Windows 7 or Higher.  What I found was the users could do most functions directly on the Green Screens, but we could not execute some comman...

Infor's response: “Enterprise is not a supported operating system for Security Administrator. You need to use Windows 7 Professional or Ultimate Edition 32-bit or64-bit” Any clues if this is true I can't imagine it to be. Thanks in advance.

I have done this in the past, but can not remember how. How do I change the character set for LID to clean up the boxes and screens

Can someone tell me more information on  the Requisition Approval Type in RQ04 - Requester form  Specifically, the values in the drop down list are as follows: - Default to Req Location 0 - Header using Approval Codes 1 - Header using Process Flow 2 - Line using Process Flow 3 - No approvals required If 3 is chosen, does this mean this Requester's Reqs will move through without approvals  Or, does 3 mean requisitions will by pass this person - they do not need to appr...

We are in iSeries platform and in version 10. One of our Lawson custom 4GL program went into Needs Recovery. When we checked the job log, we found that the print directory was automatically changed and the job went into error saying 'Pointer not set for location referenced'. The job log shows that the print directory was changed from '/LAW10P/law/print/VALLEIG/rs217/1/408938' to '/LAW10P/law/print/VALLEIG/ztrbcy/1/408938'. Also ZTRBCY (RW100 form) was a job that was run by the same user pr...

Looking to establish a discussion related to best practices related to a hosted Microsoft server configuration. Examples:  - Additional SQL server special jobs for performance. - Additional SQL Indexes added  - Rebooting Complete Lawson environment on a regular schedule. - Ticks or Trips related to CTP patching.

Ok,  Its been a while since I used Lawson 10. I am not at a company who is going to 10 from 9, and use LAUA security for many users still, and some LS.   In 10, when I turn on Lawson security in the LS application, I can go to LID as the Lawson admin login and do a lawsec status and I get a security violation.   if I turn off Lawson security in the LS application, I can then go to LID and do lawsec status and it says 'Lawson security is on'   How is this so I show it a...

I need to install JT-869845 contained in KB 1877962.  There is only a ZIP file containing one JAR file. Can someone point me to a document detailing how to do this.

We have 19 custom COBOLs in the delivered system codes.  As part of the upgrade to the Cloud, we have to create a custom system code and put our custom COBOLs into that custom system code.  I have only done this once with one COBOL.  With 19 COBOLs, I was trying to find a better way to do this.  Does someone have a method which worked well

In Infor10, how do I make the job scheduler display all users    Wanting to simulate LID's F7 (Show) then All User Names.

We are running Lawson 10.0.7.  I am working on a SQL query to identify some journal entries out of the GLTRANS table and I need to be able to show the real username instead of the operator that begins with NT00....  I cannot seem to find any SQL table that I can join to in order to provide this information in the results of the query.  Does anybody have any idea   Thank you in advance and Happy New Year!!   Allen