I need to replicate my KSH scripts from our Unix machine to our new Windows and cant seem to get it to work. I had to gut most of the syntax but I still cant get this 'basic' importdb script to work > Tokendef, etc... any help or expertise It doesnt like mypath cariable, or some of the if-then-else sytax.. Its attached in zip format...

My users want a mod to ESS. They want to add a link on the ESS page so that employees can click on it and take them to a fill-able enrollment form. I have no clue as to where to start or what to look for  in order to accomplish this. Would I need design studio for this customization  Has anyone successfully build a custom form in ESS and/or MSS

I'm looking for the table (if one exists) that I can use to look up the field name by the field number of the Personnel Action.  I know table DBHRPAD (PADICT) contains the field number and item name which is the description of the field, but it doesn't have the actual name of the field.  For example, if I look up field number 2 in DBHRPAD, the item name is 'Name - Last'.  But I need the actual name of the field 'DEMPLSTNM', not the description of the field. Is there a table that exists where...

Hello,  I am looking for ideas on how people handled the report archiving from batch run jobs.   We are Windows and SQL. Lawson Version 10.  I have searched thru the forums and looked at some of the ideas and some will work for us. I set up a custom COBOL program that can copy a prt file off to a archived location using the 'Call System Command' process.   Would anybody know if there is any doc on using the 'Call System Commands' , I looked around but could not find anything except what I foun...

I am trying to determine the feasibility for building an self-service portal on Lawson v 9.0.x atop SharePoint 2013 or SharePoint Online. I am not familiar with what web services are available, but need to know whether data can be written by Web Service or directly to DB in Lawson. Our high-level solution design is to allow end-users to modify certain fields via the user profile within SharePoint and those edits would be written back to Lawson.  So, has anyone done this and is it possible for L...

Hi, We have a framework written in .NET (C) that we've used in the past for adding and updating Lawson billing info.  The framework has allowed us to execute Transaction (AGS) and Data (DME) calls, and has worked very well. We now look to take a new hire feed from our Talent Management system, and automatically create HR11 records within Lawson. The HR11 AGS call is posing difficulties, though.  It appears that after we make the HR11 call, to form is expecting us to add tax deductions via th...

Hi Everyone, Is there a way to force 4GL output fields to be left-aligned, regardless of data type  I know this can be done for input fields, but I'm specifically wondering about output fields. Here's what my code looks like now: *------------------------------------------------------------------------------ $SCREEN    ZY912    S [ZY91]                   Jrs Leave Plan Details                          ]               |Company ;    ;         ;                              ;          ...

I am animating a custom program and got an error, which I have never seem before. I got a clean compiled and program ran ok with no errors. Anybody has an idea why I am getting the error    200     Run-Time System internal logic error - (in xenumctl.c:517257, line 703)

I copied a program that works fine in our production environment However when animating the program, I get an error due to trying to access an item beyond bounds  of memory. How do I identify an illegal character in the in /Lawdir/obj/program.int   I am not sure what that means. Any input/suggestions would be greatly appreciated.

I'm working on making some changes in MSS specifically for personnel actions. I've got things narrowed down to the pactions.htm file and after some digging through the forums realized I can pull the fld_nbr from padict for specific action types.     As I see it now, I will need to modify the function  PaintFieldsforAction in the pactions.htm file for each action they want to load new default values for.   For example, if the action is term, default the new value of status code to be X if p...

Hi All, We are on LSF 9.0.1.11.  Sometime in the past, we created a custom index on HRHISTORY (HRHSET99) that has 'Key Change = No'.  We recently identified an error with a delivered program that was attempting update HRHISTORY and found that the error was because it is trying to change a field that is included in our custom index. Since the index is only used by one program, and is only used for query (not update), can I just change the index to 'Key Change = Yes' and then recompile the progr...

We have custom javascript code in the AP20.1, AP20.2 and AP20.6 forms that alerts the user to ensure that the HOLD_CODE and REMIT_CODE are keyed in for certain AP Companies. This part works well, but somehow the code introduced yet another pop-up window that is not desired and it is unnecessarily increasing key-strokes for the users. It simply says has the text 'EXP', and the 'OK' button. It is not an error message and does not stop the process, but pops up whenever the ADD or CHANGE function is...

