I want to delete 12 records from the TAEMPTRANS table. What would be the fastest or most efficient way to do this

I am using pgmdef/Paint to create a new form in LSF 901.  After adding some fields to the form, I decided that I wanted to remove one of them.  I moved the cursor into the field and pressed 'delete' and got a 'Cannot Delete Field' message.  Then moved the cursor to the right of the field and tried backspacing, and got the same error message.  It doesn't matter if it is Input, Output, Header, Detail, Key, or Non-Key.  The only way I can find to remove a  field is to delete the entire row using th...

Hello, how could I get the accrual to round correctly  The accrual calculated amount showing as 7.499700 (LP64) and we'd like to round to 7.500000 hours. LP02 screen: HOurs Method = 1 Round to .000001

I have a custom S3 form, and I want to 'spawn' a new form when the 'Add' button is clicked, rather than having it add a record as it usually does.  I've spawned forms in the past by adding a button to the body of the form and setting the 'picture' attribute in the .scr to the form name.  Is there a way to do the same thing using the 'Add' button Thanks for your suggestions!  Kelly

I have a custom form object (ZJ35) that includes two forms (ZJ35.1 and ZJ35.2).  I'm trying to add a custom section within the object that I can reference from both forms - similar to referencing an external library.  However, I keep getting an error on compile: Warning: Illegal PERFORM: Referenced LABEL Not In SECTION Warning:           LABEL: 3000-GET-LAST-PERIOD-PROCESSED Warning:     Source Line: 403 As far as I can tell, I have the section named correctly and referenced correc...

