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 105 Views prmpassed in custom Display Exec    105  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 105
06/19/2018 2:08 PM
0 Replies and 459 Views Add HR11 (Assignment tab) Location field to ESS    459  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 459
06/13/2017 3:47 PM
1 Replies and 4630 Views Forcing ERROR from User Exit    4630  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 4630
by  ArthurThumJump to last post
06/19/2014 11:23 PM
11 Replies and 10679 Views ESS - direct URL link to feature    10679  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 10679
by  Moe AframJump to last post
05/29/2013 12:52 PM
2 Replies and 632 Views 508 file type  632  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 632
by  Russell EJump to last post
07/10/2018 4:18 PM
2 Replies and 385 Views Calling perl script from Cobol program  385  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 385
by  maalimsimoJump to last post
06/12/2018 12:46 PM
1 Replies and 1877 Views Customizing PR195  1877  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 1877
by  Ragu RaghavanJump to last post
02/08/2018 3:25 PM
0 Replies and 183 Views Customizing PR195  183  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 183
02/08/2018 12:04 PM
7 Replies and 1325 Views Custom Lawson tables using Addins  1325  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 1325
by  JudeBacJump to last post
02/06/2018 4:19 PM
6 Replies and 6966 Views How do I generate CSV output from batch program?  6966  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 6966
by  PDJump to last post
12/20/2017 9:59 AM
5 Replies and 3184 Views how to call UNIX script from tokendef  3184  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 3184
by  JaphethJump to last post
10/02/2017 12:19 PM
0 Replies and 414 Views LSO Scripting for newbie  414  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 414
09/28/2017 11:11 AM
1 Replies and 1930 Views Jobdef Job Not Found error  1930  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 1930
by  maalimsimoJump to last post
09/26/2017 1:39 PM
3 Replies and 2481 Views Paint Screen - Job Title retrieval for job-code  2481  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 2481
by  Ragu RaghavanJump to last post
08/04/2017 9:41 AM
5 Replies and 6082 Views Org Chart  6082  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 6082
by  Cheri AzereixJump to last post
06/20/2017 11:54 AM
1 Replies and 1982 Views Portal changes location of literal  1982  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 1982
by  Stuart PerkinsJump to last post
06/19/2017 1:01 PM
0 Replies and 420 Views Customizations  420  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 420
05/22/2017 3:13 PM
7 Replies and 7356 Views Distribution Group  7356  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 7356
by  mthedfordJump to last post
05/04/2017 1:52 PM
2 Replies and 2038 Views Add Custom Tables to Lawson Data Dictionary  2038  2 Started by  Lawson_Tech Any KBs please post to me 'Add Custom Tables to Lawson Data Dictionary'
2 2038
by  Kwane McNealJump to last post
04/10/2017 3:28 PM
0 Replies and 369 Views Question on Custom Table with Unique-ID field  369  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 369
04/06/2017 6:58 AM
1 Replies and 2014 Views Labels on Zebra printer  2014  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 2014
by  LauraPatJump to last post
03/30/2017 12:35 PM
0 Replies and 436 Views File Status Codes  436  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 436
03/02/2017 10:40 AM
9 Replies and 5269 Views User Exit Eamples--  5269  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 5269
by  jaherbJump to last post
02/24/2017 12:47 PM
1 Replies and 1882 Views Print labels via custom batch program  1882  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 1882
by  Ragu RaghavanJump to last post
02/23/2017 9:00 AM
1 Replies and 2230 Views jobs in waiting recovery  2230  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 2230
by  JimYJump to last post
02/20/2017 9:55 AM
2 Replies and 2120 Views Meaning of File Status 9-230  2120  2 Started by  Survivor 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 2120
by  SurvivorJump to last post
02/17/2017 8:07 AM
1 Replies and 1963 Views Customized EMSS bookmarks - caching issues  1963  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 1963
by  CindyWJump to last post
02/09/2017 1:04 PM
1 Replies and 2122 Views Program compiled w/ trace  2122  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 2122
by  LynneJump to last post
01/24/2017 2:58 PM
2 Replies and 2393 Views Rel 10 4GL Error  2393  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 2393
by  jaherbJump to last post
01/18/2017 9:04 AM
2 Replies and 3159 Views Infor10 Mingle Login Screen Customization  3159  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 3159
by  JimYJump to last post
12/15/2016 10:32 AM
7 Replies and 3146 Views Has anyone successfully parsed out job parameters from the GEN(LAW).JOBSTEP table?  3146  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 3146
by  John HenleyJump to last post
12/09/2016 2:13 PM
6 Replies and 2638 Views Form/.scr help!!  2638  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 2638
by  LauraPatJump to last post
10/07/2016 7:43 AM
4 Replies and 3343 Views Print manager files  3343  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 3343
by  SurvivorJump to last post
09/28/2016 1:42 PM
6 Replies and 2832 Views Fld Err: Decimal Field's Display Length 0  2832  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 2832
by  pgallucci12Jump to last post
09/23/2016 5:39 PM
3 Replies and 2575 Views State Tax Form  2575  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 2575
by  Jeff ShumateJump to last post
09/23/2016 4:23 PM
1 Replies and 4035 Views Lawson APIs  4035  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 4035
by  Joe CareyJump to last post
09/17/2016 10:38 AM
4 Replies and 2547 Views CSV File  2547  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 2547
by  jaherbJump to last post
09/06/2016 1:21 PM
3 Replies and 2696 Views Tab delimited  2696  3 Started by  Srini Rao Is it possible to create the TAB delimited output using the 4GL program
3 2696
by  Karen SheridanJump to last post
09/02/2016 9:00 AM
2 Replies and 2317 Views animating a lawson online screen  2317  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 2317
by  ChescaJump to last post
08/30/2016 3:08 PM
1 Replies and 2342 Views Second Report to Print Manager  2342  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 2342
by  LauraPatJump to last post
08/18/2016 11:20 AM
2 Replies and 2385 Views Lawson Rel 10  2385  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 2385
by  jaherbJump to last post
08/18/2016 9:32 AM
0 Replies and 596 Views Chrome loading pages on custom ESS  596  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 596
08/15/2016 10:02 AM
6 Replies and 2308 Views IE11 Form Messages  2308  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 2308
by  Greg MoellerJump to last post
08/03/2016 12:58 PM
5 Replies and 2739 Views waiting recovery  2739  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 2739
by  TBonneyJump to last post
07/27/2016 7:33 AM
0 Replies and 515 Views waiting recovery  515  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 515
07/26/2016 11:06 AM
3 Replies and 2654 Views Microfocus  2654  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 2654
by  LauraPatJump to last post
06/30/2016 7:44 AM
0 Replies and 705 Views How Find Programs That Use Specific Screen Rule?  705  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 705
06/24/2016 11:06 AM
2 Replies and 2387 Views Using current date in if statement  2387  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 2387
by  Jessica MJump to last post
06/22/2016 2:38 PM
6 Replies and 2864 Views calculate the last day of any month  2864  6 Started by  Chesca Is there an API I could use to calculate the last day of any month  
6 2864
by  kimJump to last post
06/16/2016 12:20 PM
1 Replies and 2363 Views Compile Error  2363  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 2363
by  jaherbJump to last post
06/13/2016 3:15 PM
6 Replies and 3599 Views 0 instead of blanks in CSV file  3599  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 3599
by  David@SOMJump to last post
06/03/2016 1:12 PM
6 Replies and 6011 Views Web service calls *FROM* Lawson  6011  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 6011
by  Jason BeardJump to last post
05/25/2016 9:29 PM
3 Replies and 2469 Views New custom program  2469  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 2469
by  Jason BeardJump to last post
05/25/2016 9:04 PM
0 Replies and 718 Views Portal Page for Workunits  718  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 718
05/18/2016 1:56 PM
2 Replies and 2535 Views tsBeginDBTransaction error is Operation illegal while in transaction (20).  2535  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 2535
by  LilybJump to last post
05/12/2016 6:52 PM
3 Replies and 2606 Views Best practice of copying a program  2606  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 2606
by  jaherbJump to last post
05/12/2016 9:53 AM
1 Replies and 3562 Views Best (certified) Lawson Development Partner for S3 and/or M3  3562  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 3562
by  shahzadJump to last post
05/03/2016 3:01 AM
2 Replies and 2511 Views Comment Attachment Processing compile error  2511  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 2511
by  John DesmaraisJump to last post
04/07/2016 10:49 AM
14 Replies and 3458 Views Extract File Issues  3458  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 3458
by  jaherbJump to last post
04/01/2016 11:52 AM
0 Replies and 769 Views Lawson Portal automated access and session handling  769  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 769
03/29/2016 2:18 PM
3 Replies and 3414 Views Oracle SQL reformat date  3414  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 3414
by  ChescaJump to last post
03/01/2016 3:23 PM
4 Replies and 2848 Views Input date validation  2848  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 2848
by  ChescaJump to last post
02/10/2016 7:39 AM
6 Replies and 4088 Views Cannot replace my own custom form  4088  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 4088
by  John HenleyJump to last post
02/05/2016 2:07 PM
2 Replies and 14620 Views SQL question on APINVOICE, APDISTRIB, APPAYMENT  14620  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 14620
by  ChescaJump to last post
01/28/2016 2:52 PM
0 Replies and 877 Views lawson 10 ESS theme 10.3 override  877  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 877
01/27/2016 2:49 PM
6 Replies and 3121 Views Windows script to do rnddbdump to file  3121  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 3121
by  pbelskyJump to last post
01/19/2016 4:36 PM
12 Replies and 3731 Views Missing data in modified CSV error report after promotion  3731  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 3731
by  pbelskyJump to last post
01/07/2016 5:46 PM
4 Replies and 3105 Views RECDEF  3105  4 Started by  Chesca Can I create a paintscreen program to access recdef 
4 3105
by  Kwane McNealJump to last post
11/30/2015 1:06 PM
3 Replies and 3285 Views Scheduling job automatically with dynamic date range  3285  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 3285
by  Vijay SJump to last post
11/25/2015 2:35 AM
2 Replies and 2530 Views Database reads INTO a unique working storage area  2530  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 2530
by  Todd MitchellJump to last post
11/19/2015 3:53 PM
5 Replies and 2904 Views Add columns to report csv beyond the print report width limit  2904  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 2904
by  jaherbJump to last post
11/17/2015 4:21 PM
6 Replies and 3068 Views Best Way to add spaces in Header of a CSV file via batch Program  3068  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 3068
by  Vijay SJump to last post
11/17/2015 5:07 AM
3 Replies and 4071 Views How to look up field name from field number.  4071  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 4071
by  Kat VJump to last post
10/09/2015 3:52 PM
4 Replies and 3244 Views work file def  3244  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 3244
by  jaherbJump to last post
10/09/2015 10:36 AM
1 Replies and 2713 Views work file def  2713  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 2713
by  jaherbJump to last post
10/09/2015 10:33 AM
1 Replies and 2843 Views Use negative values returned from DME call ?  2843  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 2843
by  mikePJump to last post
10/02/2015 2:11 PM
5 Replies and 3000 Views 4GL Report missing Company Name  3000  5 Started by  Demichener I have a custom 4GL program that has been migrated over into a new version 10 environment.  When performing a parallel comparison, the new 10 version is not listing the Company Name in the job submission parameters section.  I've tried running a new rptgen; but that hasn't helped. Any suggestions would be appreciated......
5 3000
by  DemichenerJump to last post
09/29/2015 9:04 AM
0 Replies and 1058 Views Redirect WWW Usl to Mingle  1058  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 1058
09/25/2015 5:00 PM
3 Replies and 3052 Views programming error  3052  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 3052
by  ChescaJump to last post
09/21/2015 3:03 PM
10 Replies and 4874 Views ESS new custom form  4874  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 4874
by  ChescaJump to last post
09/21/2015 2:41 PM
3 Replies and 3005 Views How to determine if string is numeric?  3005  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 3005
by  Vijay SJump to last post
09/15/2015 6:09 AM
4 Replies and 3756 Views Table for recurring job (Recdef)  3756  4 Started by  Vijay S Any guess, which GEN table store's recurring job definition
4 3756
by  Vijay SJump to last post
09/11/2015 7:41 AM
3 Replies and 2754 Views 4GL Versus HTML/JAVA  2754  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 2754
by  WoozyJump to last post
09/10/2015 9:19 AM
8 Replies and 5079 Views Extract program version numbers  5079  8 Started by  Demichener We are a Windows environment and are in the process of upgrading our systems from 9.0.1 to version 10.  While migrating some of our custom programs into the 10env; we discovered that some of the version numbers in our 9.0.1 system are higher than the version numbers in the delivered 10.0 programs.  We would like to obtain a list of the current programs and their assigned version numbers for a comparison between the systems.  Have others seen this  How did you ...
8 5079
by  KrisJump to last post
09/08/2015 12:13 PM
1 Replies and 2799 Views Multiple Report COBOL  2799  1 Started by  Survivor 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 2799
by  SurvivorJump to last post
08/28/2015 5:43 PM
0 Replies and 905 Views Custom application not displaying text fields on next\previous  905  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 905
08/19/2015 2:45 PM
7 Replies and 4697 Views Windows DOS script  4697  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 4697
by  R Wayne WalkerJump to last post
07/30/2015 10:51 AM
1 Replies and 2835 Views Pop-up Text Message in AP20.1  2835  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 2835
by  maalimsimoJump to last post
07/28/2015 4:26 PM
5 Replies and 3219 Views Changing a custom index to Key Change=Yes?  3219  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 3219
by  WoozyJump to last post
07/28/2015 9:40 AM
1 Replies and 2666 Views ESS/MSS Changes  2666  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 2666
by  bdJump to last post
07/08/2015 9:04 AM
1 Replies and 2853 Views How to Left Align Output Fields  2853  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 2853
by  jaherbJump to last post
06/25/2015 1:54 PM
4 Replies and 3100 Views Batch animator  3100  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 3100
by  ChescaJump to last post
06/24/2015 2:19 PM
11 Replies and 4977 Views HR11 AGS call  4977  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 4977
by  Tim CochraneJump to last post
06/09/2015 6:15 PM
0 Replies and 1021 Views SharePoint integration 9.0.x  1021  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 1021
05/05/2015 5:43 PM
3 Replies and 3339 Views Report archiving/emailing  3339  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 3339
by  mikePJump to last post
04/17/2015 1:04 PM
2 Replies and 3269 Views compiling error after copying a program  3269  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 3269
by  ChescaJump to last post
03/11/2015 10:59 AM
3 Replies and 3473 Views ESS - Org Chart - Hide an employee from ESS Org Chart based on their Process Level and Department  3473  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 3473
by  John HenleyJump to last post
03/02/2015 2:53 PM
0 Replies and 1197 Views This page cannot be displayed in a frame sharepoint 2013  1197  0 Started by  Ann I'm not sure how to display the webpage without having to click on the link.
0 1197
01/26/2015 2:45 PM
4 Replies and 4244 Views Advice on COBOL training  4244  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 4244
by  Scott PerrierJump to last post
01/20/2015 9:59 AM
3 Replies and 16946 Views Using wildcard in DME query  16946  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 16946
by  Deleted UserJump to last post
01/13/2015 9:45 AM
7 Replies and 3645 Views PF Eclipse designer will not initiate  3645  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 3645
by  MCJump to last post
01/07/2015 6:43 AM
7 Replies and 4143 Views Can I leverage relations in COBOL query?  4143  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 4143
by  WoozyJump to last post
12/12/2014 10:39 AM
11 Replies and 3615 Views DME call and Javascript  3615  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 3615
by  mikePJump to last post
11/18/2014 5:12 PM
3 Replies and 2057 Views ESS - Hide buttons  2057  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 2057
by  MikeDJump to last post
11/13/2014 2:08 PM
2 Replies and 2246 Views Custom code to find a previous record  2246  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 2246
by  WoozyJump to last post
11/04/2014 3:50 PM
4 Replies and 2315 Views ESS label description change  2315  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 2315
by  ChescaJump to last post
10/27/2014 3:15 PM
4 Replies and 2311 Views Proxy as another user in LSF9 Portal and/or EMSS  2311  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 2311
by  WoozyJump to last post
10/24/2014 3:02 PM
10 Replies and 1929 Views Perplexed by LAWSON  1929  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 1929
by  Jason BeardJump to last post
10/23/2014 9:35 PM
0 Replies and 851 Views html page in Lawson  851  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 851
10/19/2014 8:48 AM
7 Replies and 2646 Views Call a Process Flow from within JavaScript  2646  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 2646
by  JimYJump to last post
10/17/2014 3:49 PM
0 Replies and 2264 Views Windows AD and useratts.htm  2264  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 2264
10/10/2014 2:40 PM
1 Replies and 1324 Views RQC version 10  1324  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 1324
by  Scott PerrierJump to last post
10/08/2014 3:49 PM
7 Replies and 3396 Views Looking for Lawson API Listing  3396  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 3396
by  jaherbJump to last post
10/06/2014 11:04 AM
0 Replies and 923 Views USERPROFILE  923  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 923
09/18/2014 3:56 PM
1 Replies and 1342 Views vbscript and ags  1342  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 1342
by  John HenleyJump to last post
09/17/2014 5:09 PM
1 Replies and 1030 Views Shrinking fields  1030  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 1030
by  RitaJump to last post
09/17/2014 12:21 PM
4 Replies and 1197 Views two forms in one program  1197  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 1197
by  WoozyJump to last post
09/15/2014 3:12 PM
12 Replies and 3840 Views Job fails to kick off FTP script - unable to log in user/startstep failed  3840  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 3840
by  cpaine216Jump to last post
09/15/2014 9:28 AM
1 Replies and 1158 Views Adding fields to form  1158  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 1158
by  jaherbJump to last post
09/11/2014 11:16 AM
1 Replies and 1015 Views Painting with alternate index  1015  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 1015
by  RitaJump to last post
09/09/2014 3:16 PM
3 Replies and 1311 Views API  1311  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 1311
by  jaherbJump to last post
09/08/2014 12:36 PM
3 Replies and 1225 Views random alphanumeric string  1225  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 1225
by  Scott PerrierJump to last post
08/29/2014 2:03 PM
1 Replies and 1220 Views Infor graphic replacement on Login page  1220  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 1220
by  Srini RaoJump to last post
08/29/2014 8:41 AM
0 Replies and 841 Views What is $AUDFORM in the .scr file do?  841  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 841
08/27/2014 2:19 PM
2 Replies and 986 Views Process level changes  986  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 986
by  jaherbJump to last post
08/25/2014 10:08 AM
1 Replies and 1338 Views Javascript AGS call with Next  1338  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 1338
by  WoozyJump to last post
08/20/2014 5:12 PM
1 Replies and 1187 Views LP program syntax error  1187  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 1187
by  ChescaJump to last post
08/11/2014 3:18 PM
2 Replies and 1229 Views File dump  1229  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 1229
by  ChescaJump to last post
07/29/2014 1:23 PM
8 Replies and 1316 Views MSS - Customizations  1316  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 1316
by  Chris12Jump to last post
07/28/2014 1:44 PM
3 Replies and 1081 Views Deprecated 515-UPDATE-DATE-TIME api  1081  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 1081
by  jaherbJump to last post
07/24/2014 9:33 AM
5 Replies and 1072 Views ESS screen welcome screen  1072  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 1072
by  ChescaJump to last post
07/23/2014 2:17 PM
9 Replies and 8235 Views ESS Benefits Enrollment - My DME and AGS calls Not Working  8235  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 8235
by  Judy ConsoliJump to last post
07/03/2014 10:32 AM
0 Replies and 669 Views v10 how to define window for comments  669  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 669
06/24/2014 9:31 AM
3 Replies and 1141 Views Create var length recs  1141  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 1141
by  jaherbJump to last post
06/24/2014 9:25 AM
2 Replies and 1048 Views scan programs  1048  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 1048
by  WoozyJump to last post
06/23/2014 12:53 PM
1 Replies and 1268 Views Set up ESS Benefits Enrollment for a Medical Plan Spousal Surcharge  1268  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 1268
by  Karen SheridanJump to last post
06/13/2014 10:38 AM
5 Replies and 1180 Views CSV file read error  1180  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 1180
by  jaherbJump to last post
06/12/2014 3:28 PM
4 Replies and 1386 Views Publish Non-Lawson Report to Print Manager?  1386  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 1386
by  Greg MoellerJump to last post
05/22/2014 4:30 PM
3 Replies and 1330 Views .aif file  1330  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 1330
by  jaherbJump to last post
05/14/2014 5:22 PM
3 Replies and 2602 Views Work File error  2602  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 2602
by  jaherbJump to last post
05/08/2014 11:24 AM
3 Replies and 1287 Views Mosby Skills Interface  1287  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 1287
by  The.Sam.GrovesJump to last post
04/08/2014 11:11 AM
2 Replies and 1104 Views What are cnvscr.detail and cnvscr.out?  1104  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 1104
by  WoozyJump to last post
04/04/2014 3:07 PM
4 Replies and 3041 Views error message text not found  3041  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 3041
by  BrianMJump to last post
04/02/2014 3:55 PM
1 Replies and 1152 Views Associating Smart Office Script with the S3 Form  1152  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 1152
by  L GJump to last post
04/02/2014 6:39 AM
3 Replies and 1284 Views Script to email report from custom program - report incomplete  1284  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 1284
by  jaherbJump to last post
03/27/2014 11:18 AM
2 Replies and 1274 Views Multiple rows of comments  1274  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 1274
by  ChescaJump to last post
03/13/2014 2:01 PM
5 Replies and 1493 Views PRTIME  1493  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 1493
by  ChescaJump to last post
03/10/2014 7:03 AM
1 Replies and 1483 Views can't run/submit any jobs  1483  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 1483
by  ChescaJump to last post
03/07/2014 2:00 PM
1 Replies and 1318 Views HR11 AGS Call User Fields  1318  1 Started by  Judy Consoli Has anyone used the AGS call from html/javascript for updating fields on the User Field Tab
1 1318
by  John HenleyJump to last post
03/01/2014 7:03 AM
3 Replies and 1735 Views Employee Status change  1735  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 1735
by  jaherbJump to last post
02/27/2014 5:14 PM
6 Replies and 9314 Views Help accessing data returned by a DME call  9314  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 9314
by  ShelbyJump to last post
02/26/2014 3:52 PM
7 Replies and 2706 Views 4GL command button to launch HR13.3  2706  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 2706
by  jaherbJump to last post
02/21/2014 3:30 PM
2 Replies and 1471 Views dburf on custom paint program  1471  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 1471
by  jaherbJump to last post
02/20/2014 9:32 AM
2 Replies and 1169 Views Absence Management  1169  2 Started by  Chesca Does anybody know what table or screen would tell me if an employee is enrolled in absence plan/structure
2 1169
by  ChescaJump to last post
02/20/2014 8:19 AM
17 Replies and 2340 Views .scr file modifications  2340  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 2340
by  jaherbJump to last post
02/13/2014 5:02 PM
2 Replies and 1295 Views Effective date the employee became benefit eligible  1295  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 1295
by  ChescaJump to last post
02/10/2014 11:58 AM
7 Replies and 1510 Views Sort File for Online Update Form?  1510  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 1510
by  jaherbJump to last post
02/06/2014 1:07 PM
2 Replies and 1146 Views Calculate prior year  1146  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 1146
by  ChescaJump to last post
02/05/2014 2:21 PM
3 Replies and 4170 Views HTML/Javascript DME function for LOGAN  4170  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 4170
by  Scott PerrierJump to last post
01/31/2014 11:23 AM
5 Replies and 1721 Views Double Quotes on Empty fields in 4gl CSV file  1721  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 1721
by  Donna WirtJump to last post
01/30/2014 1:37 PM
0 Replies and 1367 Views .Net 4.5 SSO / Authentication to Lawson 9 or 10.0 Request for Examples  1367  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 1367
01/30/2014 8:05 AM
4 Replies and 1408 Views HRHISTORY  1408  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 1408
by  jaherbJump to last post
01/28/2014 10:24 AM
0 Replies and 950 Views HTTPS Post Response - Kaiser CAMS  950  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 950
01/22/2014 2:38 PM
2 Replies and 1218 Views LP35 Paint Screen  1218  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 1218
by  ChescaJump to last post
01/21/2014 8:34 AM
3 Replies and 991 Views Working with Messages  991  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 991
by  BrianMJump to last post
01/20/2014 2:53 PM
0 Replies and 860 Views Remove last four digits of SS Nbr From Printable Pay Stub  860  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 860
01/16/2014 10:58 AM
2 Replies and 1311 Views date calc API/routine  1311  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 1311
by  ChescaJump to last post
01/15/2014 8:37 AM
4 Replies and 3040 Views Barcode on Lawson Printed Form  3040  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 3040
by  Robert SpurrJump to last post
01/08/2014 8:52 PM
2 Replies and 2035 Views PGMDEF  2035  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 2035
by  WoozyJump to last post
01/06/2014 11:26 AM
2 Replies and 1395 Views PA531 - how to change 800-OPENINPUTCSV-APLLOADCSV path and file name  1395  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 1395
by  jaherbJump to last post
12/18/2013 11:17 AM
2 Replies and 1197 Views Remove a User Exit  1197  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 1197
by  Roger FrenchJump to last post
12/11/2013 9:08 AM
0 Replies and 888 Views Ho do you bold a line of text in .rpt  888  0 Started by  wilcoxmad I need to bold or highlite a line of text on a report. Anybody done that before Thanks.
0 888
12/05/2013 12:00 PM
2 Replies and 1393 Views Filters  1393  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 1393
by  ChescaJump to last post
12/03/2013 3:19 PM
3 Replies and 1159 Views Work file Field Names  1159  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 1159
by  jaherbJump to last post
12/03/2013 3:10 PM
1 Replies and 948 Views Spaces in CSV Headings  948  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 948
by  LynneJump to last post
12/03/2013 8:52 AM
4 Replies and 1032 Views Get Field Value Desciptions via Fetch  1032  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 1032
by  WoozyJump to last post
11/26/2013 1:08 PM
0 Replies and 748 Views Dynamic Key number  748  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 748
11/22/2013 10:17 AM
23 Replies and 2829 Views Help finding jobs  2829  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 2829
by  Greg MoellerJump to last post
11/19/2013 8:59 AM
5 Replies and 1162 Views new 4GL error on portal  1162  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 1162
by  MCJump to last post
11/12/2013 7:30 PM
4 Replies and 1048 Views Distinct Value in screen rules  1048  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 1048
by  ARajaJump to last post
11/12/2013 1:33 PM
4 Replies and 1461 Views database index filter routines  1461  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 1461
by  jaherbJump to last post
10/29/2013 11:35 AM
2 Replies and 1089 Views report mode  1089  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 1089
by  ChescaJump to last post
10/18/2013 12:42 PM
1 Replies and 1139 Views Lp180  1139  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 1139
by  ChescaJump to last post
10/16/2013 12:58 PM
6 Replies and 1420 Views Add a new column to an existing table while retaining table data  1420  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 1420
by  WoozyJump to last post
10/15/2013 5:15 PM
2 Replies and 2836 Views GEN/QUEUEDJOB.  2836  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 2836
by  ChescaJump to last post
10/03/2013 9:51 AM
1 Replies and 1039 Views Add workunit filter in workspace inbasket  1039  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 1039
by  John HenleyJump to last post
10/03/2013 9:16 AM
2 Replies and 1697 Views Compile Error - WS field not defined in specified WS  1697  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 1697
by  WoozyJump to last post
09/26/2013 11:32 AM
2 Replies and 1004 Views Remove Form UserExit?  1004  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 1004
by  WoozyJump to last post
09/26/2013 10:51 AM
0 Replies and 1209 Views Requisition Approval Inbasket Display Accounting Units  1209  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 1209
09/25/2013 10:42 AM
0 Replies and 856 Views Populate Audit Table via BN47 Form UserExit  856  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 856
09/23/2013 1:11 PM
4 Replies and 1922 Views workdef CSV file Header  1922  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 1922
by  jaherbJump to last post
09/16/2013 2:53 PM
2 Replies and 1397 Views ESS AGS call in JavaScript not returning data  1397  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 1397
by  ShelbyJump to last post
09/13/2013 3:27 PM
3 Replies and 1099 Views Spawn form from ADD button  1099  3 Started by  Woozy I have a custom S3 form, and I want to 'spawn' a new form when the 'Add' button is clicked, rather than having it add a record as it usually does.  I've spawned forms in the past by adding a button to the body of the form and setting the 'picture' attribute in the .scr to the form name.  Is there a way to do the same thing using the 'Add' button Thanks for your suggestions!  Kelly
3 1099
by  jaherbJump to last post
09/10/2013 6:08 PM
4 Replies and 1159 Views New Section Within a Form Object  1159  4 Started by  Woozy I have a custom form object (ZJ35) that includes two forms (ZJ35.1 and ZJ35.2).  I'm trying to add a custom section within the object that I can reference from both forms - similar to referencing an external library.  However, I keep getting an error on compile: Warning: Illegal PERFORM: Referenced LABEL Not In SECTION Warning:           LABEL: 3000-GET-LAST-PERIOD-PROCESSED Warning:     Source Line: 403 As far as I can tell, I have the ...
4 1159
by  WoozyJump to last post
09/10/2013 1:17 PM
1 Replies and 992 Views LP accrual rounding issue  992  1 Started by  Chesca Hello, how could I get the accrual to round correctly  The accrual calculated amount showing as 7.499700 (LP64) and we'd like to round to 7.500000 hours. LP02 screen: HOurs Method = 1 Round to .000001
1 992
by  jaherbJump to last post
08/27/2013 5:34 PM
3 Replies and 953 Views Deleting a painted field in a new form  953  3 Started by  Woozy I am using pgmdef/Paint to create a new form in LSF 901.  After adding some fields to the form, I decided that I wanted to remove one of them.  I moved the cursor into the field and pressed 'delete' and got a 'Cannot Delete Field' message.  Then moved the cursor to the right of the field and tried backspacing, and got the same error message.  It doesn't matter if it is Input, Output, Header, Detail, Key, or Non-Key.  The only way I can find to remove a  field is to ...
3 953
by  WoozyJump to last post
08/27/2013 12:09 PM
2 Replies and 950 Views Delete records  950  2 Started by  Chesca I want to delete 12 records from the TAEMPTRANS table. What would be the fastest or most efficient way to do this
2 950
by  ChescaJump to last post
08/23/2013 7:30 AM
1 Replies and 904 Views Handling Errors When Calling WriteAttach  904  1 Started by  BenignVanilla I wonder if anyone has experience using the WriteAttach functionality in Lawson I am making a call to WriteAttach, and am getting the following error that I can capture in Fiddler. TITLE=ERROR=Read of ORRules in  failed. ERRNBR=5016 Any ideas JD.
1 904
by  BenignVanillaJump to last post
08/22/2013 11:08 AM
2 Replies and 3391 Views Error: Bad value for argument action passed to function  3391  2 Started by  BenignVanilla I am new to the Lawson and AGS world, so bear with me if this is an obvious question. I researched on the web, and here at LawsonGuru, and have not been able to find an answer. I am attempting to login to Lawson via an AGS call, and am getting an error. In Fiddler, I see the call that is being made looks like this. User, Password and Server renamed to protect the innocent. _ssoUser=xxx&_ssoPass=yyy&_ssoLogin=Login&_action=LOGIN&_fromLoginPage=TRUE&_language=enus&_ss...
2 3391
by  BenignVanillaJump to last post
08/20/2013 1:16 PM
2 Replies and 1021 Views Lp140 TTR-day (pay period date)  1021  2 Started by  Chesca We are running LP140 for pay period end date 6/26/13. Employees enrolled in float holidays are not getting an accrual for pay period end date. Instead, they are accruing for a different pay period that's 6/21/16. That's not a valid pay period and going nuts trying to find out how this date is created .  it's only happening for employees enrolled in the float holiday plan.. I animated LP140 and no luck. Process thru date is 6/26 cycle date calculated in LP140 = 6/21
2 1021
by  ChescaJump to last post
08/19/2013 1:47 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