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 3 of 6 << < 12345 > >>
Topics
 Replies
 Views
 Last Post
0 Replies and 1179 Views Need examples - VBScript SSO and AGS calls  1179  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 1179
07/30/2013 8:14 AM
5 Replies and 895 Views scrgen form definition to display current date  895  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 895
by  DemichenerJump to last post
07/23/2013 2:15 PM
3 Replies and 1438 Views Prevent FICA Nbr from displaying in Emp[loyee drill fields  1438  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 HR.sr. However, I am unfamiliar with this file and how to modify it. (i.e. what to r...
3 1438
by  Shane JonesJump to last post
07/20/2013 7:15 PM
6 Replies and 1301 Views Default Requisition Special/Service Item Type  1301  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 1301
by  Judy ConsoliJump to last post
07/18/2013 9:58 AM
6 Replies and 2317 Views Replace characters in string in 4GL  2317  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 2317
by  maalimsimoJump to last post
07/18/2013 9:53 AM
6 Replies and 934 Views Cloned a Lawson form (IC285) missing search box on fields  934  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 934
by  LmankeJump to last post
07/01/2013 2:29 PM
2 Replies and 1236 Views Adding support for AuthUser to new HTML page  1236  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 1236
by  Darkwater23Jump to last post
06/24/2013 3:24 PM
3 Replies and 1077 Views Field Description Changes  1077  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 1077
by  John HenleyJump to last post
06/20/2013 6:21 AM
0 Replies and 617 Views How to print the standard footer on the last page of a batch report  617  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 617
06/04/2013 12:35 PM
4 Replies and 1873 Views PA100HR  1873  4 Started by  bernfc10 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 1873
by  bernfc10Jump to last post
05/31/2013 12:45 PM
4 Replies and 910 Views API/routine to calculate week days  910  4 Started by  bernfc10 Is there an API/routine tha calculates weekdays only
4 910
by  jaherbJump to last post
05/28/2013 3:41 PM
13 Replies and 2146 Views Customize home page  2146  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 2146
by  Shane JonesJump to last post
05/19/2013 10:46 PM
4 Replies and 792 Views Keep Total Section on same page as Detail  792  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 792
by  WoozyJump to last post
05/17/2013 2:38 PM
3 Replies and 787 Views Inquiry only  787  3 Started by  bernfc10 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 787
by  bernfc10Jump to last post
05/16/2013 12:47 PM
1 Replies and 843 Views ESS: Custom Giving/Donation  843  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 bclinto1fairview.org 612-672-6703
1 843
by  Shane JonesJump to last post
05/13/2013 10:41 PM
6 Replies and 779 Views SRGEN error after applying a huge CTP batch...and I can't find error in the KB.  779  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\VM.sr Line 521: ID Must Be Unique And Must Begin With SystemCode Li...
6 779
by  Kwane McNealJump to last post
05/08/2013 11:41 AM
2 Replies and 1355 Views Force an error exit in multi-step job  1355  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 1355
by  mikePJump to last post
04/15/2013 9:38 AM
2 Replies and 1636 Views custom program not found in Portal  1636  2 Started by  bernfc10 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 1636
by  bernfc10Jump to last post
04/10/2013 9:40 AM
5 Replies and 1274 Views PR530 error messages - accounting uni  1274  5 Started by  bernfc10 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 1274
by  jaherbJump to last post
04/04/2013 9:58 AM
6 Replies and 2042 Views How do I read genlib tables?  2042  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 2042
by  Donna WirtJump to last post
04/02/2013 7:42 AM
1 Replies and 1807 Views DME Query Development Guide  1807  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 1807
by  WoozyJump to last post
03/28/2013 10:36 AM
8 Replies and 7014 Views Question about LID for Development  7014  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 7014
by  trueblueg8torJump to last post
03/26/2013 11:32 AM
4 Replies and 933 Views ESS - Add custom text to Tax Withholding popup window  933  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 933
by  Deleted UserJump to last post
03/25/2013 2:12 PM
2 Replies and 582 Views Redirect S3 Form Calls  582  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 582
by  GeorgetteJump to last post
03/04/2013 1:11 PM
1 Replies and 1313 Views Implement Siteminder Lawson Authentication  1313  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 1313
by  DanaJump to last post
02/28/2013 7:04 PM
4 Replies and 1330 Views File Layout viewer  1330  4 Started by  bernfc10 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 1330
by  bernfc10Jump to last post
02/25/2013 3:19 PM
3 Replies and 1090 Views how to stop a multi-step job from ftp a file?  1090  3 Started by  bernfc10 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 1090
by  bernfc10Jump to last post
02/25/2013 10:49 AM
2 Replies and 1298 Views Retrieving User Name in LA200 program  1298  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 1298
by  ChuckMJump to last post
02/20/2013 3:52 PM
2 Replies and 872 Views email after job completes  872  2 Started by  bernfc10 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 872
by  bernfc10Jump to last post
02/14/2013 3:18 PM
6 Replies and 1126 Views Setup users with access to a multistep job from Portal  1126  6 Started by  bernfc10 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 1126
by  bernfc10Jump to last post
02/14/2013 11:24 AM
8 Replies and 953 Views How do I view sortfile data while debugging?  953  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 953
by  WoozyJump to last post
02/01/2013 5:13 PM
0 Replies and 767 Views PO20 Item Adds - Force Validation against Item master  767  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 767
01/29/2013 11:44 AM
6 Replies and 1924 Views Work File Definition  1924  6 Started by  bernfc10 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 1924
by  bernfc10Jump to last post
01/22/2013 3:09 PM
0 Replies and 1193 Views Rant: AP10.1 - VEN-PMT-INST vs VEN-BANK-INST-CODE  1193  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 1193
01/17/2013 11:31 AM
1 Replies and 1131 Views How to suppress empty reports in Print Manager  1131  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 1131
by  WoozyJump to last post
01/16/2013 12:51 PM
0 Replies and 912 Views CSV File  912  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 912
01/11/2013 9:29 PM
5 Replies and 1063 Views PA52 Call  1063  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 1063
by  WoozyJump to last post
01/10/2013 5:00 PM
4 Replies and 4818 Views COBOL NEWLINE  4818  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 4818
by  LauraPJump to last post
11/30/2012 9:28 AM
6 Replies and 1080 Views Send compiled version  1080  6 Started by  bernfc10 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 1080
by  bernfc10Jump to last post
11/26/2012 11:29 AM
1 Replies and 1009 Views Form Definition- How to left justify phrases  1009  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 1009
by  LynneJump to last post
11/13/2012 9:37 AM
2 Replies and 1477 Views PERSACTION direct manual insert  1477  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 1477
by  EBassettJump to last post
11/05/2012 3:53 PM
9 Replies and 5282 Views HR02 User Exit  5282  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 5282
by  bernfc10Jump to last post
11/05/2012 12:35 PM
1 Replies and 2321 Views Custom Calculation in Absence Management  2321  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 2321
by  bernfc10Jump to last post
11/02/2012 2:04 PM
9 Replies and 2180 Views Wrtitting the Comments.  2180  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 2180
by  Srini RaoJump to last post
10/25/2012 3:19 PM
2 Replies and 1052 Views Google Analytics?  1052  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 1052
by  John HenleyJump to last post
10/19/2012 8:00 AM
3 Replies and 908 Views AR220 - want to print each batch on a different page  908  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 908
by  SYLJump to last post
10/09/2012 4:43 PM
4 Replies and 1386 Views Relationship Between .rpt Form and Create CSV in Portal  1386  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 1386
by  Preston BurdwellJump to last post
10/09/2012 9:48 AM
1 Replies and 1233 Views Field Counts Do Not Agree Scr/Tran  1233  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 1233
by  WoozyJump to last post
09/25/2012 9:01 AM
12 Replies and 1634 Views PR198 Custom Program  1634  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 1634
by  DawnJump to last post
09/24/2012 7:13 PM
4 Replies and 1363 Views Remove Magnifying Glass from ESS  1363  4 Started by  SurvivorAC 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 1363
by  SurvivorACJump to last post
09/05/2012 2:41 PM
1 Replies and 1180 Views 900-CREATE-JOB updating current job gives error  1180  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 1180
by  Phil RomovJump to last post
09/04/2012 1:33 PM
0 Replies and 948 Views Aggregate range routines  948  0 Started by  bernfc10 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 948
08/23/2012 2:04 PM
7 Replies and 1953 Views Adding Custom Index/dbreorg question  1953  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 1953
by  John HenleyJump to last post
08/03/2012 2:38 PM
4 Replies and 1861 Views OE10.1 transaction ags call not clearing detail fields  1861  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 1861
by  LauraPJump to last post
08/03/2012 9:20 AM
5 Replies and 2069 Views Invoking PR36  2069  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 2069
by  LauraPJump to last post
08/03/2012 9:16 AM
3 Replies and 2271 Views How to join in DME calls  2271  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 2271
by  kwisserJump to last post
07/31/2012 9:01 AM
1 Replies and 1409 Views Absence Management Plan  1409  1 Started by  bernfc10 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 1409
by  John HenleyJump to last post
07/23/2012 11:16 AM
4 Replies and 2221 Views Adding Lawson Table Process?  2221  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 2221
by  Ron McDuffeeJump to last post
07/19/2012 9:55 AM
2 Replies and 1496 Views Full time vrs Part time Employee  1496  2 Started by  bernfc10 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 1496
by  bernfc10Jump to last post
07/17/2012 11:50 AM
6 Replies and 2309 Views Invalid username or password... Message  2309  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 2309
by  ChuckMJump to last post
07/13/2012 9:01 AM
4 Replies and 2609 Views FTP Script  2609  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: 9.0.1.8.221 on Windows. Thanks ---Srini
4 2609
by  Srini RaoJump to last post
07/12/2012 2:50 PM
6 Replies and 1941 Views Custom essmsgs.xml changes not working  1941  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 1941
by  BrianJump to last post
07/03/2012 10:27 AM
4 Replies and 1224 Views long running program  1224  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 1224
by  David AragoJump to last post
06/29/2012 9:57 PM
2 Replies and 1252 Views Transmit Date on PO20  1252  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 1252
by  JimYJump to last post
06/29/2012 12:52 PM
9 Replies and 3736 Views Steps to create a new custom program  3736  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 3736
by  Joe O'TooleJump to last post
06/27/2012 3:44 PM
2 Replies and 2962 Views PA100  2962  2 Started by  bernfc10 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 2962
by  Greg MoellerJump to last post
06/25/2012 3:28 PM
1 Replies and 1203 Views TAEMPTRANS/absence management  1203  1 Started by  bernfc10 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 1203
by  bernfc10Jump to last post
06/25/2012 10:07 AM
2 Replies and 1455 Views Retrieve AGS call data into custom ESS form.  1455  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 1455
by  David CronJump to last post
06/21/2012 4:23 PM
2 Replies and 1309 Views adding libraries to a 4gl program  1309  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 1309
by  Karen SheridanJump to last post
06/20/2012 3:29 PM
9 Replies and 1985 Views TIME ACCRUALS-TAEMPTRANS  1985  9 Started by  bernfc10 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 1985
by  bernfc10Jump to last post
06/20/2012 9:03 AM
3 Replies and 4192 Views Cobol signed fields  4192  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 4192
by  Karen SheridanJump to last post
05/29/2012 3:57 PM
3 Replies and 1420 Views time record service date  1420  3 Started by  bernfc10 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 1420
by  bernfc10Jump to last post
05/23/2012 3:14 PM
0 Replies and 1630 Views AD Last password change?  1630  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 1630
05/21/2012 11:25 AM
1 Replies and 2019 Views Modify AR150 for AFP template  2019  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 2019
by  AriJump to last post
05/17/2012 7:35 PM
1 Replies and 1985 Views DB read and initializing values  1985  1 Started by  bernfc10 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 1985
by  AriJump to last post
05/08/2012 7:10 PM
2 Replies and 2414 Views SQL to Lawson Data Types  2414  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 2414
by  AriJump to last post
05/03/2012 2:20 PM
0 Replies and 1138 Views Compile errors  1138  0 Started by  bernfc10 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 1138
04/30/2012 12:18 PM
4 Replies and 1955 Views TAEEMASTER FILE  1955  4 Started by  bernfc10 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 1955
by  bernfc10Jump to last post
04/30/2012 12:16 PM
2 Replies and 1495 Views Drill to 3rd Party Tables  1495  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 1495
by  AriJump to last post
04/27/2012 2:55 PM
3 Replies and 1871 Views ERRORNBR lookup table?  1871  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 1871
by  Kwane McNealJump to last post
04/12/2012 5:09 PM
5 Replies and 2980 Views user exit compile  2980  5 Started by  bernfc10 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 2980
by  bernfc10Jump to last post
04/10/2012 9:38 AM
3 Replies and 2447 Views 4GL CSV file name truncated  2447  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 2447
by  DemichenerJump to last post
04/04/2012 3:22 PM
5 Replies and 1669 Views Creating a custom Errors report  1669  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 1669
by  WoozyJump to last post
04/03/2012 9:56 AM
5 Replies and 1499 Views Display Zero in Portal Form Field  1499  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 1499
by  WoozyJump to last post
04/02/2012 9:22 AM
5 Replies and 2084 Views error 163  2084  5 Started by  bernfc10 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 2084
by  Ragu RaghavanJump to last post
04/01/2012 4:05 PM
2 Replies and 1120 Views Sections vrs Thru exit  1120  2 Started by  bernfc10 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 1120
by  bernfc10Jump to last post
03/29/2012 11:33 AM
1 Replies and 2340 Views Execute AP520 from external App on Iseries  2340  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 2340
by  Steven GrayJump to last post
03/24/2012 3:07 PM
8 Replies and 1418 Views custom 4GLs  1418  8 Started by  Demichener Can anyone tell me where, why and how to correct this We've recently upgraded both our apps (9.0.0.6 to 9.0.1.7) and our env (9.0.0.8 to 9.0.1.9). 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 1418
by  DemichenerJump to last post
03/16/2012 2:53 PM
3 Replies and 2202 Views scrgen errpr: Field Counts Do Not Agree Scr/Tran: 156/152  2202  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 2202
by  Evan RosenbergJump to last post
02/29/2012 8:16 AM
1 Replies and 1784 Views Joining PURCHORDER to APINVOICE  1784  1 Started by  kwisser Is there any way to pull in PURCHORDER.PO-USER-FLD-1 into the following call http://lawtest.ccf.org:40203/servlet/Router/Data/Erp_PDL=FPDE5&file=APINVOICE&FIELD=INVOICE&select=&out=csv&DELIM=|&MAX=1 I want to do something like http://lawtest.ccf.org:40203/servlet/Router/Data/Erp_PDL=FPDE5&file=APINVOICE&FIELD=INVOICE;PURCHORDER.PO-USER-FLD-1&select=&out=csv&DELIM=|&MAX=1 but it tells me that the reference is not valid. Thanks, K...
1 1784
by  John HenleyJump to last post
02/28/2012 8:15 AM
0 Replies and 966 Views Modify TRNLOAD to include the status.  966  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 966
02/28/2012 8:04 AM
1 Replies and 1205 Views Limit values in MSS personnel actions  1205  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 1205
by  Roger FrenchJump to last post
02/07/2012 10:55 AM
2 Replies and 2136 Views Javascript/AGS: Code after AGS call executes too quickly before AGS is complete.  2136  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 2136
by  Larry ChoughJump to last post
01/30/2012 8:44 AM
2 Replies and 1709 Views PO20 Last Modified Date  1709  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 1709
by  JimYJump to last post
01/17/2012 6:34 AM
1 Replies and 1471 Views Packet Length Error - OE10  1471  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 1471
by  LauraPJump to last post
01/12/2012 2:35 PM
8 Replies and 2700 Views Linking to a Lawson form from an HTML page  2700  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 2700
by  pklupaJump to last post
01/06/2012 1:40 PM
11 Replies and 2717 Views scrgen error  2717  11 Started by  LauraP Getting the error 'Form Exceeds Limit Of 24 Lines' when doing an scrgen.  Removed all the lines I put in (restored the .scr actually) and did the scrgen and it worked.  Started by just changing the name of a tab from 'User' to 'User WMOS'.  Did the scrgen and received the error again.  Any thoughts anybody  Thanks so much in advance - I'm pulling my hair out!
11 2717
by  John HenleyJump to last post
12/20/2011 1:09 PM
10 Replies and 6035 Views New Table w\compilation issues  6035  10 Started by  Demichener    I've been tasked with adding a new database table to the Lawson PR system.  I've created my table, ran blddbdict and dbreorg. My new (empty) table shows up in the database.  I've since created two custom programs(using pgmdef & copy) to use my new table but when I run through a compile I keep getting this error: Warning: Error - PrcWRKFILE(): 'NewTableName' Not Found In WsGrp Warning: Work File 'NewTableName' May Not Be Defined In workdef /lawson/g...
10 6035
by  DemichenerJump to last post
12/19/2011 3:59 PM
21 Replies and 5457 Views PA52 AGS call doesn't populate new value fields  5457  21 Started by  Woozy I'm modifying a custom ESS form so it will use an AGS call to create a PA52 action. The AGS call gives an 'Action Processed' message and adds the action to PA52.1, but the 'new value' fields aren't populating. It must be something simple, but I can't figure out what I'm missing. Can anyone give me a clue I'm attaching several items: - Javascript AGS Call - Fiddler capture of the AGS call - Result Code Thanks f...
21 5457
by  WoozyJump to last post
12/14/2011 9:46 AM
2 Replies and 3533 Views Lawson MM to EPIC interface  3533  2 Started by  jcarrott We started using IC527 to extract data for EPIC, only to find out that IC527 is a delta extract. It only extracts what has changed since the last run of the IC527. We need to load the FULL extract before we can start doing the delta. Does anybody know what to use for the full extract, it would be great if it was in the same format and with the same name as the IC527.
2 3533
by  jcarrottJump to last post
12/08/2011 2:44 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