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

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

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

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

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

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             A     01         SB     yc2   COR-OPTIONS-WIN   2    *OUF-PALLET-CNT-LBL    A     03         SB     yc3   COR-OPTIONS-WIN   2    *OUF-LPN-LABEL-TYPE   A     03          SB     yc4   COR-...

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!

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!

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/gen/bin/bismark: Error Encountered IN...

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

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.

With some high level research, it looks like the availability of PA Action Comments in MSS (pactions.htm) should be driven by some user defined field or setting.  We want to remove the comments from that page and if it can be done by data setting versus editing the page, that would be the preferred method. Has anyone come across a table or file setting that determines this access I have tried removing access to the table via Lawson security and that did not remove it from the page...

We have custom update program where alot of users will be updating their data.  In order to not clobber each other's data when updating at the smae time,  my understanding is that we need to use splat fields.  I would like to get a good explanation of what is ocurring and what needs to be saved in the splat fields.  Does anyone know of any good documentatiomn/discussion around this

I am using 4GL routines to add URL attachments to APINVOICE. It works fine (at least in LID) when I use: \\lawsonappstest\e$\lsftest\law\dev...PImage.pdf It just hangs when I use this and then click on the URL from the drill-around: \\lawsonappstest\e$\lsftest\law\dev...PImage.pdf Does anybody know if there is a size limit if so what Thanks. Ragu

I am getting the error Form Size exceeds limit of 24 lines.  I don't think it does. This is a very simple report parameter form - it has 2 tabs Main tab has company, company name and then a detail line.  The detail line has 4 fields on it and there are 10 lines. The (run) Options tab has a couple of flags and a date range.  I think the problem is in my definition of the detail line.  I've attached the SCR - if you've got any ideas - please let me know. TIA, Karen

Does everyone that customizes Lawson programs use the LID editor I am wondering if there is a better editor out there. The little box that can't be maximized makes it very difficult. I am new to Lawson and have just begun customizing with LID. Thanks for any suggestions.

We created two custom tables, a head and detail table.  The quick paint utility painted the fields for the header table but did not for the detail.  I am trying to manually paint the detail lines.  I have created an initial detail line but do not know how to repeat it since I want 5 detail lines. Also just curious, does anyone have any documentation or additional instructions on how to use the paint utility in Lawson Thank you, Dan

I have created a custom online inquiry form.  When the form opens, I would like to populate some of the query parameters with calculated default values (which the user could override).  Is this possible in 4GL   For example, I'd like to pre-populate from/thru date fields based on the current date. From my testing, It appears that none of the PD code is called until the user clicks Inquire/Next/Previous, which is too late for my purposes.  Am I missing something

We have a custom servlet that allows ESS users to change their password.  Once the password is changed, a link is displays that takes the user to the Logon page.  This servlet is called from a help section of our intranet employee application. I was asked to place a link to this password change servlet on our Lawson Logon page.  So the ESS user goes to the Logon page, finds out they can't log on...they select the link that takes them to the change password app.  Then a link on that page t...

FYI - new to lawson, so learning the ropes. I'm writing a COBOL program to read in 1 or more files and for each file, kick of a batch job, of another program, that I defined via jobdef.  Since each file will be processed by the same job, my thought was to copy using the work file, using 900-movefiles, to a working directory and file-name that I defined in the job-def, and then use 900-load, 900-create, and 900-submit to run the job, and then when the job was over, repeat the process for e...

I've been successful creating Data Service Calls and executing them from form scripts created in Design Studio. Now I'm trying to do the same from an htm file, and it blows up when it tries to execute the URL saying that portalWnd is not defined. (eg: var vDMEInfo = portalWnd.httpRequest(mDME)  I'm guessing this is because the script is not attached to a form. What would be the proper syntax to run the URL from an htm file  Is there an example of this TIA...ChuckM

I am looking to find a way to use the OR operation in my web browser DME call. http://myhr.sjhsyr.org/se...68611&out=csv&DELIM=|&MAX=99999 I would like modify the above search to select PO-NUMBER=868611 or PO-NUMBER=13.  I've tried using the plus () but I must be missing something. Thanks

Is it possible to filter a DME web browser query on a related table  For example, I want to find all PO lines that have a null PO-USR-FLD-5.  https://myhr.sjhsyr.org/s...!=00&out=csv&DELIM=|&MAX=99999 When I run the above query, it never ends.  I've even let it run overnight and it doesn't finish.  I don't think it has anything to do with the size of the result set because I've also tried adding a condition to the &select to pull a hardcoded PO-Number.  From all my testing it se...

Getting an error on a custome program that we can't explain (or decipher).  The odd part here, is that the file it is complaining about is only used for input and there is not a single PERFORM 800-WRITECSV-MAFVNIN in the program.  Any idea what this error is actually trying to tell me WriteCSV():File /lawson/lawprod/law/test9/hht/MAFVNIN/MAFVNIN MAFVNIN 0 Not In Write Mode Execution error : file 'mfini' error code: 119, pc=0, call=1, seg=0 119 Name is not unique (binding symbol 'mfini...

Does anyone know how to display the productline name near the welcome message in portal for 9.0.1 In the older system we would change the default.xml to place it in the header.  Before someone pontificates about this, our users get confused on which productline they are in on the test system and this helps.