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 3 of 6 << < 12345 > >>
 Last Post
5 Replies and 942 Views Link table  942  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 942
by  Srini RaoJump to last post
08/14/2013 6:42 AM
2 Replies and 876 Views LP SERVICE RECORDS -TAEMPSERV  876  2 Started by  Chesca Does anybody know how service records get created
2 876
by  ChescaJump to last post
08/13/2013 7:29 AM
2 Replies and 797 Views ESS - Avaliablity of benefit plans contingent on enrollment in different plan.  797  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 797
by  The.Sam.GrovesJump to last post
08/08/2013 10:53 AM
4 Replies and 3048 Views Integrating with Lawson  3048  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 3048
by  ArielJump to last post
08/01/2013 10:28 AM
0 Replies and 1243 Views Need examples - VBScript SSO and AGS calls  1243  0 Started by  jocelyn From reading the IOS manual, cruising this site and others have been able to put together the 'calls' to log into Lawson, perform an AP20 add transaction and log out...from the browser.   I need to be able to do the same from an outside application using VBScript.   The examples I've seen are for java, javascript.  Can't get it working from javascript or HTML, either, yet.  But really need to use VBScript.    Using Lawson 10, if that helps.
0 1243
07/30/2013 8:14 AM
5 Replies and 948 Views scrgen form definition to display current date  948  5 Started by  Demichener I'm trying to display, by default; the current date on a portal form using the scrgen form definition. ie. after the initial search box selection, the form would pop-up with the default values already populated. I've used various combinations, but can't seem to find one that works.  Can someone please share how to accomplish this
5 948
by  DemichenerJump to last post
07/23/2013 2:15 PM
3 Replies and 1513 Views Prevent FICA Nbr from displaying in Emp[loyee drill fields  1513  3 Started by  TBonney Has anyone got a solution for how to prevent employee's FICA Numbers from being displayed on results of Employee drill fields Whenever anyone drills around on the employee field from any screen, the displayed results include every employee's social security number. We would like to prevent this information form being so plainly and easily visible. I have found some articles and discussion threads referencing However, I am unfamiliar with this file and how to modify it. (i.e. what to r...
3 1513
by  Shane JonesJump to last post
07/20/2013 7:15 PM
6 Replies and 1376 Views Default Requisition Special/Service Item Type  1376  6 Started by  SKMacCauley I am trying to default the item type for the Requisition Special/Service screen (not RQ10.1). I believe the cose may be stored somewhere in the rqc.war file and was wondering if anyone was familiar on working with this form for customization. I simply need to default the Item Type field to read 'Amount Service' instead of 'Special'.
6 1376
by  Judy ConsoliJump to last post
07/18/2013 9:58 AM
6 Replies and 2407 Views Replace characters in string in 4GL  2407  6 Started by  Lorena Hi, I need to replace spaces by _ in a string in 4GL. Does anyone know if Lawson provides any routine for this Example: Input: Boca Raton Output: Boca_Raton Thanks, Lorena
6 2407
by  maalimsimoJump to last post
07/18/2013 9:53 AM
6 Replies and 992 Views Cloned a Lawson form (IC285) missing search box on fields  992  6 Started by  Lmanke I recently cloned IC285 to ZC285 so we can make a customization to it and I notice that the some of the fields no longer have the search box next to them.  (ie Company, Item, Report Group). I do have 1 field with the search box but it doesn't displays any values. When I copied this program I did put it into another source folder where we put all our custom programs. Not sure if that's the issue or not. Any ideas what I might be missing Thanks!
6 992
by  LmankeJump to last post
07/01/2013 2:29 PM
2 Replies and 1281 Views Adding support for AuthUser to new HTML page  1281  2 Started by  Darkwater23 Hello! I'm a software developer for Woodmen of the World. A co-worker asked for my assistance with integrating a single sign-on solution in Lawson under the employee self-service for signing our employees into the United Way website. I created an HTML page that does the sign in work using Javascript. What I'd like to do is add some JS references to the page so that it can be served up on the same box as Lawson and use some kind of Javascript user object to get the employee number. I'm not ...
2 1281
by  Darkwater23Jump to last post
06/24/2013 3:24 PM
3 Replies and 1171 Views Field Description Changes  1171  3 Started by  Deleted User Good morning - our users requested the description display for Ben date 1, 2 and 3 (on PAEMPLOYEE) be changed in their portal view.  The decision was made to change the descriptions using design studio on HR11   - however, users make the bulk of changes using personnel actions, and we didn't think things through since the HR11 change doesn't flow over to the PA52 screens.  Is there a way to change the descriptions here, also Many thanks for any insight -
3 1171
by  John HenleyJump to last post
06/20/2013 6:21 AM
0 Replies and 657 Views How to print the standard footer on the last page of a batch report  657  0 Started by  Woozy I have a custom batch program that includes a standard footer section.   The section works great, except that it doesn't print on the last page.  I've tried using PERFORM 700-PRINT-STD-FTR just before the end of my code, but that doesn't seem to work.  I've also tried just calling it as a regular section, but that throws a nasty error.  I suppose could duplicate the section and make it a 'regular' section I could call directly, but that seems really clumsy. Is there some t...
0 657
06/04/2013 12:35 PM
4 Replies and 1968 Views PA100HR  1968  4 Started by  Chesca PA100HR went in recovery mode due to a duplicate record.  How can I find the duplicate record or data that's causing this issue other than animating the program  Errror message:  ** Creating .prt and .dtl files                 Processing PA100 (Action Update)                 File PROD9/PGEMPLOYEE.  &nbs...
4 1968
by  ChescaJump to last post
05/31/2013 12:45 PM
4 Replies and 960 Views API/routine to calculate week days  960  4 Started by  Chesca Is there an API/routine tha calculates weekdays only
4 960
by  jaherbJump to last post
05/28/2013 3:41 PM
13 Replies and 2295 Views Customize home page  2295  13 Started by  Lorena Hi, We are working on the ESS implementation and we are trying to change&160;the home page. We want to remove the Useful information box (that contains the hotkeys help and the Portal user help). Can someone know how to do it Thanks, Lorena. &160;
13 2295
by  Shane JonesJump to last post
05/19/2013 10:46 PM
4 Replies and 851 Views Keep Total Section on same page as Detail  851  4 Started by  Woozy I have a custom batch report that has a detail section and a totals section for each employee.  I'd like to force the report to keep the employee detail and employee total sections together on the same page (i.e. don't page break between), but I can't figure out how to do that.  It seems like I've done this before, but I can't find it. Can anyone point me in the right direction Thanks!
4 851
by  WoozyJump to last post
05/17/2013 2:38 PM
3 Replies and 858 Views Inquiry only  858  3 Started by  Chesca My users want me to build a screen that allows them update some type of records and others allowed for inquire only (list the record). I am not sure if this would be possible with an online update screen.
3 858
by  ChescaJump to last post
05/16/2013 12:47 PM
1 Replies and 914 Views ESS: Custom Giving/Donation  914  1 Started by  Brandon I need to understand if there are other organizations utilizing ESS for employee giving campaigns. Currently we have a form and process built, however, I would like to see if: 1. Anyone else is attempting this functionality  2. If anyone would be willing to demo what they have been able to set up. Thanks Brandon Clinton Fairview 612-672-6703
1 914
by  Shane JonesJump to last post
05/13/2013 10:41 PM
6 Replies and 822 Views SRGEN error after applying a huge CTP batch...and I can't find error in the KB.  822  6 Started by  CindyW We applied about 150 CTPs in our newest development product line, and the SRGEN threw out a bunch of errors on the .sr files, and we cleaned up most of them.  However, there is one error that we can't figure out, and I can't find anything on it in the KB - ID Must Be Unique And Must Begin With SystemCode This is the section of the srgen output file that contains the errors. Processing D:\LSF9DEV\law\newtest901\vmsrc\ Line 521: ID Must Be Unique And Must Begin With SystemCode Li...
6 822
by  Kwane McNealJump to last post
05/08/2013 11:41 AM
2 Replies and 1440 Views Force an error exit in multi-step job  1440  2 Started by  mikeP I posted the gist of this question as a follow on to a different thread I started in the S3 Systems Admin forum, then realized it might be more appropriate here.  I hope this doesn't violate any cross posting rules. The first step of a two step job runs a token assigned to a Windows command file that first runs a VB script, then calls loadrpts.  The second job step runs PR530.  I don't want the PR530 to run if the first step fails., it would better for to job to go into recover...
2 1440
by  mikePJump to last post
04/15/2013 9:38 AM
2 Replies and 1734 Views custom program not found in Portal  1734  2 Started by  Chesca I created a custom program and moved to our test environment. The user is having issues finding/accessing the program. Errro:  search results: No program or bookmarks were found for 'program'.
2 1734
by  ChescaJump to last post
04/10/2013 9:40 AM
5 Replies and 1380 Views PR530 error messages - accounting uni  1380  5 Started by  Chesca Has anybody had any of the following errors when running PR530 or would know what library creates these error messages  Payroll wants to customize the library that creates such error messages,  but I don't know which library Employee    Message 12345           Accounting unit 12345 does not allow posting
5 1380
by  jaherbJump to last post
04/04/2013 9:58 AM
6 Replies and 2161 Views How do I read genlib tables?  2161  6 Started by  Donna Wirt I'm trying to read the genlib/JOBSTEP table to get a parameter value to use in a custom lawson program and a shell script.  Any help is greatly appreciated.  Thanks.
6 2161
by  Donna WirtJump to last post
04/02/2013 7:42 AM
1 Replies and 2036 Views DME Query Development Guide  2036  1 Started by  Layne Does anyone know of a DME Query Development Guide.  We are using Process Flow and a just got a newer version called Lawson Process Designer to be used to query the Landmark System.  Most of us do not have much exposure to using the DME queries, so any help with White Paper or Development Guides would be helpful.
1 2036
by  WoozyJump to last post
03/28/2013 10:36 AM
8 Replies and 7166 Views Question about LID for Development  7166  8 Started by  Woozy Our infrastructure/security folks really REALLY&160;want to eliminate telnet access to our Lawson servers.&160; Because of this, they are suggesting that we utilize PuTTY instead of LID&160;for our Lawson&160;development tasks so we can access using SSH instead of telnet.&160; Is LID&160;is more than just a terminal emulator&160;&160;Can we use a different emulator and still do what we need to do&160;&160;We'll be using the Application Development Workbench/4GL&160;to create cus...
8 7166
by  trueblueg8torJump to last post
03/26/2013 11:32 AM
4 Replies and 997 Views ESS - Add custom text to Tax Withholding popup window  997  4 Started by  Deleted User I want to add a customer disclaimer to the ESS Tax Withholding popup window that has the Update & Cancel buttons and states 'Under penalties of perjury, I declare....' but i'm having trouble locating which file it is. Can someone point me in the right direction Thanks.
4 997
by  Deleted UserJump to last post
03/25/2013 2:12 PM
2 Replies and 617 Views Redirect S3 Form Calls  617  2 Started by  Woozy At business request, I have created a customized (4GL, not DS) cloned version of 'HR55' named 'ZR55'.  Is there any way for me to 'force' the custom program to be called rather than the canned version  I know Design Studio does something like this, but I don't know if it is possible to do something similar outside of DS. Thanks for your help! Kelly
2 617
by  GeorgetteJump to last post
03/04/2013 1:11 PM
1 Replies and 1379 Views Implement Siteminder Lawson Authentication  1379  1 Started by  BigDave I have and older Lawson system that's been retired but we need to keep it in service for a while for reference.  It's basically the portal and the financial components of Lawson.  I don't have the version off hand as I write this, but I can get it.  I'm working on removing LDAP authentication (against Active Directory) in the Apache web server running on Unix and replacing it with Siteminder authentication.  Siteminder is pretty straight forward. The problem I need to...
1 1379
by  DanaJump to last post
02/28/2013 7:04 PM
4 Replies and 1404 Views File Layout viewer  1404  4 Started by  Chesca I am viewing a file that's hard to decipher how the file is laid out. I was a mainframe programmer and we use Fileaid. I was wondering if there is a MF cobol product or software I can use to view/edit datafiles/records. 
4 1404
by  ChescaJump to last post
02/25/2013 3:19 PM
3 Replies and 1135 Views how to stop a multi-step job from ftp a file?  1135  3 Started by  Chesca I want to run a multi-step job that FTP the output file when step 1 completes. Step 2 is a script to ftp the file.  
3 1135
by  ChescaJump to last post
02/25/2013 10:49 AM
2 Replies and 1365 Views Retrieving User Name in LA200 program  1365  2 Started by  ChuckM We had a case a couple of days ago where a user ran a multi-step job that was created by another user.  The form step created a csv file in the directory of the user who created the job.  Then in the LA200 job step the program tried to find the csv file based on the userid of the person who ran the job...the program couldn't find the file and job err'd out. I thought I could write a program that would retrieve both userids from the fields in ECONTROL or JOBWS, but when I run the pr...
2 1365
by  ChuckMJump to last post
02/20/2013 3:52 PM
2 Replies and 906 Views email after job completes  906  2 Started by  Chesca My users told me that they receive an email whenever the job they run completes, I am looking at the script and can't figure out which line of code does that. I see it commented it out. Could somebody please take a look and let me know if I am missing anything !/usr/bin/perl -w  use Env;  use Net::FTP;  $PERL_SID = $ENV{'PERL_SID'};  $PERL_PDL = $ENV{'PERL_PDL'};  unless(defined($PERL_SID)){&F;exit(1);}  $PATH = '/usr/local/bin:$ENV{'PATH'}';  $...
2 906
by  ChescaJump to last post
02/14/2013 3:18 PM
6 Replies and 1181 Views Setup users with access to a multistep job from Portal  1181  6 Started by  Chesca Could somebody please help me or point me to a Lawson article that can show me how do I give users access to run jobs
6 1181
by  ChescaJump to last post
02/14/2013 11:24 AM
8 Replies and 1004 Views How do I view sortfile data while debugging?  1004  8 Started by  Woozy I am debugging a custom program that utilizes a very wide sort file.  Is there any way for me to see what is in that file while I'm debugging other than the little-tiny query variable display window in LID  I need to be able to view/compare records within that file. Does anyone have any magic they can share  Thanks! Kelly We're on DB2 AIX (Unix), if that matters.
8 1004
by  WoozyJump to last post
02/01/2013 5:13 PM
0 Replies and 829 Views PO20 Item Adds - Force Validation against Item master  829  0 Started by  Preston Burdwell When Requisition Items are Added as Special/Service, there is a setting within RQC_config.xml that allows for special_item_validation to be set to skip, warn, or deny. Is there a similar setting for PO Line creation Or, has anyone customized PO20 so that it will do this type of validation before adding a new line I was presented with this issue by purchasing and couldn't find anything on the PO side that was as easy as the RQC setting . . . Thanks
0 829
01/29/2013 11:44 AM
6 Replies and 2064 Views Work File Definition  2064  6 Started by  Chesca How to add/append a new field to a work file I don't see the pre-fix/ field definitions under Work file.  I provided a screenshop of the work file.            Field Name              Occurs Type      Size    1 INAL1-RECORD               &n...
6 2064
by  ChescaJump to last post
01/22/2013 3:09 PM
0 Replies and 1277 Views Rant: AP10.1 - VEN-PMT-INST vs VEN-BANK-INST-CODE  1277  0 Started by  darwin collins My day of pushing a new workflow for Vendor ACH support was going well, until we found form name differences in AP10.1.   I know that the TEST and PRODUCTION systems are not the same, but, really, we can't keep the form files in sync   (well, to be fair, system folks may not have not pushed the new forms live due to change management/etc) Basically, we are taking a task that involves about 70 steps doing it the manual way for a person (updating ACH data for ...
0 1277
01/17/2013 11:31 AM
1 Replies and 1194 Views How to suppress empty reports in Print Manager  1194  1 Started by  Woozy I have a custom batch report that includes secondary 'error' report.  When I run the program, the error report appears in Print Manager, even if it is empty (i.e. no errors).  When I select that report from Print Manager is shows 'No Data in Report File - Check Report Parameters for Possible Error Message'. Is there some way to suppress this report in Print Manager if it is empty Thanks!  Kelly
1 1194
by  WoozyJump to last post
01/16/2013 12:51 PM
0 Replies and 974 Views CSV File  974  0 Started by  Srini Rao Hello, I'm writing the user exit for a existing Lawson program. Can I create CSV file in user exit
0 974
01/11/2013 9:29 PM
5 Replies and 1161 Views PA52 Call  1161  5 Started by  Srini Rao I created a new javascript form to perform PA52 Action.  Here is my code... var pObj = new AGSObject(authUser.prodline, 'PA52.1');    pObj.event = 'CHANGE';    pObj.rtn    = 'MESSAGE';    pObj.longNames = true;    pObj.tds    = false;    pObj.func = 'parent.CheckForErrors()';    pObj.preInquire = true;    pObj.field = 'FC=A'            &nbs...
5 1161
by  WoozyJump to last post
01/10/2013 5:00 PM
4 Replies and 5243 Views COBOL NEWLINE  5243  4 Started by  slm4 I have a program that writes out variable length records with maximum length of 3700 bytes. For some reason file is being written as one line.  No newlines.  Can someone help. 
4 5243
by  LauraPJump to last post
11/30/2012 9:28 AM
6 Replies and 1192 Views Send compiled version  1192  6 Started by  Chesca My user wants me to send her a compiled version of LP140 program but I have no idea how to do this, any help would be appreciated it. Thanks!
6 1192
by  ChescaJump to last post
11/26/2012 11:29 AM
1 Replies and 1056 Views Form Definition- How to left justify phrases  1056  1 Started by  Lynne I am creating a custom program/form and can't seem to get the first line of my text left justified.  I have 5 lines of text and have gotten the last four to left justify by adding the &93; delimiter.  I have tried many different scenarios and the first line continues to start halfway across the form.  It doesn't seem like this should be so difficult, but I obviously am not understanding how the delimiters work. Here is my section of scrgen code:   |   ...
1 1056
by  LynneJump to last post
11/13/2012 9:37 AM
2 Replies and 1526 Views PERSACTION direct manual insert  1526  2 Started by  EBassett I have some user fields that I want to update periodically. I wan to build a project using Sql Server integration Services that will check a few things determin the value of the user field then use the persaction to update it. At first I tried just setting the columns that I thought it would need but, got cannot insert null in most of the columns, so I am inserting a value for all fields in the table. But when I do so I get the following error. Error: 0xC0024104 at Execute SQL Task: T...
2 1526
by  EBassettJump to last post
11/05/2012 3:53 PM
9 Replies and 5352 Views HR02 User Exit  5352  9 Started by  SamKinnamon Hi everyone-- Hopefully this is something very easy that I am just missing, since I am new to using Lawson and User Exits.&160; My problem is that I have a User Exit for HR02.&160; The user exit kicks off a process flow each time a department is changed, added or deleted.&160; The user exit works perfectly when it is executed in the LID.&160; But, it does not appear to triggered at all when a change is made in Portal. I have tried an ISO Cache Refresh.&160; In addition, I've done the tmco...
9 5352
by  ChescaJump to last post
11/05/2012 12:35 PM
1 Replies and 2374 Views Custom Calculation in Absence Management  2374  1 Started by  Michael Beaupre Kara, our GL Specialist, brought an issue to Lawson which is that our Flex Leave liability is not posting from the Absence Management (LP) System to the General Ledger according to normal accounting rules. The Lawson Rep is recommending that we create a custom calculation in LP by setting the variables in LP07.1 and then writing code in the LPCUSTOMPD Library. If someone has a simliar custom calculation in LP that they would be willing to share, I would really appreciate it. Gracias.
1 2374
by  ChescaJump to last post
11/02/2012 2:04 PM
9 Replies and 2230 Views Wrtitting the Comments.  2230  9 Started by  Srini Rao Hello I'm trying to add comments to existing requisition and my program fails on the compile it self :-) Here is my code and I copied it from RQ500... 323697               INITIALIZE             WS-CMTRQH.  64911                PERFORM 900-CREATE-CMT-REQHEADER.  64913      &n...
9 2230
by  Srini RaoJump to last post
10/25/2012 3:19 PM
2 Replies and 1104 Views Google Analytics?  1104  2 Started by  ChuckM We just brought EMSS up and gave our users the ability to log in from home.  It would be good to collect some usage statistics if we could. Has anyone used Google Analytics with Lawson in an external environment like this  Or do you have any other recommendations for getting usage statistics TIA...Chuck
2 1104
by  John HenleyJump to last post
10/19/2012 8:00 AM
3 Replies and 965 Views AR220 - want to print each batch on a different page  965  3 Started by  SYL I would like to force the program to page break after each batch when printing the AR220 program.  Can the .rpt be modified to meet this need  What else can be done
3 965
by  SYLJump to last post
10/09/2012 4:43 PM
4 Replies and 1450 Views Relationship Between .rpt Form and Create CSV in Portal  1450  4 Started by  Preston Burdwell Where does Lawson get the field mapping parameters to Create CSV when this button is pushed within the Portal
4 1450
by  Preston BurdwellJump to last post
10/09/2012 9:48 AM
1 Replies and 1273 Views Field Counts Do Not Agree Scr/Tran  1273  1 Started by  Dawn My screen is not compiling during the qcompile, it has this err - Field Counts Do Not Agree Scr/Tran: 2/1  I figure it is telling me that there is only one field on for input on my screen but it sees two - any ideas on how to fix this.
1 1273
by  WoozyJump to last post
09/25/2012 9:01 AM
12 Replies and 1818 Views PR198 Custom Program  1818  12 Started by  Dawn I duplicated the PR198 into our custom system code and made a change to the program on what comments to send to AP.  When we run my new program it goes into recovery with 'Program Report is Not Opened Process ID 4612' after the Phase 3: Creating General Ledger (GL) Posting Report message.  I cannot find anything on the Lawson site or in the job log to help me with this error.
12 1818
by  DawnJump to last post
09/24/2012 7:13 PM
4 Replies and 1422 Views Remove Magnifying Glass from ESS  1422  4 Started by  Survivor We applied an MSP and lost a customization which was not documented.  In the direct deposit screen in ESS, we want to remove the magnifying glass. Has anyone removed the search from another ESS/MSS or non-COBOL screen Thanks!
4 1422
by  SurvivorJump to last post
09/05/2012 2:41 PM
1 Replies and 1230 Views 900-CREATE-JOB updating current job gives error  1230  1 Started by  Phil Romov Getting WSJR-ERROR = Y when updating the currently running job using 900-CREATE-JOB (works fine if I use a different JOBREQ-JOB-NAME)  I suppose this makes sense, since in lapm you can't update a job if its in queue (e.g. in recovery) What I'm trying to do is run a job but override some parameters using logic with db lookups.  Has anyone accomplished this  If not cobol I also tried design studio but there's no straightforward way there to update the job definition either. ...
1 1230
by  Phil RomovJump to last post
09/04/2012 1:33 PM
0 Replies and 993 Views Aggregate range routines  993  0 Started by  Chesca Has anyone used the 880-FIND-DBAG function/API to sum a column I have the developers API doc and I am having a hard time understanding and wanted to look a sample code.  Is there a Lawson program that use this API Thanks! 
0 993
08/23/2012 2:04 PM
7 Replies and 2011 Views Adding Custom Index/dbreorg question  2011  7 Started by  LauraP I think I know the answer - but I want to get the input of those here who are more knowledgeable! A consultant wants to add a custom index  to our Lawson ITEMLOC table (which has over 63,000,000 rows - yes that is MILLION).  I know once the index is added - a blddbdict and dbreorg are needed. The question is - will the dbreorg UNLOAD and RELOAD the table as part of adding the index  I wasn't sure because it is NOT a conditional index. Based on whether this happens or...
7 2011
by  John HenleyJump to last post
08/03/2012 2:38 PM
4 Replies and 1915 Views OE10.1 transaction ags call not clearing detail fields  1915  4 Started by  wwaters I am getting an intermittent error message when making a jquery post to Lawson's transaction IOS API.  I am trying to add a line to an existing order through OE10.1 and I am getting a message telling me that  'Account cannot be entered for inventory items'.  The field that the message is referring to is 'COL-EXP-ACCT-UNIT'.  What I'm not understanding is that I am not putting anything into this field when doing the AGS call.  I don't get this error on every attempt and m...
4 1915
by  LauraPJump to last post
08/03/2012 9:20 AM
5 Replies and 2125 Views Invoking PR36  2125  5 Started by  Garry Ferwerda Hi all: I am writing a 4gl program to take multiple hours only pay code time records and creating one or more 'pay' time records out of them.  I was hoping to invoke PR36 to create the time records.  The form seems fairly uncomplicated with only a minimum number of fields required.   But I cannot get it to work,  I invoke the form and I can retrieve the employee name so I know that the form did something but I get a return code fo zero and no time records ...
5 2125
by  LauraPJump to last post
08/03/2012 9:16 AM
3 Replies and 2329 Views How to join in DME calls  2329  3 Started by  kwisser I'm trying to find out how I can do a call like: http://x.x.x.x/servlet/Router/Data/Erp_PDL=FPDE5&file=POLINE&FIELD=PO-NUMBER;PURCHORDER.POPCRUF.PCR-USR-FLD-01&select=PO-NUMBER=6000303&out=csv&DELIM=|&MAX=100 I'm running into an issue with that part that says 'PURCHORDER.POPCRUF.PCR-USR-FLD-01'.  I figure since I can select POPCRUF from PURCHORDER, and since I can select PURCHORDER from POLINE, there must be a way for me to select POPCRUF from POLINE.  My...
3 2329
by  kwisserJump to last post
07/31/2012 9:01 AM
1 Replies and 1449 Views Absence Management Plan  1449  1 Started by  Chesca Hello everybody, I was asked to create a custom routine to calculation vacation bonuses which are given to Employee on their anniversary date. Is this field available in Lawson If not, could I use the EMP ADJ Hire date to calculate EMP anniversary and how Thanks in advance for your help! Here is the specs: 1 year anniversary, 1 day = 8 vacation bonus hours 2nd year, 3 days = 24 hours 3rd year, 3 days = 32 hours 4th year, 4 days = 40 hours 5th year, 5 days = 48 hours 6t...
1 1449
by  John HenleyJump to last post
07/23/2012 11:16 AM
4 Replies and 2296 Views Adding Lawson Table Process?  2296  4 Started by  Ron McDuffee We have a custom Interface Program that gets data for 401k payroll deductions.  Our Database is SQL Server.  This program already reads data from tables EMPLOYEE and PAYDEDUCTN.  I need to add a read for the PRDISTRIB table. I have added code to build the filter and perform the PERFORM 850-FILTER-BEGRNG-PRDSET2 command.  The program compiles but the program always returns PRDISTRIB-NOTFOUND as True. I am sure I have not performed a neccesary step or steps. Can anyone point me...
4 2296
by  Ron McDuffeeJump to last post
07/19/2012 9:55 AM
2 Replies and 1544 Views Full time vrs Part time Employee  1544  2 Started by  Chesca I am writing custom code to calculate float accruals and need to identify fulltime employees.  How do I determine full time vrs part time employee based on  EMP FTE
2 1544
by  ChescaJump to last post
07/17/2012 11:50 AM
6 Replies and 2458 Views Invalid username or password... Message  2458  6 Started by  ChuckM I'd like to either change the standard message that gets displayed when a user tries to logon with an invalid password or display an additional message below the logon button if a logon error occurs. The objective is to remind ESS users that it may take a while for password changes to take effect. How would I go about doing this  TIA...Chuck
6 2458
by  ChuckMJump to last post
07/13/2012 9:01 AM
4 Replies and 2675 Views FTP Script  2675  4 Started by  Srini Rao Hello, I'm trying to excute a batch file to FTp the file from external unix system to Lawson windows app server. When I run the script from dos command /LID it does work. When I execute the FTP batch file from 4GL it does not work. It execute the batch file but skips the FTP part . We are on ersion: on Windows. Thanks ---Srini
4 2675
by  Srini RaoJump to last post
07/12/2012 2:50 PM
6 Replies and 2011 Views Custom essmsgs.xml changes not working  2011  6 Started by  Brian I have editted the essmsgs.xml file at WEBDIR\lawson\xhrnet\xml\lang\enus\ I wanted to add two new phrases and change 1 I saved the file.  No chnages I cleared IOS. No Changes. I cleared the IE files...went to a different workstation...rebooted the server....Still no changes... Am I editting the correct file  (I have validated in the pajobreq.htm that it is taking my edits there and applying them to the ESS page and that the phrases used there do come from essmsgs.xml) ...
6 2011
by  BrianJump to last post
07/03/2012 10:27 AM
4 Replies and 1262 Views long running program  1262  4 Started by  Deleted User We have two custom programs that read in PMTOUT.  One program read the employee table to get the employee status (so was a direct read).  On one server/productline,  it took 17 minutes.  On the other productline (productin unfortunately),  it took 1 and 1/2 hours.  Then we took the database read out, so that it was just reading in PMTOUT and writing out a revised PMTOUT.  It now takes 5 seconds in both productlines. The second program is similar but we need to...
4 1262
by  David AragoJump to last post
06/29/2012 9:57 PM
2 Replies and 1303 Views Transmit Date on PO20  1303  2 Started by  JimY When a PO has been transmitted the date shows up on PO20.  Does anyone know where that date is stored  I would like to use it for a program I am developing.  Thank you.
2 1303
by  JimYJump to last post
06/29/2012 12:52 PM
9 Replies and 4027 Views Steps to create a new custom program  4027  9 Started by  Joe O'Toole I need to recreate a custom version of BN106 that we have on our 8.03 system in 9.01. Can someone share the steps used to do this The 8.03 version ports across but there have been too many changes to the Lawson supplied code. Once there is a pristine copy created on the 9.01 side, I should be able to roll in the changes I need to make. Thanks!
9 4027
by  Joe O'TooleJump to last post
06/27/2012 3:44 PM
2 Replies and 3135 Views PA100  3135  2 Started by  Chesca I am new to Lawson and unfortunately, I can't get any formal training yet and people on my team are not really willing to share knowledge. I had a production issue with PA100 that was in recovery due to data error from another interface system. I want to be able to research problems but I don't even know where to look. First, how do I find out what the input/output interfaces are What about the script How often a job runs and if any output files are Ftps a all How is the job setup&...
2 3135
by  Greg MoellerJump to last post
06/25/2012 3:28 PM
1 Replies and 1244 Views TAEMPTRANS/absence management  1244  1 Started by  Chesca is anybody familiar with the TAEMPTRANS table I know LP140 writes to this table, but I am not quite sure why every time I run LP140, the records are wiped out. I am twriting a custom routine to calculate Float holidays which requires me to get the most recent accrual in the same employee group. Any input would greatly be appreciated.
1 1244
by  ChescaJump to last post
06/25/2012 10:07 AM
2 Replies and 1508 Views Retrieve AGS call data into custom ESS form.  1508  2 Started by  David Cron This is weird.  I can run a DME call from the same page without an error (saving to the same iframe) Here's the AGS call function getEnrEndDate()  {   // change to use BS09 so we can be direct to the employee's specific rules    var obj       = new AGSObject(authUser.prodline,'BS09.1')    obj.event     = 'ADD'    obj.rtn       = 'DATA'    obj.longNa...
2 1508
by  David CronJump to last post
06/21/2012 4:23 PM
2 Replies and 1368 Views adding libraries to a 4gl program  1368  2 Started by  Karen Sheridan I created a new 4gl program shell.  Added a filter to the database call and now it won't compile because its missing the database library.  I've been all over pgmdef and cannot figure out how to add a library to an existing 4gl definition. Thanks in advance, Karen
2 1368
by  Karen SheridanJump to last post
06/20/2012 3:29 PM
9 Replies and 2041 Views TIME ACCRUALS-TAEMPTRANS  2041  9 Started by  Chesca Most recent dated Tran Type 21 or 22 in same Employee Group I have the required data including company, employee, plan, employee group and position to fill in the DB fileds/primary key. I have access to the docs for develpers API and I am reading on database inquiry processing, but just don't know which find routine to read data from the database files would give return the most recent dated trans. Could you please help Thanks!
9 2041
by  ChescaJump to last post
06/20/2012 9:03 AM
3 Replies and 4362 Views Cobol signed fields  4362  3 Started by  Karen Sheridan We have a file going to a vendor with contribution fields defined as S9(08)v99.  We sent negative values recently and they went over 88.8u and 168.3x. The vendor needs them      Digit                Character (negative)         0               =          ...
3 4362
by  Karen SheridanJump to last post
05/29/2012 3:57 PM
3 Replies and 1496 Views time record service date  1496  3 Started by  Chesca I am processing a record for retro accruals and all I have is a TR-DATE and need to find out what the pay period should've been for a record. Does anybody know how to find this out given a TR-DATE
3 1496
by  ChescaJump to last post
05/23/2012 3:14 PM
0 Replies and 1692 Views AD Last password change?  1692  0 Started by  Kurt L Hello, We are looking to retrieve the portal user's last change date of password from Active Directory to notify the user as they login to portal.  I have read in here somewhere that it is doable, but not seeing how. We are on LSF9.0.1.7, WAS7, MS ADAM LDAP bound to AD. Any ideas would be appreciated.
0 1692
05/21/2012 11:25 AM
1 Replies and 2097 Views Modify AR150 for AFP template  2097  1 Started by  Erin Is it possible to modify the output of the AR150 so we can use an AFP (Advanced Function Printing) template once routed to the printer Specifically, we have custom sized tear forms and want to use an AFP template specifically formatted for that custom tear form. If not possible to modify the output of the AR150, can anyone share what they do for customizing statements (outside of 3rd party software like MHC or Bottomline)
1 2097
by  AriJump to last post
05/17/2012 7:35 PM
1 Replies and 2050 Views DB read and initializing values  2050  1 Started by  Chesca coming from the mainframe world and SQL, I would initialize DB fields by initializing the declagen. How is it done in 4GL             MOVE LPMST-TEM-COMPANY        TO DB-COMPANY.            MOVE LPMST-TEM-EMPLOYEE       TO DB-EMPLOYEE.            MOVE LPMST-TEM-PLAN &nbs...
1 2050
by  AriJump to last post
05/08/2012 7:10 PM
2 Replies and 2507 Views SQL to Lawson Data Types  2507  2 Started by  Ari I am creating a Drill that will be able to drill back into a foreign system from the GLTRANS Table. I have set up all the necessary drill info(file defs, relations, indexes, .or file descriptions, etc.) for the tables in the foreign system. The Lawson app database and the foreign system database are SQL Server.  I have created a separate Database Space for the tables with Is View to YES so that Lawson will not try to manage the foreign tables.( I am using a synonym rather than a v...
2 2507
by  AriJump to last post
05/03/2012 2:20 PM
0 Replies and 1197 Views Compile errors  1197  0 Started by  Chesca I am not familiar with this error and was wondering if someone could help me figure out how to find out more info about the error message: Node Type NONE Found At Node  538            This Is An Internal Error
0 1197
04/30/2012 12:18 PM
4 Replies and 2031 Views TAEEMASTER FILE  2031  4 Started by  Chesca How to perform a DB call to get a single record off the TAAMATER FILE I am not sure how to populate the index key and use the 840-FIND-TEMSET1 or the 850-NLT-NEXT Thanks
4 2031
by  ChescaJump to last post
04/30/2012 12:16 PM
2 Replies and 1555 Views Drill to 3rd Party Tables  1555  2 Started by  Ari We have a Process Flow that picks up GL extracts from a foreign system and creates importdb and GL165 jobs that posts the GL transactions in Lawson. I would like to be able to drill back into the foreign system from the posted transactions and/or from the GL165 print file. I can create all the necessary drill info(file defs, relations, indexes, .or file descriptions, etc.) for the tables in the foreign system. The Lawson app database and the foreign system database are SQL Server.  What ...
2 1555
by  AriJump to last post
04/27/2012 2:55 PM
3 Replies and 1967 Views ERRORNBR lookup table?  1967  3 Started by  Janice I'm trying to trace an error in HR54.1.  Where is the translation table that translates the error number to the error message that gets displayed to the user  In the code, the error number is set like this: EVAL                 EERRORNBR     = 133 I'm trying to find a table where I can see what error number 133 is. Thank you.
3 1967
by  Kwane McNealJump to last post
04/12/2012 5:09 PM
5 Replies and 3087 Views user exit compile  3087  5 Started by  Chesca I created a user exit XXXXXPD and have working storage XXXXWS source files for a batch program that will invoke a user online screen that calls my user exits. I know I am supposed to compile with option -u but what needs to be compiled, the user-exit or the base program Do I need a perform statement to call my user exit
5 3087
by  ChescaJump to last post
04/10/2012 9:38 AM
3 Replies and 2546 Views 4GL CSV file name truncated  2546  3 Started by  Karen Sheridan I cloned a custom 4gl extract program that is working correctly.  I changed the hard coded file name in the program.  The display statement show the correct file name, but the actual file name is being truncated. ws-filename pic x(80) its defined in workdef as a CSV file Program Messages:                 ** Creating .prt and .dtl files            &nbs...
3 2546
by  DemichenerJump to last post
04/04/2012 3:22 PM
5 Replies and 1793 Views Creating a custom Errors report  1793  5 Started by  Woozy I am building a custom batch program and I want to add a secondary report (i.e for errors) to the Print Manager output for this report. I added another $REPORT section to my .rpt file, and it included the error report as part of the .prt file rather than as a separate file and separate Print Manager record.  Is there some trick to creating it as a separate file  Thanks! 
5 1793
by  WoozyJump to last post
04/03/2012 9:56 AM
5 Replies and 1573 Views Display Zero in Portal Form Field  1573  5 Started by  Woozy I have a custom form that includes a numeric field where zero is a valid value.  I'd like Portal to display a zero, but it only displays a blank even though the underlying table actually shows a value of zero. Is there a way to do this without using Design Studio Thanks!
5 1573
by  WoozyJump to last post
04/02/2012 9:22 AM
5 Replies and 2161 Views error 163  2161  5 Started by  Chesca Has anybody gotten an error 63 Illegal character in numeric field I am doing a DB call against the PAEMPLOYEE file to get the employee bargain unit. Here is where I get the error. I have trying '05' or '06 or 05 06 and still not working. Thanks IF (PEM-BARGAIN-UNIT = 05 OR 06)      DO Somthing.. 
5 2161
by  Ragu RaghavanJump to last post
04/01/2012 4:05 PM
2 Replies and 1171 Views Sections vrs Thru exit  1171  2 Started by  Chesca Hi, I am a mainframe COBOL programmer and I am used to writing a routine ' PERFORM THRU EXIT. I am having hard time understanding how routines in Section work. What's the difference when you build a routine with/without section I am animating my program, and I'd like my program to exit paragraph 3150 and go back to where it was performed. Instead, it goes to the next line/paragraph 31.
2 1171
by  ChescaJump to last post
03/29/2012 11:33 AM
1 Replies and 2417 Views Execute AP520 from external App on Iseries  2417  1 Started by  desichet We need to process sperate Invoices batches coming into Lawson using AP520.  LAIBCH7 command executes the job in Lawson env but ignores overrides to DBAPCVI/DBAPCVD files. Is there a way to execute Lawson Batch Process (AP520) with OVRDBF command to process selected records   Not sure how to modify AP520 process  
1 2417
by  Steven GrayJump to last post
03/24/2012 3:07 PM
8 Replies and 1481 Views custom 4GLs  1481  8 Started by  Demichener Can anyone tell me where, why and how to correct this We've recently upgraded both our apps ( to and our env ( to I'm working on several of our custom delivered 4GLs and have found that our CSV output files are now being generated with quotations around each line.
8 1481
by  DemichenerJump to last post
03/16/2012 2:53 PM
3 Replies and 2293 Views scrgen errpr: Field Counts Do Not Agree Scr/Tran: 156/152  2293  3 Started by  Chris Hi everyone, Here's an scrgen error that has me and all of my colleagues perplexed: Line 78: Field Counts Do Not Agree Scr/Tran: 156/152 The screen is a header/detail screen with a tab region. I've attached the .scr file, with the extension changed to .txt.  Any insights Thanks in advance!
3 2293
by  Evan RosenbergJump to last post
02/29/2012 8:16 AM
1 Replies and 1843 Views Joining PURCHORDER to APINVOICE  1843  1 Started by  kwisser Is there any way to pull in PURCHORDER.PO-USER-FLD-1 into the following call|&MAX=1 I want to do something like;PURCHORDER.PO-USER-FLD-1&select=&out=csv&DELIM=|&MAX=1 but it tells me that the reference is not valid. Thanks, K...
1 1843
by  John HenleyJump to last post
02/28/2012 8:15 AM
0 Replies and 1000 Views Modify TRNLOAD to include the status.  1000  0 Started by  Cindy We would like to use TR500 to load training information so that we can automate the process.  The status field is not included in TRNLOAD and we would like to know if anyone has modified it to include the field.  Thanks, Cindy
0 1000
02/28/2012 8:04 AM
1 Replies and 1252 Views Limit values in MSS personnel actions  1252  1 Started by  Anthony We're currently implementing personnel actions in MSS for Managers.  We would like to limit the values Managers can select from when performing submitting actions.  For example, we only want to allow for one status code for a termination action.  We would also like to default in specific values for other fields and prevent the Manager from making changes to those values.  What's the best way to do this thank you
1 1252
by  Roger FrenchJump to last post
02/07/2012 10:55 AM
2 Replies and 2213 Views Javascript/AGS: Code after AGS call executes too quickly before AGS is complete.  2213  2 Started by  Larry Chough Hello, I'm a web developer, but a newbie to Lawson.  My company has a lot of custom web pages derived from ESS. Is there any convention to make sure the JavaScript code has completed an AGS call before continuing to execute I've been running into instances where the code is trying to process data from AGS (or DME), but fails because the AGS call has not yet completed and thus no data to process yet.  I've been trying timeouts, but those aren't 100 reliable. Any help or in...
2 2213
by  Larry ChoughJump to last post
01/30/2012 8:44 AM
2 Replies and 1772 Views PO20 Last Modified Date  1772  2 Started by  kwisser I'm looking for a field on either of the PURCHORDER or POLINE tables that represent the last time PO20 was either updated or Released.  Does such a field exist  I can't imagine there is no history on Release Date or Last Modified Date. Thanks, Kevin
2 1772
by  JimYJump to last post
01/17/2012 6:34 AM
1 Replies and 1523 Views Packet Length Error - OE10  1523  1 Started by  LauraP OK - I've modified OE10.scr to have 5 new splat fields to be passed to OE12.  They tie to a new stand-alone userflds table (LAWSON.ORDERUFLDS) that I created.   The fields are as follows:     2    *OUF-PRINT-INVOICE      A     01         SB     yc1   COR-OPTIONS-WIN   2    *OUF-PRINT-SED      &...
1 1523
by  LauraPJump to last post
01/12/2012 2:35 PM
8 Replies and 2781 Views Linking to a Lawson form from an HTML page  2781  8 Started by  pklupa Hi Everyone, I am building an HTML menu screen with links to several Employee Self Service screens.  These links work OK.  I am trying to add a link from the HTML screen directly to a Lawson form that I created.  Does anyone know the format of the URL that I need to have in the link to cause the Lawson form to come up  Thanks!
8 2781
by  pklupaJump to last post
01/06/2012 1:40 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 3 of 6 << < 12345 > >>

RSS Feed Available