Search this forum:
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 2 of 6 << < 12345 > >>
 Last Post
3 Replies and 1974 Views ESS - Hide buttons  1974  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 1974
by  MikeDJump to last post
11/13/2014 2:08 PM
2 Replies and 2184 Views Custom code to find a previous record  2184  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 2184
by  WoozyJump to last post
11/04/2014 3:50 PM
4 Replies and 2210 Views ESS label description change  2210  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'),';return false', 'margin-top:10px') if(parent.errorPlans.length==0 && (parent.errorGroups.length==0 ||...
4 2210
by  ChescaJump to last post
10/27/2014 3:15 PM
4 Replies and 2238 Views Proxy as another user in LSF9 Portal and/or EMSS  2238  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 2238
by  WoozyJump to last post
10/24/2014 3:02 PM
10 Replies and 1836 Views Perplexed by LAWSON  1836  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 1836
by  Jason BeardJump to last post
10/23/2014 9:35 PM
0 Replies and 803 Views html page in Lawson  803  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 803
10/19/2014 8:48 AM
7 Replies and 2553 Views Call a Process Flow from within JavaScript  2553  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 2553
by  JimYJump to last post
10/17/2014 3:49 PM
0 Replies and 2189 Views Windows AD and useratts.htm  2189  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 2189
10/10/2014 2:40 PM
1 Replies and 1249 Views RQC version 10  1249  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 1249
by  Scott PerrierJump to last post
10/08/2014 3:49 PM
7 Replies and 3082 Views Looking for Lawson API Listing  3082  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 3082
by  jaherbJump to last post
10/06/2014 11:04 AM
0 Replies and 855 Views USERPROFILE  855  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 855
09/18/2014 3:56 PM
1 Replies and 1264 Views vbscript and ags  1264  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 1264
by  John HenleyJump to last post
09/17/2014 5:09 PM
1 Replies and 979 Views Shrinking fields  979  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 979
by  RitaJump to last post
09/17/2014 12:21 PM
4 Replies and 1136 Views two forms in one program  1136  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 1136
by  WoozyJump to last post
09/15/2014 3:12 PM
12 Replies and 3631 Views Job fails to kick off FTP script - unable to log in user/startstep failed  3631  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 - 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 3631
by  cpaine216Jump to last post
09/15/2014 9:28 AM
1 Replies and 1082 Views Adding fields to form  1082  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 1082
by  jaherbJump to last post
09/11/2014 11:16 AM
1 Replies and 961 Views Painting with alternate index  961  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 961
by  RitaJump to last post
09/09/2014 3:16 PM
3 Replies and 1250 Views API  1250  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 1250
by  jaherbJump to last post
09/08/2014 12:36 PM
3 Replies and 1121 Views random alphanumeric string  1121  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 1121
by  Scott PerrierJump to last post
08/29/2014 2:03 PM
1 Replies and 1158 Views Infor graphic replacement on Login page  1158  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 1158
by  Srini RaoJump to last post
08/29/2014 8:41 AM
0 Replies and 765 Views What is $AUDFORM in the .scr file do?  765  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 765
08/27/2014 2:19 PM
2 Replies and 927 Views Process level changes  927  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 927
by  jaherbJump to last post
08/25/2014 10:08 AM
1 Replies and 1238 Views Javascript AGS call with Next  1238  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 1238
by  WoozyJump to last post
08/20/2014 5:12 PM
1 Replies and 1115 Views LP program syntax error  1115  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 1115
by  ChescaJump to last post
08/11/2014 3:18 PM
2 Replies and 1185 Views File dump  1185  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 1185
by  ChescaJump to last post
07/29/2014 1:23 PM
8 Replies and 1222 Views MSS - Customizations  1222  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 1222
by  Chris12Jump to last post
07/28/2014 1:44 PM
3 Replies and 1018 Views Deprecated 515-UPDATE-DATE-TIME api  1018  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 1018
by  jaherbJump to last post
07/24/2014 9:33 AM
5 Replies and 1016 Views ESS screen welcome screen  1016  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 1016
by  ChescaJump to last post
07/23/2014 2:17 PM
9 Replies and 7637 Views ESS Benefits Enrollment - My DME and AGS calls Not Working  7637  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 7637
by  Judy ConsoliJump to last post
07/03/2014 10:32 AM
0 Replies and 616 Views v10 how to define window for comments  616  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 616
06/24/2014 9:31 AM
3 Replies and 1088 Views Create var length recs  1088  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 1088
by  jaherbJump to last post
06/24/2014 9:25 AM
2 Replies and 968 Views scan programs  968  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 968
by  WoozyJump to last post
06/23/2014 12:53 PM
1 Replies and 1198 Views Set up ESS Benefits Enrollment for a Medical Plan Spousal Surcharge  1198  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 1198
by  Karen SheridanJump to last post
06/13/2014 10:38 AM
5 Replies and 1126 Views CSV file read error  1126  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 1126
by  jaherbJump to last post
06/12/2014 3:28 PM
4 Replies and 1287 Views Publish Non-Lawson Report to Print Manager?  1287  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 1287
by  Greg MoellerJump to last post
05/22/2014 4:30 PM
3 Replies and 1180 Views .aif file  1180  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 1180
by  jaherbJump to last post
05/14/2014 5:22 PM
3 Replies and 2331 Views Work File error  2331  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 2331
by  jaherbJump to last post
05/08/2014 11:24 AM
3 Replies and 1201 Views Mosby Skills Interface  1201  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 1201
by  The.Sam.GrovesJump to last post
04/08/2014 11:11 AM
2 Replies and 1044 Views What are cnvscr.detail and cnvscr.out?  1044  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 1044
by  WoozyJump to last post
04/04/2014 3:07 PM
4 Replies and 2699 Views error message text not found  2699  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 2699
by  BrianMJump to last post
04/02/2014 3:55 PM
1 Replies and 1077 Views Associating Smart Office Script with the S3 Form  1077  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 1077
by  L GJump to last post
04/02/2014 6:39 AM
3 Replies and 1185 Views Script to email report from custom program - report incomplete  1185  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 1185
by  jaherbJump to last post
03/27/2014 11:18 AM
2 Replies and 1090 Views Multiple rows of comments  1090  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 1090
by  ChescaJump to last post
03/13/2014 2:01 PM
5 Replies and 1439 Views PRTIME  1439  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 1439
by  ChescaJump to last post
03/10/2014 7:03 AM
1 Replies and 1409 Views can't run/submit any jobs  1409  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 1409
by  ChescaJump to last post
03/07/2014 2:00 PM
1 Replies and 1213 Views HR11 AGS Call User Fields  1213  1 Started by  Judy Consoli Has anyone used the AGS call from html/javascript for updating fields on the User Field Tab
1 1213
by  John HenleyJump to last post
03/01/2014 7:03 AM
3 Replies and 1660 Views Employee Status change  1660  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 1660
by  jaherbJump to last post
02/27/2014 5:14 PM
6 Replies and 9055 Views Help accessing data returned by a DME call  9055  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 9055
by  ShelbyJump to last post
02/26/2014 3:52 PM
7 Replies and 2591 Views 4GL command button to launch HR13.3  2591  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 2591
by  jaherbJump to last post
02/21/2014 3:30 PM
2 Replies and 1401 Views dburf on custom paint program  1401  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 1401
by  jaherbJump to last post
02/20/2014 9:32 AM
2 Replies and 1095 Views Absence Management  1095  2 Started by  Chesca Does anybody know what table or screen would tell me if an employee is enrolled in absence plan/structure
2 1095
by  ChescaJump to last post
02/20/2014 8:19 AM
17 Replies and 2151 Views .scr file modifications  2151  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 2151
by  jaherbJump to last post
02/13/2014 5:02 PM
2 Replies and 1248 Views Effective date the employee became benefit eligible  1248  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 1248
by  ChescaJump to last post
02/10/2014 11:58 AM
7 Replies and 1442 Views Sort File for Online Update Form?  1442  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 1442
by  jaherbJump to last post
02/06/2014 1:07 PM
2 Replies and 1076 Views Calculate prior year  1076  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 1076
by  ChescaJump to last post
02/05/2014 2:21 PM
3 Replies and 4061 Views HTML/Javascript DME function for LOGAN  4061  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 4061
by  Scott PerrierJump to last post
01/31/2014 11:23 AM
5 Replies and 1630 Views Double Quotes on Empty fields in 4gl CSV file  1630  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 1630
by  Donna WirtJump to last post
01/30/2014 1:37 PM
0 Replies and 1297 Views .Net 4.5 SSO / Authentication to Lawson 9 or 10.0 Request for Examples  1297  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. Thanks,
0 1297
01/30/2014 8:05 AM
4 Replies and 1330 Views HRHISTORY  1330  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 1330
by  jaherbJump to last post
01/28/2014 10:24 AM
0 Replies and 888 Views HTTPS Post Response - Kaiser CAMS  888  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 888
01/22/2014 2:38 PM
2 Replies and 1141 Views LP35 Paint Screen  1141  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 1141
by  ChescaJump to last post
01/21/2014 8:34 AM
3 Replies and 926 Views Working with Messages  926  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 926
by  BrianMJump to last post
01/20/2014 2:53 PM
0 Replies and 799 Views Remove last four digits of SS Nbr From Printable Pay Stub  799  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 799
01/16/2014 10:58 AM
2 Replies and 1246 Views date calc API/routine  1246  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 1246
by  ChescaJump to last post
01/15/2014 8:37 AM
4 Replies and 2893 Views Barcode on Lawson Printed Form  2893  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 2893
by  Robert SpurrJump to last post
01/08/2014 8:52 PM
2 Replies and 1876 Views PGMDEF  1876  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 1876
by  WoozyJump to last post
01/06/2014 11:26 AM
2 Replies and 1319 Views PA531 - how to change 800-OPENINPUTCSV-APLLOADCSV path and file name  1319  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 1319
by  jaherbJump to last post
12/18/2013 11:17 AM
2 Replies and 1108 Views Remove a User Exit  1108  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 1108
by  Roger FrenchJump to last post
12/11/2013 9:08 AM
0 Replies and 830 Views Ho do you bold a line of text in .rpt  830  0 Started by  wilcoxmad I need to bold or highlite a line of text on a report. Anybody done that before Thanks.
0 830
12/05/2013 12:00 PM
2 Replies and 1241 Views Filters  1241  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 1241
by  ChescaJump to last post
12/03/2013 3:19 PM
3 Replies and 1074 Views Work file Field Names  1074  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 1074
by  jaherbJump to last post
12/03/2013 3:10 PM
1 Replies and 860 Views Spaces in CSV Headings  860  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 860
by  LynneJump to last post
12/03/2013 8:52 AM
4 Replies and 992 Views Get Field Value Desciptions via Fetch  992  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 992
by  WoozyJump to last post
11/26/2013 1:08 PM
0 Replies and 697 Views Dynamic Key number  697  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 697
11/22/2013 10:17 AM
23 Replies and 2742 Views Help finding jobs  2742  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 2742
by  Greg MoellerJump to last post
11/19/2013 8:59 AM
5 Replies and 1112 Views new 4GL error on portal  1112  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.( a...
5 1112
by  MCJump to last post
11/12/2013 7:30 PM
4 Replies and 990 Views Distinct Value in screen rules  990  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 990
by  ARajaJump to last post
11/12/2013 1:33 PM
4 Replies and 1398 Views database index filter routines  1398  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 1398
by  jaherbJump to last post
10/29/2013 11:35 AM
2 Replies and 1033 Views report mode  1033  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 1033
by  ChescaJump to last post
10/18/2013 12:42 PM
1 Replies and 1051 Views Lp180  1051  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 1051
by  ChescaJump to last post
10/16/2013 12:58 PM
6 Replies and 1281 Views Add a new column to an existing table while retaining table data  1281  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 1281
by  WoozyJump to last post
10/15/2013 5:15 PM
2 Replies and 2615 Views GEN/QUEUEDJOB.  2615  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 2615
by  ChescaJump to last post
10/03/2013 9:51 AM
1 Replies and 953 Views Add workunit filter in workspace inbasket  953  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 953
by  John HenleyJump to last post
10/03/2013 9:16 AM
2 Replies and 1561 Views Compile Error - WS field not defined in specified WS  1561  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 1561
by  WoozyJump to last post
09/26/2013 11:32 AM
2 Replies and 953 Views Remove Form UserExit?  953  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 953
by  WoozyJump to last post
09/26/2013 10:51 AM
0 Replies and 1144 Views Requisition Approval Inbasket Display Accounting Units  1144  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 1144
09/25/2013 10:42 AM
0 Replies and 809 Views Populate Audit Table via BN47 Form UserExit  809  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 809
09/23/2013 1:11 PM
4 Replies and 1773 Views workdef CSV file Header  1773  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 1773
by  jaherbJump to last post
09/16/2013 2:53 PM
2 Replies and 1334 Views ESS AGS call in JavaScript not returning data  1334  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 1334
by  ShelbyJump to last post
09/13/2013 3:27 PM
3 Replies and 1033 Views Spawn form from ADD button  1033  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 1033
by  jaherbJump to last post
09/10/2013 6:08 PM
4 Replies and 1103 Views New Section Within a Form Object  1103  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 1103
by  WoozyJump to last post
09/10/2013 1:17 PM
1 Replies and 929 Views LP accrual rounding issue  929  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 929
by  jaherbJump to last post
08/27/2013 5:34 PM
3 Replies and 911 Views Deleting a painted field in a new form  911  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 911
by  WoozyJump to last post
08/27/2013 12:09 PM
2 Replies and 903 Views Delete records  903  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 903
by  ChescaJump to last post
08/23/2013 7:30 AM
1 Replies and 821 Views Handling Errors When Calling WriteAttach  821  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 821
by  BenignVanillaJump to last post
08/22/2013 11:08 AM
2 Replies and 3206 Views Error: Bad value for argument action passed to function  3206  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 3206
by  BenignVanillaJump to last post
08/20/2013 1:16 PM
2 Replies and 971 Views Lp140 TTR-day (pay period date)  971  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 971
by  ChescaJump to last post
08/19/2013 1:47 PM
0 Replies and 667 Views How to resize ESS Direct Deposit Add Account Pane  667  0 Started by  agersh After adding aditional text to the ESS Direct Deposit Add Account Pane a vertical scroll bar now appears. Is it possible though programming resize height of the Direct Deposit Add Account Pane I have attached a screenshot to this incident.
0 667
08/15/2013 4:40 PM
6 Replies and 1414 Views LP balances - taeemaster  1414  6 Started by  Chesca I am writing a custom program to apply caps to the available balance after payroll close. The program is updating the balances but I jus realized TAEMPTRANS might have to be updated as well.  How can I find out what other tables might have to be updated if updating balances in taeemaster Employee Mastr TAEEMASTER   Required                        &nbs...
6 1414
by  ChescaJump to last post
08/15/2013 6:51 AM
0 Replies and 861 Views Issue with DME variable scope  861  0 Started by  Chad Dirst I have added a DME query to an ESS screen and am having issues with when I can use the variable. I define a globalvariable called EmployeeProcessLevel.   During one of the original Lawson functions, I call my function (QueryOEEmployeeProcessLevel) to get the data I need.  This dme function in turn calls the SetOEProcessLevel function which should set the global variable (EmployeeProcessLevel) I defined.  The issue is that when control passes ba...
0 861
08/14/2013 11:33 AM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 2 of 6 << < 12345 > >>

RSS Feed Available