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 5 << < 12345 > >>
 Last Post
1 Replies and 2140 Views Design Studio AGS call delete not working  2140  1 Started by  Linda Ogle I am trying to get the AGS call below to delete a record from a file.  I have checked all the variables to make sure they are populated properly.  Is it because the form,,FE14, requires a inquire before the delete   I am getting message nbr =11 and message 'no more records for given key'.  Any suggestions   I am new to this and therefore I am Javascript challenged! var s = portalWnd.AGSPath '_PDL=';          ...
1 2140
by  Linda OgleJump to last post
02/14/2011 5:36 PM
2 Replies and 1276 Views Best Practices  1276  2 Started by  Angela Collins Much of the Javascripting references the field ID.  OnBlur uses the field ID as well as several others.  How do you make it easy to maintain since the field numbers can change with patches  Our thought was to put as much of our customizations in Javascripting because when customizing the COBOL, that normally gets the response that the customization is the issue.
2 1276
by  Angela CollinsJump to last post
02/02/2011 2:04 PM
3 Replies and 1619 Views OnClick  1619  3 Started by  khart I am able to use OnClickCheckBox and OnRowClick to trigger events but is there an Event to know the exact field a user clicked on the row if you are using OnRowClick
3 1619
by  khartJump to last post
01/26/2011 2:37 PM
3 Replies and 1248 Views changing how a table is accessed  1248  3 Started by  SusanB I am working on a Design Studio modification to a Work Flow inbasket. The Design Studio accesses the APINVOICE table and the APDISTRIB table. Currently, both DMEs are using the following fields to query the tables:company;vendor;invoice;suffix;cancel_seq. Since querying the APDISTRIB in this manner is inefficient, I would like to change this to retrieve the obj_id field from the APINVOICE table and use it to query the APDISTRIB table. My problem is I am new to Design Studio and am having difficu...
3 1248
by  David WilliamsJump to last post
01/13/2011 12:39 PM
6 Replies and 1767 Views Portal Page Design studio Select product line workunits  1767  6 Started by  Deleted User I understand there is only one Logan DB on the server we use, but we have 3 product lines on that server.  We get workunits in our inbaskets from all product lines when we are logged on to one product line.  I know we specify the product line in the .xml, but is there a way to specify the product line on each field we are populating to the Portal Page. How can we ensure we only get the workunits from the designated product line  Thank you for any light you can shed on this i...
6 1767
by  Roger FrenchJump to last post
01/08/2011 2:17 PM
2 Replies and 1208 Views Portal page xml Source  1208  2 Started by  Deleted User New to design studio; I think I need to start from scratch. Is there any to take a Portal Page .xml file and determine the steps the designer went through to create it.  I can understand the tables, and the fields, BUT how do you know how they created the access to the tables Thank you.
2 1208
by  Deleted UserJump to last post
01/06/2011 11:55 AM
8 Replies and 1843 Views Securing DS in PROD  1843  8 Started by  mark.cook We are looking at options to install DS in PROD but securing it from the common Lawson users. To date we have only had it installed in DEV and move the forms to PROD updating the product line,etc as needed. Has anyone been successful in securing DS in a PROD environment
8 1843
by  NickJump to last post
01/03/2011 10:58 AM
49 Replies and 40629 Views AGS call from .net to Lawson 9.0  40629  49 Started by  John Polito Before we upgraded to Lawson 9.0 i was able to do AGS call from my .net web application. I am now having security issues, can someone tell me the process now to pass the username and password in to the Credentials. Also i'm getting an error on servlet/ags saying that the servlet is not found. If you need more info just let me know! Thanks, John
49 40629
by  vbJump to last post
12/30/2010 11:06 PM
4 Replies and 1228 Views ee20.2 process level to ee20.3  1228  4 Started by  Kate Liamero on ee20.2 there is a field exp-proc-level. On the bottom of the form  there is a detail button , that opens the ee20.3 form .  I need the exp-proc-level to display on the ee20.3 form also but it is not an available data source on that form.  I am javascript inpaired  and don't have a clue on how to make this happen.  thanks and happy holiday season to all. Kate
4 1228
by  Kate LiameroJump to last post
12/23/2010 1:30 PM
6 Replies and 1292 Views Transferred form values  1292  6 Started by  David Williams I'm transferring from GM11.1 to GM11.3 and need to capture the Employee value which isn't displayed on GM11.3 but is used to limit what's displayed.
6 1292
by  MallaiahJump to last post
12/14/2010 8:44 AM
0 Replies and 1279 Views Adding Checkbox to UI Form  1279  0 Started by  Eddie Smith We have modified RQ45.1(Reportable Income Adjustment) form by adding a checkbox in the detail section of the form in hopes of being able to 'check-off' vendor invoices that have been reviewed for 1099 reporting. Each AP invoice record shows the check box and is actionable but is there anyway to associate the check box to the invoice Unfortunately the checkbox data source fields that available for associating is very limited and does not contain the invoice field. Can this be...
0 1279
12/10/2010 11:40 AM
0 Replies and 1508 Views Adding javascript functions to Design Studio  1508  0 Started by  Tim Cochrane Has anybody successfully added javascript functions to the UI Designer section of Design Studio  I could use onkeypress for PA31 to asterick the SSN as it's entered, but it's not a selection.  I've found where it could possibly be added in designer.xml and dom.xml, but I'm not sure if that's the real answer. Any ideas
0 1508
12/09/2010 10:15 AM
2 Replies and 1272 Views access the sql created by default index  1272  2 Started by  Deleted User I'm new to Design Studio, so these questions may sound simple but I don't get it.  Our problem: Our tech folks did a trace while a user was accessing inbasket data in Portal.  The trace shows all the sql statements used in the process.  When I open the .xml in Design Studio we only see a generic select statement in the Source, we do not see all the sql.  How do we see it so we can change it  We want to select an index rather than letting it default to an index Anothe...
2 1272
by  Deleted UserJump to last post
12/02/2010 2:49 PM
11 Replies and 3677 Views Understanding oUserProfile.getAttribute  3677  11 Started by  Deleted User LawsonGuru's, I am looking as some coding and came across the following line: var currentUSERCMP=portalWnd.oUserProfile.getAttribute('company'); I think it pulls from some user profile obect, but exactly what does it pull for The line that has: var currentPDL=portalWnd.oUserProfile.getAttribute('productline'); Returns the product line I am currently in but the 'company' returns me empty. Where is this value being pulled from and how can it be populated are my questions. Thanks in advance...
11 3677
by  Deleted UserJump to last post
12/01/2010 9:39 AM
1 Replies and 1295 Views move field from one tab to another  1295  1 Started by  Kate Liamero I need to move the field cash code (API-CAS-Code) which comes form cb00.3 on the AP20.2 from the Options tab4 to the Main tab1 but I don't see this field as a selection option on the main tab. thanks kate
1 1295
by  David WilliamsJump to last post
12/01/2010 8:41 AM
0 Replies and 1726 Views using POST method for java api call  1726  0 Started by  vinh299 Has anyone been able to make POST method call with the Lawson API instead of the GET method I've been looking at the documentation but haven't figured it out yet. Does it require an XML file as input If so, where do I find out how to setup the schema of the XML file. Also, are there any advantages/disadvantages for using either GET or POST methods Thank you in advance, Vinh
0 1726
11/24/2010 10:38 AM
3 Replies and 1858 Views Querying comments table for comments  1858  3 Started by  Deleted User We did some work some time ago via sql querying comments for an invoice using the following query: SELECT top 3 api.COMPANY ,ISNULL(apd.DIS_ACCOUNT,'') ,ISNULL(apd.DIS_ACCT_UNIT,'') ,ISNULL(apd.DIS_SUB_ACCT,'') ,ISNULL(apv.VENDOR_VNAME,'') -----AS VENDORNAME ,api.INVOICE_DTE -----AS INV_DATE ,api.INVOICE ,api.TRAN_INV_AMT ----AS AMOUNT ,api.DESCRIPTION ,api.BATCH_NUM ----AS Batch ,api.VENDOR ,api.L_INDEX ,ISNULL(lhap.NAME,'') ----AS FIRSTCOMMENT ,ISNULL(lhap.&91;OBJECT&93;,''...
3 1858
by  Terry PJump to last post
11/18/2010 5:22 PM
7 Replies and 2443 Views Select return value  2443  7 Started by  Terry P I'm still trying to figure out how to get the value from a select IDA call. Here is the function this is executed when they click a button at the top: //********************************************************************************* // If the user clicked the lookup employee&160; button //********************************************************************************* function btn_LookEmp() { &160;idaCall = '/servlet/ida_STY=&_TYP=SL&_OUT=XML&_PDL=LAWAPP8&_SYS=HR&am...
7 2443
by  balayogeshJump to last post
11/15/2010 10:42 PM
0 Replies and 1132 Views Freeze Pane function in Query  1132  0 Started by  David Williams Is there a way to freeze the field headings of a Query when a user scrolls down. They'd rather not have to page next and previous to see all of their records but when you scroll down you loose the headers.
0 1132
11/15/2010 9:32 AM
1 Replies and 1286 Views Saving more data than .scr screen field size  1286  1 Started by  jdever I have a custom database field in a Lawson table that holds 256 chars.  I am trying to use an AGS call to save data to the database field from a text area.   The screen field defintion in the .scr TRANS section is 99 chars. I am trying to see if there is a way to save directly to the database field. I am trying to avoid a work around of having additional hidden screen fields that must be concatenated on the save and parsed on the inquiry.
1 1286
by  John HenleyJump to last post
11/14/2010 2:01 PM
0 Replies and 1169 Views JavaScript problem with the Detail Line on the 2nd Form  1169  0 Started by  shaylaw A customed online program is written with 3 different forms.  There is a button on the first form to press to go to the 2nd form which has the detail lines.  My JavaScript is preventing all the data to be displayed on the 2nd form including the data on the detatil lines.  I'd like to get this script running when I am on the 2nd form (how do you check to see that you're on the right form).  I would like to Change/Delete the detail line when the account is the one we wa...
0 1169
11/12/2010 11:15 AM
1 Replies and 1453 Views Replace Text Box with Text Area  1453  1 Started by  jdever I have a hidden text box on a Lawson form.  I am trying to replace it with a text Area to allow greater input.  The database field has plenty of room. I was hoping by simply adding the text Area and changing the XML source to the data field for the original text box, I could 'fool' Lawson into handling the text area as the orignal text box. Has anyone accomplished this  Or must I do a DME & AGS call to tie to the text Area... regardless
1 1453
by  jdeverJump to last post
11/10/2010 11:44 AM
4 Replies and 1871 Views Attach Document through Design Studio  1871  4 Started by  Robert Spurr I'm currently working on a variant of the requisition approval process with a focus on service requests.  So far everyhting is working as designed but I've hit a road block on how to request and send documents through the approval process.  Specifically is their a way through Design Studio to proved a file browsing option with the ability to save the file to a designated path  Our goal is to allow any user the ability to submit a service request and have all relevent files stored...
4 1871
by  David WilliamsJump to last post
11/02/2010 9:13 AM
16 Replies and 2361 Views Trigger PFI from Submit button on LM199  2361  16 Started by  amylynanderson I am trying to use java to do this. I cannot find a variable that is unique enough to say it is a submit. The message on all transactions is submit The fc code is not set for a button. I know my ags call works but I only want it to happen when they submit the job. Any suggestions, Amy
16 2361
by  David WilliamsJump to last post
10/29/2010 1:51 PM
5 Replies and 1566 Views 8.1 to 9.01 Design Studio Issue  1566  5 Started by  Robert Spurr I'm currently migrating forms & pages from 8.1 to 9.01 and ran into an issue I don't understand.  I have a Portal page with a DME call that passes variables from the DME to a custom form (attached formlet) and forces a refresh,  In 8.1 this is working without issue but in 9.01 the form acts like no variables were passed before the refresh.  I went as far as rebuilding the entire thing in 9.01 but with no success.  Note:  I've verified the DME values with alerts s...
5 1566
by  Robert SpurrJump to last post
10/25/2010 4:07 PM
7 Replies and 1753 Views Disable DME object from being Actionable?  1753  7 Started by  Eddie Smith Is there anyway to disable a DME query result from being 'actionable' In other words,when a user clicks on a row in the first DME object, a second DME object is rendered; however, we would like for the second DME object to be static (i.e. non-clickable).
7 1753
by  John HenleyJump to last post
10/21/2010 4:41 PM
2 Replies and 1583 Views Hide or remove line FC  1583  2 Started by  David Williams We need to remove the line FC field from our form. How can you do that
2 1583
by  David WilliamsJump to last post
10/20/2010 11:11 AM
2 Replies and 1142 Views How does OnAfterDrillSelect work?  1142  2 Started by  David Williams I want to use the OnAfterDrillSelect function and use the keysNode value returned to the form. I can't figure out how to make my script read and do something with the value before the return keysNode puts the value into the field. Has anyone got this to work
2 1142
by  David WilliamsJump to last post
10/19/2010 3:57 PM
3 Replies and 2484 Views AGS call to update HR11 field  2484  3 Started by  Joe O'Toole I want to update a single field in HR11 from within a users ESS session. I have the Product line, Company and Employee values for the EMPSET1 key and am able to read the record with a DME call but the AGS call to update the record is not working. I'm checking the status but don't get any value. Could anyone priovide a working example of an AGS call to update a single field&160;including the status&160;check Is there any Lawson supplied documentation on this other&160;than the DS users guide...
3 2484
by  Joe O'TooleJump to last post
10/13/2010 9:41 AM
0 Replies and 1340 Views AGS call to update the CYCLE and/or BIL field in BR42  1340  0 Started by  Trever Kresge Hi everyone, I am not having much luck with creating an AGS URL (query) to change the cycle and/or the bill fields in BR42 on a specific activity. Has anyone done things like this with BR42 before I've made other AGS calls but nothing with multiple lines like BR42 and wanted to how if there is a trick. Thanks in advance. -Trever Kresge
0 1340
09/14/2010 3:48 PM
7 Replies and 2321 Views Limiting User Access to a Design Studio Form  2321  7 Started by  Walter We've modified form PO20 in design studio to add a function (Request Approval) which would trigger a Process Flow.&160; Ideally, I would like&160; to limited the design studio form to a select group of users.&160; The others would&160;continue to use the&160;Lawson delivered PO20.&160; In other words, they&160;would not see the new function.&160;&160;
7 2321
by  Mike FlynnJump to last post
09/14/2010 12:47 PM
2 Replies and 1555 Views Loading Local Files  1555  2 Started by  Deleted User Friends, Hey. I am still new in Lawson getting my feet wet and have a question. I want to open up custom screen xml files in Design Studio but seem to get ActiveX errors when I do so. So I went through and found the attached issue on the myLawson knowledge base to resolve (Article ID:86038). So I adjusted accordingly and now can get the Local Files to let me choose a location, but when I choose an XML file, the file does not load into the Design Studio. I am lost here, what is happening
2 1555
by  Deleted UserJump to last post
09/09/2010 1:13 PM
6 Replies and 2135 Views Using JavaScript to Perform an Inquiry on a Form upon Initialization  2135  6 Started by  pklupa Hi Everyone, I have created a custom form using the CASE tool with two key fields - company and employee. The company is always 0001 and I can get the employee from the user profile: var vEmployee = portalWnd.oUserProfile.getAttribute('employee') I am setting up this form so that when a user logs into the form, the company and the user's employee number are pre-populated in the key fields. I have made these fields output-only, so the user cannot perform an inquiry or update any other...
6 2135
by  KK - InforJump to last post
09/09/2010 12:02 PM
3 Replies and 1389 Views Field will not update  1389  3 Started by  TommyT I have added a field to a custom table (that was designed in dbdef and lawson knows about) and I cannot make it appear on a portal form in which other fields from this table are displayed. The textbox displays and accepts data but does not store it. In doing the setup I cannot set the data source for this textbox. The only choice I get is 'None' and I am not allowed to select anything. Any Ideas TIA
3 1389
by  TommyTJump to last post
09/07/2010 10:03 AM
2 Replies and 1163 Views identifying the user  1163  2 Started by  TommyT Is there a way in a design studio form to identify the ID number of the person logged in and using the form
2 1163
by  TommyTJump to last post
09/03/2010 11:38 AM
1 Replies and 1544 Views Drill from GL to AP detail  1544  1 Started by  Eddie Smith I know per Lawson KB articel 556138, that if the system code and the source code are AP, then drill back is not available (we are seeing that on GL90.1 drill around); however, we are trying to create a portal page with DME queries that start from APPAYMENT but cannot seem to get back to APDISTRIB. Has anyone been able to do this using DS We are able to get back to APINVOICE and get the first distribution record associated with the payment using related tables, but how can we get all
1 1544
by  John HenleyJump to last post
08/18/2010 5:18 PM
9 Replies and 2727 Views portal page 2 data objects--need bottom one to refresh  2727  9 Started by  Deleted User We have a portal page with 2 data objects (vendor invoices top; invoice payments at bottom).&160; The problem is that if we filter or hit Previous or Next, we need the&160;bottom&160;data object to disappear until an invoice is clicked (based on the new query). Does anyone know how to do this
9 2727
by  Eddie SmithJump to last post
08/18/2010 8:05 AM
2 Replies and 1049 Views Portal Page Security  1049  2 Started by  Eddie Smith We would like to create DME queries using the Portal Page Designer but need for the queries to only allow a user to access data for the Lawson companies they have access to as defined in our LAUA security setup. Would JAVA scripting be required and if so how would the script be constructed.
2 1049
by  Eddie SmithJump to last post
08/12/2010 9:31 AM
13 Replies and 1869 Views Passing values from one form to another  1869  13 Started by  Todd I'm trying to pop up a screen from OE10.3 detail line that will total prices from a custom table and pass that total back to OE10.3 detail line price field. Is this possible I'm thinking that there has to be a global variable, or some shared memory trick.
13 1869
by  Terry PJump to last post
08/11/2010 3:39 PM
8 Replies and 1391 Views Security Error on DS Form for wfwk.3  1391  8 Started by  Woozy I have created a series of Design Studio versions of WFWK.3 (workflow trigger). Basically, I modified the form to default the service name and description, and removed the fields that were not required. All the forms work fine for me, but other users can see and use one of the forms, but get a Servlet Xpress error when they try to use the others (see attached). The xml files are identical except for the defaulted fields. The only other difference is security. I have full r...
8 1391
by  WoozyJump to last post
07/22/2010 2:41 PM
7 Replies and 2187 Views Creating a customized form  2187  7 Started by  Deleted User Be gentle, a newbie to the inners of Lawson :D I am trying to make a customized screen in Lawson via an .xml file. I am trying to understand how to go about customizing an existing screen. I know there is a way to take some existing data to create the xml file and then I can custommize - or at least I hope so. Am I on the right track Example: I want to make some cosmetic screen customizations to the AP81 screen. How would I go about doing that Thanks in advance friends!
7 2187
by  Deleted UserJump to last post
07/15/2010 5:18 PM
8 Replies and 3107 Views Hide button on screen based on group/role  3107  8 Started by  Rudy Need some assistance. I have a button on the HR11 screen that will launch a webpage. This works fine. But, we are rolling out in a phased approach to 40 offices, 1-2 at a time and the powers that be do not want anyone seeing the button until it is their turn to go live. We are talking about 2-4 people per branch. Using the hammer approach I was able to get the code working below but it requires me to add user IDs every time a new office goes live. This requires a lot of extra red tape goi...
8 3107
by  David WilliamsJump to last post
07/14/2010 12:29 PM
1 Replies and 1510 Views Show Wizard not working  1510  1 Started by  Eddie Smith We have created a form wizard and want the Wizard to load automatically whenever a user accesses the custom form. We have tried to use Lawson JAVA script below, but the form wizard does not show. Are we misinterpreting Lawson's script function FORM_OnInit() { oWizard=new Wizard(window, strPDL, strTKN); oWizard.showWizard(); return true; }
1 1510
by  Eddie SmithJump to last post
06/30/2010 1:57 PM
6 Replies and 4000 Views PO20 Error: Value not in List:  4000  6 Started by  AG We just applied patches into our DEV/UAT environment. We have a custom PO20 design studio form. On this form we have a button that triggers a process flow. After we applied the patches this button is not working! When the user clicks the button it now throws up an alert 'Value not in list: '. Does anyone know what this means and/or how to fix this We are on AS400/ISERIES V8.0.3.
6 4000
by  Steven GrayJump to last post
06/24/2010 12:25 PM
4 Replies and 1317 Views Including a Missing PO Line Field in a DS PO20 Form  1317  4 Started by  S. Rosa I'll start with the standard newbee disclaimer that I am new to DS and need a little help from the experts:blush: Background: This client does not own RQ or Process Flow but requires a basic form of PO approvals. We devised an approval process that would withstand audit using security setup, buyer limits and PO releasing. One of the approvers asked for a new form that would basically mimic PO20 except it would display much of the PLI and MMD fields that are within tabs or hidden. All ...
4 1317
by  S. RosaJump to last post
06/17/2010 10:21 AM
9 Replies and 2915 Views Employee photo on HR11  2915  9 Started by  wilcoxmad I want to add code to our custom HR11 screen that will show the employee photo. Anyone done this
9 2915
by  wilcoxmadJump to last post
06/14/2010 8:33 AM
8 Replies and 1241 Views Making Froms/Field Display Only on the fly  1241  8 Started by  Saurabh Hi All I have a custom design studio form with a status field. Based on the status field value i would like to set the whole form to be 'display only' or just certain key fields to be 'Display Only'. e.g if the Status is 'Rejected' the user cannot make any changes in the fields, but if the Status is 'Level1 Check' he is only allowed to make changes to certain non-key fields. Any other tips on how that can be achieved One thought i had was to capture the Change event and then check...
8 1241
by  David WilliamsJump to last post
06/09/2010 3:12 PM
4 Replies and 2872 Views AP20.1 in Lawson 9 OnAfterTransaction  2872  4 Started by  Deleted User On AP20.1 we have added another row to the detail line item area for the account number description (GDT-DESCRIPTION). We try to clear these out and the following code was working in 9.0 (we're in the process of an upgrade), but when I save the form now, I get the error re 'Script is saved with syntax error checking. A&160;script control component is not found. Please refer to the documentation for download instructions.' I&160;have removed all of the javascript in the form except this beginni...
4 2872
by  mikePJump to last post
06/08/2010 9:54 AM
1 Replies and 1542 Views Value not in list still allows change  1542  1 Started by  Mark A I added two listboxes to AP20 and upon add or change update the Invoice Group by concatenating the values in the listboxes. Normally, if you key in a value that's not in the list and tab out of the field, the system stops you from processing and provides a 'Value not in list' message. However, if you simply type in a value and click change on the form without leaving the field, it allows the change and updates the field even though there's a 'Value not in list' message. I'd like to captur...
1 1542
by  Ragu RaghavanJump to last post
06/06/2010 8:58 PM
1 Replies and 1126 Views Show dialog box based on Toolbar option pressed in form  1126  1 Started by  Saurabh All I would like to add an additional prompt when the user Presses the DELETE button in a form (the button is next to Change and Next) Looking at the form properties i can hide(UnAssign) the action but ideally looking for a way to show a dialog box and if the user presses NO to return him back Any tips regards Saurabh
1 1126
by  David WilliamsJump to last post
05/27/2010 12:34 PM
9 Replies and 1578 Views Java Script Looping  1578  9 Started by  Eddie Smith I'm new to using Design Studio and trying to make an IC user field a required field on the IC21.1 form (Inventory Issue screen). I'm able to get the script to check the first line on the detail section, but how do you get it to check all lines having an item being issued out Below is my JAVA script. Any help would be appreciated. function FORM_OnBeforeTransaction(fc) { if (fc == 'A' || fc == 'C') { var sUserFld = lawForm.getFormValue('text22'); if (sUserFld == '') ...
9 1578
by  Eddie SmithJump to last post
05/26/2010 4:25 PM
1 Replies and 1822 Views RQ10 getattachrec.exc for comments  1822  1 Started by  BrianP Has anyone used with V9.0.0.6 and LSF thanks
1 1822
by  Derek CzarnyJump to last post
05/21/2010 1:34 PM
2 Replies and 1204 Views Modify Birthdate to show Month only  1204  2 Started by  Nabil I have a DME call for specific fields in HR11 and one of these fields is PEM-BIRTHDATE but instead of showing the whole date, I need to only show the month. Is there an easy way to do this Thanks
2 1204
by  NabilJump to last post
05/07/2010 5:05 PM
3 Replies and 2710 Views DME Query  2710  3 Started by  Nabil I'm trying to add a field (EMS-DESCRIPTION)&160;to this DME&160;query in my form, but I get an error when I run it: function doDME() { var sDME; var vCompany = 1; var vEmployee = lawForm.getFormValue('txtemployee'); sDME ='PROD=' strPDL; sDME ='&FILE=EMPLOYEE&FIELD=FICA-NBR-LAST4;FULL-NAME;EMS-DESCRIPTION;EMP-STATUS;HM-ACCT-UNIT;LOCATION.CODE;LOCATION.DESCRIPTION;COMPANY;EMPLOYEE'; sDME ='&SELECT=COMPANY3D' vCompany; sDME ='26EMPLOYEE3D' vEmployee;...
3 2710
by  NabilJump to last post
05/07/2010 12:56 PM
1 Replies and 1260 Views Setting a Checkbox on intial Load  1260  1 Started by  Robert Spurr I've created a design studio modification of RQ10 for RSS approval with a checkbox. I want to inquire on a table and set the checkbox based on the value I retrieve. I have no problem reading the value to update the table but reversing the process doesn't seem to work. Does anyone have an example of setting a checkbox Thanks Robert
1 1260
by  Robert SpurrJump to last post
05/07/2010 10:06 AM
2 Replies and 1192 Views Javacript to Browse For a File  1192  2 Started by  Terry P This may seem a little complicated, so bear with me. I have developed a custom form based on RQ10.1 that prompts for a filename. It then creates a URL for a Header URL attachment. When they click a button, it adds the attachment for the requisition without having to go thru the 3-4 clicks normally. Everything works good. Problem is when the user scans a document in, it goes to the specific folder on the server, but does not tell the user the 'name' of the file it assigned. So what I would ...
2 1192
by  Terry PJump to last post
04/27/2010 11:07 AM
4 Replies and 1288 Views Percent Sign in a user description for GL40  1288  4 Started by  Ken Carley How do I pass the percent sign() in the description field to GL40.1&160; I will still be working on it but I don't seem to find it here yet. Here is the relavant section of the call: &GLT-DESCRIPTIONr0=Precert team 25 reclass Thanks for your help. &160; Ken
4 1288
by  Ragu RaghavanJump to last post
04/23/2010 12:24 PM
2 Replies and 1219 Views Display Fields on  1219  2 Started by  TommyT I am consolidating several tabs into one, and I am having a problem getting design studio to allow me to set a data source for some of the display only fields - the ones that appear after you clicked on a dropdown and made a selection. For example I've moved the worker's compensation class dropdown to a different tab on hr06, but now I cant create a text box with the field WCC-DESC because the field isnt available. Any Ideas TIA
2 1219
by  TommyTJump to last post
04/15/2010 8:21 AM
0 Replies and 1737 Views Inquire twice issue- AP10.1  1737  0 Started by  brihyn I added a fairly simple script to AP10.1 that upon hitting inquire, using an 'Form_OnAfterTransaction', looks at the User Fields tab, and if there's data on the first User Fields field, adds an asterisk to a field on the Main tab. This thing works great when I log on. I go to ap10, look at a vendor record with data on the user fields, inquire, i get the *. I go to a different vendor record that doesn't have user field data, inquire, * goes away. I've also tried browsing to a couple random scre...
0 1737
04/09/2010 9:06 AM
1 Replies and 1547 Views by-pass pr13.3 from HR11  1547  1 Started by  Teresa I&160;have a Design Studio HR11 form. I would like to by-pass the PR13.3 screen I&160;get when I&160;select add. How do I&160;do this
1 1547
by  KK - InforJump to last post
03/31/2010 1:38 PM
2 Replies and 1648 Views Using DoFunction with OnBeforeTransaction  1648  2 Started by  Nick I have a customized PA49 form with 2 new text fields (not tied to the database) that I am trying to concatenate into&160;one field tied to the database.&160; I am using an OnBeforeTransaction to get the values and then write to the&160;standard field.&160; That part is working fine.&160; However, I am having trouble getting a lawformDoFunction call to then perform the original transaction that the user requested.&160; I am getting a result where either the user has to&160;click the Add/Ch...
2 1648
by  NickJump to last post
03/10/2010 4:31 AM
4 Replies and 1331 Views Portal Page checkboxes  1331  4 Started by  Deleted User ConsultDavidW, On your April 18th 2008 blog entry regarding Checkbox on portal included the code to select all the checkboxes, could you also include the code that would detect which checkbox row was selected and how to obtain the row info to start a new process based on what was selected
4 1331
by  Deleted UserJump to last post
03/04/2010 1:08 PM
5 Replies and 1564 Views Checkbox value is always on  1564  5 Started by  Deleted User I have a Design Studio UI form created to kick off a New User request process.&160; On the form I have several checkboxes for Network Access, Blackberry, etc...&160; When I try to read the value of those checkboxes, it's always 'on' regardless of whether the box is checked or not.&160; I've tried various methods (lawForm.getFormElement('chkbb').value) but no matter what I try the value is either 'on' or null.&160; I'm sure there's a simple solution, but I haven't found it.&160; Anyone have ...
5 1564
by  Deleted UserJump to last post
03/03/2010 10:27 AM
2 Replies and 1404 Views Securing Design Studio Changes.  1404  2 Started by  Jay2 We have made changes to AR24.1 We have changed one of the options under LINE-FC and we also added a submit button. These changed are not reflected in the Lawson Security Administrator when trying to secure this form. Is there a step missing that will allow us to see these additions to the form when creating rules in a new security class
2 1404
by  Jay2Jump to last post
03/03/2010 7:58 AM
1 Replies and 1499 Views design studio TEXT_OnFocus not work on line function code  1499  1 Started by  BeckyC I am in MA43.1, I would like to know the line number when the user click on any text on the line. I was able to use the following code to find out the line number on any text field, except the line function code.&160; When the user clicks on function code, it does not show the alert statement.&160; Is there any way to figure that out function TEXT_OnFocus(id, row) { &160; var vCurrentLineNbr3 =lawForm.getDataValue('MAD-LINE-NBR',formState.currentRow); &160; alert ('onfocus = ' vCurr...
1 1499
by  David WilliamsJump to last post
03/01/2010 3:36 PM
1 Replies and 1128 Views Checking For Comments  1128  1 Started by  Terry P Client has requested a Process Flow be triggered&160;when a specific type of Comment is entered on PO30 (Receiving). How to trigger the flow is not the problem. The problem is how do I know they have pushed the comment button and written out an attachment. Is there an event I could check, or am I going to have to go out and see if one has been written out for todays date Anyone done anything like this
1 1128
by  David WilliamsJump to last post
02/22/2010 1:53 PM
4 Replies and 2521 Views Accessing Inbasket Variables  2521  4 Started by  Vito Amatulli I&160;am faily new to Design Studio and I&160;am trying to figure out how to access Inbasket variables.&160; I&160;put the portal in debuig mode and was able to determinre the variables that are being returned. I&160;have attached the XML&160;that is returned. I&160;can access all variables under the WUVARIABLE&160;tag by using the page.paramters method. I am trying to access the wun=19580 variable in the WORKDETAIL or the the WORrKUNIT&160;variable in the FOLDRADDURL&160;tag. A...
4 2521
by  Steven GrayJump to last post
02/17/2010 9:25 AM
1 Replies and 1210 Views Lawson host variable  1210  1 Started by  Mark A I have a Crystal report with drill around links.&160; The links contain a hard coded string with the Lawson web server included.&160; I'd like to get the host in Design Studio and pass it as a variable so I can publish the report on either test or production server and have the drill to the correct server. How do I get the host variable from within Design Studio
1 1210
by  John HenleyJump to last post
02/09/2010 3:56 PM
2 Replies and 1482 Views AP20.1 (modified) works on dev server but not prod server  1482  2 Started by  Deleted User Not sure if this is the right forum but we're upgrading to Lawson 9 and I&160;have an AP20.1 form that tests fine on the dev server. When we copy to production server, and Rebuild Forms Index, it doesn't work. When you enter your invoice and line item detail and click Add, it clears out some fields and gives an error message at the bottom 'Account information required' I've searched Lawson's KB and can't find this specific issue. Any thoughts/suggestions would be greatly appreciated!
2 1482
by  Deleted UserJump to last post
02/03/2010 11:57 AM
9 Replies and 3358 Views Hide and unhide button objects  3358  9 Started by  Deborah Creek I am working on version and a change to the look and feel of buttons from previous versions if causing a problem for me.&160; I would like to use javascript code to hide and unhide buttons.&160; In previous versions I was able to use setFormValue to change the button text to either be blank (hide) or contain writing (unhide) as needed and since the button was displayed as a link this made the object disappear.&160; Now that the button displays regardless of the text I need a way to tr...
9 3358
by  Steven GrayJump to last post
02/03/2010 8:46 AM
5 Replies and 1377 Views Conditional DS Code Based On The Return MSG Of A Chg Function  1377  5 Started by  LCM A little background is that I am attempting to build a custom page with DS to be used to certify effort that combines the functionality of a couple of GM screens.&160; I have gotten every piece of this project to work when the various functions are segregated out to their own action buttons but I am running in to trouble when I attempt to combine the various pieces in to one button (and add some conditional logic).&160; The problem is timing related.&160; Essentially functions that are called...
5 1377
by  wilcoxmadJump to last post
01/29/2010 1:14 PM
13 Replies and 3118 Views JavaScript Substring  3118  13 Started by  Nabil Can someone help me use JavaScript and the Substring function to show only the last 4 digits of the SSN in my form Thank you
13 3118
by  NabilJump to last post
01/22/2010 5:18 PM
8 Replies and 1829 Views RQ10 on Add script  1829  8 Started by  Queue Without using Process Flow, is there a way to execute some sort of script that when a user adds a record on RQ10, that I could take the form Req Number generated by the add, and then populate&160;that&160;value&160;into PO User Field&160;5 and then execute a change request to save the update&160; I know I can use lawForm.getDataValue('RQH-REQ-NUMBER'); and I'm fairly certain I can figure out how to set the RQH-PO-USER-FLD-5 (whatever the command is) to that value. Just not sure how to e...
8 1829
by  John HenleyJump to last post
01/20/2010 8:38 AM
7 Replies and 1642 Views Design Studio upgrade 3 to 9/javascript errors  1642  7 Started by  Deleted User We are upgrading to Design Studio 9 and I'm trying to alter the Design Studio customizations we had on AP20.1. I have downloaded the latest documentation from Lawson but didn't find a definitive list of Javascript changes. I'm putting one piece of Javascript into the form at a time and get an error on each piece. Here's where I'm starting so that pay vendor doesn't default to the prior invoice's pay vendor: function FORM_OnBeforeTransaction(fc) { &160;if (fc=='A') &160;{ &160;&160; var ...
7 1642
by  Deleted UserJump to last post
01/19/2010 2:42 PM
10 Replies and 5112 Views AGS Call: Bypass / Ignore Warning  5112  10 Started by  Tony2 Hi All: Searched for quite some time with no luck, so I&160;figured I would ask. Posting an AGS call and encountering a soft warning:&160;Message=Warning-Date Invalid; OK&160;to continue Executing this via the Lawson forms, we click OK and voila, the transaction submits. Has anyone encountered this and worked around it through some bypass warning parameter with the AGS parameters ON a side note, is there a listing of all possible AGS parameters somewhere&160;I&160;could not find that...
10 5112
by  TracyOJump to last post
01/18/2010 2:53 PM
8 Replies and 1552 Views Can this be done?  1552  8 Started by  Nabil Hi, I'm quiet new to Design Studio developing. I wanted to ask a question before I waiste too much time trying to create a Portal Page that will not serve its role... Basically, I'm trying to figure out if Portal Page Designer could create a query, where users can enter a portion of the employees name or number and hit a 'Search' button to display some basic employee information, like FULL-NAME, COMPANY, and FICA-NBR. Could this be done in Portal Designer, using a search box, not clicking on ...
8 1552
by  John HenleyJump to last post
01/13/2010 3:49 PM
3 Replies and 1353 Views DS communicating with a Web Service?  1353  3 Started by  Deborah Creek Is it possible to call a web service from javascript within a Design Studio form&160; We would like to add validation to data entry on a Design Studio form by utilizing a web service.
3 1353
by  Deborah CreekJump to last post
01/07/2010 2:08 PM
3 Replies and 1368 Views radio box in portal page designer  1368  3 Started by  khart I have been unable to place a radio box in portal page designer but in user interface designer I can drop it onto the page using the UI&160;Toolbox and define the choices.&160; Does anyone know how to put a radio box in portal page designer
3 1368
by  khartJump to last post
01/06/2010 4:14 PM
3 Replies and 1500 Views Change size of DS paint palette??  1500  3 Started by  Tim Cochrane Anybody know how, or if, the size of the DS&160;palette screen&160;can be&160;increased&160; Since a COBOL screen is limited to 80 characters, you have the same limitation &160;whether doing 'quick paint' or 'blank palette'.&160; I've tried changing the width parameter in the first line '<form> TOKEN=...' but that didn't work.&160; I'm trying to paint a screen that will be 100 characters wide. Any info would be appreciated
3 1500
by  wilcoxmadJump to last post
01/04/2010 10:18 AM
3 Replies and 1666 Views Send data to another server  1666  3 Started by  wilcoxmad &160; function callMEMB() { &160;&160;&160;&160; var s = 'http://myserver:80/gscmembership/hr/lawson.svc/update' &160;&160;&160;&160; s = 'ClockId=' lawForm.getFormValue('text2'); &160;&160;&160;&160; s = 'Division=' lawForm.getFormValue('text168'); &160;&160;&160;&160; s = 'Department=' lawForm.getFormValue('text169'); &160;&160;&160;&160; s = 'HireDate=' lawForm.getFormValue('text186'); &160;&160;&160;&160; s = 'LastName=' lawForm.getFo...
3 1666
by  RobertJump to last post
12/10/2009 10:28 AM
6 Replies and 1728 Views Design Studio & PA52  1728  6 Started by  mjpeterson I'm new to Design Studio, so please bear with me. Currently, we use Manager Self-Service as a view only application. However, we want to implement the MSS personnel actions as soon as possible. My plan is to start with the termination personnel action. Unfortunately, the delivered functionality of MSS does not meet our needs, so to make a long story short I need to create a termination screen. My plan is to use Design Studio and build it off of the PA52 screen, which I have already started. My q...
6 1728
by  RobertJump to last post
12/09/2009 9:15 AM
7 Replies and 2074 Views Updating Attributes in LSF9 in Design Studio  2074  7 Started by  Aida We are upgrading to LSF9 environment with 8.03 apps and are in the process of converting flows and design studio forms.&160; We have added a field to the rq04 that is used to identify specific requesters and tha we&160;do an ags call to update&160;the attribute in the rd30 record for that user.&160; Since LX90 does not exist anylonger in 9 how would we update that users record
7 2074
by  AidaJump to last post
11/30/2009 9:34 AM
3 Replies and 1990 Views Process Flow Design Studio Inbasket  1990  3 Started by  vc727 I am not sure if I should post this here or in the proces flow section. I have several flows that route Job Requisitions to different levels of management for approval. The inbasket for these processes is a design studio portal page. These flows have been running for years. We upgraded to 9.0 this past year and I rebuilt the inbasket pages at that time but all seemed to be working fine. Now I am hearing from 2 of my users that whe they open the inbasket item the only information that populates i...
3 1990
by  Jimmy ChiuJump to last post
11/27/2009 12:51 PM
1 Replies and 1381 Views Update hidden field  1381  1 Started by  Bob Clark I am trying to update a hidden field in Design studio.&160; I am new to Design Studio so please forgive.&160; The hidden field needs to be updated when the select12 is 'S'.&160; How would I do this function FORM_OnBeforeTransaction() { &160;&160;&160;&160; var vList = lawForm.getFormValue('select12'); &160;&160;&160; if (vList == 'S'); //&160;&160;&160;&160;&160;&160;&160;&160; UPDATE hidden56 = y; &160;&160;&160;&160;&160;&160;&160;&160;&160;&160; return ...
1 1381
by  Bob ClarkJump to last post
11/23/2009 11:41 AM
1 Replies and 1257 Views Food for thought  1257  1 Started by  Terry P Let me start out by saying I am not (any longer) a COBOL or RPG programmer. I don't have access to the code to make changes. I think however I've gotton pretty good at using Design Studio's scripting feature to make pretty extensive changes to a form (knowing all to well the risk you take) After a recent project where I was able to extensively modify a form that was designed for one purpose, and used for another, it got me to thinking - If a generic form was written that ONLY did read/write bet...
1 1257
by  David WilliamsJump to last post
11/17/2009 7:44 AM
9 Replies and 1946 Views Number of rows in Detail Area (AP20.1)  1946  9 Started by  Tom Sinkula Can I alter the number of rows in the Detail Area of a screen, e.g. AP20.1&160; It currently is set to 5.
9 1946
by  Tom SinkulaJump to last post
11/16/2009 4:23 PM
10 Replies and 2830 Views Any ideas?  2830  10 Started by  wilcoxmad I have a form that allows the users to select an applicant with a push button. The form then sends the user to an HR11 clone with the company and SSN. The default form for the GH11 looks for an inquire function with out an employee number. It then does an applicant lookup by ssn. The problem is that the passed data is not getting to the second form. When I do an alert on the SSN for the second form, it is blank. Here is the code from the two forms. &160; &160; FORM&160;&160; 1 &160;---...
10 2830
by  wilcoxmadJump to last post
11/12/2009 1:23 PM
4 Replies and 1615 Views Non Lawson system Code  1615  4 Started by  JavaCafe Hi All; This question has been asked in the past but there's no answer so I create this topic again and hopefully someone will have an answer for me &160;I try to create some custom forms in DS based on some Non-Lawson tables. I've created new system code, defined db files; rebuild dic and run dbreorg. Everything&160;seems OK.&160;In DS, I can see the new system&160;code and new file in Data&160;Query; however i&160;don't see the form ID from that system code if&160;use&160;Formlet or ...
4 1615
by  JavaCafeJump to last post
11/11/2009 12:37 PM
5 Replies and 1621 Views Error not displayed after AGS call  1621  5 Started by  Joe O'Toole We have a custom form that is calling out to a modified version of HR11. When a BSI tax factory error is detected a message should be displayed indicating that tax errors exist and the user can click off to continue. At some point either through upgrading to LSF 9, upgrading to BSI or modifying the custom DS form, the error has stopped being displayed. The code to check for errors after the AGS call is as follows. Any ideas on where to start with&160;debugging where this is broken AGS CALL OC...
5 1621
by  John HenleyJump to last post
11/11/2009 12:28 PM
2 Replies and 1635 Views Images for Design Studio  1635  2 Started by  Woozy I'm trying to use some custom jpg images in design studio, but all I'm getting is the blasted red-x-of-death.&160; I&160;have been able to use other jpg images that I've found elsewhere (i.e. google-logo.jpg) and they work fine. Is there something I'm missing&160;&160;Is there a resolution or size limit on these files I'm pulling my hair out over this one.&160; Thanks!
2 1635
by  WoozyJump to last post
11/11/2009 6:48 AM
4 Replies and 1196 Views StringIndexOutOfBoundsException: 00000000  1196  4 Started by  Goober This one I've Looked at over and over and can't figure it out.&160; It tests fine via HTTP URL but when I attempt to run it by clicking the button it flakes on me and I get the StringIndexOutOfBoundsException: 00000000.&160;&160; The code is straight forward. I'm doing an AGS call to a process flow trigger via WFWK.1.&160; It begins to exicute&160; but then crashes. function BUTTON_OnClick(id, row) { &160;&160;&160;&160;&160;&160;&160; if (id == “push5”) &160;&160;&160;&160;&...
4 1196
by  GooberJump to last post
11/03/2009 10:11 AM
2 Replies and 1270 Views AP20 AGS Query dropping line items higher than 5  1270  2 Started by  thegris I'm programmatically building a query to submit an AP20 invoice to Lawson's URL&160;interface.&160; It dynamically generates the query and puts in however many line items are associated with the invoice. When I&160;look up the invoice using the AP20 screen, only the first five line items are retained.&160; I&160;also get an error message returned from the query that says 'Distributions out of balance', which makes sense if it is dropping additional line items. Is there a way to increase t...
2 1270
by  thegrisJump to last post
10/26/2009 10:59 AM
6 Replies and 1769 Views Send a partially filled out DS form from another  1769  6 Started by  wilcoxmad I want to allow a user to select a record from a list on a Design Studio form. Then I'll send them all the related data from the record they selected, after pulling the data from a custom table in the DB, to another DS form. They can use that data, along with more that they enter, to do an add on the second form. In this case I want to show them a partially filled out form that is a single page , no tabs, version of HR11. So I want to send them a form created in Desing Studio, with the data ...
6 1769
by  David WilliamsJump to last post
10/19/2009 1:01 PM
2 Replies and 1119 Views Implementing portal page as a self-service module/component  1119  2 Started by  Teresa I want to Implement a design studio portal page to display emergency contacts for a group of as a self-service module. Ihave success with using the user variable on the Index. But I have had no success doing this in the the query criteria. It seems to ignore the entry. For instance I want to check an RM attribute of the logged in user against the value in the employee record so that the person inquiring only see the people assgined to him. I picked the field from the dropdown list of th...
2 1119
by  TeresaJump to last post
10/16/2009 8:45 AM
4 Replies and 1412 Views Maximize window in Page Designer  1412  4 Started by  Mark A I'm creating a page using Portal Page Designer with only one window and would like to automatically maximize the window on screen for the user.&160; I can set the width and height but would rather have it fit to the screen.&160; I'm sure you can script it, but not sure how. -Mark
4 1412
by  Mark AJump to last post
10/14/2009 8:38 AM
1 Replies and 1341 Views Updating Attributes in LSF9 using Design Studio  1341  1 Started by  Aida I could not update this topic.&160; Kept getting&160; the following error:&160; Exception has been thrown by the target of an invocation so I had to start a new topic.&160; Joe O'Toole below is the answer to the question you asked. Our RQ04 is a design studio screen that we’ve added a flag to that can be flipped to identify a requester as an overnight requester.&160;That field updates the rd30 attribute...which is used in the req approval flow.&160;We are looking t...
1 1341
by  Judy ConsoliJump to last post
10/13/2009 9:28 AM
8 Replies and 2855 Views validating field for each row in the details section of a form  2855  8 Started by  mjcindc Hi All, I'm working on and customizaton to PO39.1. I need to iterate through all rows in the details section and check to see if the 'FC' value is 'A' or 'C'.&160; If it is, I want to make sure there is something in the 'sublot' field.&160; With what I've written, it only checks the 'sublot' field on the first row even if the add or change is on another row.&160; As long as the 'sublot' field is populated in row one it accepts the change.&160; This is what I've got so far.&160; It's clear ...
8 2855
by  John HenleyJump to last post
10/03/2009 6:08 PM
3 Replies and 1925 Views Additional Detail Lines possible in AR30.1 or AR33.1?  1925  3 Started by  michael2 Our AR departments find it very difficult to deal with only 11 detail lines in AR30 (and only 8 in AR33).&160; Is there any way, short of COBOL, to have more than that number of lines display and allow interaction when inquiring A little help please...
3 1925
by  John HenleyJump to last post
10/03/2009 6:08 PM
1 Replies and 1917 Views AGS Syntax is AddChange supported?  1917  1 Started by  Joe O'Toole I can't seem to remember what manual the AGS syntax summary is in - does anyone know Specifically what I'm tring to do is run an ADD/UPDATE from the AGS call to a custom program that was originally built off of HR11. The&160;code&160;within the call contains&160;&160;_EVT=ADD&FC=AC. I swear the FC=AC was working a few days ago but the update part isn't working today. There is a portal content related XML file error in IOS.log, but I don't think this is related&160;to my problem&160;an...
1 1917
by  RandallJump to last post
09/29/2009 3:09 PM
5 Replies and 1912 Views Invoking a function from radio button state change  1912  5 Started by  Joe O'Toole I've tried&160;adding the onclick or onchange options to the radio button FLD definition - IE:&160;onclick='test_function()', but it&160;seems to have no effect. has anyone done this or is there a better way Thanks.
5 1912
by  Joe O'TooleJump to last post
09/22/2009 10:57 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 5 << < 12345 > >>

RSS Feed Available