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  Here is w...

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.

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.longNames = true    obj.tds       = false     obj.out       = 'XML'    obj.field     = 'FC=I'          '&BAE-COMPANY='  escape(authUser.co...

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

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!

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               =                     }          1               =                    J          2               =                    K          3               =                    L          4               =                    M          5               ...

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

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.

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)

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           TO DB-PLAN.            MOVE LPMST-TEM-EMPLOYEE-GROUP TO DB-EMPLOYEE-GROUP.            MOVE LPMST-TEM-POSITION       TO DB-POSITION.            MOVE 5                        TO WS-DB-BEG-RNG.            MOVE SPACES  ...

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 view but it shou...

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

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

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 I nee...

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.

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

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                 Processing ZR210 - VHM pedometer Deduction                 *** WS-FILENAME=/lawdev/law/testhcm/work/VHM/TheChristHospital_1389347_GWS_2012...

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!

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!

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..

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.

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

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.

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!

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, Kevin