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
4 Replies and 2995 Views Integrating with Lawson  2995  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 2995
by  ArielJump to last post
08/01/2013 10:28 AM
0 Replies and 1205 Views Need examples - VBScript SSO and AGS calls  1205  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 1205
07/30/2013 8:14 AM
5 Replies and 921 Views scrgen form definition to display current date  921  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 921
by  DemichenerJump to last post
07/23/2013 2:15 PM
3 Replies and 1465 Views Prevent FICA Nbr from displaying in Emp[loyee drill fields  1465  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 1465
by  Shane JonesJump to last post
07/20/2013 7:15 PM
6 Replies and 1327 Views Default Requisition Special/Service Item Type  1327  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 1327
by  Judy ConsoliJump to last post
07/18/2013 9:58 AM
6 Replies and 2353 Views Replace characters in string in 4GL  2353  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 2353
by  maalimsimoJump to last post
07/18/2013 9:53 AM
6 Replies and 957 Views Cloned a Lawson form (IC285) missing search box on fields  957  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 957
by  LmankeJump to last post
07/01/2013 2:29 PM
2 Replies and 1253 Views Adding support for AuthUser to new HTML page  1253  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 1253
by  Darkwater23Jump to last post
06/24/2013 3:24 PM
3 Replies and 1118 Views Field Description Changes  1118  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 1118
by  John HenleyJump to last post
06/20/2013 6:21 AM
0 Replies and 633 Views How to print the standard footer on the last page of a batch report  633  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 633
06/04/2013 12:35 PM
4 Replies and 1908 Views PA100HR  1908  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 1908
by  bernfc10Jump to last post
05/31/2013 12:45 PM
4 Replies and 930 Views API/routine to calculate week days  930  4 Started by  bernfc10 Is there an API/routine tha calculates weekdays only
4 930
by  jaherbJump to last post
05/28/2013 3:41 PM
13 Replies and 2209 Views Customize home page  2209  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 2209
by  Shane JonesJump to last post
05/19/2013 10:46 PM
4 Replies and 819 Views Keep Total Section on same page as Detail  819  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 819
by  WoozyJump to last post
05/17/2013 2:38 PM
3 Replies and 818 Views Inquiry only  818  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 818
by  bernfc10Jump to last post
05/16/2013 12:47 PM
1 Replies and 880 Views ESS: Custom Giving/Donation  880  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 880
by  Shane JonesJump to last post
05/13/2013 10:41 PM
6 Replies and 801 Views SRGEN error after applying a huge CTP batch...and I can't find error in the KB.  801  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 801
by  Kwane McNealJump to last post
05/08/2013 11:41 AM
2 Replies and 1397 Views Force an error exit in multi-step job  1397  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 1397
by  mikePJump to last post
04/15/2013 9:38 AM
2 Replies and 1678 Views custom program not found in Portal  1678  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 1678
by  bernfc10Jump to last post
04/10/2013 9:40 AM
5 Replies and 1304 Views PR530 error messages - accounting uni  1304  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 1304
by  jaherbJump to last post
04/04/2013 9:58 AM
6 Replies and 2083 Views How do I read genlib tables?  2083  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 2083
by  Donna WirtJump to last post
04/02/2013 7:42 AM
1 Replies and 1895 Views DME Query Development Guide  1895  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 1895
by  WoozyJump to last post
03/28/2013 10:36 AM
8 Replies and 7082 Views Question about LID for Development  7082  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 7082
by  trueblueg8torJump to last post
03/26/2013 11:32 AM
4 Replies and 963 Views ESS - Add custom text to Tax Withholding popup window  963  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 963
by  Deleted UserJump to last post
03/25/2013 2:12 PM
2 Replies and 597 Views Redirect S3 Form Calls  597  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 597
by  GeorgetteJump to last post
03/04/2013 1:11 PM
1 Replies and 1340 Views Implement Siteminder Lawson Authentication  1340  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 1340
by  DanaJump to last post
02/28/2013 7:04 PM
4 Replies and 1363 Views File Layout viewer  1363  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 1363
by  bernfc10Jump to last post
02/25/2013 3:19 PM
3 Replies and 1106 Views how to stop a multi-step job from ftp a file?  1106  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 1106
by  bernfc10Jump to last post
02/25/2013 10:49 AM
2 Replies and 1318 Views Retrieving User Name in LA200 program  1318  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 1318
by  ChuckMJump to last post
02/20/2013 3:52 PM
2 Replies and 885 Views email after job completes  885  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 885
by  bernfc10Jump to last post
02/14/2013 3:18 PM
6 Replies and 1149 Views Setup users with access to a multistep job from Portal  1149  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 1149
by  bernfc10Jump to last post
02/14/2013 11:24 AM
8 Replies and 980 Views How do I view sortfile data while debugging?  980  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 980
by  WoozyJump to last post
02/01/2013 5:13 PM
0 Replies and 797 Views PO20 Item Adds - Force Validation against Item master  797  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 797
01/29/2013 11:44 AM
6 Replies and 1990 Views Work File Definition  1990  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 1990
by  bernfc10Jump to last post
01/22/2013 3:09 PM
0 Replies and 1218 Views Rant: AP10.1 - VEN-PMT-INST vs VEN-BANK-INST-CODE  1218  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 1218
01/17/2013 11:31 AM
1 Replies and 1157 Views How to suppress empty reports in Print Manager  1157  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 1157
by  WoozyJump to last post
01/16/2013 12:51 PM
0 Replies and 935 Views CSV File  935  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 935
01/11/2013 9:29 PM
5 Replies and 1086 Views PA52 Call  1086  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 1086
by  WoozyJump to last post
01/10/2013 5:00 PM
4 Replies and 4954 Views COBOL NEWLINE  4954  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 4954
by  LauraPJump to last post
11/30/2012 9:28 AM
6 Replies and 1122 Views Send compiled version  1122  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 1122
by  bernfc10Jump to last post
11/26/2012 11:29 AM
1 Replies and 1031 Views Form Definition- How to left justify phrases  1031  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 1031
by  LynneJump to last post
11/13/2012 9:37 AM
2 Replies and 1498 Views PERSACTION direct manual insert  1498  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 1498
by  EBassettJump to last post
11/05/2012 3:53 PM
9 Replies and 5306 Views HR02 User Exit  5306  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 5306
by  bernfc10Jump to last post
11/05/2012 12:35 PM
1 Replies and 2345 Views Custom Calculation in Absence Management  2345  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 2345
by  bernfc10Jump to last post
11/02/2012 2:04 PM
9 Replies and 2204 Views Wrtitting the Comments.  2204  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 2204
by  Srini RaoJump to last post
10/25/2012 3:19 PM
2 Replies and 1075 Views Google Analytics?  1075  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 1075
by  John HenleyJump to last post
10/19/2012 8:00 AM
3 Replies and 932 Views AR220 - want to print each batch on a different page  932  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 932
by  SYLJump to last post
10/09/2012 4:43 PM
4 Replies and 1418 Views Relationship Between .rpt Form and Create CSV in Portal  1418  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 1418
by  Preston BurdwellJump to last post
10/09/2012 9:48 AM
1 Replies and 1252 Views Field Counts Do Not Agree Scr/Tran  1252  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 1252
by  WoozyJump to last post
09/25/2012 9:01 AM
12 Replies and 1692 Views PR198 Custom Program  1692  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 1692
by  DawnJump to last post
09/24/2012 7:13 PM
4 Replies and 1390 Views Remove Magnifying Glass from ESS  1390  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 1390
by  SurvivorACJump to last post
09/05/2012 2:41 PM
1 Replies and 1204 Views 900-CREATE-JOB updating current job gives error  1204  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 1204
by  Phil RomovJump to last post
09/04/2012 1:33 PM
0 Replies and 968 Views Aggregate range routines  968  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 968
08/23/2012 2:04 PM
7 Replies and 1979 Views Adding Custom Index/dbreorg question  1979  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 1979
by  John HenleyJump to last post
08/03/2012 2:38 PM
4 Replies and 1882 Views OE10.1 transaction ags call not clearing detail fields  1882  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 1882
by  LauraPJump to last post
08/03/2012 9:20 AM
5 Replies and 2096 Views Invoking PR36  2096  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 2096
by  LauraPJump to last post
08/03/2012 9:16 AM
3 Replies and 2292 Views How to join in DME calls  2292  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 2292
by  kwisserJump to last post
07/31/2012 9:01 AM
1 Replies and 1432 Views Absence Management Plan  1432  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 1432
by  John HenleyJump to last post
07/23/2012 11:16 AM
4 Replies and 2252 Views Adding Lawson Table Process?  2252  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 2252
by  Ron McDuffeeJump to last post
07/19/2012 9:55 AM
2 Replies and 1523 Views Full time vrs Part time Employee  1523  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 1523
by  bernfc10Jump to last post
07/17/2012 11:50 AM
6 Replies and 2366 Views Invalid username or password... Message  2366  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 2366
by  ChuckMJump to last post
07/13/2012 9:01 AM
4 Replies and 2635 Views FTP Script  2635  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 2635
by  Srini RaoJump to last post
07/12/2012 2:50 PM
6 Replies and 1968 Views Custom essmsgs.xml changes not working  1968  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 1968
by  BrianJump to last post
07/03/2012 10:27 AM
4 Replies and 1240 Views long running program  1240  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 1240
by  David AragoJump to last post
06/29/2012 9:57 PM
2 Replies and 1271 Views Transmit Date on PO20  1271  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 1271
by  JimYJump to last post
06/29/2012 12:52 PM
9 Replies and 3857 Views Steps to create a new custom program  3857  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 3857
by  Joe O'TooleJump to last post
06/27/2012 3:44 PM
2 Replies and 3014 Views PA100  3014  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 3014
by  Greg MoellerJump to last post
06/25/2012 3:28 PM
1 Replies and 1217 Views TAEMPTRANS/absence management  1217  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 1217
by  bernfc10Jump to last post
06/25/2012 10:07 AM
2 Replies and 1476 Views Retrieve AGS call data into custom ESS form.  1476  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 1476
by  David CronJump to last post
06/21/2012 4:23 PM
2 Replies and 1340 Views adding libraries to a 4gl program  1340  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 1340
by  Karen SheridanJump to last post
06/20/2012 3:29 PM
9 Replies and 2010 Views TIME ACCRUALS-TAEMPTRANS  2010  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 2010
by  bernfc10Jump to last post
06/20/2012 9:03 AM
3 Replies and 4272 Views Cobol signed fields  4272  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 4272
by  Karen SheridanJump to last post
05/29/2012 3:57 PM
3 Replies and 1447 Views time record service date  1447  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 1447
by  bernfc10Jump to last post
05/23/2012 3:14 PM
0 Replies and 1654 Views AD Last password change?  1654  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 1654
05/21/2012 11:25 AM
1 Replies and 2042 Views Modify AR150 for AFP template  2042  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 2042
by  AriJump to last post
05/17/2012 7:35 PM
1 Replies and 2007 Views DB read and initializing values  2007  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 2007
by  AriJump to last post
05/08/2012 7:10 PM
2 Replies and 2454 Views SQL to Lawson Data Types  2454  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 2454
by  AriJump to last post
05/03/2012 2:20 PM
0 Replies and 1166 Views Compile errors  1166  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 1166
04/30/2012 12:18 PM
4 Replies and 1989 Views TAEEMASTER FILE  1989  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 1989
by  bernfc10Jump to last post
04/30/2012 12:16 PM
2 Replies and 1521 Views Drill to 3rd Party Tables  1521  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 1521
by  AriJump to last post
04/27/2012 2:55 PM
3 Replies and 1908 Views ERRORNBR lookup table?  1908  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 1908
by  Kwane McNealJump to last post
04/12/2012 5:09 PM
5 Replies and 3030 Views user exit compile  3030  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 3030
by  bernfc10Jump to last post
04/10/2012 9:38 AM
3 Replies and 2475 Views 4GL CSV file name truncated  2475  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 2475
by  DemichenerJump to last post
04/04/2012 3:22 PM
5 Replies and 1742 Views Creating a custom Errors report  1742  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 1742
by  WoozyJump to last post
04/03/2012 9:56 AM
5 Replies and 1531 Views Display Zero in Portal Form Field  1531  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 1531
by  WoozyJump to last post
04/02/2012 9:22 AM
5 Replies and 2112 Views error 163  2112  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 2112
by  Ragu RaghavanJump to last post
04/01/2012 4:05 PM
2 Replies and 1142 Views Sections vrs Thru exit  1142  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 1142
by  bernfc10Jump to last post
03/29/2012 11:33 AM
1 Replies and 2370 Views Execute AP520 from external App on Iseries  2370  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 2370
by  Steven GrayJump to last post
03/24/2012 3:07 PM
8 Replies and 1445 Views custom 4GLs  1445  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 1445
by  DemichenerJump to last post
03/16/2012 2:53 PM
3 Replies and 2233 Views scrgen errpr: Field Counts Do Not Agree Scr/Tran: 156/152  2233  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 2233
by  Evan RosenbergJump to last post
02/29/2012 8:16 AM
1 Replies and 1808 Views Joining PURCHORDER to APINVOICE  1808  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 1808
by  John HenleyJump to last post
02/28/2012 8:15 AM
0 Replies and 979 Views Modify TRNLOAD to include the status.  979  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 979
02/28/2012 8:04 AM
1 Replies and 1225 Views Limit values in MSS personnel actions  1225  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 1225
by  Roger FrenchJump to last post
02/07/2012 10:55 AM
2 Replies and 2170 Views Javascript/AGS: Code after AGS call executes too quickly before AGS is complete.  2170  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 2170
by  Larry ChoughJump to last post
01/30/2012 8:44 AM
2 Replies and 1737 Views PO20 Last Modified Date  1737  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 1737
by  JimYJump to last post
01/17/2012 6:34 AM
1 Replies and 1491 Views Packet Length Error - OE10  1491  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 1491
by  LauraPJump to last post
01/12/2012 2:35 PM
8 Replies and 2728 Views Linking to a Lawson form from an HTML page  2728  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 2728
by  pklupaJump to last post
01/06/2012 1:40 PM
11 Replies and 2745 Views scrgen error  2745  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 2745
by  John HenleyJump to last post
12/20/2011 1:09 PM
10 Replies and 6155 Views New Table w\compilation issues  6155  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 6155
by  DemichenerJump to last post
12/19/2011 3:59 PM
21 Replies and 5509 Views PA52 AGS call doesn't populate new value fields  5509  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 5509
by  WoozyJump to last post
12/14/2011 9:46 AM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 3 of 6 << < 12345 > >>

RSS Feed Available