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 493 Views prmpassed in custom Display Exec    493  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 493
06/19/2018 2:08 PM
0 Replies and 823 Views Add HR11 (Assignment tab) Location field to ESS    823  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 823
06/13/2017 3:47 PM
1 Replies and 5889 Views Forcing ERROR from User Exit    5889  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 5889
by  ArthurThumJump to last post
06/19/2014 11:23 PM
11 Replies and 12480 Views ESS - direct URL link to feature    12480  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 12480
by  Moe AframJump to last post
05/29/2013 12:52 PM
0 Replies and 207 Views Handling Unpaid Time in Payroll Processing  207  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 207
08/28/2019 9:30 AM
6 Replies and 1791 Views Does anyone know how to run the VisualCOBOL debugger on a remote machine?  1791  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 1791
by  PatoJump to last post
08/12/2019 8:54 AM
0 Replies and 208 Views Default search field in AP20 drill around  208  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 208
08/06/2019 3:53 PM
1 Replies and 274 Views Database Inquiry using 850-FIND-NLT-<index> returns the 'Next' record  274  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 274
by  Ragu RaghavanJump to last post
08/01/2019 10:27 AM
0 Replies and 343 Views PHP scripts  343  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 343
05/14/2019 12:36 PM
1 Replies and 798 Views DBREORG failed: file already exists  798  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 798
by  JimYJump to last post
04/02/2019 11:04 AM
1 Replies and 592 Views loadrpts.cfg - does anyone have any information on it?  592  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 592
by  SWilkinsJump to last post
03/25/2019 11:50 AM
8 Replies and 1016 Views New Report Added to Custom Report Program  1016  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 1016
by  maalimsimoJump to last post
02/01/2019 10:42 AM
2 Replies and 1366 Views 508 file type  1366  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 1366
by  Russell EJump to last post
07/10/2018 4:18 PM
2 Replies and 986 Views Calling perl script from Cobol program  986  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 986
by  maalimsimoJump to last post
06/12/2018 12:46 PM
1 Replies and 2324 Views Customizing PR195  2324  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 2324
by  Ragu RaghavanJump to last post
02/08/2018 3:25 PM
0 Replies and 513 Views Customizing PR195  513  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 513
02/08/2018 12:04 PM
7 Replies and 1983 Views Custom Lawson tables using Addins  1983  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 1983
by  JudeBacJump to last post
02/06/2018 4:19 PM
6 Replies and 7877 Views How do I generate CSV output from batch program?  7877  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 7877
by  PDJump to last post
12/20/2017 9:59 AM
5 Replies and 4155 Views how to call UNIX script from tokendef  4155  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 4155
by  JaphethJump to last post
10/02/2017 12:19 PM
0 Replies and 1023 Views LSO Scripting for newbie  1023  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 1023
09/28/2017 11:11 AM
1 Replies and 2426 Views Jobdef Job Not Found error  2426  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 2426
by  maalimsimoJump to last post
09/26/2017 1:39 PM
3 Replies and 3014 Views Paint Screen - Job Title retrieval for job-code  3014  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 3014
by  Ragu RaghavanJump to last post
08/04/2017 9:41 AM
5 Replies and 6857 Views Org Chart  6857  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 6857
by  Cheri AzereixJump to last post
06/20/2017 11:54 AM
1 Replies and 2384 Views Portal changes location of literal  2384  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 2384
by  Stuart PerkinsJump to last post
06/19/2017 1:01 PM
0 Replies and 736 Views Customizations  736  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 736
05/22/2017 3:13 PM
7 Replies and 8761 Views Distribution Group  8761  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 8761
by  mthedfordJump to last post
05/04/2017 1:52 PM
2 Replies and 2384 Views Add Custom Tables to Lawson Data Dictionary  2384  2 Started by  Lawson_Tech Any KBs please post to me 'Add Custom Tables to Lawson Data Dictionary'
2 2384
by  Kwane McNealJump to last post
04/10/2017 3:28 PM
0 Replies and 675 Views Question on Custom Table with Unique-ID field  675  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 675
04/06/2017 6:58 AM
1 Replies and 2499 Views Labels on Zebra printer  2499  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 2499
by  LauraPatJump to last post
03/30/2017 12:35 PM
0 Replies and 789 Views File Status Codes  789  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 789
03/02/2017 10:40 AM
9 Replies and 6315 Views User Exit Eamples--  6315  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 6315
by  jaherbJump to last post
02/24/2017 12:47 PM
1 Replies and 2226 Views Print labels via custom batch program  2226  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 2226
by  Ragu RaghavanJump to last post
02/23/2017 9:00 AM
1 Replies and 2949 Views jobs in waiting recovery  2949  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 2949
by  JimYJump to last post
02/20/2017 9:55 AM
2 Replies and 2552 Views Meaning of File Status 9-230  2552  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 2552
by  ALBJump to last post
02/17/2017 8:07 AM
1 Replies and 2281 Views Customized EMSS bookmarks - caching issues  2281  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 2281
by  CindyWJump to last post
02/09/2017 1:04 PM
1 Replies and 2604 Views Program compiled w/ trace  2604  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 2604
by  LynneJump to last post
01/24/2017 2:58 PM
2 Replies and 2942 Views Rel 10 4GL Error  2942  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 2942
by  jaherbJump to last post
01/18/2017 9:04 AM
2 Replies and 3825 Views Infor10 Mingle Login Screen Customization  3825  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 3825
by  JimYJump to last post
12/15/2016 10:32 AM
7 Replies and 3825 Views Has anyone successfully parsed out job parameters from the GEN(LAW).JOBSTEP table?  3825  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 3825
by  John HenleyJump to last post
12/09/2016 2:13 PM
6 Replies and 3244 Views Form/.scr help!!  3244  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 3244
by  LauraPatJump to last post
10/07/2016 7:43 AM
4 Replies and 4473 Views Print manager files  4473  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 4473
by  ALBJump to last post
09/28/2016 1:42 PM
6 Replies and 3309 Views Fld Err: Decimal Field's Display Length 0  3309  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 3309
by  pgallucci12Jump to last post
09/23/2016 5:39 PM
3 Replies and 2900 Views State Tax Form  2900  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 2900
by  Jeff ShumateJump to last post
09/23/2016 4:23 PM
1 Replies and 5460 Views Lawson APIs  5460  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 5460
by  Joe CareyJump to last post
09/17/2016 10:38 AM
4 Replies and 2874 Views CSV File  2874  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 2874
by  jaherbJump to last post
09/06/2016 1:21 PM
3 Replies and 3033 Views Tab delimited  3033  3 Started by  Srini Rao Is it possible to create the TAB delimited output using the 4GL program
3 3033
by  Karen SheridanJump to last post
09/02/2016 9:00 AM
2 Replies and 2594 Views animating a lawson online screen  2594  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 2594
by  ChescaJump to last post
08/30/2016 3:08 PM
1 Replies and 2741 Views Second Report to Print Manager  2741  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 2741
by  LauraPatJump to last post
08/18/2016 11:20 AM
2 Replies and 2753 Views Lawson Rel 10  2753  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 2753
by  jaherbJump to last post
08/18/2016 9:32 AM
0 Replies and 986 Views Chrome loading pages on custom ESS  986  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 986
08/15/2016 10:02 AM
6 Replies and 2810 Views IE11 Form Messages  2810  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 2810
by  Greg MoellerJump to last post
08/03/2016 12:58 PM
5 Replies and 3326 Views waiting recovery  3326  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 3326
by  TBonneyJump to last post
07/27/2016 7:33 AM
0 Replies and 756 Views waiting recovery  756  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 756
07/26/2016 11:06 AM
3 Replies and 3028 Views Microfocus  3028  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 3028
by  LauraPatJump to last post
06/30/2016 7:44 AM
0 Replies and 1040 Views How Find Programs That Use Specific Screen Rule?  1040  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 1040
06/24/2016 11:06 AM
2 Replies and 2790 Views Using current date in if statement  2790  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 2790
by  Jessica MJump to last post
06/22/2016 2:38 PM
6 Replies and 3304 Views calculate the last day of any month  3304  6 Started by  Chesca Is there an API I could use to calculate the last day of any month  
6 3304
by  kimJump to last post
06/16/2016 12:20 PM
1 Replies and 2709 Views Compile Error  2709  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 2709
by  jaherbJump to last post
06/13/2016 3:15 PM
6 Replies and 4227 Views 0 instead of blanks in CSV file  4227  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 4227
by  David@SOMJump to last post
06/03/2016 1:12 PM
6 Replies and 6572 Views Web service calls *FROM* Lawson  6572  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 6572
by  Jason BeardJump to last post
05/25/2016 9:29 PM
3 Replies and 2821 Views New custom program  2821  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 2821
by  Jason BeardJump to last post
05/25/2016 9:04 PM
0 Replies and 1068 Views Portal Page for Workunits  1068  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 1068
05/18/2016 1:56 PM
2 Replies and 3015 Views tsBeginDBTransaction error is Operation illegal while in transaction (20).  3015  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 3015
by  LilybJump to last post
05/12/2016 6:52 PM
3 Replies and 3017 Views Best practice of copying a program  3017  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 3017
by  jaherbJump to last post
05/12/2016 9:53 AM
1 Replies and 3801 Views Best (certified) Lawson Development Partner for S3 and/or M3  3801  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 3801
by  shahzadJump to last post
05/03/2016 3:01 AM
2 Replies and 2889 Views Comment Attachment Processing compile error  2889  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 2889
by  John DesmaraisJump to last post
04/07/2016 10:49 AM
14 Replies and 3962 Views Extract File Issues  3962  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 3962
by  jaherbJump to last post
04/01/2016 11:52 AM
0 Replies and 1084 Views Lawson Portal automated access and session handling  1084  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 1084
03/29/2016 2:18 PM
3 Replies and 4001 Views Oracle SQL reformat date  4001  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 4001
by  ChescaJump to last post
03/01/2016 3:23 PM
4 Replies and 3163 Views Input date validation  3163  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 3163
by  ChescaJump to last post
02/10/2016 7:39 AM
6 Replies and 5093 Views Cannot replace my own custom form  5093  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 5093
by  John HenleyJump to last post
02/05/2016 2:07 PM
2 Replies and 15330 Views SQL question on APINVOICE, APDISTRIB, APPAYMENT  15330  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 15330
by  ChescaJump to last post
01/28/2016 2:52 PM
0 Replies and 1259 Views lawson 10 ESS theme 10.3 override  1259  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 1259
01/27/2016 2:49 PM
6 Replies and 3598 Views Windows script to do rnddbdump to file  3598  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 3598
by  pbelskyJump to last post
01/19/2016 4:36 PM
12 Replies and 4172 Views Missing data in modified CSV error report after promotion  4172  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 4172
by  pbelskyJump to last post
01/07/2016 5:46 PM
4 Replies and 3602 Views RECDEF  3602  4 Started by  Chesca Can I create a paintscreen program to access recdef 
4 3602
by  Kwane McNealJump to last post
11/30/2015 1:06 PM
3 Replies and 3633 Views Scheduling job automatically with dynamic date range  3633  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 3633
by  Vijay SJump to last post
11/25/2015 2:35 AM
2 Replies and 2789 Views Database reads INTO a unique working storage area  2789  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 2789
by  Todd MitchellJump to last post
11/19/2015 3:53 PM
5 Replies and 3239 Views Add columns to report csv beyond the print report width limit  3239  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 3239
by  jaherbJump to last post
11/17/2015 4:21 PM
6 Replies and 3449 Views Best Way to add spaces in Header of a CSV file via batch Program  3449  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 3449
by  Vijay SJump to last post
11/17/2015 5:07 AM
3 Replies and 4757 Views How to look up field name from field number.  4757  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 4757
by  Kat VJump to last post
10/09/2015 3:52 PM
4 Replies and 3699 Views work file def  3699  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 3699
by  jaherbJump to last post
10/09/2015 10:36 AM
1 Replies and 2985 Views work file def  2985  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 2985
by  jaherbJump to last post
10/09/2015 10:33 AM
1 Replies and 3168 Views Use negative values returned from DME call ?  3168  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 3168
by  mikePJump to last post
10/02/2015 2:11 PM
5 Replies and 3423 Views 4GL Report missing Company Name  3423  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 3423
by  DemiJump to last post
09/29/2015 9:04 AM
0 Replies and 1475 Views Redirect WWW Usl to Mingle  1475  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 1475
09/25/2015 5:00 PM
3 Replies and 3403 Views programming error  3403  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 3403
by  ChescaJump to last post
09/21/2015 3:03 PM
10 Replies and 5699 Views ESS new custom form  5699  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 5699
by  ChescaJump to last post
09/21/2015 2:41 PM
3 Replies and 3404 Views How to determine if string is numeric?  3404  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 3404
by  Vijay SJump to last post
09/15/2015 6:09 AM
4 Replies and 4723 Views Table for recurring job (Recdef)  4723  4 Started by  Vijay S Any guess, which GEN table store's recurring job definition
4 4723
by  Vijay SJump to last post
09/11/2015 7:41 AM
3 Replies and 3113 Views 4GL Versus HTML/JAVA  3113  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 3113
by  WoozyJump to last post
09/10/2015 9:19 AM
8 Replies and 6348 Views Extract program version numbers  6348  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 6348
by  KrisJump to last post
09/08/2015 12:13 PM
1 Replies and 3163 Views Multiple Report COBOL  3163  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 3163
by  ALBJump to last post
08/28/2015 5:43 PM
0 Replies and 1287 Views Custom application not displaying text fields on next\previous  1287  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 1287
08/19/2015 2:45 PM
7 Replies and 5453 Views Windows DOS script  5453  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 5453
by  R Wayne WalkerJump to last post
07/30/2015 10:51 AM
1 Replies and 3309 Views Pop-up Text Message in AP20.1  3309  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 3309
by  maalimsimoJump to last post
07/28/2015 4:26 PM
5 Replies and 3662 Views Changing a custom index to Key Change=Yes?  3662  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 3662
by  WoozyJump to last post
07/28/2015 9:40 AM
1 Replies and 2965 Views ESS/MSS Changes  2965  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 2965
by  bdJump to last post
07/08/2015 9:04 AM
1 Replies and 3214 Views How to Left Align Output Fields  3214  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 3214
by  jaherbJump to last post
06/25/2015 1:54 PM
4 Replies and 3465 Views Batch animator  3465  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 3465
by  ChescaJump to last post
06/24/2015 2:19 PM
11 Replies and 6087 Views HR11 AGS call  6087  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 6087
by  Tim CochraneJump to last post
06/09/2015 6:15 PM
0 Replies and 1514 Views SharePoint integration 9.0.x  1514  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 1514
05/05/2015 5:43 PM
3 Replies and 3688 Views Report archiving/emailing  3688  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 3688
by  mikePJump to last post
04/17/2015 1:04 PM
2 Replies and 3745 Views compiling error after copying a program  3745  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 3745
by  ChescaJump to last post
03/11/2015 10:59 AM
3 Replies and 3775 Views ESS - Org Chart - Hide an employee from ESS Org Chart based on their Process Level and Department  3775  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 3775
by  John HenleyJump to last post
03/02/2015 2:53 PM
0 Replies and 1520 Views This page cannot be displayed in a frame sharepoint 2013  1520  0 Started by  Ann I'm not sure how to display the webpage without having to click on the link.
0 1520
01/26/2015 2:45 PM
4 Replies and 4724 Views Advice on COBOL training  4724  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 4724
by  Scott PerrierJump to last post
01/20/2015 9:59 AM
3 Replies and 17779 Views Using wildcard in DME query  17779  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 17779
by  Deleted UserJump to last post
01/13/2015 9:45 AM
7 Replies and 3997 Views PF Eclipse designer will not initiate  3997  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 3997
by  MCJump to last post
01/07/2015 6:43 AM
7 Replies and 4653 Views Can I leverage relations in COBOL query?  4653  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 4653
by  WoozyJump to last post
12/12/2014 10:39 AM
11 Replies and 4064 Views DME call and Javascript  4064  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 4064
by  mikePJump to last post
11/18/2014 5:12 PM
3 Replies and 2373 Views ESS - Hide buttons  2373  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 2373
by  MikeDJump to last post
11/13/2014 2:08 PM
2 Replies and 2553 Views Custom code to find a previous record  2553  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 2553
by  WoozyJump to last post
11/04/2014 3:50 PM
4 Replies and 2697 Views ESS label description change  2697  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 2697
by  ChescaJump to last post
10/27/2014 3:15 PM
4 Replies and 2583 Views Proxy as another user in LSF9 Portal and/or EMSS  2583  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 2583
by  WoozyJump to last post
10/24/2014 3:02 PM
10 Replies and 2425 Views Perplexed by LAWSON  2425  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 2425
by  Jason BeardJump to last post
10/23/2014 9:35 PM
0 Replies and 1105 Views html page in Lawson  1105  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 1105
10/19/2014 8:48 AM
7 Replies and 3031 Views Call a Process Flow from within JavaScript  3031  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 3031
by  JimYJump to last post
10/17/2014 3:49 PM
0 Replies and 2531 Views Windows AD and useratts.htm  2531  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 2531
10/10/2014 2:40 PM
1 Replies and 1629 Views RQC version 10  1629  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 1629
by  Scott PerrierJump to last post
10/08/2014 3:49 PM
7 Replies and 4193 Views Looking for Lawson API Listing  4193  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 4193
by  jaherbJump to last post
10/06/2014 11:04 AM
0 Replies and 1248 Views USERPROFILE  1248  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 1248
09/18/2014 3:56 PM
1 Replies and 1668 Views vbscript and ags  1668  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 1668
by  John HenleyJump to last post
09/17/2014 5:09 PM
1 Replies and 1283 Views Shrinking fields  1283  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 1283
by  RitaJump to last post
09/17/2014 12:21 PM
4 Replies and 1533 Views two forms in one program  1533  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 1533
by  WoozyJump to last post
09/15/2014 3:12 PM
12 Replies and 4419 Views Job fails to kick off FTP script - unable to log in user/startstep failed  4419  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 4419
by  cpaine216Jump to last post
09/15/2014 9:28 AM
1 Replies and 1669 Views Adding fields to form  1669  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 1669
by  jaherbJump to last post
09/11/2014 11:16 AM
1 Replies and 1342 Views Painting with alternate index  1342  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 1342
by  RitaJump to last post
09/09/2014 3:16 PM
3 Replies and 1707 Views API  1707  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 1707
by  jaherbJump to last post
09/08/2014 12:36 PM
3 Replies and 1589 Views random alphanumeric string  1589  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 1589
by  Scott PerrierJump to last post
08/29/2014 2:03 PM
1 Replies and 1510 Views Infor graphic replacement on Login page  1510  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 1510
by  Srini RaoJump to last post
08/29/2014 8:41 AM
0 Replies and 1165 Views What is $AUDFORM in the .scr file do?  1165  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 1165
08/27/2014 2:19 PM
2 Replies and 1266 Views Process level changes  1266  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 1266
by  jaherbJump to last post
08/25/2014 10:08 AM
1 Replies and 1745 Views Javascript AGS call with Next  1745  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 1745
by  WoozyJump to last post
08/20/2014 5:12 PM
1 Replies and 1464 Views LP program syntax error  1464  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 1464
by  ChescaJump to last post
08/11/2014 3:18 PM
2 Replies and 1537 Views File dump  1537  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 1537
by  ChescaJump to last post
07/29/2014 1:23 PM
8 Replies and 1777 Views MSS - Customizations  1777  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 1777
by  Chris12Jump to last post
07/28/2014 1:44 PM
3 Replies and 1362 Views Deprecated 515-UPDATE-DATE-TIME api  1362  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 1362
by  jaherbJump to last post
07/24/2014 9:33 AM
5 Replies and 1348 Views ESS screen welcome screen  1348  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 1348
by  ChescaJump to last post
07/23/2014 2:17 PM
9 Replies and 10490 Views ESS Benefits Enrollment - My DME and AGS calls Not Working  10490  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 10490
by  Judy ConsoliJump to last post
07/03/2014 10:32 AM
0 Replies and 911 Views v10 how to define window for comments  911  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 911
06/24/2014 9:31 AM
3 Replies and 1432 Views Create var length recs  1432  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 1432
by  jaherbJump to last post
06/24/2014 9:25 AM
2 Replies and 1312 Views scan programs  1312  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 1312
by  WoozyJump to last post
06/23/2014 12:53 PM
1 Replies and 1506 Views Set up ESS Benefits Enrollment for a Medical Plan Spousal Surcharge  1506  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 1506
by  Karen SheridanJump to last post
06/13/2014 10:38 AM
5 Replies and 1557 Views CSV file read error  1557  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 1557
by  jaherbJump to last post
06/12/2014 3:28 PM
4 Replies and 1812 Views Publish Non-Lawson Report to Print Manager?  1812  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 1812
by  Greg MoellerJump to last post
05/22/2014 4:30 PM
3 Replies and 2168 Views .aif file  2168  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 2168
by  jaherbJump to last post
05/14/2014 5:22 PM
3 Replies and 3423 Views Work File error  3423  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 3423
by  jaherbJump to last post
05/08/2014 11:24 AM
3 Replies and 1659 Views Mosby Skills Interface  1659  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 1659
by  The.Sam.GrovesJump to last post
04/08/2014 11:11 AM
2 Replies and 1366 Views What are cnvscr.detail and cnvscr.out?  1366  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 1366
by  WoozyJump to last post
04/04/2014 3:07 PM
4 Replies and 4055 Views error message text not found  4055  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 4055
by  BrianMJump to last post
04/02/2014 3:55 PM
1 Replies and 1436 Views Associating Smart Office Script with the S3 Form  1436  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 1436
by  L GJump to last post
04/02/2014 6:39 AM
3 Replies and 1610 Views Script to email report from custom program - report incomplete  1610  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 1610
by  jaherbJump to last post
03/27/2014 11:18 AM
2 Replies and 1598 Views Multiple rows of comments  1598  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 1598
by  ChescaJump to last post
03/13/2014 2:01 PM
5 Replies and 1856 Views PRTIME  1856  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 1856
by  ChescaJump to last post
03/10/2014 7:03 AM
1 Replies and 1792 Views can't run/submit any jobs  1792  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 1792
by  ChescaJump to last post
03/07/2014 2:00 PM
1 Replies and 1629 Views HR11 AGS Call User Fields  1629  1 Started by  Judy Consoli Has anyone used the AGS call from html/javascript for updating fields on the User Field Tab
1 1629
by  John HenleyJump to last post
03/01/2014 7:03 AM
3 Replies and 2117 Views Employee Status change  2117  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 2117
by  jaherbJump to last post
02/27/2014 5:14 PM
6 Replies and 10022 Views Help accessing data returned by a DME call  10022  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 10022
by  ShelbyJump to last post
02/26/2014 3:52 PM
7 Replies and 3204 Views 4GL command button to launch HR13.3  3204  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 3204
by  jaherbJump to last post
02/21/2014 3:30 PM
2 Replies and 1782 Views dburf on custom paint program  1782  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 1782
by  jaherbJump to last post
02/20/2014 9:32 AM
2 Replies and 1483 Views Absence Management  1483  2 Started by  Chesca Does anybody know what table or screen would tell me if an employee is enrolled in absence plan/structure
2 1483
by  ChescaJump to last post
02/20/2014 8:19 AM
17 Replies and 2870 Views .scr file modifications  2870  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 2870
by  jaherbJump to last post
02/13/2014 5:02 PM
2 Replies and 1537 Views Effective date the employee became benefit eligible  1537  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 1537
by  ChescaJump to last post
02/10/2014 11:58 AM
7 Replies and 1794 Views Sort File for Online Update Form?  1794  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 1794
by  jaherbJump to last post
02/06/2014 1:07 PM
2 Replies and 1449 Views Calculate prior year  1449  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 1449
by  ChescaJump to last post
02/05/2014 2:21 PM
3 Replies and 4586 Views HTML/Javascript DME function for LOGAN  4586  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 4586
by  Scott PerrierJump to last post
01/31/2014 11:23 AM
5 Replies and 2052 Views Double Quotes on Empty fields in 4gl CSV file  2052  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 2052
by  Donna WirtJump to last post
01/30/2014 1:37 PM
0 Replies and 1648 Views .Net 4.5 SSO / Authentication to Lawson 9 or 10.0 Request for Examples  1648  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 1648
01/30/2014 8:05 AM
4 Replies and 1757 Views HRHISTORY  1757  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 1757
by  jaherbJump to last post
01/28/2014 10:24 AM
0 Replies and 1190 Views HTTPS Post Response - Kaiser CAMS  1190  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 1190
01/22/2014 2:38 PM
2 Replies and 1661 Views LP35 Paint Screen  1661  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 1661
by  ChescaJump to last post
01/21/2014 8:34 AM
3 Replies and 1286 Views Working with Messages  1286  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 1286
by  BrianMJump to last post
01/20/2014 2:53 PM
0 Replies and 1123 Views Remove last four digits of SS Nbr From Printable Pay Stub  1123  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 1123
01/16/2014 10:58 AM
2 Replies and 1595 Views date calc API/routine  1595  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 1595
by  ChescaJump to last post
01/15/2014 8:37 AM
4 Replies and 3529 Views Barcode on Lawson Printed Form  3529  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 3529
by  Robert SpurrJump to last post
01/08/2014 8:52 PM
2 Replies and 2370 Views PGMDEF  2370  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 2370
by  WoozyJump to last post
01/06/2014 11:26 AM
2 Replies and 1660 Views PA531 - how to change 800-OPENINPUTCSV-APLLOADCSV path and file name  1660  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 1660
by  jaherbJump to last post
12/18/2013 11:17 AM
2 Replies and 1627 Views Remove a User Exit  1627  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 1627
by  Roger FrenchJump to last post
12/11/2013 9:08 AM
0 Replies and 1092 Views Ho do you bold a line of text in .rpt  1092  0 Started by  wilcoxmad I need to bold or highlite a line of text on a report. Anybody done that before Thanks.
0 1092
12/05/2013 12:00 PM
2 Replies and 1633 Views Filters  1633  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 1633
by  ChescaJump to last post
12/03/2013 3:19 PM
3 Replies and 1420 Views Work file Field Names  1420  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 1420
by  jaherbJump to last post
12/03/2013 3:10 PM
1 Replies and 1184 Views Spaces in CSV Headings  1184  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 1184
by  LynneJump to last post
12/03/2013 8:52 AM
4 Replies and 1275 Views Get Field Value Desciptions via Fetch  1275  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 1275
by  WoozyJump to last post
11/26/2013 1:08 PM
0 Replies and 977 Views Dynamic Key number  977  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 977
11/22/2013 10:17 AM
23 Replies and 3360 Views Help finding jobs  3360  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 3360
by  Greg MoellerJump to last post
11/19/2013 8:59 AM
5 Replies and 1474 Views new 4GL error on portal  1474  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 1474
by  MCJump to last post
11/12/2013 7:30 PM
4 Replies and 1345 Views Distinct Value in screen rules  1345  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 1345
by  ARajaJump to last post
11/12/2013 1:33 PM
4 Replies and 1747 Views database index filter routines  1747  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 1747
by  jaherbJump to last post
10/29/2013 11:35 AM
2 Replies and 1333 Views report mode  1333  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 1333
by  ChescaJump to last post
10/18/2013 12:42 PM
1 Replies and 1464 Views Lp180  1464  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 1464
by  ChescaJump to last post
10/16/2013 12:58 PM
6 Replies and 1853 Views Add a new column to an existing table while retaining table data  1853  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 1853
by  WoozyJump to last post
10/15/2013 5:15 PM
2 Replies and 3609 Views GEN/QUEUEDJOB.  3609  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 3609
by  ChescaJump to last post
10/03/2013 9:51 AM
1 Replies and 1380 Views Add workunit filter in workspace inbasket  1380  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 1380
by  John HenleyJump to last post
10/03/2013 9:16 AM
2 Replies and 2093 Views Compile Error - WS field not defined in specified WS  2093  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 2093
by  WoozyJump to last post
09/26/2013 11:32 AM
2 Replies and 1327 Views Remove Form UserExit?  1327  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 1327
by  WoozyJump to last post
09/26/2013 10:51 AM
0 Replies and 1533 Views Requisition Approval Inbasket Display Accounting Units  1533  0 Started by  SKMacCauley Issue Description:  Process Flow in-basket display - The requisition approval in-basket display does not show the accounting unit, account and asset template for an asset when the total requisition lines is one but the requisition line number is two. I don't know if it is possible to accomodate this situation with the query that populates the display but if possible it would be nice. I think this is an unintentional error on the part of the requester but it happens sometimes. (Screensho...
0 1533
09/25/2013 10:42 AM
0 Replies and 1079 Views Populate Audit Table via BN47 Form UserExit  1079  0 Started by  Woozy Our Benefits department has asked us to build a process that will update a custom audit table anytime Beneficiary data is changed via BN47.  This seems like a perfect use for a Form UserExit, but I've never built one of these so I have a question. It seems to me that an 'End' user exit is the logical place to put my logic, since it is after the form  transaction has completed successfully.  However, it appears that when the End UserExit runs, all the LINE-FC values have already...
0 1079
09/23/2013 1:11 PM
4 Replies and 2443 Views workdef CSV file Header  2443  4 Started by  Srini Rao Hello, Is their a way to create a mixed case header for csv file using workdef. My vendor wants the field name as 'BatchNumber' but when I can't declare the field name in mixed case in workdef. Thanks
4 2443
by  jaherbJump to last post
09/16/2013 2:53 PM
2 Replies and 2040 Views ESS AGS call in JavaScript not returning data  2040  2 Started by  Shelby Hi, I am trying to copy an existing custom AGS call from elect_benefits.htm to elect_ben_05.htm. We are using ZN31.1 to determine if the Evidence of Insurability (EOI) statement should be displayed. 501 indicates the message should be displayed. In elect_benefits, the returned data is found in self.js1.RtnMsgErrNbr. However, when I step through the code in elect_ben_05, self.js1.RtnMsgErrNbr is undefined. (I can momentarily see the value set as 501 in the Debugging Tool. But when cont...
2 2040
by  ShelbyJump to last post
09/13/2013 3:27 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 1 of 3123 > >>


RSS Feed Available