Does anyone know how to use wildcard in DME's query For example, I'd like to search in vendor table for all records where vendor's name starts with 'SM' In Structured-Query-Language, I can enter the followed statement in a query using the percent sign () as wildcard to get the result that I wanted. 'Select vendorname From vendor Where vendorname = 'SM'' The statement above would returned all vendors where vendor's name starts with 'SM' Thanks,

We moved to a new server this summer, at the time that we upgraded to our current versions. Apps -ver 9.0.1 MSP3 Env - 9.0.1.8.221 SQL server 2008 We have a process that we created, which kicks off a script that FTPs our payroll distribution files to another sytem, outside of our firewall.  We've used this process for years, and the only issues we had were when the user changed her Lawson account password, we would have to have her come up and change the identity password in Lawson Secu...

We are looking to add customization to our Benefits Enrollment within EMSS.  A major part of this customization would include calling a process flow that would send an email to that specific staff person with a form attached.  Looking for a way to call this process flow and pass to the flow the staff person's employee id. Has anyone done something similar  Suggestions on how to accomplish this  Fairly new to JavaScript so details would help greatly!!! Thank you!

As I stated before I am new to LAWSON and have a few questions. Please excuse me if they sound dumb. I see custom defined code which looks like this: MOVE EMP-LAST-NAME          TO HRWS-LAST-NAME. MOVE EMP-FIRST-NAME         TO HRWS-FIRST-NAME. MOVE EMP-MIDDLE-INIT        TO HRWS-MIDDLE-INIT. MOVE EMP-NAME-SUFFIX        TO HRWS-NAME-SUFFIX. MOVE EMP-LAST-NAME-PRE      TO HRWS-LAST-NAME-PRE. PERFORM 750-HR-FORMAT-NAME. MOVE HRWS-FORMAT-NAME       TO PR32F2-EMP-FULL-NAME as I paint...

One more question. I need to use TRDSET5 rather than TIMERECORD on my form, but when I use PAINT FORM option it brings me to the data base selection screen which lists table names only. Is there a way to switch it to use an index, or do I need to do it manually after I paint most of my form

How do I add fields to regular and detail part of a form (during the painting stage) which are not coming from data base In my case, I need to add arrays one for header and one for detail similar to the ones in PR32.

Is it possible to paint two forms (ie the key information entry small form xx99.1, and then the full header/detail form xx99.2) in the same program Or is my only option to create two different programs via painting and then merge them together

From time to time, we have had to create a new function call using vbscript (or .net) to do a AGS call on the Lawson S3 forms like RQ10.1, HR11, AP20.1, MA43, PA,  etc, in our efforts to update Lawson data from our Intranet website.   (for example, we scan incoming invoices, route them via workflow for approvals/distributions, then upload/pay them via ags calls)  So, from to time, I have needed help on trying to figure out the weirdness of forms (example: RQ10.2).  However, it can be hard to...

Is there a trick to shrinking a field that appears on a form without doing a burdensome field redefining and moving In my case it's a numeric fields, but I can already see a request for an alpha field, too.

When you run the set command you see a variable USERPROFILE set - does anyone know why this variable would be returning a different value based on running from Windows Server via dos prompt and LID From dos on server: USERPROFILE=C:\Users\cpaine From LID: USERPROFILE=C:\Windows\system32\config\systemprofile And does anyone know how to force this value to be: USERPROFILE=C:\Users\Default and make it stay

I am just getting back into Lawson Development and I used to have a API listing that had inputs/outputs along with a definition of what it does.  I no longer have it and would like to get my hands on one.  Does anyone have anything like that I am working on a user exit for PA52 and all the fields on the screen are Alpha.  I need to convert them to numeric to compute.  Any help is appreciated. Thanks, Carrie Schoonover

We are upgrding to version 10 and want to carry over customizations added to RQC version 9. Does anyone know if directories and files stay the same  Where can I get a list of RQC directories and files  Lawson RQC v10 Install Guide is useless. Thanks.

I have been reviewing discussions in here in regard to Lawson AD and Windows AD and how Lawson really doesn't use AD (although it thinks it does) I am wondering if anyone has taken the time to write a script that looks at Windows AD and the end-users password expiration date to trigger an email to the end-user to use the useratts.htm link to re-sink their environment password I saw writing about configuring a bookmark with the link but I like behind the scenes automation. Our users don't alw...

Can anyone share an example of a html page that will live in Lawson portal that takes some User Input and updates a Lawson table We need to gather some data into Lawson for a new table that I have created. Thank you.

We are doing some development on our LSF v9 Portal and EMSS pages, and it would be handy to be able to proxy as another user - from a UI (rather than security) standpoint.  It seems to me that there is a way to do this by adding a url parameter, but I can't remember for sure. This may be related Portal or EMSS or both. Can anyone point me in the right direction Thanks!  Kelly

Benefits wants to change the button label from 'make Changes' to Continue. The bensummary.htm has the label but I have no idea how to change it. It looks like it's searching for the phrase in a file but not sure how to find the location of the file/script. Any help would be greatly appreciated! Here is the code:  html=uiButton(getSeaPhrase('MAKE_CHANGES','BEN'),'parent.no();return false', 'margin-top:10px') if(parent.errorPlans.length==0 && (parent.errorGroups.length==0 || !parent.verifyPla...

Hello, I am looking in the docs for Developers API only found for online programs. Is there a Lawson batch program you can point me to so I can see sample code to find a previous record. I am trying to find a record in HRHISTORY and then get the previous record. Thanks in advance for your time.

We have Employee Manager Self Service with LSF9 security.  We have set up security so that users cannot change their own information -- they can view it through ESS, but they have to go through our HR department to change or add anything.  This is just the policy we have at the company.  Unfortunately, the users still see the 'Add' and 'Update' buttons in ESS, such as the Add button on the 'Dependents' and 'Certifications' page, or the 'Update' button on the 'Home Address' page. Is there any wa...

I’ve trying to create a mobile inbasket display exec html file using the example provided by Lawson.  The example displays requisitions, I want to display purchase orders.   We’re on environment 9.0.12.   The example has a function that makes a DME call to retrieve a requisition header, a second function that retrieves requisition lines, and a third that constructs html code using data retrieved in the first two functions, and writes it using mainFrame1.document.write().   The example as i...

Is table relationship data available after performing a COBOL find   For example, if I do an 840-FIND-EMPSET1, is there a way to retrieve data from a related table (i.e PAEMPLOYEE) without having to do an 840-FIND-PAESET1  Something like EMP-PAEMPLOYEE-PEM-LOCAT-CODE I don't think this is possible, but I'd be very happy to be wrong. Thanks! Kelly

I had no issues, then suddenly the designer will create the log in screen, I log in and the application does not give an error, and it does not initiate.   I can use the old designer still, but the size of some of my PFs really need to be able to use the eclipse version.   Has anyone had this  Do you know where on the PC there may be a log file   Thanks

I am looking to learn COBOL (again). Not sure if this is Micro Focus COBOL. I can't seem to find one in InforExtreme training courses.   Thank you

I'm not sure how to display the webpage without having to click on the link.

Is it possible to hide (not display) an employee from the ESS Org Chart based on their Process Level and Department

I have to customize AP270 so I copied the program to  new program LC270. I get compiled error because the work file definition.  I am  not sure how to change or copy the work file definition to be LC270 instead of AP270.  compiling error: Warning: Error - PrcWRKFILE(): LC2701SORT Not Found In WsGrp Warning:         Work File LC2701SORT May Not Be Defined In workdef