Hi, I am trying to copy an existing custom AGS call from elect_benefits.htm to elect_ben_05.htm. We are using ZN31.1 to determine if the Evidence of Insurability (EOI) statement should be displayed. 501 indicates the message should be displayed. In elect_benefits, the returned data is found in self.js1.RtnMsgErrNbr. However, when I step through the code in elect_ben_05, self.js1.RtnMsgErrNbr is undefined. (I can momentarily see the value set as 501 in the Debugging Tool. But when control r...

Hello, Is their a way to create a mixed case header for csv file using workdef. My vendor wants the field name as 'BatchNumber' but when I can't declare the field name in mixed case in workdef. Thanks

Our Benefits department has asked us to build a process that will update a custom audit table anytime Beneficiary data is changed via BN47.  This seems like a perfect use for a Form UserExit, but I've never built one of these so I have a question. It seems to me that an 'End' user exit is the logical place to put my logic, since it is after the form  transaction has completed successfully.  However, it appears that when the End UserExit runs, all the LINE-FC values have already been cleared, ...

I created an 'End' UserExit for a form, and then decided that I need to move that code to a 'Middle' UserExit instead. How do I remove the 'End' UserExit after it was been compiled  I tried deleting the source files and then recompiling with the -u, and that didn't work.   What's the trick Thanks!

Issue Description:  Process Flow in-basket display - The requisition approval in-basket display does not show the accounting unit, account and asset template for an asset when the total requisition lines is one but the requisition line number is two. I don't know if it is possible to accomodate this situation with the query that populates the display but if possible it would be nice. I think this is an unintentional error on the part of the requester but it happens sometimes. (Screenshot exa...

Hi All - this is a strange one. I created a custom library (ZZBNFPD/ZZBNFWS), defined it using libdef so that the PD references the WS.  I then put a call into BNBNFPD to the new library.  The only entry in the custom library (at this moment) is a display statement (DISPLAY 'TEXT').  When I compile the program, it compiles without errors.  If I run the base program, the library is called and the display appears in the log. Next, I tried adding a line to the custom library to display a valu...

Our users would like to have a filter added to the workunit inbasket that will allow them to chose a specific category filter, which is company number in our case. Lawson has provided other filter options like workunit, start date and originator, but not on the filter value column.   We just moved from lawson 8 to 10 and I am not familiar with where the inbasket code is. In 8 there was an inbasket.js file that we modified, but I am unable to find this in 10. Has anyone made this type of modif...

Hello, I am trying to run a job and it hangs. I checked the logs, has anybody seem the following error before and how can I resolve it File GEN/QUEUEDJOB. tsStoreDBRec error is Bad data in field(s) (82). Additional information is 1722. Additional Text is: StoreSqlRec(GEN9.'QUEUEDJOB') OCIStmtExecute() returned OCI_ERROR code 1722 parse offset 30343168 ( ORA-01722: invalid number

I have a custom table that has been around for some time.  The business has requested a modification which requires the addition of an additional column to the table.  Can I make this change without losing the existing data in the table  If not, what is the best way to export/import the data that will work with a new table layout By the way, I will be making the table change in DEV which will then be promoted to PROD.  I'm most concerned that the folks who do the promotion are told what to ...

I created a custom program (batch update) to update the taeemastr, taemptrans and tatransum files. We are still testing the program and whenever the records are not updating correctly, I have to go back and fix these records using a paint screen. The users mentioned I could run the program in report mode, what does that mean and would I have to change the program type

I ran LP180 to transfer the Vacation bonus hours to the Vacation plan and it didn’t work. When I look at employees LP64 records the hours are in the bonus plan but when I look at the LP31 records there is no balance in the  vacation bonus plan. Any thoughts

I am trying to use filters and using sample code in the doc for developers API. But I don't quite understand how to use WS-DB-BEG-RNG or it's purpse. Does it matter if I use company or employee number

I wrote a new 4GL program that is working correctly in LID.   I then ran this in portal (it is an online update program against a custom table).   After working with the end users we made a few changes.  I made changes in LID, they are working correctly, but when I run in Portal I am getting: Server Xpress error     java.lang.StringIndexOutOfBoundsException         at java.lang.String.(String.java:176) any ideas Thanks

I have a custom file with three fields in it. All three fields are part of the primary key. I have a selects built that are working but they return all records. Is there a way to return only the distinct list of the first field. So My table has Group, company, and location in it. Currently my selects return every combination in the table. I want to return only a distinct list of group names. So instead of Group1, company1, location1 Group1, company1, location2 Group2, ...... I want Grou...

We had an ex employee who created numerous custom jobs in lawson. (more knowledge than I have in lawson). One program she created was a token called ZZ412 I pull it up and its just a screen to run a job. I can go into LID and pull up this job and the few parameters I can find in jobdef, but is there somewhere in lawson or LID i can go into to actually see what this job is doing or where this job is actually created, what fields it is using etc. Also, is there a way I can see all custom job...

Hi, Is there a way to have the dropdowns(Select) dynamically from different tables, depends on one of the input fields. Thanks, Alex

I have a table that includes a 'status' field that has a value list with translations defined in dbdef (i.e 0=Entered, 1=Submitted, etc).  If I do a fetch against that table, are the field translations returned as well as the field value For example, if my table is ZZTEST with prefix ZZZ, I can do an 840-FIND-ZZZSET1.  Once I do this, I will be able to do a 'MOVE ZZZ-STATUS TO whatever'.  Is there a way for me to move the translation value as well I know I can do this on a screen using k...

We are in process on writing the conversion program for GHR implementation.  GHR needs long filed names like ” ContactDetail.Telephone.InternationalPrefix”. I tried to use 800-OVRDESCCSV- API, but it only uses 35 chars on the override field name.  Is there a way to get big filed names

Does anyone know if it's possible in 4GL to put spaces in CSV column headings  For example, I need 'Contract Number' as opposed to 'ContractNumber' for the heading of a column.  I tried using the 800-OVRDESCCSV with spaces, but it doesn't respect them.  Thanks!

I have been trying to figure out why my code wouldn't filter transactions with date > given date. It's reading all the transactions, am I misssing something  Here is the code:               MOVE 'FTFLOAT80'       TO WS-ETT-PLAN-NAME               MOVE WR-TEM-COMPANY        TO DB-COMPANY.               MOVE WR-TEM-EMPLOYEE       TO DB-EMPLOYEE.               MOVE WS-ETT-PLAN-NAME      TO DB-PLAN-NAME.               INITIALIZE                                          DB-SEQ-NBR             ...