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 2 of 6 << < 12345 > >>
Topics
 Replies
 Views
 Last Post
10 Replies and 1715 Views Perplexed by LAWSON  1715  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 1715
by  Jason BeardJump to last post
10/23/2014 9:35 PM
0 Replies and 713 Views html page in Lawson  713  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 713
10/19/2014 8:48 AM
7 Replies and 2428 Views Call a Process Flow from within JavaScript  2428  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 2428
by  JimYJump to last post
10/17/2014 3:49 PM
0 Replies and 2091 Views Windows AD and useratts.htm  2091  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 2091
10/10/2014 2:40 PM
1 Replies and 1142 Views RQC version 10  1142  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 1142
by  Scott PerrierJump to last post
10/08/2014 3:49 PM
7 Replies and 2774 Views Looking for Lawson API Listing  2774  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 2774
by  jaherbJump to last post
10/06/2014 11:04 AM
0 Replies and 763 Views USERPROFILE  763  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 763
09/18/2014 3:56 PM
1 Replies and 1120 Views vbscript and ags  1120  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 1120
by  John HenleyJump to last post
09/17/2014 5:09 PM
1 Replies and 888 Views Shrinking fields  888  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 888
by  RitaJump to last post
09/17/2014 12:21 PM
4 Replies and 1022 Views two forms in one program  1022  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 1022
by  WoozyJump to last post
09/15/2014 3:12 PM
12 Replies and 3455 Views Job fails to kick off FTP script - unable to log in user/startstep failed  3455  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 3455
by  cpaine216Jump to last post
09/15/2014 9:28 AM
1 Replies and 942 Views Adding fields to form  942  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 942
by  jaherbJump to last post
09/11/2014 11:16 AM
1 Replies and 840 Views Painting with alternate index  840  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 840
by  RitaJump to last post
09/09/2014 3:16 PM
3 Replies and 1129 Views API  1129  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 1129
by  jaherbJump to last post
09/08/2014 12:36 PM
3 Replies and 962 Views random alphanumeric string  962  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 962
by  Scott PerrierJump to last post
08/29/2014 2:03 PM
1 Replies and 1044 Views Infor graphic replacement on Login page  1044  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 1044
by  Srini RaoJump to last post
08/29/2014 8:41 AM
0 Replies and 654 Views What is $AUDFORM in the .scr file do?  654  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 654
08/27/2014 2:19 PM
2 Replies and 822 Views Process level changes  822  2 Started by  bernfc10 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 822
by  jaherbJump to last post
08/25/2014 10:08 AM
1 Replies and 1081 Views Javascript AGS call with Next  1081  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 1081
by  WoozyJump to last post
08/20/2014 5:12 PM
1 Replies and 1008 Views LP program syntax error  1008  1 Started by  bernfc10 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 1008
by  bernfc10Jump to last post
08/11/2014 3:18 PM
2 Replies and 1066 Views File dump  1066  2 Started by  bernfc10 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 1066
by  bernfc10Jump to last post
07/29/2014 1:23 PM
8 Replies and 1071 Views MSS - Customizations  1071  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 1071
by  Chris12Jump to last post
07/28/2014 1:44 PM
3 Replies and 893 Views Deprecated 515-UPDATE-DATE-TIME api  893  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 893
by  jaherbJump to last post
07/24/2014 9:33 AM
5 Replies and 913 Views ESS screen welcome screen  913  5 Started by  bernfc10 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 913
by  bernfc10Jump to last post
07/23/2014 2:17 PM
9 Replies and 7174 Views ESS Benefits Enrollment - My DME and AGS calls Not Working  7174  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 7174
by  Judy ConsoliJump to last post
07/03/2014 10:32 AM
0 Replies and 546 Views v10 how to define window for comments  546  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 546
06/24/2014 9:31 AM
3 Replies and 995 Views Create var length recs  995  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 995
by  jaherbJump to last post
06/24/2014 9:25 AM
2 Replies and 874 Views scan programs  874  2 Started by  bernfc10 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 874
by  WoozyJump to last post
06/23/2014 12:53 PM
1 Replies and 1066 Views Set up ESS Benefits Enrollment for a Medical Plan Spousal Surcharge  1066  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 1066
by  Karen SheridanJump to last post
06/13/2014 10:38 AM
5 Replies and 966 Views CSV file read error  966  5 Started by  Brian 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 966
by  jaherbJump to last post
06/12/2014 3:28 PM
4 Replies and 1119 Views Publish Non-Lawson Report to Print Manager?  1119  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 1119
by  Greg MoellerJump to last post
05/22/2014 4:30 PM
3 Replies and 1078 Views .aif file  1078  3 Started by  Brian 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 1078
by  jaherbJump to last post
05/14/2014 5:22 PM
3 Replies and 2044 Views Work File error  2044  3 Started by  bernfc10 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 2044
by  jaherbJump to last post
05/08/2014 11:24 AM
3 Replies and 1075 Views Mosby Skills Interface  1075  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 1075
by  The.Sam.GrovesJump to last post
04/08/2014 11:11 AM
2 Replies and 949 Views What are cnvscr.detail and cnvscr.out?  949  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 949
by  WoozyJump to last post
04/04/2014 3:07 PM
4 Replies and 2382 Views error message text not found  2382  4 Started by  Brian 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 2382
by  BrianJump to last post
04/02/2014 3:55 PM
1 Replies and 975 Views Associating Smart Office Script with the S3 Form  975  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 975
by  L GJump to last post
04/02/2014 6:39 AM
3 Replies and 1080 Views Script to email report from custom program - report incomplete  1080  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 1080
by  jaherbJump to last post
03/27/2014 11:18 AM
2 Replies and 941 Views Multiple rows of comments  941  2 Started by  bernfc10 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 941
by  bernfc10Jump to last post
03/13/2014 2:01 PM
5 Replies and 1316 Views PRTIME  1316  5 Started by  bernfc10 Does anybody know if I can use PRTIME to report a breakdown of salary information for an employee within a specific time period
5 1316
by  BarbLRJump to last post
03/10/2014 7:03 AM
1 Replies and 1263 Views can't run/submit any jobs  1263  1 Started by  bernfc10 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 1263
by  bernfc10Jump to last post
03/07/2014 2:00 PM
1 Replies and 1109 Views HR11 AGS Call User Fields  1109  1 Started by  Judy Consoli Has anyone used the AGS call from html/javascript for updating fields on the User Field Tab
1 1109
by  John HenleyJump to last post
03/01/2014 7:03 AM
3 Replies and 1561 Views Employee Status change  1561  3 Started by  bernfc10 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 1561
by  jaherbJump to last post
02/27/2014 5:14 PM
6 Replies and 8832 Views Help accessing data returned by a DME call  8832  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 8832
by  ShelbyJump to last post
02/26/2014 3:52 PM
7 Replies and 2407 Views 4GL command button to launch HR13.3  2407  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 2407
by  jaherbJump to last post
02/21/2014 3:30 PM
2 Replies and 1292 Views dburf on custom paint program  1292  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 1292
by  jaherbJump to last post
02/20/2014 9:32 AM
2 Replies and 984 Views Absence Management  984  2 Started by  bernfc10 Does anybody know what table or screen would tell me if an employee is enrolled in absence plan/structure
2 984
by  bernfc10Jump to last post
02/20/2014 8:19 AM
17 Replies and 1907 Views .scr file modifications  1907  17 Started by  Brian 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 1907
by  jaherbJump to last post
02/13/2014 5:02 PM
2 Replies and 1146 Views Effective date the employee became benefit eligible  1146  2 Started by  bernfc10 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 1146
by  bernfc10Jump to last post
02/10/2014 11:58 AM
7 Replies and 1313 Views Sort File for Online Update Form?  1313  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 1313
by  jaherbJump to last post
02/06/2014 1:07 PM
2 Replies and 975 Views Calculate prior year  975  2 Started by  bernfc10 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 975
by  bernfc10Jump to last post
02/05/2014 2:21 PM
3 Replies and 3909 Views HTML/Javascript DME function for LOGAN  3909  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 3909
by  Scott PerrierJump to last post
01/31/2014 11:23 AM
5 Replies and 1486 Views Double Quotes on Empty fields in 4gl CSV file  1486  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 1486
by  Donna WirtJump to last post
01/30/2014 1:37 PM
0 Replies and 1210 Views .Net 4.5 SSO / Authentication to Lawson 9 or 10.0 Request for Examples  1210  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 1210
01/30/2014 8:05 AM
4 Replies and 1200 Views HRHISTORY  1200  4 Started by  bernfc10 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 1200
by  jaherbJump to last post
01/28/2014 10:24 AM
0 Replies and 789 Views HTTPS Post Response - Kaiser CAMS  789  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 789
01/22/2014 2:38 PM
2 Replies and 1039 Views LP35 Paint Screen  1039  2 Started by  bernfc10 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 1039
by  bernfc10Jump to last post
01/21/2014 8:34 AM
3 Replies and 853 Views Working with Messages  853  3 Started by  Brian 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 853
by  BrianJump to last post
01/20/2014 2:53 PM
0 Replies and 708 Views Remove last four digits of SS Nbr From Printable Pay Stub  708  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 708
01/16/2014 10:58 AM
2 Replies and 1155 Views date calc API/routine  1155  2 Started by  bernfc10 Is there a routine/API to return the last day in a given month or return a date such as 1/31/2014
2 1155
by  bernfc10Jump to last post
01/15/2014 8:37 AM
4 Replies and 2731 Views Barcode on Lawson Printed Form  2731  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 2731
by  Robert SpurrJump to last post
01/08/2014 8:52 PM
2 Replies and 1725 Views PGMDEF  1725  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 1725
by  WoozyJump to last post
01/06/2014 11:26 AM
2 Replies and 1217 Views PA531 - how to change 800-OPENINPUTCSV-APLLOADCSV path and file name  1217  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 1217
by  jaherbJump to last post
12/18/2013 11:17 AM
2 Replies and 992 Views Remove a User Exit  992  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 992
by  Roger FrenchJump to last post
12/11/2013 9:08 AM
0 Replies and 772 Views Ho do you bold a line of text in .rpt  772  0 Started by  wilcoxmad I need to bold or highlite a line of text on a report. Anybody done that before Thanks.
0 772
12/05/2013 12:00 PM
2 Replies and 1174 Views Filters  1174  2 Started by  bernfc10 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 1174
by  bernfc10Jump to last post
12/03/2013 3:19 PM
3 Replies and 960 Views Work file Field Names  960  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 960
by  jaherbJump to last post
12/03/2013 3:10 PM
1 Replies and 778 Views Spaces in CSV Headings  778  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 778
by  LynneJump to last post
12/03/2013 8:52 AM
4 Replies and 906 Views Get Field Value Desciptions via Fetch  906  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 906
by  WoozyJump to last post
11/26/2013 1:08 PM
0 Replies and 617 Views Dynamic Key number  617  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 617
11/22/2013 10:17 AM
23 Replies and 2572 Views Help finding jobs  2572  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 2572
by  Greg MoellerJump to last post
11/19/2013 8:59 AM
5 Replies and 1020 Views new 4GL error on portal  1020  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 1020
by  MCJump to last post
11/12/2013 7:30 PM
4 Replies and 900 Views Distinct Value in screen rules  900  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 900
by  ARajaJump to last post
11/12/2013 1:33 PM
4 Replies and 1287 Views database index filter routines  1287  4 Started by  bernfc10 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 1287
by  jaherbJump to last post
10/29/2013 11:35 AM
2 Replies and 946 Views report mode  946  2 Started by  bernfc10 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 946
by  bernfc10Jump to last post
10/18/2013 12:42 PM
1 Replies and 964 Views Lp180  964  1 Started by  bernfc10 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 964
by  bernfc10Jump to last post
10/16/2013 12:58 PM
6 Replies and 1152 Views Add a new column to an existing table while retaining table data  1152  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 1152
by  WoozyJump to last post
10/15/2013 5:15 PM
2 Replies and 2407 Views GEN/QUEUEDJOB.  2407  2 Started by  bernfc10 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 2407
by  bernfc10Jump to last post
10/03/2013 9:51 AM
1 Replies and 866 Views Add workunit filter in workspace inbasket  866  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 866
by  John HenleyJump to last post
10/03/2013 9:16 AM
2 Replies and 1447 Views Compile Error - WS field not defined in specified WS  1447  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 1447
by  WoozyJump to last post
09/26/2013 11:32 AM
2 Replies and 890 Views Remove Form UserExit?  890  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 890
by  WoozyJump to last post
09/26/2013 10:51 AM
0 Replies and 1063 Views Requisition Approval Inbasket Display Accounting Units  1063  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 1063
09/25/2013 10:42 AM
0 Replies and 742 Views Populate Audit Table via BN47 Form UserExit  742  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 742
09/23/2013 1:11 PM
4 Replies and 1631 Views workdef CSV file Header  1631  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 1631
by  jaherbJump to last post
09/16/2013 2:53 PM
2 Replies and 1283 Views ESS AGS call in JavaScript not returning data  1283  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 1283
by  ShelbyJump to last post
09/13/2013 3:27 PM
3 Replies and 945 Views Spawn form from ADD button  945  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 945
by  jaherbJump to last post
09/10/2013 6:08 PM
4 Replies and 1043 Views New Section Within a Form Object  1043  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 1043
by  WoozyJump to last post
09/10/2013 1:17 PM
1 Replies and 855 Views LP accrual rounding issue  855  1 Started by  bernfc10 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 855
by  jaherbJump to last post
08/27/2013 5:34 PM
3 Replies and 852 Views Deleting a painted field in a new form  852  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 852
by  WoozyJump to last post
08/27/2013 12:09 PM
2 Replies and 836 Views Delete records  836  2 Started by  bernfc10 I want to delete 12 records from the TAEMPTRANS table. What would be the fastest or most efficient way to do this
2 836
by  bernfc10Jump to last post
08/23/2013 7:30 AM
1 Replies and 759 Views Handling Errors When Calling WriteAttach  759  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 759
by  BenignVanillaJump to last post
08/22/2013 11:08 AM
2 Replies and 3093 Views Error: Bad value for argument action passed to function  3093  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 3093
by  BenignVanillaJump to last post
08/20/2013 1:16 PM
2 Replies and 912 Views Lp140 TTR-day (pay period date)  912  2 Started by  bernfc10 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 912
by  bernfc10Jump to last post
08/19/2013 1:47 PM
0 Replies and 624 Views How to resize ESS Direct Deposit Add Account Pane  624  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 624
08/15/2013 4:40 PM
6 Replies and 1280 Views LP balances - taeemaster  1280  6 Started by  bernfc10 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 1280
by  bernfc10Jump to last post
08/15/2013 6:51 AM
0 Replies and 812 Views Issue with DME variable scope  812  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 812
08/14/2013 11:33 AM
5 Replies and 918 Views Link table  918  5 Started by  Srini Rao I have SQL Server 2008 with database A on machine A. Another  SQL Server 2008 with Lawson S3 database on B. I want to link tables from the database on machine A into a database on machine B and Update the table A using 4GL program. Any help is Appreciated.
5 918
by  Srini RaoJump to last post
08/14/2013 6:42 AM
2 Replies and 823 Views LP SERVICE RECORDS -TAEMPSERV  823  2 Started by  bernfc10 Does anybody know how service records get created
2 823
by  bernfc10Jump to last post
08/13/2013 7:29 AM
2 Replies and 768 Views ESS - Avaliablity of benefit plans contingent on enrollment in different plan.  768  2 Started by  The.Sam.Groves We are talking about setting up a plan which is only avalaible if the employee enrolled in a specific health plan. We've been told that stock ESS wouldn't be able to handle preventing the employee from seeing the plan, since normal avaliablity is based on groups, which wouldn't be updated till after enrollment was finished. How much of a headache are we looking at if we wanted to do a customization for this in ESS Naivity would lead me to think it would be a relatively simple thing.
2 768
by  The.Sam.GrovesJump to last post
08/08/2013 10:53 AM
4 Replies and 2962 Views Integrating with Lawson  2962  4 Started by  Art I am looking for the best way to help a client automatically import data into lawson on a regular basis, for example monthly journal entries for various accounts.  What is the best way to do this  Is their an API that we can use, or can we connect directly to the lawson database via ODBC  Does lawson have any SDKs or kits for developers  What is best practice  Any help anyone can provide would be greatly appreciated.  Thank you.
4 2962
by  ArielJump to last post
08/01/2013 10:28 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