I have a custom 4GL program that has been migrated over into a new version 10 environment.  When performing a parallel comparison, the new 10 version is not listing the Company Name in the job submission parameters section.  I've tried running a new rptgen; but that hasn't helped. Any suggestions would be appreciated......

Hi all,  I have created a custom application with a custom database table using CASE (for the first time) to quick paint the form.  Pretty simple table and form... it has company, employee, a location code, a sequence number, and start and stop dates.  I have set it up similar to HR11, so when you search for or enter an employee number, company, or location there is a text field with key number defined that will show the employee name, company name, and location description.  If I enter the valu...

We are a Windows environment and are in the process of upgrading our systems from 9.0.1 to version 10.  While migrating some of our custom programs into the 10env; we discovered that some of the version numbers in our 9.0.1 system are higher than the version numbers in the delivered 10.0 programs.  We would like to obtain a list of the current programs and their assigned version numbers for a comparison between the systems.  Have others seen this  How did you handle it  If you had a custom pro...

We created a COBOL program with multiple reports.  We can see the reports in the print directory but only the first report is in print manager.  How do you get the other report(s) in print manager

Standard Lawson 4GL/COBOL Portal transactions programs can be Add-Ins driven. This is a very powerful tool to be used for mass data update. If someone develops an HTML/JAVA Portal transaction, is there any tool that can be used to mimic Add-Ins for that transaction Such that it could be used for mass updating I would think that fully conversational program interaction would be an issue, but beyond that Are there any other considerations when there is a choice of using Lawson 4GL/COBOL or HTML...

Any guess, which GEN table store's recurring job definition

Hi All, It seems like I've done this before, but I can't remember how to do it.  I have a string field that may or may not be numeric.  How do I determine if it is numeric so I can redefine it and output the numeric value  When I try just redefining the string as numeric in the WS, it returns the numeric as empty and throws the 'Illegal character in numeric field' error when I try to reference it. Thanks!  Kelly

I am trying to redirect my.XXXX.com URL to Mignle and I am getting Error , Please let me know if we ca do this

I’m working with ESS page leavebalances.htm and trying to do some math on numeric values returned from a DME call:     function getTaemptrans() {     var obj = new DMEObject(authUser.prodline, 'taemptrans');     obj.out = 'JAVASCRIPT';     obj.index = 'ttrset1';     obj.field = 'company;employee;plan;ta-hours';     obj.key = authUser.company'='Employee;     obj.debug = false;     obj.otmmax = '1';     obj.select = 'status;     obj.max = '600'; ...

Hello, we are in the process of upgrading from Lawson MSP 9.1 to MSP 9.11. We have some custom code that I need to put back in vendor's programs. I am having a problem when copying the code, it doesn't rename the work files so it keeps the vendor's work file name. So I have a program that has like 6 works file that I need to copy and it can be so tedious. Is there an easy way to copy the work file definitions

Hello, we are in the process of upgrading from Lawson MSP 9.1 to MSP 9.11. What would be the easiest way to copy a program with all the wfd and libraries I did a program copy and it did not copy any of the wfd or libraries so I am getting a compiling error.

Dear All,   What is the best way to add spaces in a Header for a CSV file which is generated via a Lawson 4GL batch program while using 800-WRITECSV-. I also need to add a field 'Debit/Credit Separator' in the file with spaces and '/'. what is the best and simple way to achieve this. CSV files doesn't take spaces and '/' when defining it in workdef.        Thanks  Vijay

Hi Everyone, I have a 4GL custom program that includes a work file with lots of fields.  I want to create a secondary report for the job based on the work file (so it shows in Print Manager), but there are more columns than will fit on the print report. I really would prefer to include only a couple of rows on the print report, but have all the columns show on the csv version of the report. I've tried adding additional fields to the report group $FIELDS section without including them in the $F...