Search this forum:
Search
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 1 of 3123 > >>
Topics
 Replies
 Views
 Last Post
0 Replies and 330 Views prmpassed in custom Display Exec    330  0 Started by  dslough We are creating a process for an item add, where the request is coming from outside Infor and kicking off an approval IPA.  Within the approval IPA, it'll route to one person to assign a charge number, and then to procurement to assign an item description, vendor catalog, etc.  I'm trying to handle all of this within the inbasket, but since there isn't a classic workunit generated, the landmark workunit number doesn't get passed to the display exec for use in the chgvariable serlvets ...
0 330
06/19/2018 2:08 PM
0 Replies and 672 Views Add HR11 (Assignment tab) Location field to ESS    672  0 Started by  agersh Has anyone added the HR11 (Assignment tab) Location field to ESS so that an employee can select (or change) their assignment location using ESS If possible I would also need to have the Drill Select window available for the Location field in ESS.  
0 672
06/13/2017 3:47 PM
1 Replies and 5693 Views Forcing ERROR from User Exit    5693  1 Started by  ArthurThum I have an error condition that I would like the beginning USER EXIT to pass back to PA52. I am Setting CRT-ERROR-NBR = 106, CRT-ERROR-CAT ='PA52B', CRT-ERR-VAR1, CRT-ERR-VAR2 When I animate the program, as soon as the user exit exits and returns to PA52, the error variables are reset and the error is not passed along. What do I need to code to force ANY error to appear
1 5693
by  ArthurThumJump to last post
06/19/2014 11:23 PM
11 Replies and 12064 Views ESS - direct URL link to feature    12064  11 Started by  Shane Jones I&160;am trying to send associates a link that will open a lawson Self Service tool (Payroll Modeling) however, if I combine the links I do not get the entire page of ESS ....&160;&160; (the CSS gets by passed)&160; &160; THIS&160;WORKS&160;WITH&160;MISSING&160;PAGE&160;CONTENT: http://lawdev/lawson/xhrnet/paymentmodeling.htm THIS IS WHAT I WANT: First open: 'http://lawdev/lawson/portal/' Then direct here: '/lawson/xhrnet/paymentmodling.htm' Is this possible in Lawson - ES...
11 12064
by  Moe AframJump to last post
05/29/2013 12:52 PM
0 Replies and 141 Views PHP scripts  141  0 Started by  DavidV We have about 20 CGI/PHP scripts that prompt the user to upload files from their PC for processing by Infor/Lawson jobs.   I used to load PHP5 into httpd.conf and run php scripts to accommodate.  With the update to WAS to 8.5.5.x that doesn't appear to be allowed any longer through WebSphere's HTTP server.  I tried to load PHP7 an it wouldn't load.  I then tried fastCGI and that won't work either.   Has anyone been able to accomplish this with WAS/WebSpher...
0 141
05/14/2019 12:36 PM
1 Replies and 608 Views DBREORG failed: file already exists  608  1 Started by  maalimsimo   We created a new custom table thru dbdef, followed by a blddbdict, but before the dbreorg was executed we  'CREATE'd the same table in Oracle and loaded some records. Now we know we should have waited for the dbreorg. When we attempted to run the dbreorg later, we got the error message 'File already exists'. We have since 'DROP'ped the file in Oracle, but a subsequent dbreorg says 'Cannot open lock file /law1/lsf/law/test/dictlock'. How do we get around this 'lock'   My sear...
1 608
by  JimYJump to last post
04/02/2019 11:04 AM
1 Replies and 360 Views loadrpts.cfg - does anyone have any information on it?  360  1 Started by  Russell E I ran loadrpts on a Windows 2012R2 server and I received Error: loadrpts.cfg not found. Abort loading reports from      
1 360
by  SWilkinsJump to last post
03/25/2019 11:50 AM
8 Replies and 743 Views New Report Added to Custom Report Program  743  8 Started by  maalimsimo After adding a new report to an existing .rpt program, adding the $PRINTFILE XXXXX to the workdef, adding lines to OPEN OUTPUT XXXXX-FILE and CLOSE XXXXX-FILE to the PD, when I run a job I am getting the message 'Unable to Open the Output File...'. Subsequently, my attempt to write to the Print file results in a longish error message 'No XRef for RptSub(3) to iXFFRef file - write ignored....'.I probably missed a step somewhere but I am not sure what. Any ideas
8 743
by  maalimsimoJump to last post
02/01/2019 10:42 AM
4 Replies and 1283 Views Does anyone know how to run the VisualCOBOL debugger on a remote machine?  1283  4 Started by  Russell E Does anyone know how to do the setup to debug batch programs on a remote server.  We are on Windows 2012 R2 servers.  I was able to get the cobdebugremote64 running and I do see Connection with established and closed when done.  What is happening is a have been getting MFRUN.gnt not found.  This is not the program that is being debugged. Can anyone help
4 1283
by  RandallJump to last post
01/25/2019 12:31 PM
2 Replies and 1172 Views 508 file type  1172  2 Started by  Russell E What is this file used for  It looks like the 508 files have the token, field number (from the xml), field name, current label and new label. I can't find any documentation on this type of file.
2 1172
by  Russell EJump to last post
07/10/2018 4:18 PM
2 Replies and 729 Views Calling perl script from Cobol program  729  2 Started by  maalimsimo I have developed a perl script that  calls (and passes parameters) to a Sql script to create a report from Lawson tables. Now, I need to call this perl script from some basic Cobol program to pass parameters to the perl script (example Company, Date Range, etc). I have done this at a past job many years in the past but I am unable to get help from there. I know that we had a custom pdlib and wslib files to do this. The pdlib basically had a 'Call 'system' using .....' statement', which...
2 729
by  maalimsimoJump to last post
06/12/2018 12:46 PM
1 Replies and 2164 Views Customizing PR195  2164  1 Started by  PD The PR195 report (csv) has almost everything that I need except PayType. I am sure the delivered program can be modified to bring in the needed field, the question is where do I start
1 2164
by  Ragu RaghavanJump to last post
02/08/2018 3:25 PM
0 Replies and 384 Views Customizing PR195  384  0 Started by  PD The PR195 report (csv) has almost everything that I need except PayType. I am sure the delivered program can be modified to bring in the needed field, the question is where do I start
0 384
02/08/2018 12:04 PM
7 Replies and 1777 Views Custom Lawson tables using Addins  1777  7 Started by  JudeBac I have a new custom table ZACCT with fields COMPANY, ACCTUNIT, ACCOUNT, SUBACCOUNT, all derived from GLMASTER. My plan is for our AP users to use excel addins to add records. Can I copy a similar program and replaced the field names or should I start from scratch using pgmdef Any pgmdef for dummies is much appreciated.   Thanks
7 1777
by  JudeBacJump to last post
02/06/2018 4:19 PM
6 Replies and 7573 Views How do I generate CSV output from batch program?  7573  6 Started by  Woozy We use an external scheduler to launch S3 batch jobs from the command line using wtsubmit or jqsubmit.  After the jobs finish, we want to retrieve the .csv file from the $LAWDIR/print directory, but these files don't appear to exist until a user opens Print Manager and clicks the 'Create CSV' button, which our automated scheduler can't do. Is there a way for us to trigger the creation of the CSV file from the command line, or some other way to make this happen The programs ...
6 7573
by  PDJump to last post
12/20/2017 9:59 AM
5 Replies and 3767 Views how to call UNIX script from tokendef  3767  5 Started by  Lilyb We're migrating from UNIX platform to Windows, and have tons of UNIX scripts.  I can run the shell scripts from LID prompt just like on UNIX after running initluu.  However, when I define the script in tokendef, it will not run.  Does anyone know how to make UNIX script to run with tokendef   Thanks.
5 3767
by  JaphethJump to last post
10/02/2017 12:19 PM
0 Replies and 790 Views LSO Scripting for newbie  790  0 Started by  sadams Hello all, I'm new to LSO scripting using Jscript.Net to add ability to Lawson forms.  I have written some beginning scripts to move fields and add labels etc.  I have some programming background, but don't know where to find more information/examples.  Any help would be appreciated. Thanks sadams
0 790
09/28/2017 11:11 AM
1 Replies and 2222 Views Jobdef Job Not Found error  2222  1 Started by  maalimsimo We have just upgraded to Lawson 10 and while most of our custom jobs are running as expected, we are have a few challenges. We have a job defined in jobdef for a batch user 'pcnprd', but then a korn shell script to run the job is giving the error 'Job not found in JOB table for User.' I have deleted and recreated the job in jobdef multiple times, and even created a brand new job with a different name but I still get the very same error.   Any thoughts on this    
1 2222
by  maalimsimoJump to last post
09/26/2017 1:39 PM
3 Replies and 2794 Views Paint Screen - Job Title retrieval for job-code  2794  3 Started by  Leonard Courchaine Hi all,  Sorry if I'm missing something simple.   Trying to paint a custom screen that goes with a custom table.  Custom table is simply job-code, chg-min, chg-max.  I'm developing a Paint Screen form that has job-code, title (output only:  description from job-code table), chg-min, chg-max.  In the form I've developed,  I populate the job-code, chg-min and ch-max then click A (Add) and *then* the title appears.  I'd like the title to appear after the use...
3 2794
by  Ragu RaghavanJump to last post
08/04/2017 9:41 AM
5 Replies and 6606 Views Org Chart  6606  5 Started by  Greg Moeller Hello, all: I've been tasked to investigate the possibility of a searchable org chart (the one that displays in ESS/MSS would be preferable) Anyone figured out a way to make this searchable by name&160; If you don't know who someone reports to and what the chain of command is above them, it's pretty difficult to find one of our 5000 employees. Thanks for any response! -Greg
5 6606
by  Cheri AzereixJump to last post
06/20/2017 11:54 AM
1 Replies and 2244 Views Portal changes location of literal  2244  1 Started by  Stuart Perkins How can I control the placement of text on portal on a batch program parameter screen  Literal text after the fields explaining their use is being moved too far left to be useful.
1 2244
by  Stuart PerkinsJump to last post
06/19/2017 1:01 PM
0 Replies and 635 Views Customizations  635  0 Started by  Carla Ferrari Hi, Has anyone come up with a customization request form that they would be kind enough to share I'm trying to centralize and formalize the way the user community requests customizations to forms, portal pages, process flow, etc. Thanks! Carla
0 635
05/22/2017 3:13 PM
7 Replies and 8341 Views Distribution Group  8341  7 Started by  Chesca We created a multistep job that runs MA236 for different users. Reports are run and supposed to be distributed to users and are available to view in their print managers. The problem is that only one of the users is able to see the report. The other 17 users/buyers can't see the reports in their print manager queue in Portal.  I can go into Print Manager and see the reports in each user's queue, but they can't. Any suggestions
7 8341
by  mthedfordJump to last post
05/04/2017 1:52 PM
2 Replies and 2244 Views Add Custom Tables to Lawson Data Dictionary  2244  2 Started by  Lawson_Tech Any KBs please post to me 'Add Custom Tables to Lawson Data Dictionary'
2 2244
by  Kwane McNealJump to last post
04/10/2017 3:28 PM
0 Replies and 550 Views Question on Custom Table with Unique-ID field  550  0 Started by  LauraPat Hi - I've created a  custom table and the first column in the table is the UNIQUE_I_D column because there are going to be duplicates within the key fields.  I want to use importdb to load a file into this table that was created by an outside system.  Because the first field in the table is the UNIQUE_I_D - I made the first field in every record in the file I'm loading equal to 0 (zero).  I realized I had to allow for that field when loading or everything is shifted off by 1 ...
0 550
04/06/2017 6:58 AM
1 Replies and 2319 Views Labels on Zebra printer  2319  1 Started by  LauraPat All - I've created a custom program to print labels on a Zebra printer.  I basically copied the way AP290 has the labels set up in the .prt file.  The new Zebra printer is hooked up on the network, defined in prtdef, etc.  When I try to send the output (from the print manager) to the printer (I select the printer from the dropdown in print manager) - I get the message that the print file was printed but nothing physically prints on the printer.  After working with others for ...
1 2319
by  LauraPatJump to last post
03/30/2017 12:35 PM
0 Replies and 663 Views File Status Codes  663  0 Started by  jaherb I am receiving a file status code that I have no documentation and cannot find it in Google.   The file status is on a sort file and the status code is 9 230.   Anyone know what that means   Thanks   Jim
0 663
03/02/2017 10:40 AM
9 Replies and 5997 Views User Exit Eamples--  5997  9 Started by  tambrosi   Hello,  I am very, very new to the Lawson software, and was asked to look at the user exit process.  I was wondering if somebody would be willing to share a simple user exit program.   I have been going thru the doc's and any posts or all information I can find.  But an example would go along way. I am not real sure of the naming convention that needs to be followed and if the user exit needs to be defined in the source lib or the obj lib.  I think the obj lib i...
9 5997
by  jaherbJump to last post
02/24/2017 12:47 PM
1 Replies and 2108 Views Print labels via custom batch program  2108  1 Started by  LauraPat Hi - I did this back at my old job (that had Lawson V8 - we're on V10 here where I am now).  I want to print SMALL labels using data from ITEMMAST.  The labels are only 2.5 ' x 1'.  The way I did this in the past was I set the labels up in the .prt file for the custom program, made sure they lined up and then ran the program to generate the .prt file and send that to the printer.  I remember the one issue was, in V8 anyways, you couldn't bypass the banner page so that wa...
1 2108
by  Ragu RaghavanJump to last post
02/23/2017 9:00 AM
1 Replies and 2636 Views jobs in waiting recovery  2636  1 Started by  MarkDK we are creating an IPA to query jobs in a 'waiting recovery' status.  What I would like to do is resubmit the job in waiting recovery status using WebRun node.  We have an IPA using WebRun that submits a job.  Is there a way to resubmit a job using webrun using the job id of the job in a 'waiting recovery' status 
1 2636
by  JimYJump to last post
02/20/2017 9:55 AM
2 Replies and 2396 Views Meaning of File Status 9-230  2396  2 Started by  ALB Does anyone know the meaning of file status 9-230  We have a custom COBOL which runs in Windows in v9.0.1 but throws that error on a sort file in the Cloud in v10.
2 2396
by  ALBJump to last post
02/17/2017 8:07 AM
1 Replies and 2137 Views Customized EMSS bookmarks - caching issues  2137  1 Started by  Judy Consoli We have created several customized EMSS bookmarks.  Since upgrading to Infor 10 and using IE without compability mode on, we are having issues with older versions of .htm .js being cached.  Any suggestions on how to clear cache for these custom bookmarks when changes are required
1 2137
by  CindyWJump to last post
02/09/2017 1:04 PM
1 Replies and 2442 Views Program compiled w/ trace  2442  1 Started by  Lynne I have a program that somehow has a trace turned on and I can't figure out how to turn it off.  I've re-compiled it numerous times with no special options, just a straight 'qcompile test ic ip527'.  It fills up the log with a trace of sections/paragraphs executed.  Does anyone know how to shut this off  Thanks!   Here's a sampling of the output: Step 1: IP527 Started. . . . . .: Tue Jan 24 15:07:43 2017 Token Command. . . . . .: D:\lsfdev\law\test\obj\IP527.gn...
1 2442
by  LynneJump to last post
01/24/2017 2:58 PM
2 Replies and 2741 Views Rel 10 4GL Error  2741  2 Started by  jaherb We are in the process of moving to the cloud from Rel 9.0.1 Unix.   We have a few custom programs that are not compiling and I am getting an error that I have never seen before. Not knowing what to look for, I have validated paths, slash direction and called Lawson routines and everything seems to be in place.  There are only a few of our custom programs that are not compiling and there is nothing unusual about these programs.  Has anyone run into before The error message I am ...
2 2741
by  jaherbJump to last post
01/18/2017 9:04 AM
2 Replies and 3566 Views Infor10 Mingle Login Screen Customization  3566  2 Started by  Michael Ewing Users have inquired about customizing the labels for the Login/Password input boxes on the Infor10 Mingle Login screen to be more helpful to the users about what values are to be used for logging into the Infor10 system(s). Other customizations (ie.  Listing the environment, displaying links to Tutorials, displaying notices, etc) may also be requested in the future. We are familiar with doing such customizations for the old 9.X version, but with the code...
2 3566
by  JimYJump to last post
12/15/2016 10:32 AM
7 Replies and 3567 Views Has anyone successfully parsed out job parameters from the GEN(LAW).JOBSTEP table?  3567  7 Started by  b.svr It seems like this is one jumbled text field that isn't very readable. Has anyone come up with a good way to parse this out for something more readable   Thank you,
7 3567
by  John HenleyJump to last post
12/09/2016 2:13 PM
6 Replies and 3036 Views Form/.scr help!!  3036  6 Started by  LauraPat I copied an existing program to create a new one (online program).  The existing program only had a single form in the .scr file.  I added 5 more forms (.2, .3, .4, etc) to the new .scr file and updated the PD to process the data in the forms.  The forms in LID work perfect.  I can do a form transfer to all 6 forms and enter/update data.  However, when I go into LSA - only the '.1' form is showing and when I go into Design Studio and Ming.le - only the '.1' is showing.&n...
6 3036
by  LauraPatJump to last post
10/07/2016 7:43 AM
4 Replies and 4106 Views Print manager files  4106  4 Started by  LauraPat Hi - I know you can go into the print manager and force a .prt file to be dumped to a .csv/.pdf file using the tools within print manager.  Does anyone know if there is a way, via a Unix script, where I can take the .prt file and transform it into a .csv or .pdf file  I'm trying to write a process to backup all the files within specific print directories and save them to the network.  But I found out that the users typically go in and save the files into other formats, from with...
4 4106
by  ALBJump to last post
09/28/2016 1:42 PM
6 Replies and 3124 Views Fld Err: Decimal Field's Display Length 0  3124  6 Started by  Maynard F. I have a custom program with an error on the screen.  It points to line 94, but line 94 is just like the ones before and after it. ZBAHW.scr                           Menus On            Line:94         Col:1    3    OPT-OUT-CODE-8  ...
6 3124
by  pgallucci12Jump to last post
09/23/2016 5:39 PM
3 Replies and 2753 Views State Tax Form  2753  3 Started by  Deleted User Hello everyone!  I am completely new to Lawson/Infor and have been asked by my employer to create a state tax form. I am pretty well versed in HTML, JavaScript, jQuery. After opening the W4,html file and looking at the use of frames and the functions within, I am very lost. Does anyone have any design guide or any information on creation of new forms with a dictionary of functions Any experience modifying the W4 into a state form I could even entertain paid consulting work for this proj...
3 2753
by  Jeff ShumateJump to last post
09/23/2016 4:23 PM
1 Replies and 4919 Views Lawson APIs  4919  1 Started by  Kimm Does anyone have documentation of information they could send for Lawson API calls We are looking to gather vendor, invoice, gl details as well as load data to the APC tables but the documentation from Infor has not proved helpful.  TIA!
1 4919
by  Joe CareyJump to last post
09/17/2016 10:38 AM
4 Replies and 2764 Views CSV File  2764  4 Started by  Srini Rao Hello - Is it possible to add the CSV file to user exit.   I have user exit and I like to add the csv file to User Exit. How do I do that.         
4 2764
by  jaherbJump to last post
09/06/2016 1:21 PM
3 Replies and 2911 Views Tab delimited  2911  3 Started by  Srini Rao Is it possible to create the TAB delimited output using the 4GL program
3 2911
by  Karen SheridanJump to last post
09/02/2016 9:00 AM
2 Replies and 2497 Views animating a lawson online screen  2497  2 Started by  Chesca I am trying to animate an online screen like HR11 and got an error: getsockname: Bad file number. This is happening with all the lawson screens and they system is extremely slow.  Any idea what getsockname: Bad file number means
2 2497
by  ChescaJump to last post
08/30/2016 3:08 PM
1 Replies and 2592 Views Second Report to Print Manager  2592  1 Started by  LauraPat I’ve created a custom program that has two reports coming out of it.  I have given the $PRINTFILE command in the .rpt for the second and I open/close the file in the PD and have the workfile defined.  Everything is working and if I go into the Unix print file directory from the command line, I see the second report there but it doesn’t show in the print manager itself.  What am I missing  I know in Unix (from a script), I can run the loadrpts command to get a fil...
1 2592
by  LauraPatJump to last post
08/18/2016 11:20 AM
2 Replies and 2620 Views Lawson Rel 10  2620  2 Started by  jaherb Can anyone shed some light on the Rel 10 upgrade where we will be 'forced' to move to Visual COBOL   What are the differences as far as development practices  Any good references on-line   We are scheduled to upgrade in April at the present time and just trying to get ideas on what to expect on the development side...   Thank you   Jim
2 2620
by  jaherbJump to last post
08/18/2016 9:32 AM
0 Replies and 844 Views Chrome loading pages on custom ESS  844  0 Started by  MC We have a customization within pactions.htm that in V9 was not a problem.  The customization was 3 DME with functions that called each other.  In V10 portal, if we run this in chrome only the functions seem to run in one thread and the rest of the program in one of more other threads.  As a result the loading of internal tables that are needed for the rest of the program are not available when needed.  The only thing that we have found that fixes this...
0 844
08/15/2016 10:02 AM
6 Replies and 2629 Views IE11 Form Messages  2629  6 Started by  jaherb We have some users who have upgraded their browsers to IE11.   Seems once we upgrade a browser, we loose visibility of form messages at the bottom; for example; Job Added, Change Complete, etc... We have made sure the forms are set no larger than 100 but that does not seem to matter.  Anyone else experiencing this or have you managed to correct this issue in some way     Thanks.. Jim  
6 2629
by  Greg MoellerJump to last post
08/03/2016 12:58 PM
5 Replies and 3110 Views waiting recovery  3110  5 Started by  Chesca Does anyone know if there is a Lawson process to check or monitor the recovery queue Or would I have to create a job script to monitor and notify whenever there is job in waiting recovery
5 3110
by  TBonneyJump to last post
07/27/2016 7:33 AM
0 Replies and 654 Views waiting recovery  654  0 Started by  Chesca Does anyone know if there is a Lawson process to check or monitor the recovery queue Or would I have to create a job script to monitor and notify whenever there is job in waiting recovery
0 654
07/26/2016 11:06 AM
3 Replies and 2891 Views Microfocus  2891  3 Started by  LauraPat Not sure anybody has ever used Oracle ProCobol or not but....  Been working with Lawson for about 21 years now and at both of my previous employers we purchased our MF licenses via Lawson.  I also used Oracle ProCobol which requires a MF license as well.  never had a problem compiling/executing Oracle ProCobol programs - never had a license issue and Lawson worked fine as well. At my new employer, we are on Version 10 (previous employer was Version 8) and I can't get the Oracle p...
3 2891
by  LauraPatJump to last post
06/30/2016 7:44 AM
0 Replies and 917 Views How Find Programs That Use Specific Screen Rule?  917  0 Started by  Kathy Eckert We are going from 1 company code to multiple company codes. Some of our custom Screen Rules (.sr files) Hard Code the company, so we need to know which programs use these hard-coded screen rules. Via grep (we're a UNIX shop), I've identified all 14 Form Rules that hard-code ('1111') Company.  However, when I tried to grep which programs used the Form IDs ('H1-EMP-S-0001' is one of the Form Rules, for example), I got no results.  Of the 14 Form Rules, 3 are Rules, 8 are S...
0 917
06/24/2016 11:06 AM
2 Replies and 2636 Views Using current date in if statement  2636  2 Started by  Jessica M I am hoping someone can help me with a COBOL statement.  I haven't touched cobol in quite a while and my co-worker that usually works with our custom cobol is out of the office for a bit. I have a custom program that was excluding any employee with a term date in a file.  They now want to change it to include anyone termed that day.  The current statement is: IF (EMP-TERM-DATE > '00000000')             GO TO 1040-NEXT-EMP...
2 2636
by  Jessica MJump to last post
06/22/2016 2:38 PM
6 Replies and 3156 Views calculate the last day of any month  3156  6 Started by  Chesca Is there an API I could use to calculate the last day of any month  
6 3156
by  kimJump to last post
06/16/2016 12:20 PM
1 Replies and 2580 Views Compile Error  2580  1 Started by  Judy Longo I created AR15M from AR150, reentered all of the workfiles in workdef and get following error   PrcWRKFILE(): AR15M Not Found In WsGrp
1 2580
by  jaherbJump to last post
06/13/2016 3:15 PM
6 Replies and 3988 Views 0 instead of blanks in CSV file  3988  6 Started by  pgallucci12 When a 4GL program creates a CSV file, and numeric fields defined in that CSV contain ZERO values, BLANKS are substituted. Is there a way to force a ZERO instead Is there a setting in a configuration file that can do that Example: CSV file contains 2 fields, NAME and COUNT. The value in NAME = 'J.Jones' The value in COUNT = 0 Currently the CSV record for the above looks like... 'J.Jones', I need it to look like... 'J.Jones',0
6 3988
by  David@SOMJump to last post
06/03/2016 1:12 PM
6 Replies and 6355 Views Web service calls *FROM* Lawson  6355  6 Started by  MBond How would one call a web service on another machine FROM lawson&160; The call would need to be made in the background without opening a new window.&160;&160; The web service can accept either a POST or GET request.&160; For this request, the response is not processed but future request probably would need to process the response.&160;I think the xmlhttp request is the answer but have no documentation on it's use. I've seen a lot of posts on calling into Lawson web services from external a...
6 6355
by  Jason BeardJump to last post
05/25/2016 9:29 PM
3 Replies and 2688 Views New custom program  2688  3 Started by  Greg Moeller I have developed a custom program that just calls a shell script.... When I try to add the job with the custom form in it, I get an error that says 'The value {1} is invalid for the parameter _TKN' Any clues what is happening here
3 2688
by  Jason BeardJump to last post
05/25/2016 9:04 PM
0 Replies and 941 Views Portal Page for Workunits  941  0 Started by  LauraBryant I have a design studio portal page that displays all the AP workunits.  I would like to filter the results to only include the accounting units that the users requester code has access to.  I get the requester code and I get the account units from the RQAcctU table.  How can I filter the results from the WFWORKUNIT table to only select the rows that have an accounting unit allowed.
0 941
05/18/2016 1:56 PM
2 Replies and 2871 Views tsBeginDBTransaction error is Operation illegal while in transaction (20).  2871  2 Started by  Lilyb I'm developing a custom program (update job) to invoke a copy of AP30.3, and keep getting the following error: File SYSTEST/TXTAXTABLE. tsBeginDBTransaction error is Operation illegal while in transaction (20). Does anyone know what this means and how to fix it Thank you
2 2871
by  LilybJump to last post
05/12/2016 6:52 PM
3 Replies and 2872 Views Best practice of copying a program  2872  3 Started by  Vijay S Dear All, I have to copy a standard program having around 10 workfiles. We all know that Lawson doesn't change the name of workfile and WS-Field ID in work file definition while copying , It changes the same in PD (like wherever I am using WH130, it will change it to ZZ130 in PD/WS, The workfile name starting from WH130 doesn't change). It seems like I have to manually go into PD and change the name of all the Workfiles and other field. I had done it earlier also where there were like couple of...
3 2872
by  jaherbJump to last post
05/12/2016 9:53 AM
1 Replies and 3693 Views Best (certified) Lawson Development Partner for S3 and/or M3  3693  1 Started by  AvaTax Calc for Lawson/Infor I am seeking a third-party shop who is certified by Lawson/Infor to develop 'Connectors' with S3 and/or M3. Avalara is an Infor Partner, supporting eight (8) different Infor ERP platforms. I hope to find the A1 certified development partner for S3 and/or M3. Thank you for your help!
1 3693
by  shahzadJump to last post
05/03/2016 3:01 AM
2 Replies and 2746 Views Comment Attachment Processing compile error  2746  2 Started by  John Desmarais I'm trying to do something that should be very simple - determine the existence of Comments on Invoice Messages, just like MA66 does when it needs to determine what text to put in the Message Button on the screen.  Simple, no I looked through the API manual to see if there was any voodoo involved - looked pretty easy. copied the code right out of MA66PD and dropped it into my program.              INITIALIZE   &...
2 2746
by  John DesmaraisJump to last post
04/07/2016 10:49 AM
14 Replies and 3771 Views Extract File Issues  3771  14 Started by  jaherb I am not sure why I am not seeing the issue with a simple extract program... but I am at a loss at this point.    We have an extract file being produced as a 250 byte fixed length file.   There are 3 record types... a typical Header, Detail and Trailer record.  Each record must be delimited by  CR/LF characters. The logic writes the records to an intermediate sequential file and then at the end of the job it is reformatted by a cnvexp -f  filename  250  ...
14 3771
by  jaherbJump to last post
04/01/2016 11:52 AM
0 Replies and 966 Views Lawson Portal automated access and session handling  966  0 Started by  andrewwalk Hello, Is there a way to automatically send to Lawson a bunch of requests to a specified form via a Java http client  Actually I am able to do this, but it is very slow as I have to programmatically logon and logoff for each request.  I need to be able to log in once, and then send all the requests I need to.   Any time I send a request after the session has timed out, then I want to be able to detect this and re login, then send my requests.  Is there an API for this in e...
0 966
03/29/2016 2:18 PM
3 Replies and 3741 Views Oracle SQL reformat date  3741  3 Started by  Chesca I am writing an SQL statement to select dates from a table and creates a file.  I want to convert date to string mm/dd/yyyy.  Any help would be greatly appreciated. select startdate from table;  this date is displayed as 31-MAY-15 so I want it displayed as 05-31-2015
3 3741
by  ChescaJump to last post
03/01/2016 3:23 PM
4 Replies and 3050 Views Input date validation  3050  4 Started by  Chesca We have a custom batch program that validates input date from a csv file. The date is never formatted properly and sometimes could be mddyy, mmddyy, or mmdyy. We want the date to be reformatted as mmddyyyy.  If the input date is 8 digits and mmddyyyy. then continue processing. Otherwise, check if the date length and fix it. Is there a Lawson API I can use to reformat the input date to be mmddyyyy 
4 3050
by  ChescaJump to last post
02/10/2016 7:39 AM
6 Replies and 4763 Views Cannot replace my own custom form  4763  6 Started by  mikeP Working on my first update form in PGMDEF and have run into a number of issues.  Currently, I can’t seem to get rid of the previous version of my form. Ideally it will have multiple PRDISTRIB records and allow just the account field to be updated.  At this point, it’s just and “online inquiry” that shows a few fields from the file. The problem is that I created a new version but Lawson won’t display it. Here’s the sequence: Create form in PGMDEF....
6 4763
by  John HenleyJump to last post
02/05/2016 2:07 PM
2 Replies and 15106 Views SQL question on APINVOICE, APDISTRIB, APPAYMENT  15106  2 Started by  Karl Kemp I am trying to write a query that will return APINVOICE, APDISTRIB, APVENMAST, and APPAYMENT information. Basically the user wants the Paid invoice detail information including vendor name and check number & date. I created the following query but it doesn't seem to completely work the way I would like it to do. It pulls the same invoice & distrib twice for each combination. In other words, if there is a single invoice with 2 distribution records, instead of the query returning 2 r...
2 15106
by  ChescaJump to last post
01/28/2016 2:52 PM
0 Replies and 1091 Views lawson 10 ESS theme 10.3 override  1091  0 Started by  KellyB Hi, is there a way to add 'themes' I found the  xhrnet/xml/config - emss_config_xml where it says themes but I am not sure where this is getting the theme files I can manually change the css link in the header.htm file to refer to a custom style sheet but wanted to know if there is a better way using themes I am running lawson 10 on webshere not via sharepoint.
0 1091
01/27/2016 2:49 PM
6 Replies and 3411 Views Windows script to do rnddbdump to file  3411  6 Started by  tambrosi Hi all,  I am looking for some help on scripting in Lawson,  I am new to the software, looking to run a script to dump a table to csv file. I can run the  rngdbdump –c gen queuedjob >  jqstat.csv   from the server and it will run clean and dump the data to the csv file.  When I apply the same code in a script, nothing gets dumped to the csv file,  the file is created but no records in the file.  I also tried the jqstatus same issue.     ...
6 3411
by  pbelskyJump to last post
01/19/2016 4:36 PM
12 Replies and 4018 Views Missing data in modified CSV error report after promotion  4018  12 Started by  Woozy Hi Gurus - I'm stumped, and I need some ideas. We have a custom batch program that includes an error report.  I recently modified the program and the error report to add additional columns.  With the new columns, the report is too wide for the printed report but works fine in the CSV export in DEV. However, after promoting the changes to PROD, the report compiles and runs without errors in PROD, but some of the new columns are blank in the CSV including the error message column (from...
12 4018
by  pbelskyJump to last post
01/07/2016 5:46 PM
4 Replies and 3413 Views RECDEF  3413  4 Started by  Chesca Can I create a paintscreen program to access recdef 
4 3413
by  Kwane McNealJump to last post
11/30/2015 1:06 PM
3 Replies and 3517 Views Scheduling job automatically with dynamic date range  3517  3 Started by  Vijay S Is there a way to schedule a job automatically in 'recdef' and passing job parameters automaticcaly like To & From date range. They have to be from the past 7 days . Like for today's run , From-date=today, to-date=today-7 days.......      Thanks,   Vijay
3 3517
by  Vijay SJump to last post
11/25/2015 2:35 AM
2 Replies and 2690 Views Database reads INTO a unique working storage area  2690  2 Started by  Todd Mitchell Curious if anyone has done a database read (find) where the read places the data into a separate or unique working storage section.  Example READ VENMAST INTO VENMAST-PAY-VENDOR.       
2 2690
by  Todd MitchellJump to last post
11/19/2015 3:53 PM
5 Replies and 3113 Views Add columns to report csv beyond the print report width limit  3113  5 Started by  Woozy 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 t...
5 3113
by  jaherbJump to last post
11/17/2015 4:21 PM
6 Replies and 3303 Views Best Way to add spaces in Header of a CSV file via batch Program  3303  6 Started by  Vijay S 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
6 3303
by  Vijay SJump to last post
11/17/2015 5:07 AM
3 Replies and 4489 Views How to look up field name from field number.  4489  3 Started by  Janice 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 tab...
3 4489
by  Kat VJump to last post
10/09/2015 3:52 PM
4 Replies and 3548 Views work file def  3548  4 Started by  Chesca 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 
4 3548
by  jaherbJump to last post
10/09/2015 10:36 AM
1 Replies and 2882 Views work file def  2882  1 Started by  Chesca 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.
1 2882
by  jaherbJump to last post
10/09/2015 10:33 AM
1 Replies and 3036 Views Use negative values returned from DME call ?  3036  1 Started by  mikeP   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;  &n...
1 3036
by  mikePJump to last post
10/02/2015 2:11 PM
5 Replies and 3261 Views 4GL Report missing Company Name  3261  5 Started by  Demichener 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......
5 3261
by  DemichenerJump to last post
09/29/2015 9:04 AM
0 Replies and 1342 Views Redirect WWW Usl to Mingle  1342  0 Started by  xxxxxttysfh 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
0 1342
09/25/2015 5:00 PM
3 Replies and 3271 Views programming error  3271  3 Started by  Chesca 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.  
3 3271
by  ChescaJump to last post
09/21/2015 3:03 PM
10 Replies and 5440 Views ESS new custom form  5440  10 Started by  Chesca 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  
10 5440
by  ChescaJump to last post
09/21/2015 2:41 PM
3 Replies and 3239 Views How to determine if string is numeric?  3239  3 Started by  Woozy 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    
3 3239
by  Vijay SJump to last post
09/15/2015 6:09 AM
4 Replies and 4368 Views Table for recurring job (Recdef)  4368  4 Started by  Vijay S Any guess, which GEN table store's recurring job definition
4 4368
by  Vijay SJump to last post
09/11/2015 7:41 AM
3 Replies and 2976 Views 4GL Versus HTML/JAVA  2976  3 Started by  Eric Haugen 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...
3 2976
by  WoozyJump to last post
09/10/2015 9:19 AM
8 Replies and 5882 Views Extract program version numbers  5882  8 Started by  Demichener 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 ...
8 5882
by  KrisJump to last post
09/08/2015 12:13 PM
1 Replies and 3036 Views Multiple Report COBOL  3036  1 Started by  ALB 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
1 3036
by  ALBJump to last post
08/28/2015 5:43 PM
0 Replies and 1132 Views Custom application not displaying text fields on next\previous  1132  0 Started by  haddixst 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.  ...
0 1132
08/19/2015 2:45 PM
7 Replies and 5219 Views Windows DOS script  5219  7 Started by  This_Guy 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...
7 5219
by  R Wayne WalkerJump to last post
07/30/2015 10:51 AM
1 Replies and 3174 Views Pop-up Text Message in AP20.1  3174  1 Started by  maalimsimo 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...
1 3174
by  maalimsimoJump to last post
07/28/2015 4:26 PM
5 Replies and 3526 Views Changing a custom index to Key Change=Yes?  3526  5 Started by  Woozy 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...
5 3526
by  WoozyJump to last post
07/28/2015 9:40 AM
1 Replies and 2857 Views ESS/MSS Changes  2857  1 Started by  bd 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...
1 2857
by  bdJump to last post
07/08/2015 9:04 AM
1 Replies and 3063 Views How to Left Align Output Fields  3063  1 Started by  Woozy 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 &91;ZY91&93;                   Jrs Leave Plan Details          ...
1 3063
by  jaherbJump to last post
06/25/2015 1:54 PM
4 Replies and 3319 Views Batch animator  3319  4 Started by  Chesca 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)
4 3319
by  ChescaJump to last post
06/24/2015 2:19 PM
11 Replies and 5751 Views HR11 AGS call  5751  11 Started by  JimK 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 deducti...
11 5751
by  Tim CochraneJump to last post
06/09/2015 6:15 PM
0 Replies and 1359 Views SharePoint integration 9.0.x  1359  0 Started by  skhenry 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 ...
0 1359
05/05/2015 5:43 PM
3 Replies and 3556 Views Report archiving/emailing  3556  3 Started by  tambrosi 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 anythin...
3 3556
by  mikePJump to last post
04/17/2015 1:04 PM
2 Replies and 3592 Views compiling error after copying a program  3592  2 Started by  Chesca 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
2 3592
by  ChescaJump to last post
03/11/2015 10:59 AM
3 Replies and 3654 Views ESS - Org Chart - Hide an employee from ESS Org Chart based on their Process Level and Department  3654  3 Started by  agersh Is it possible to hide (not display) an employee from the ESS Org Chart based on their Process Level and Department
3 3654
by  John HenleyJump to last post
03/02/2015 2:53 PM
0 Replies and 1399 Views This page cannot be displayed in a frame sharepoint 2013  1399  0 Started by  Ann I'm not sure how to display the webpage without having to click on the link.
0 1399
01/26/2015 2:45 PM
4 Replies and 4532 Views Advice on COBOL training  4532  4 Started by  JudeBac 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
4 4532
by  Scott PerrierJump to last post
01/20/2015 9:59 AM
3 Replies and 17516 Views Using wildcard in DME query  17516  3 Started by  Deleted User 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,
3 17516
by  Deleted UserJump to last post
01/13/2015 9:45 AM
7 Replies and 3872 Views PF Eclipse designer will not initiate  3872  7 Started by  MC 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  
7 3872
by  MCJump to last post
01/07/2015 6:43 AM
7 Replies and 4491 Views Can I leverage relations in COBOL query?  4491  7 Started by  Woozy 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
7 4491
by  WoozyJump to last post
12/12/2014 10:39 AM
11 Replies and 3876 Views DME call and Javascript  3876  11 Started by  mikeP 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.wr...
11 3876
by  mikePJump to last post
11/18/2014 5:12 PM
3 Replies and 2253 Views ESS - Hide buttons  2253  3 Started by  MikeD 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. ...
3 2253
by  MikeDJump to last post
11/13/2014 2:08 PM
2 Replies and 2435 Views Custom code to find a previous record  2435  2 Started by  Chesca 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. 
2 2435
by  WoozyJump to last post
11/04/2014 3:50 PM
4 Replies and 2568 Views ESS label description change  2568  4 Started by  Chesca 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 ||...
4 2568
by  ChescaJump to last post
10/27/2014 3:15 PM
4 Replies and 2489 Views Proxy as another user in LSF9 Portal and/or EMSS  2489  4 Started by  Woozy 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
4 2489
by  WoozyJump to last post
10/24/2014 3:02 PM
10 Replies and 2244 Views Perplexed by LAWSON  2244  10 Started by  Rita 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-...
10 2244
by  Jason BeardJump to last post
10/23/2014 9:35 PM
0 Replies and 1000 Views html page in Lawson  1000  0 Started by  khart 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.
0 1000
10/19/2014 8:48 AM
7 Replies and 2877 Views Call a Process Flow from within JavaScript  2877  7 Started by  FireGeek21 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!
7 2877
by  JimYJump to last post
10/17/2014 3:49 PM
0 Replies and 2431 Views Windows AD and useratts.htm  2431  0 Started by  cpaine216 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...
0 2431
10/10/2014 2:40 PM
1 Replies and 1514 Views RQC version 10  1514  1 Started by  Scooter 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.
1 1514
by  Scott PerrierJump to last post
10/08/2014 3:49 PM
7 Replies and 3926 Views Looking for Lawson API Listing  3926  7 Started by  cschoonover 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
7 3926
by  jaherbJump to last post
10/06/2014 11:04 AM
0 Replies and 1124 Views USERPROFILE  1124  0 Started by  cpaine216 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
0 1124
09/18/2014 3:56 PM
1 Replies and 1557 Views vbscript and ags  1557  1 Started by  darwin collins 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).&nb...
1 1557
by  John HenleyJump to last post
09/17/2014 5:09 PM
1 Replies and 1187 Views Shrinking fields  1187  1 Started by  Rita 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.  
1 1187
by  RitaJump to last post
09/17/2014 12:21 PM
4 Replies and 1410 Views two forms in one program  1410  4 Started by  Rita 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
4 1410
by  WoozyJump to last post
09/15/2014 3:12 PM
12 Replies and 4229 Views Job fails to kick off FTP script - unable to log in user/startstep failed  4229  12 Started by  CindyW 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 L...
12 4229
by  cpaine216Jump to last post
09/15/2014 9:28 AM
1 Replies and 1506 Views Adding fields to form  1506  1 Started by  Rita 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.
1 1506
by  jaherbJump to last post
09/11/2014 11:16 AM
1 Replies and 1214 Views Painting with alternate index  1214  1 Started by  Rita 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
1 1214
by  RitaJump to last post
09/09/2014 3:16 PM
3 Replies and 1567 Views API  1567  3 Started by  Rita I am new to Lawson.  I need to add an output field with a name that gets generated via API 750-HR-FORMAT-NAME. Do I have to add this code manually or is there a way to add during design paint (pgmdef) mode   I also need to add fields which are both input and output, meaning if information (key) exists I need it displayed and changed on demand, but if it doesn't exist I need it to show up empty. The paint form allows only for Input fields (F2) or Output fields (F3...
3 1567
by  jaherbJump to last post
09/08/2014 12:36 PM
3 Replies and 1449 Views random alphanumeric string  1449  3 Started by  Srini Rao We have a request to generate a random alphanumeric string of characters using 4GL.  Any ideas if there are any random character generating functions available in COBOL
3 1449
by  Scott PerrierJump to last post
08/29/2014 2:03 PM
1 Replies and 1393 Views Infor graphic replacement on Login page  1393  1 Started by  Shane Jones We have just moved our test system to version 10.0.5 and there is a change to the way the LOGIN page graphics are being handled in this version....    I know how to find and replace the graphics in the older versions but this version is hiding it a bit more...   Anyone have any suggestions (The location changed from version 10.0.2 --> 10.0.5)
1 1393
by  Srini RaoJump to last post
08/29/2014 8:41 AM
0 Replies and 1038 Views What is $AUDFORM in the .scr file do?  1038  0 Started by  Russell E In version 10 of the S3 apps there is a new item in a number of the .scr files.  $AUDFORM0  HR93.1  is an example.  Does anyone know what this $AUDFORM does  It is not in the Application Dev Workbench Standards document.
0 1038
08/27/2014 2:19 PM
2 Replies and 1128 Views Process level changes  1128  2 Started by  Chesca I am writing custom code and we have encountered an issue. when employee switch process levels, it reports the new process level, I want to be able to look in history and get the previous process level. Where can I get this data from Would that be in HRHISTORY
2 1128
by  jaherbJump to last post
08/25/2014 10:08 AM
1 Replies and 1602 Views Javascript AGS call with Next  1602  1 Started by  Woozy I have a custom 4GL form that includes a grid with rows for all the employees of a supervisor, along with additional data (vacation used & available).  This flow makes use of Next/Previous functionality to browse through records when there are more subordinates than the form allows.  TThe form works perfectly using the Next/Previous functionality. Now we've been given a requirement to build an EMSS version of this form.  Do do this,  We want to retrieve all of the re...
1 1602
by  WoozyJump to last post
08/20/2014 5:12 PM
1 Replies and 1352 Views LP program syntax error  1352  1 Started by  Chesca All of the sudden, I am getting the following syntax errors and nothing was changed in the program as far as I know. I have no idea how to even look for the missing libraries. Can anybody help me please   Build Of Int Complete For LP140 Error - TH1-COMPANY Not Defined In Specified WS Error - TH2-COMPANY Not Defined In Specified WS Error - TH3-COMPANY Not Defined In Specified WS Error - TH4-COMPANY Not Defined In Specified WS Error - TH5-COMPANY Not Defined In Specified WS Error ...
1 1352
by  ChescaJump to last post
08/11/2014 3:18 PM
2 Replies and 1409 Views File dump  1409  2 Started by  Chesca Hello, Lawson is requesting a file dump with headers for TAEEMASTER, TAEMPTRANS and TAEMPSERV tables. Is there a command to do this or can I just write a crystal report and export to a file 
2 1409
by  ChescaJump to last post
07/29/2014 1:23 PM
8 Replies and 1609 Views MSS - Customizations  1609  8 Started by  Chris12 I am looking to customize MSS so that when a manager enter a PA action on someone, I can hard code a value into a 'CURRENT VALUE' field. For example, I want to hardcode the Current Value for STATUS to be 'ACTIVE' for everyone.  Does anyone know what file would call the CURRENT VALUE, or any pointers in getting this accomplished Thanks in advance
8 1609
by  Chris12Jump to last post
07/28/2014 1:44 PM
3 Replies and 1236 Views Deprecated 515-UPDATE-DATE-TIME api  1236  3 Started by  Russell E Lawson has deprecated a number of date/time apis.  This was done atleast in version 9 and is also listed in the 10 manual.  There is no replacement for a number of the apis.  The one I am interested in is 515-UPDATE-DATE-TIME.  This gives the current date/time.  Does anyone know of the replacement that is recommended
3 1236
by  jaherbJump to last post
07/24/2014 9:33 AM
5 Replies and 1221 Views ESS screen welcome screen  1221  5 Started by  Chesca Does anybody know where ESS pulls a user’s first name for the “Welcome…” in the upper right hand corner  An employee has changed her first name and Lawson has been updated, but when she logs into ESS she still sees her previous name.
5 1221
by  ChescaJump to last post
07/23/2014 2:17 PM
9 Replies and 9443 Views ESS Benefits Enrollment - My DME and AGS calls Not Working  9443  9 Started by  agersh I added the following two functions and SRC references to the ESS Benefits Enrollment disp_ben_01.htm file to retrieve and update the HL_COV_PROOF field in the PAEMPLOYEE table. Both functions die at the DME and AGS call which causes Benefits Enrollment to display continuously a 'Processing...' message. Does anyone know why I am experiencing this issue with my DME and AGS calls &60;&115;&99;&114;&105;&112;&116;&32;&115;&114;&99;&61;&34;&47;&108;&97;&119;&115;&111;&11...
9 9443
by  Judy ConsoliJump to last post
07/03/2014 10:32 AM
0 Replies and 824 Views v10 how to define window for comments  824  0 Started by  MAL I am trying to build a custom screen where I would like comments like CB80. Can someone help me understand the definition in CB80 (87=CMT)
0 824
06/24/2014 9:31 AM
3 Replies and 1301 Views Create var length recs  1301  3 Started by  ArthurThum Does any know how to force a file to be variable length from 4GL. I know file media needs to be Tape. But I cannot get variable lengths to come out. Vendor requires 4 recs lengths and must be var. How can this be accomplished with 4GL
3 1301
by  jaherbJump to last post
06/24/2014 9:25 AM
2 Replies and 1208 Views scan programs  1208  2 Started by  Chesca I am trying to find out if any of the HR/PR/LP programs including custom programs use field HREMPUSF so I am looking for a command or utility to scan the system, is there such command Any help would be greatly appreciated, thanks!
2 1208
by  WoozyJump to last post
06/23/2014 12:53 PM
1 Replies and 1420 Views Set up ESS Benefits Enrollment for a Medical Plan Spousal Surcharge  1420  1 Started by  agersh Hi, we use Employee Self-Service for our Annual and New Hire benefits enrollment. I am trying to figure out if possible how to configure S3 ESS Benefits Enrollment to handle a Spousal Surcharge for our Medical plan. We also would like to add a new form/screen to our ESS Benefits Enrollment process that would display Spousal Surcharge Affidavit verbiage and have the employee select either a Yes or No on the affidavit which would update the HR11 Ben Flags->Spouse Coverage Health Coverage field/fla...
1 1420
by  Karen SheridanJump to last post
06/13/2014 10:38 AM
5 Replies and 1384 Views CSV file read error  1384  5 Started by  BrianM We have a custom program that has been working fine but all of a sudden came up with what looks like a ReadCSV error (see attachment).  There is no READ done in the program, only OPEN, WRITE, and CLOSE.  Yet the user gets this error.  Anyone have any ideas Thanks in advance for your help!
5 1384
by  jaherbJump to last post
06/12/2014 3:28 PM
4 Replies and 1669 Views Publish Non-Lawson Report to Print Manager?  1669  4 Started by  Kyle Jorgensen Is it possible to 'publish' a non-Lawson text file to a user's Print Manger Specifically, we have a 'batch-like' process flow that creates a print file and an error file. I know we can email users the reports from process flow, but it would be nice if the reports could be displayed/accessed through the user's print managers.
4 1669
by  Greg MoellerJump to last post
05/22/2014 4:30 PM
3 Replies and 1581 Views .aif file  1581  3 Started by  BrianM I compiled a custom program and ended up with a .aif file in my obj directory.  I don't recall ever seeing this before. That or I didn't look hard enough.  Does anyone know why this file is in there and what it might be used for  Can it be deleted  Thanks in advance for your help.
3 1581
by  jaherbJump to last post
05/14/2014 5:22 PM
3 Replies and 3168 Views Work File error  3168  3 Started by  Chesca Hello, I have never wrote Lawson code to sort a file internally so I am using a Lawson program as model. My goal is to sort some records and then create a report. Any suggestions would be greatly appreciated. I created a WF and SF file in the work definition section. I am getting an error :  bad File Status 9 009 on file Work-File. Here is my source code:             PERFORM 900-BUILD-TMP-FILE-NAME.   ...
3 3168
by  jaherbJump to last post
05/08/2014 11:24 AM
3 Replies and 1518 Views Mosby Skills Interface  1518  3 Started by  jaherb Is anyone transmitting an interface file to Mosby's Skills I have a very simple extract file we are trying to send to them.  It is basically a tab-delimited file with 'lf' at the end of each line.   I am including a 'lf' character (hex 0A) at the end of each line but they are picking this up as an invalid character.   We have tried transmitting the file in binary format, auto format and via a pgp file and nothing seems to work. Would be interested in knowing how you address...
3 1518
by  The.Sam.GrovesJump to last post
04/08/2014 11:11 AM
2 Replies and 1254 Views What are cnvscr.detail and cnvscr.out?  1254  2 Started by  Woozy Hi All, Every so often I see files named 'cnvscr.detail' and 'cnvscr.out' show up in my $LAWDIR/{prodline} directory.  The files appear to be empty. Can anyone tell me what these are  Any concerns with deleting them Thanks! Kelly
2 1254
by  WoozyJump to last post
04/04/2014 3:07 PM
4 Replies and 3716 Views error message text not found  3716  4 Started by  BrianM I have a user who sent me an error message I've never seen before.  They ran a PO220 and got the following examine log message.  Does anyone know what this means  Thanks in advance for your help! Program Messages:         ** Creating .prt and .dtl files         Processing PO220 - PO Status Report         Execution error : file '/lawson/law/prod/obj/PO220...
4 3716
by  BrianMJump to last post
04/02/2014 3:55 PM
1 Replies and 1314 Views Associating Smart Office Script with the S3 Form  1314  1 Started by  L G Hi I am trying to change the layout of the screen in Smart Office Script Tool and have been able to get the script working against the S3 form when I run it. However how do I associate this script with the form permanently and then deploy to all users
1 1314
by  L GJump to last post
04/02/2014 6:39 AM
3 Replies and 1502 Views Script to email report from custom program - report incomplete  1502  3 Started by  AnnH Emailing a report from a custom program but the report is incomplete even though the script call is at the very end.  I need to close the report file manually but CLOSE REPORT-FILE returns compile error.  We have gotten by this in scheduled jobs by calling the script from a token but this report is processed on demand and I can't tie a token to it as the user may process the job under another name.  Is there a Lawson API that will clear the report buffer and close the report...
3 1502
by  jaherbJump to last post
03/27/2014 11:18 AM
2 Replies and 1478 Views Multiple rows of comments  1478  2 Started by  Chesca Hello, I am trying to write custom code to update a table. My users wants to enter comments up to 150 characters long, but I can only fit up to 75 characters. So I added multiple rows of comments to give me that many characters. However, I am not sure how to code it in my program to concatenate both rows and display on the screen or move it to the database. is there a Lawson program I can use as example to do this Thank you in advance for your help! I have attached the screen. &60;&1...
2 1478
by  ChescaJump to last post
03/13/2014 2:01 PM
5 Replies and 1732 Views PRTIME  1732  5 Started by  Chesca Does anybody know if I can use PRTIME to report a breakdown of salary information for an employee within a specific time period
5 1732
by  ChescaJump to last post
03/10/2014 7:03 AM
1 Replies and 1649 Views can't run/submit any jobs  1649  1 Started by  Chesca Hello, I am trying to run a program and get the following error: Scheduler: timeout on message from server  invalid server response calling: /cgi-lawson/xjobctr.exe We have already tried bringing system down (stop and start), deleting the job, recovering the job. I also check in the jobqueue and it's there with a status = 22. any help would be greatly appreciated, thanks!
1 1649
by  ChescaJump to last post
03/07/2014 2:00 PM
1 Replies and 1506 Views HR11 AGS Call User Fields  1506  1 Started by  Judy Consoli Has anyone used the AGS call from html/javascript for updating fields on the User Field Tab
1 1506
by  John HenleyJump to last post
03/01/2014 7:03 AM
3 Replies and 2001 Views Employee Status change  2001  3 Started by  Chesca I am writing custom code to calculate accruals based on the employee's FTE and  annual hours. When employees switch from full time to part-time, I need to know what their FTE was when he/she was full time. I was originally looking in HRHISTORY but I noticed we don't have a record in HRHISTORY for a change in FTE. It only shows the updated FTE value. Any suggestions would be greatly appreciated.
3 2001
by  jaherbJump to last post
02/27/2014 5:14 PM
6 Replies and 9781 Views Help accessing data returned by a DME call  9781  6 Started by  Shelby I am new to HTML/Javascript coding in Lawson S3. I have been asked to replace the use of cycles.htm with a BS06 AGS call in the benefit enrollment (ESS) calculations for mid-year new hires. However, I think a DME call to the BNCYCDTL table will be easier since I only need to retrieve the number of cycles remaining (and not do any type of updating). I can run my DME query in Excel Add-ins and get the one record that I need. But when I try to add the DME code in elect_ben_06.htm I cannot find the ...
6 9781
by  ShelbyJump to last post
02/26/2014 3:52 PM
7 Replies and 3018 Views 4GL command button to launch HR13.3  3018  7 Started by  Woozy I have a custom form, and I want to add a command button to each detail record pointing to HR13.3, similar to how the BN32 does it. I have created the button and pointed it to HR13.3, but when I inquire the button disappears. I've added matching keys to the .scr. What am I doing wrong What determines whether a button shows or not Thanks. Kelly
7 3018
by  jaherbJump to last post
02/21/2014 3:30 PM
2 Replies and 1671 Views dburf on custom paint program  1671  2 Started by  L G When i try to run dburf on a custom paint program it doesn't work. It works with clones of standard programs but doesn't work on paint programs. Anyone know how i should generate compile / or add in the program logic so that dburf can work with the program.
2 1671
by  jaherbJump to last post
02/20/2014 9:32 AM
2 Replies and 1372 Views Absence Management  1372  2 Started by  Chesca Does anybody know what table or screen would tell me if an employee is enrolled in absence plan/structure
2 1372
by  ChescaJump to last post
02/20/2014 8:19 AM
17 Replies and 2691 Views .scr file modifications  2691  17 Started by  BrianM I have a new program that I am creating and am having a heck of a time with the last line on the screen.  My code looks like this on the .scr file: |                  Company:&    &93;      ;                            &nb...
17 2691
by  jaherbJump to last post
02/13/2014 5:02 PM
2 Replies and 1432 Views Effective date the employee became benefit eligible  1432  2 Started by  Chesca I have a custom program that is incorrectly calculating retro accruals for an employee. I need to modify my code that it looks back to the effective date the employee became benefits eligible to calculate retro accruals. I am thinking about looking in HRHISTORY. Is there any other table/file I can look at to find out the effective date employee became eligible for benefits Any suggestions
2 1432
by  ChescaJump to last post
02/10/2014 11:58 AM
7 Replies and 1670 Views Sort File for Online Update Form?  1670  7 Started by  Woozy We have a customized online update form (copy of BS31 - Web Pending Benefit Enrollments), and the business would like to have this custom form sorted by StartDate/PlanType/PlanCode rather than PlanType/PlanCode/StartDate.  The source table is BNBEN which does not have an index the matches their request. Is it possible and reasonable to use a sort file to re-sequence the data for an online update form like this  I'm thinking 'no', but thought I'd ask the question. Does anyone hav...
7 1670
by  jaherbJump to last post
02/06/2014 1:07 PM
2 Replies and 1346 Views Calculate prior year  1346  2 Started by  Chesca Hello everybody, is there an API to calculate the prior year Do I need to convert year to Julian and can I just subtract 1 from the current year
2 1346
by  ChescaJump to last post
02/05/2014 2:21 PM
3 Replies and 4435 Views HTML/Javascript DME function for LOGAN  4435  3 Started by  Roger French I'm doing some portal customizations where I need to use the DME() function. I've used it OK before with application productlines with no issues, but I need to use it to query some LOGAN tables. I've tried various things within the DME function, but it's not working. It is always bombing out on the data.js function. I've reviewed it several times but haven't figured it out yet. Does anyone have an example of a javascript function where it successfully works by querying LOGAN Do I need to us...
3 4435
by  Scott PerrierJump to last post
01/31/2014 11:23 AM
5 Replies and 1921 Views Double Quotes on Empty fields in 4gl CSV file  1921  5 Started by  Nancy I have written a 4gl program to output a csv file as an extract for one of our vendors.    My problem is that the vendor wants double quotes around all fields in the file - even it the field has nothing in it. With quote char defaulted - everything in the file has double quotes around it except the fields without values. I tried setting the quote-char to low-values and manually stringing the doube quotes in front and behind each of fields. This did not correct the p...
5 1921
by  Donna WirtJump to last post
01/30/2014 1:37 PM
0 Replies and 1535 Views .Net 4.5 SSO / Authentication to Lawson 9 or 10.0 Request for Examples  1535  0 Started by  JasonP I am looking to connect .Net to Lawson to use AGS calls or query data from a .Net web application.  Does anyone have any code samples that do this that they could share.  Also, does there need to be any special setup in Lawson to allow it.  I have found the follow link, but Ive tried to piece it together with no luck. https://www.lawsonguru.com/forums/ux...lawson-90/ Thanks,
0 1535
01/30/2014 8:05 AM
4 Replies and 1636 Views HRHISTORY  1636  4 Started by  Chesca I want to write to code to look at hrhistory to find out if the employee FTE changed. I need to know the field number from the data dictionary, where would I find the data dictionary
4 1636
by  jaherbJump to last post
01/28/2014 10:24 AM
0 Replies and 1087 Views HTTPS Post Response - Kaiser CAMS  1087  0 Started by  Woozy I'm looking for some help with an HTTPS POST Response issue. Our company offers Kaiser Permanente (California) as one of our health benefits options for a subset of our workforce.  Kaiser is implementing a new (required) step for employees that elect this plan during the enrollment process.  Basically, if an employee elects the Kaiser plan in ESS, we are required to redirect them to the Kaiser website so they can read and accept/reject their arbitration agreement. The only option...
0 1087
01/22/2014 2:38 PM
2 Replies and 1508 Views LP35 Paint Screen  1508  2 Started by  Chesca My users have asked me to create a paint screen for LP35 to delete records from last year and right now the only way to get rid of them is to delete each line individually. I created the paint screen, I can page fwd and find records but I can't select values in the employee or employee group field. No ecords to select from.
2 1508
by  ChescaJump to last post
01/21/2014 8:34 AM
3 Replies and 1168 Views Working with Messages  1168  3 Started by  BrianM I have created a clone of PA340 and pretty much gutted out what I didn't need.  When I go into pgmdef and go into the message definition for this program I got rid of the messages I didn't need.  My question is this . . . .  the messages that are left are all the messages that were with the original PA340.  Can I just modify the messages OR do I need to leave the existing messages as they are, then create a new message number and make my changes there  I don't want...
3 1168
by  BrianMJump to last post
01/20/2014 2:53 PM
0 Replies and 1011 Views Remove last four digits of SS Nbr From Printable Pay Stub  1011  0 Started by  JimY I have been asked to remove the Social Security number from the Printable Pay Stub.  It is showing the last four digits and they don't want that.  Has anybody done this and would you be willing to share with me how  Thank you.
0 1011
01/16/2014 10:58 AM
2 Replies and 1481 Views date calc API/routine  1481  2 Started by  Chesca Is there a routine/API to return the last day in a given month or return a date such as 1/31/2014
2 1481
by  ChescaJump to last post
01/15/2014 8:37 AM
4 Replies and 3331 Views Barcode on Lawson Printed Form  3331  4 Started by  Robert Spurr Does anyone know if it is possible to include a barcode on a Lawson printed report  In my case they want a barcoded version of the PO Number on the Delivery Document.  I've already look at RAD and it barcodes the tracking number. Thanks
4 3331
by  Robert SpurrJump to last post
01/08/2014 8:52 PM
2 Replies and 2230 Views PGMDEF  2230  2 Started by  Ronnie Is there another area in LID where things are defined for programs inside of LID We have a custom program an ex employee wrote, but are finding lines that say for example PERFORM 780-DISPLAY-MESSAGE but when you look in the program you dont see this defined anywhere. Is there something I am missing I have looked all in the program...all the options, the working storage, etc etc etc. Thoughts
2 2230
by  WoozyJump to last post
01/06/2014 11:26 AM
2 Replies and 1558 Views PA531 - how to change 800-OPENINPUTCSV-APLLOADCSV path and file name  1558  2 Started by  Tim Simmons I know how to assign a path and file name to a PA531 job by using the jobdef CSV File Attributes, but what if the CSV file is dynamically named I need to load a third-party created file of applicants.  The file will be dropped off to our FTP site daily with the date imbedded in the file name. I want to modify the PA531 to read the file based on the run date. How can i handle the file name so the 800-OPENINPUTCSV-APLLOAD can recognize it Thanks for your hel...
2 1558
by  jaherbJump to last post
12/18/2013 11:17 AM
2 Replies and 1463 Views Remove a User Exit  1463  2 Started by  Roger French I've got a User Exit for a program that's linked to a Lawson program. I compiled it OK. Now I don't want to use the user exit any longer. How do I unlink it or 'uncompile' it Do I remove the PD and the WS Or some other step Or do I recompile the Lawson program that uses the User Exit Thank you, Roger
2 1463
by  Roger FrenchJump to last post
12/11/2013 9:08 AM
0 Replies and 1002 Views Ho do you bold a line of text in .rpt  1002  0 Started by  wilcoxmad I need to bold or highlite a line of text on a report. Anybody done that before Thanks.
0 1002
12/05/2013 12:00 PM
2 Replies and 1536 Views Filters  1536  2 Started by  Chesca I have been trying to figure out why my code wouldn't filter transactions with date > given date. It's reading all the transactions, am I misssing something  Here is the code:               MOVE 'FTFLOAT80'       TO WS-ETT-PLAN-NAME               MOVE WR-TEM-COMPANY        TO DB-COMPANY.  &...
2 1536
by  ChescaJump to last post
12/03/2013 3:19 PM
3 Replies and 1319 Views Work file Field Names  1319  3 Started by  Srini Rao We are in process on writing the conversion program for GHR implementation.  GHR needs long filed names like ” ContactDetail.Telephone.InternationalPrefix”. I tried to use 800-OVRDESCCSV- API, but it only uses 35 chars on the override field name.  Is there a way to get big filed names
3 1319
by  jaherbJump to last post
12/03/2013 3:10 PM
1 Replies and 1098 Views Spaces in CSV Headings  1098  1 Started by  Lynne Does anyone know if it's possible in 4GL to put spaces in CSV column headings  For example, I need 'Contract Number' as opposed to 'ContractNumber' for the heading of a column.  I tried using the 800-OVRDESCCSV with spaces, but it doesn't respect them.  Thanks!
1 1098
by  LynneJump to last post
12/03/2013 8:52 AM
4 Replies and 1187 Views Get Field Value Desciptions via Fetch  1187  4 Started by  Woozy I have a table that includes a 'status' field that has a value list with translations defined in dbdef (i.e 0=Entered, 1=Submitted, etc).  If I do a fetch against that table, are the field translations returned as well as the field value For example, if my table is ZZTEST with prefix ZZZ, I can do an 840-FIND-ZZZSET1.  Once I do this, I will be able to do a 'MOVE ZZZ-STATUS TO whatever'.  Is there a way for me to move the translation value as well I know I can do this on a...
4 1187
by  WoozyJump to last post
11/26/2013 1:08 PM
0 Replies and 890 Views Dynamic Key number  890  0 Started by  ARaja Hi, Is there a way to have the dropdowns(Select) dynamically from different tables, depends on one of the input fields. Thanks, Alex
0 890
11/22/2013 10:17 AM
23 Replies and 3132 Views Help finding jobs  3132  23 Started by  Ronnie We had an ex employee who created numerous custom jobs in lawson. (more knowledge than I have in lawson). One program she created was a token called ZZ412 I pull it up and its just a screen to run a job. I can go into LID and pull up this job and the few parameters I can find in jobdef, but is there somewhere in lawson or LID i can go into to actually see what this job is doing or where this job is actually created, what fields it is using etc. Also, is there a way I can see all custom job...
23 3132
by  Greg MoellerJump to last post
11/19/2013 8:59 AM
5 Replies and 1349 Views new 4GL error on portal  1349  5 Started by  MC I wrote a new 4GL program that is working correctly in LID.   I then ran this in portal (it is an online update program against a custom table).   After working with the end users we made a few changes.  I made changes in LID, they are working correctly, but when I run in Portal I am getting: Server Xpress error     java.lang.StringIndexOutOfBoundsException         at java.lang.String.(String.java:176) a...
5 1349
by  MCJump to last post
11/12/2013 7:30 PM
4 Replies and 1236 Views Distinct Value in screen rules  1236  4 Started by  ARaja I have a custom file with three fields in it. All three fields are part of the primary key. I have a selects built that are working but they return all records. Is there a way to return only the distinct list of the first field. So My table has Group, company, and location in it. Currently my selects return every combination in the table. I want to return only a distinct list of group names. So instead of Group1, company1, location1 Group1, company1, location2 Group2, ...... I w...
4 1236
by  ARajaJump to last post
11/12/2013 1:33 PM
4 Replies and 1651 Views database index filter routines  1651  4 Started by  Chesca I am trying to use filters and using sample code in the doc for developers API. But I don't quite understand how to use WS-DB-BEG-RNG or it's purpse. Does it matter if I use company or employee number
4 1651
by  jaherbJump to last post
10/29/2013 11:35 AM
2 Replies and 1257 Views report mode  1257  2 Started by  Chesca I created a custom program (batch update) to update the taeemastr, taemptrans and tatransum files. We are still testing the program and whenever the records are not updating correctly, I have to go back and fix these records using a paint screen. The users mentioned I could run the program in report mode, what does that mean and would I have to change the program type
2 1257
by  ChescaJump to last post
10/18/2013 12:42 PM
1 Replies and 1353 Views Lp180  1353  1 Started by  Chesca I ran LP180 to transfer the Vacation bonus hours to the Vacation plan and it didn’t work. When I look at employees LP64 records the hours are in the bonus plan but when I look at the LP31 records there is no balance in the  vacation bonus plan. Any thoughts
1 1353
by  ChescaJump to last post
10/16/2013 12:58 PM
6 Replies and 1724 Views Add a new column to an existing table while retaining table data  1724  6 Started by  Woozy I have a custom table that has been around for some time.  The business has requested a modification which requires the addition of an additional column to the table.  Can I make this change without losing the existing data in the table  If not, what is the best way to export/import the data that will work with a new table layout By the way, I will be making the table change in DEV which will then be promoted to PROD.  I'm most concerned that the folks who do the promoti...
6 1724
by  WoozyJump to last post
10/15/2013 5:15 PM
2 Replies and 3329 Views GEN/QUEUEDJOB.  3329  2 Started by  Chesca Hello, I am trying to run a job and it hangs. I checked the logs, has anybody seem the following error before and how can I resolve it File GEN/QUEUEDJOB. tsStoreDBRec error is Bad data in field(s) (82). Additional information is 1722. Additional Text is: StoreSqlRec(GEN9.'QUEUEDJOB') OCIStmtExecute() returned OCI_ERROR code 1722 parse offset 30343168 ( ORA-01722: invalid number
2 3329
by  ChescaJump to last post
10/03/2013 9:51 AM
1 Replies and 1270 Views Add workunit filter in workspace inbasket  1270  1 Started by  Jamie Our users would like to have a filter added to the workunit inbasket that will allow them to chose a specific category filter, which is company number in our case. Lawson has provided other filter options like workunit, start date and originator, but not on the filter value column.   We just moved from lawson 8 to 10 and I am not familiar with where the inbasket code is. In 8 there was an inbasket.js file that we modified, but I am unable to find this in 10. Has anyone made thi...
1 1270
by  John HenleyJump to last post
10/03/2013 9:16 AM
2 Replies and 1951 Views Compile Error - WS field not defined in specified WS  1951  2 Started by  Woozy Hi All - this is a strange one. I created a custom library (ZZBNFPD/ZZBNFWS), defined it using libdef so that the PD references the WS.  I then put a call into BNBNFPD to the new library.  The only entry in the custom library (at this moment) is a display statement (DISPLAY 'TEXT').  When I compile the program, it compiles without errors.  If I run the base program, the library is called and the display appears in the log. Next, I tried adding a line to the custom libra...
2 1951
by  WoozyJump to last post
09/26/2013 11:32 AM
2 Replies and 1225 Views Remove Form UserExit?  1225  2 Started by  Woozy I created an 'End' UserExit for a form, and then decided that I need to move that code to a 'Middle' UserExit instead. How do I remove the 'End' UserExit after it was been compiled  I tried deleting the source files and then recompiling with the -u, and that didn't work.   What's the trick Thanks!
2 1225
by  WoozyJump to last post
09/26/2013 10:51 AM
0 Replies and 1398 Views Requisition Approval Inbasket Display Accounting Units  1398  0 Started by  SKMacCauley Issue Description:  Process Flow in-basket display - The requisition approval in-basket display does not show the accounting unit, account and asset template for an asset when the total requisition lines is one but the requisition line number is two. I don't know if it is possible to accomodate this situation with the query that populates the display but if possible it would be nice. I think this is an unintentional error on the part of the requester but it happens sometimes. (Screensho...
0 1398
09/25/2013 10:42 AM
0 Replies and 978 Views Populate Audit Table via BN47 Form UserExit  978  0 Started by  Woozy Our Benefits department has asked us to build a process that will update a custom audit table anytime Beneficiary data is changed via BN47.  This seems like a perfect use for a Form UserExit, but I've never built one of these so I have a question. It seems to me that an 'End' user exit is the logical place to put my logic, since it is after the form  transaction has completed successfully.  However, it appears that when the End UserExit runs, all the LINE-FC values have already...
0 978
09/23/2013 1:11 PM
4 Replies and 2241 Views workdef CSV file Header  2241  4 Started by  Srini Rao Hello, Is their a way to create a mixed case header for csv file using workdef. My vendor wants the field name as 'BatchNumber' but when I can't declare the field name in mixed case in workdef. Thanks
4 2241
by  jaherbJump to last post
09/16/2013 2:53 PM
2 Replies and 1691 Views ESS AGS call in JavaScript not returning data  1691  2 Started by  Shelby Hi, I am trying to copy an existing custom AGS call from elect_benefits.htm to elect_ben_05.htm. We are using ZN31.1 to determine if the Evidence of Insurability (EOI) statement should be displayed. 501 indicates the message should be displayed. In elect_benefits, the returned data is found in self.js1.RtnMsgErrNbr. However, when I step through the code in elect_ben_05, self.js1.RtnMsgErrNbr is undefined. (I can momentarily see the value set as 501 in the Debugging Tool. But when cont...
2 1691
by  ShelbyJump to last post
09/13/2013 3:27 PM
3 Replies and 1356 Views Spawn form from ADD button  1356  3 Started by  Woozy I have a custom S3 form, and I want to 'spawn' a new form when the 'Add' button is clicked, rather than having it add a record as it usually does.  I've spawned forms in the past by adding a button to the body of the form and setting the 'picture' attribute in the .scr to the form name.  Is there a way to do the same thing using the 'Add' button Thanks for your suggestions!  Kelly
3 1356
by  jaherbJump to last post
09/10/2013 6:08 PM
4 Replies and 1295 Views New Section Within a Form Object  1295  4 Started by  Woozy I have a custom form object (ZJ35) that includes two forms (ZJ35.1 and ZJ35.2).  I'm trying to add a custom section within the object that I can reference from both forms - similar to referencing an external library.  However, I keep getting an error on compile: Warning: Illegal PERFORM: Referenced LABEL Not In SECTION Warning:           LABEL: 3000-GET-LAST-PERIOD-PROCESSED Warning:     Source Line: 403 As far as I can tell, I have the ...
4 1295
by  WoozyJump to last post
09/10/2013 1:17 PM
1 Replies and 1259 Views LP accrual rounding issue  1259  1 Started by  Chesca Hello, how could I get the accrual to round correctly  The accrual calculated amount showing as 7.499700 (LP64) and we'd like to round to 7.500000 hours. LP02 screen: HOurs Method = 1 Round to .000001
1 1259
by  jaherbJump to last post
08/27/2013 5:34 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 1 of 3123 > >>


RSS Feed Available