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 735 Views prmpassed in custom Display Exec    735  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 735
06/19/2018 2:08 PM
0 Replies and 976 Views Add HR11 (Assignment tab) Location field to ESS    976  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 976
06/13/2017 3:47 PM
1 Replies and 6064 Views Forcing ERROR from User Exit    6064  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 6064
by  ArthurThumJump to last post
06/19/2014 11:23 PM
11 Replies and 12798 Views ESS - direct URL link to feature    12798  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 12798
by  Moe AframJump to last post
05/29/2013 12:52 PM
0 Replies and 41 Views Report can't run in LBI  41  0 Started by  LauraPat HI - I need some help.  I had to create a cloned version of the Lawson IC145 in order to add additional fields to the report (I&39;m making an invoke to IC44 to grab the calculated fields that I need and displaying them onto the report).  The report works fine - the users have been running it for a couple weeks now in Portal.  However, they want to put this report on LBI and they keep getting an error that the report cannot be burst.  The user opened up a ticket with Infor w...
0 41
03/27/2020 11:00 AM
8 Replies and 781 Views Custom IC145 - Pandemic Reporting  781  8 Started by  LauraPat Good Morning - wondering if anyone has already done this before I "reinvent the wheel".  I&39;ve been asked to add Current Average Daily Usage and Current Day&39;s Supply On Hand to the existing Lawson-delivered IC145 report in order to do Pandemic reporting.  These fields are visible in IC44 form but according to Infor Support they are not included in any delivered report.  Because of the emergency need for Pandemic reporting - looking up every time individu...
8 781
by  LauraPatJump to last post
03/10/2020 9:34 AM
1 Replies and 334 Views IOS error on AGS calls  334  1 Started by  Ragu Raghavan Env 10.0.9, Windows Apps: 10.0.MSP7 so I have this new custom 4GL screen. Works in LID and Portal. However when I try to do an AGS call from Design Studio or IPD, it bombs with a message : Check IOS.log for details. The log has these entries. Can anybody point me to where I should be troubleshooting I am able to do AGS calls on other screens, Lawson delivered or custom. Just this one screen bombs. Thanks.   2020-02-26 11:14:05,266 ERROR &91;WebContainer : 0&93; &91;lawson...
1 334
by  Ragu RaghavanJump to last post
02/26/2020 11:56 AM
1 Replies and 707 Views How to find where invoked code is called  707  1 Started by  LauraPat We have a custom library that is a clone of a Lawson-delivered program.  It is invoked from within one of our custom programs - but we don&39;t seem to know where so we aren&39;t sure it is even needed anymore.  Can someone please refresh my memory on how to tell where the program is invoked from  I believe you do it using the "lstinvk" command and possibly the "-A" option  I don&39;t want to submit any compiles - I just want to determine what program...
1 707
by  Ragu RaghavanJump to last post
01/13/2020 11:31 AM
0 Replies and 494 Views Handling Unpaid Time in Payroll Processing  494  0 Started by  maalimsimo We have been having just a handful of employees with Unpaid Time hours each payroll and so it has been handled manually through PR36 fairly well. Now we need the process automated. We have set up a Pay Code (615) for Unpaid Time, presently as 'Hours Only' in PR20.4.  What we need is to somehow reduce the Regular Hours (and the Wages) by the Unpaid Hours. PR User Guide states that PR28 can be set up to create an 'Offset Rule' for the Salaried Employee group and run PR128 during the payro...
0 494
08/28/2019 9:30 AM
6 Replies and 2062 Views Does anyone know how to run the VisualCOBOL debugger on a remote machine?  2062  6 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
6 2062
by  PatoJump to last post
08/12/2019 8:54 AM
0 Replies and 485 Views Default search field in AP20 drill around  485  0 Started by  Alex Our AP team came to me requesting an update to the Purchase Order drill around within AP20. Currently, when you drill into the PO field and attempt to do a search, it defaults the search field to '*Code'. To save a few clicks, the team would like for it to default to Purchase Order instead.   I attempted going into AP.sr and changing the DEFINE SELECT      'Released Purchase Orders By PO Code' sections to re-order the fields. It looks like the change did apply successf...
0 485
08/06/2019 3:53 PM
1 Replies and 453 Views Database Inquiry using 850-FIND-NLT-<index> returns the 'Next' record  453  1 Started by  maalimsimo I have created a new custom index to a custom table to access records through either 850-FIND-NLT- or 850-FIND-BEGRNG-.   The index has 2 numeric fields,one PIC 9(4)) and the other PIC 9(8) for date (format YYYMMDD). The next to last field is a PIC X(32) for names (e.g 'Adam Smith'), and the last field is numeric that I move zeroes as I populate the index:   MOVE STL-DIVISION              TO DB-DIVISION. MOVE STL-PAYROLL-DATE    TO DB-P...
1 453
by  Ragu RaghavanJump to last post
08/01/2019 10:27 AM
0 Replies and 609 Views PHP scripts  609  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 609
05/14/2019 12:36 PM
1 Replies and 1042 Views DBREORG failed: file already exists  1042  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 1042
by  JimYJump to last post
04/02/2019 11:04 AM
1 Replies and 770 Views loadrpts.cfg - does anyone have any information on it?  770  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 770
by  SWilkinsJump to last post
03/25/2019 11:50 AM
8 Replies and 2701 Views New Report Added to Custom Report Program  2701  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 2701
by  maalimsimoJump to last post
02/01/2019 10:42 AM
2 Replies and 1512 Views 508 file type  1512  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 1512
by  Russell EJump to last post
07/10/2018 4:18 PM
2 Replies and 1202 Views Calling perl script from Cobol program  1202  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 1202
by  maalimsimoJump to last post
06/12/2018 12:46 PM
1 Replies and 2485 Views Customizing PR195  2485  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 2485
by  Ragu RaghavanJump to last post
02/08/2018 3:25 PM
0 Replies and 670 Views Customizing PR195  670  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 670
02/08/2018 12:04 PM
7 Replies and 2198 Views Custom Lawson tables using Addins  2198  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 2198
by  JudeBacJump to last post
02/06/2018 4:19 PM
6 Replies and 8105 Views How do I generate CSV output from batch program?  8105  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 8105
by  PDJump to last post
12/20/2017 9:59 AM
5 Replies and 4501 Views how to call UNIX script from tokendef  4501  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 4501
by  JaphethJump to last post
10/02/2017 12:19 PM
0 Replies and 1235 Views LSO Scripting for newbie  1235  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 1235
09/28/2017 11:11 AM
1 Replies and 2648 Views Jobdef Job Not Found error  2648  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 2648
by  maalimsimoJump to last post
09/26/2017 1:39 PM
3 Replies and 3211 Views Paint Screen - Job Title retrieval for job-code  3211  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 3211
by  Ragu RaghavanJump to last post
08/04/2017 9:41 AM
5 Replies and 7041 Views Org Chart  7041  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 7041
by  Cheri AzereixJump to last post
06/20/2017 11:54 AM
1 Replies and 2532 Views Portal changes location of literal  2532  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 2532
by  Stuart PerkinsJump to last post
06/19/2017 1:01 PM
0 Replies and 880 Views Customizations  880  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 880
05/22/2017 3:13 PM
7 Replies and 9098 Views Distribution Group  9098  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 9098
by  mthedfordJump to last post
05/04/2017 1:52 PM
2 Replies and 2537 Views Add Custom Tables to Lawson Data Dictionary  2537  2 Started by  Lawson_Tech Any KBs please post to me 'Add Custom Tables to Lawson Data Dictionary'
2 2537
by  Kwane McNealJump to last post
04/10/2017 3:28 PM
0 Replies and 833 Views Question on Custom Table with Unique-ID field  833  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 833
04/06/2017 6:58 AM
1 Replies and 2662 Views Labels on Zebra printer  2662  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 2662
by  LauraPatJump to last post
03/30/2017 12:35 PM
0 Replies and 927 Views File Status Codes  927  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 927
03/02/2017 10:40 AM
9 Replies and 6547 Views User Exit Eamples--  6547  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 6547
by  jaherbJump to last post
02/24/2017 12:47 PM
1 Replies and 2361 Views Print labels via custom batch program  2361  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 2361
by  Ragu RaghavanJump to last post
02/23/2017 9:00 AM
1 Replies and 3184 Views jobs in waiting recovery  3184  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 3184
by  JimYJump to last post
02/20/2017 9:55 AM
2 Replies and 2697 Views Meaning of File Status 9-230  2697  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 2697
by  ALBJump to last post
02/17/2017 8:07 AM
1 Replies and 2492 Views Customized EMSS bookmarks - caching issues  2492  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 2492
by  CindyWJump to last post
02/09/2017 1:04 PM
1 Replies and 2788 Views Program compiled w/ trace  2788  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 2788
by  LynneJump to last post
01/24/2017 2:58 PM
2 Replies and 3147 Views Rel 10 4GL Error  3147  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 3147
by  jaherbJump to last post
01/18/2017 9:04 AM
2 Replies and 4071 Views Infor10 Mingle Login Screen Customization  4071  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 4071
by  JimYJump to last post
12/15/2016 10:32 AM
7 Replies and 4068 Views Has anyone successfully parsed out job parameters from the GEN(LAW).JOBSTEP table?  4068  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 4068
by  John HenleyJump to last post
12/09/2016 2:13 PM
6 Replies and 3452 Views Form/.scr help!!  3452  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 3452
by  LauraPatJump to last post
10/07/2016 7:43 AM
4 Replies and 4771 Views Print manager files  4771  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 4771
by  ALBJump to last post
09/28/2016 1:42 PM
6 Replies and 3472 Views Fld Err: Decimal Field's Display Length 0  3472  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 3472
by  pgallucci12Jump to last post
09/23/2016 5:39 PM
3 Replies and 3077 Views State Tax Form  3077  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 3077
by  Jeff ShumateJump to last post
09/23/2016 4:23 PM
1 Replies and 6143 Views Lawson APIs  6143  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 6143
by  Joe CareyJump to last post
09/17/2016 10:38 AM
4 Replies and 2995 Views CSV File  2995  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 2995
by  jaherbJump to last post
09/06/2016 1:21 PM
3 Replies and 3153 Views Tab delimited  3153  3 Started by  Srini Rao Is it possible to create the TAB delimited output using the 4GL program
3 3153
by  Karen SheridanJump to last post
09/02/2016 9:00 AM
2 Replies and 2713 Views animating a lawson online screen  2713  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 2713
by  ChescaJump to last post
08/30/2016 3:08 PM
1 Replies and 2922 Views Second Report to Print Manager  2922  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 2922
by  LauraPatJump to last post
08/18/2016 11:20 AM
2 Replies and 2901 Views Lawson Rel 10  2901  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 2901
by  jaherbJump to last post
08/18/2016 9:32 AM
0 Replies and 1136 Views Chrome loading pages on custom ESS  1136  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 1136
08/15/2016 10:02 AM
6 Replies and 2992 Views IE11 Form Messages  2992  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 2992
by  Greg MoellerJump to last post
08/03/2016 12:58 PM
5 Replies and 3512 Views waiting recovery  3512  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 3512
by  TBonneyJump to last post
07/27/2016 7:33 AM
0 Replies and 894 Views waiting recovery  894  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 894
07/26/2016 11:06 AM
3 Replies and 3199 Views Microfocus  3199  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 3199
by  LauraPatJump to last post
06/30/2016 7:44 AM
0 Replies and 1218 Views How Find Programs That Use Specific Screen Rule?  1218  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 1218
06/24/2016 11:06 AM
2 Replies and 2966 Views Using current date in if statement  2966  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 2966
by  Jessica MJump to last post
06/22/2016 2:38 PM
6 Replies and 3470 Views calculate the last day of any month  3470  6 Started by  Chesca Is there an API I could use to calculate the last day of any month  
6 3470
by  kimJump to last post
06/16/2016 12:20 PM
1 Replies and 2877 Views Compile Error  2877  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 2877
by  jaherbJump to last post
06/13/2016 3:15 PM
6 Replies and 4407 Views 0 instead of blanks in CSV file  4407  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 4407
by  David@SOMJump to last post
06/03/2016 1:12 PM
6 Replies and 6740 Views Web service calls *FROM* Lawson  6740  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 6740
by  Jason BeardJump to last post
05/25/2016 9:29 PM
3 Replies and 2952 Views New custom program  2952  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 2952
by  Jason BeardJump to last post
05/25/2016 9:04 PM
0 Replies and 1263 Views Portal Page for Workunits  1263  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 1263
05/18/2016 1:56 PM
2 Replies and 3169 Views tsBeginDBTransaction error is Operation illegal while in transaction (20).  3169  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 3169
by  LilybJump to last post
05/12/2016 6:52 PM
3 Replies and 3185 Views Best practice of copying a program  3185  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 3185
by  jaherbJump to last post
05/12/2016 9:53 AM
1 Replies and 3953 Views Best (certified) Lawson Development Partner for S3 and/or M3  3953  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 3953
by  shahzadJump to last post
05/03/2016 3:01 AM
2 Replies and 3048 Views Comment Attachment Processing compile error  3048  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 3048
by  John DesmaraisJump to last post
04/07/2016 10:49 AM
14 Replies and 4155 Views Extract File Issues  4155  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 4155
by  jaherbJump to last post
04/01/2016 11:52 AM
0 Replies and 1198 Views Lawson Portal automated access and session handling  1198  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 1198
03/29/2016 2:18 PM
3 Replies and 4163 Views Oracle SQL reformat date  4163  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 4163
by  ChescaJump to last post
03/01/2016 3:23 PM
4 Replies and 3294 Views Input date validation  3294  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 3294
by  ChescaJump to last post
02/10/2016 7:39 AM
6 Replies and 5333 Views Cannot replace my own custom form  5333  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 5333
by  John HenleyJump to last post
02/05/2016 2:07 PM
2 Replies and 15542 Views SQL question on APINVOICE, APDISTRIB, APPAYMENT  15542  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 15542
by  ChescaJump to last post
01/28/2016 2:52 PM
0 Replies and 1487 Views lawson 10 ESS theme 10.3 override  1487  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 1487
01/27/2016 2:49 PM
6 Replies and 3752 Views Windows script to do rnddbdump to file  3752  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 3752
by  pbelskyJump to last post
01/19/2016 4:36 PM
12 Replies and 4335 Views Missing data in modified CSV error report after promotion  4335  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 4335
by  pbelskyJump to last post
01/07/2016 5:46 PM
4 Replies and 3804 Views RECDEF  3804  4 Started by  Chesca Can I create a paintscreen program to access recdef 
4 3804
by  Kwane McNealJump to last post
11/30/2015 1:06 PM
3 Replies and 3784 Views Scheduling job automatically with dynamic date range  3784  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 3784
by  Vijay SJump to last post
11/25/2015 2:35 AM
2 Replies and 2923 Views Database reads INTO a unique working storage area  2923  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 2923
by  Todd MitchellJump to last post
11/19/2015 3:53 PM
5 Replies and 3371 Views Add columns to report csv beyond the print report width limit  3371  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 3371
by  jaherbJump to last post
11/17/2015 4:21 PM
6 Replies and 3604 Views Best Way to add spaces in Header of a CSV file via batch Program  3604  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 3604
by  Vijay SJump to last post
11/17/2015 5:07 AM
3 Replies and 5034 Views How to look up field name from field number.  5034  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 5034
by  Kat VJump to last post
10/09/2015 3:52 PM
4 Replies and 3838 Views work file def  3838  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 3838
by  jaherbJump to last post
10/09/2015 10:36 AM
1 Replies and 3111 Views work file def  3111  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 3111
by  jaherbJump to last post
10/09/2015 10:33 AM
1 Replies and 3343 Views Use negative values returned from DME call ?  3343  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 3343
by  mikePJump to last post
10/02/2015 2:11 PM
5 Replies and 3588 Views 4GL Report missing Company Name  3588  5 Started by  Demi 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 3588
by  DemiJump to last post
09/29/2015 9:04 AM
0 Replies and 1622 Views Redirect WWW Usl to Mingle  1622  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 1622
09/25/2015 5:00 PM
3 Replies and 3577 Views programming error  3577  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 3577
by  ChescaJump to last post
09/21/2015 3:03 PM
10 Replies and 5913 Views ESS new custom form  5913  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 5913
by  ChescaJump to last post
09/21/2015 2:41 PM
3 Replies and 3561 Views How to determine if string is numeric?  3561  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 3561
by  Vijay SJump to last post
09/15/2015 6:09 AM
4 Replies and 4994 Views Table for recurring job (Recdef)  4994  4 Started by  Vijay S Any guess, which GEN table store's recurring job definition
4 4994
by  Vijay SJump to last post
09/11/2015 7:41 AM
3 Replies and 3284 Views 4GL Versus HTML/JAVA  3284  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 3284
by  WoozyJump to last post
09/10/2015 9:19 AM
8 Replies and 6695 Views Extract program version numbers  6695  8 Started by  Demi 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 6695
by  KrisJump to last post
09/08/2015 12:13 PM
1 Replies and 3310 Views Multiple Report COBOL  3310  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 3310
by  ALBJump to last post
08/28/2015 5:43 PM
0 Replies and 1437 Views Custom application not displaying text fields on next\previous  1437  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 1437
08/19/2015 2:45 PM
7 Replies and 5668 Views Windows DOS script  5668  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 5668
by  R Wayne WalkerJump to last post
07/30/2015 10:51 AM
1 Replies and 3441 Views Pop-up Text Message in AP20.1  3441  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 3441
by  maalimsimoJump to last post
07/28/2015 4:26 PM
5 Replies and 3800 Views Changing a custom index to Key Change=Yes?  3800  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 3800
by  WoozyJump to last post
07/28/2015 9:40 AM
1 Replies and 3096 Views ESS/MSS Changes  3096  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 3096
by  bdJump to last post
07/08/2015 9:04 AM
1 Replies and 3364 Views How to Left Align Output Fields  3364  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 3364
by  jaherbJump to last post
06/25/2015 1:54 PM
4 Replies and 3590 Views Batch animator  3590  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 3590
by  ChescaJump to last post
06/24/2015 2:19 PM
11 Replies and 6305 Views HR11 AGS call  6305  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 6305
by  Tim CochraneJump to last post
06/09/2015 6:15 PM
0 Replies and 1668 Views SharePoint integration 9.0.x  1668  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 1668
05/05/2015 5:43 PM
3 Replies and 3833 Views Report archiving/emailing  3833  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 3833
by  mikePJump to last post
04/17/2015 1:04 PM
2 Replies and 3902 Views compiling error after copying a program  3902  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 3902
by  ChescaJump to last post
03/11/2015 10:59 AM
3 Replies and 3907 Views ESS - Org Chart - Hide an employee from ESS Org Chart based on their Process Level and Department  3907  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 3907
by  John HenleyJump to last post
03/02/2015 2:53 PM
0 Replies and 1660 Views This page cannot be displayed in a frame sharepoint 2013  1660  0 Started by  Ann I'm not sure how to display the webpage without having to click on the link.
0 1660
01/26/2015 2:45 PM
4 Replies and 4891 Views Advice on COBOL training  4891  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 4891
by  Scott PerrierJump to last post
01/20/2015 9:59 AM
3 Replies and 18054 Views Using wildcard in DME query  18054  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 18054
by  Deleted UserJump to last post
01/13/2015 9:45 AM
7 Replies and 4140 Views PF Eclipse designer will not initiate  4140  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 4140
by  MCJump to last post
01/07/2015 6:43 AM
7 Replies and 4809 Views Can I leverage relations in COBOL query?  4809  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 4809
by  WoozyJump to last post
12/12/2014 10:39 AM
11 Replies and 4237 Views DME call and Javascript  4237  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 4237
by  mikePJump to last post
11/18/2014 5:12 PM
3 Replies and 2507 Views ESS - Hide buttons  2507  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 2507
by  MikeDJump to last post
11/13/2014 2:08 PM
2 Replies and 2680 Views Custom code to find a previous record  2680  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 2680
by  WoozyJump to last post
11/04/2014 3:50 PM
4 Replies and 2848 Views ESS label description change  2848  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 2848
by  ChescaJump to last post
10/27/2014 3:15 PM
4 Replies and 2744 Views Proxy as another user in LSF9 Portal and/or EMSS  2744  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 2744
by  WoozyJump to last post
10/24/2014 3:02 PM
10 Replies and 2581 Views Perplexed by LAWSON  2581  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 2581
by  Jason BeardJump to last post
10/23/2014 9:35 PM
0 Replies and 1239 Views html page in Lawson  1239  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 1239
10/19/2014 8:48 AM
7 Replies and 3203 Views Call a Process Flow from within JavaScript  3203  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 3203
by  JimYJump to last post
10/17/2014 3:49 PM
0 Replies and 2661 Views Windows AD and useratts.htm  2661  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 2661
10/10/2014 2:40 PM
1 Replies and 1760 Views RQC version 10  1760  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 1760
by  Scott PerrierJump to last post
10/08/2014 3:49 PM
7 Replies and 4413 Views Looking for Lawson API Listing  4413  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 4413
by  jaherbJump to last post
10/06/2014 11:04 AM
0 Replies and 1390 Views USERPROFILE  1390  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 1390
09/18/2014 3:56 PM
1 Replies and 1800 Views vbscript and ags  1800  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 1800
by  John HenleyJump to last post
09/17/2014 5:09 PM
1 Replies and 1421 Views Shrinking fields  1421  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 1421
by  RitaJump to last post
09/17/2014 12:21 PM
4 Replies and 1667 Views two forms in one program  1667  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 1667
by  WoozyJump to last post
09/15/2014 3:12 PM
12 Replies and 4646 Views Job fails to kick off FTP script - unable to log in user/startstep failed  4646  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 4646
by  cpaine216Jump to last post
09/15/2014 9:28 AM
1 Replies and 1821 Views Adding fields to form  1821  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 1821
by  jaherbJump to last post
09/11/2014 11:16 AM
1 Replies and 1458 Views Painting with alternate index  1458  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 1458
by  RitaJump to last post
09/09/2014 3:16 PM
3 Replies and 1875 Views API  1875  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 1875
by  jaherbJump to last post
09/08/2014 12:36 PM
3 Replies and 1732 Views random alphanumeric string  1732  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 1732
by  Scott PerrierJump to last post
08/29/2014 2:03 PM
1 Replies and 1642 Views Infor graphic replacement on Login page  1642  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 1642
by  Srini RaoJump to last post
08/29/2014 8:41 AM
0 Replies and 1342 Views What is $AUDFORM in the .scr file do?  1342  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 1342
08/27/2014 2:19 PM
2 Replies and 1397 Views Process level changes  1397  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 1397
by  jaherbJump to last post
08/25/2014 10:08 AM
1 Replies and 1905 Views Javascript AGS call with Next  1905  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 1905
by  WoozyJump to last post
08/20/2014 5:12 PM
1 Replies and 1593 Views LP program syntax error  1593  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 1593
by  ChescaJump to last post
08/11/2014 3:18 PM
2 Replies and 1693 Views File dump  1693  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 1693
by  ChescaJump to last post
07/29/2014 1:23 PM
8 Replies and 1906 Views MSS - Customizations  1906  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 1906
by  Chris12Jump to last post
07/28/2014 1:44 PM
3 Replies and 1514 Views Deprecated 515-UPDATE-DATE-TIME api  1514  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 1514
by  jaherbJump to last post
07/24/2014 9:33 AM
5 Replies and 1489 Views ESS screen welcome screen  1489  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 1489
by  ChescaJump to last post
07/23/2014 2:17 PM
9 Replies and 10750 Views ESS Benefits Enrollment - My DME and AGS calls Not Working  10750  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 10750
by  Judy ConsoliJump to last post
07/03/2014 10:32 AM
0 Replies and 1019 Views v10 how to define window for comments  1019  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 1019
06/24/2014 9:31 AM
3 Replies and 1581 Views Create var length recs  1581  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 1581
by  jaherbJump to last post
06/24/2014 9:25 AM
2 Replies and 1447 Views scan programs  1447  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 1447
by  WoozyJump to last post
06/23/2014 12:53 PM
1 Replies and 1638 Views Set up ESS Benefits Enrollment for a Medical Plan Spousal Surcharge  1638  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 1638
by  Karen SheridanJump to last post
06/13/2014 10:38 AM
5 Replies and 1724 Views CSV file read error  1724  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 1724
by  jaherbJump to last post
06/12/2014 3:28 PM
4 Replies and 1962 Views Publish Non-Lawson Report to Print Manager?  1962  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 1962
by  Greg MoellerJump to last post
05/22/2014 4:30 PM
3 Replies and 2300 Views .aif file  2300  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 2300
by  jaherbJump to last post
05/14/2014 5:22 PM
3 Replies and 3668 Views Work File error  3668  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 3668
by  jaherbJump to last post
05/08/2014 11:24 AM
3 Replies and 1816 Views Mosby Skills Interface  1816  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 1816
by  The.Sam.GrovesJump to last post
04/08/2014 11:11 AM
2 Replies and 1484 Views What are cnvscr.detail and cnvscr.out?  1484  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 1484
by  WoozyJump to last post
04/04/2014 3:07 PM
4 Replies and 4366 Views error message text not found  4366  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 4366
by  BrianMJump to last post
04/02/2014 3:55 PM
1 Replies and 1567 Views Associating Smart Office Script with the S3 Form  1567  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 1567
by  L GJump to last post
04/02/2014 6:39 AM
3 Replies and 1747 Views Script to email report from custom program - report incomplete  1747  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 1747
by  jaherbJump to last post
03/27/2014 11:18 AM
2 Replies and 1734 Views Multiple rows of comments  1734  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 1734
by  ChescaJump to last post
03/13/2014 2:01 PM
5 Replies and 1996 Views PRTIME  1996  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 1996
by  ChescaJump to last post
03/10/2014 7:03 AM
1 Replies and 1943 Views can't run/submit any jobs  1943  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 1943
by  ChescaJump to last post
03/07/2014 2:00 PM
1 Replies and 1759 Views HR11 AGS Call User Fields  1759  1 Started by  Judy Consoli Has anyone used the AGS call from html/javascript for updating fields on the User Field Tab
1 1759
by  John HenleyJump to last post
03/01/2014 7:03 AM
3 Replies and 2291 Views Employee Status change  2291  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 2291
by  jaherbJump to last post
02/27/2014 5:14 PM
6 Replies and 10259 Views Help accessing data returned by a DME call  10259  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 10259
by  ShelbyJump to last post
02/26/2014 3:52 PM
7 Replies and 3387 Views 4GL command button to launch HR13.3  3387  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 3387
by  jaherbJump to last post
02/21/2014 3:30 PM
2 Replies and 1927 Views dburf on custom paint program  1927  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 1927
by  jaherbJump to last post
02/20/2014 9:32 AM
2 Replies and 1627 Views Absence Management  1627  2 Started by  Chesca Does anybody know what table or screen would tell me if an employee is enrolled in absence plan/structure
2 1627
by  ChescaJump to last post
02/20/2014 8:19 AM
17 Replies and 3068 Views .scr file modifications  3068  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 3068
by  jaherbJump to last post
02/13/2014 5:02 PM
2 Replies and 1661 Views Effective date the employee became benefit eligible  1661  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 1661
by  ChescaJump to last post
02/10/2014 11:58 AM
7 Replies and 1941 Views Sort File for Online Update Form?  1941  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 1941
by  jaherbJump to last post
02/06/2014 1:07 PM
2 Replies and 1582 Views Calculate prior year  1582  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 1582
by  ChescaJump to last post
02/05/2014 2:21 PM
3 Replies and 4744 Views HTML/Javascript DME function for LOGAN  4744  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 4744
by  Scott PerrierJump to last post
01/31/2014 11:23 AM
5 Replies and 2193 Views Double Quotes on Empty fields in 4gl CSV file  2193  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 2193
by  Donna WirtJump to last post
01/30/2014 1:37 PM
0 Replies and 1779 Views .Net 4.5 SSO / Authentication to Lawson 9 or 10.0 Request for Examples  1779  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 1779
01/30/2014 8:05 AM
4 Replies and 1885 Views HRHISTORY  1885  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 1885
by  jaherbJump to last post
01/28/2014 10:24 AM
0 Replies and 1370 Views HTTPS Post Response - Kaiser CAMS  1370  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 1370
01/22/2014 2:38 PM
2 Replies and 1851 Views LP35 Paint Screen  1851  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 1851
by  ChescaJump to last post
01/21/2014 8:34 AM
3 Replies and 1430 Views Working with Messages  1430  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 1430
by  BrianMJump to last post
01/20/2014 2:53 PM
0 Replies and 1264 Views Remove last four digits of SS Nbr From Printable Pay Stub  1264  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 1264
01/16/2014 10:58 AM
2 Replies and 1730 Views date calc API/routine  1730  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 1730
by  ChescaJump to last post
01/15/2014 8:37 AM
4 Replies and 3697 Views Barcode on Lawson Printed Form  3697  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 3697
by  Robert SpurrJump to last post
01/08/2014 8:52 PM
2 Replies and 2546 Views PGMDEF  2546  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 2546
by  WoozyJump to last post
01/06/2014 11:26 AM
2 Replies and 1786 Views PA531 - how to change 800-OPENINPUTCSV-APLLOADCSV path and file name  1786  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 1786
by  jaherbJump to last post
12/18/2013 11:17 AM
2 Replies and 1774 Views Remove a User Exit  1774  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 1774
by  Roger FrenchJump to last post
12/11/2013 9:08 AM
0 Replies and 1199 Views Ho do you bold a line of text in .rpt  1199  0 Started by  wilcoxmad I need to bold or highlite a line of text on a report. Anybody done that before Thanks.
0 1199
12/05/2013 12:00 PM
2 Replies and 1771 Views Filters  1771  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 1771
by  ChescaJump to last post
12/03/2013 3:19 PM
3 Replies and 1550 Views Work file Field Names  1550  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 1550
by  jaherbJump to last post
12/03/2013 3:10 PM
1 Replies and 1324 Views Spaces in CSV Headings  1324  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 1324
by  LynneJump to last post
12/03/2013 8:52 AM
4 Replies and 1379 Views Get Field Value Desciptions via Fetch  1379  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 1379
by  WoozyJump to last post
11/26/2013 1:08 PM
0 Replies and 1083 Views Dynamic Key number  1083  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 1083
11/22/2013 10:17 AM
23 Replies and 3567 Views Help finding jobs  3567  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 3567
by  Greg MoellerJump to last post
11/19/2013 8:59 AM
5 Replies and 1637 Views new 4GL error on portal  1637  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 1637
by  MCJump to last post
11/12/2013 7:30 PM
4 Replies and 1467 Views Distinct Value in screen rules  1467  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 1467
by  ARajaJump to last post
11/12/2013 1:33 PM
4 Replies and 1881 Views database index filter routines  1881  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 1881
by  jaherbJump to last post
10/29/2013 11:35 AM
2 Replies and 1453 Views report mode  1453  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 1453
by  ChescaJump to last post
10/18/2013 12:42 PM
1 Replies and 1583 Views Lp180  1583  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 1583
by  ChescaJump to last post
10/16/2013 12:58 PM
6 Replies and 2006 Views Add a new column to an existing table while retaining table data  2006  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 2006
by  WoozyJump to last post
10/15/2013 5:15 PM
2 Replies and 3851 Views GEN/QUEUEDJOB.  3851  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 3851
by  ChescaJump to last post
10/03/2013 9:51 AM
1 Replies and 1525 Views Add workunit filter in workspace inbasket  1525  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 1525
by  John HenleyJump to last post
10/03/2013 9:16 AM
2 Replies and 2233 Views Compile Error - WS field not defined in specified WS  2233  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 2233
by  WoozyJump to last post
09/26/2013 11:32 AM
2 Replies and 1475 Views Remove Form UserExit?  1475  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 1475
by  WoozyJump to last post
09/26/2013 10:51 AM
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