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 3 << < 123
 Last Post
7 Replies and 3778 Views MS Add-ins version level with LSF9 env/8.03 aps  3778  7 Started by  Deleted User We are upgrading to LSF9, but remaining on 8.03 applications until next year.&160; We are currently on MS Add ins v2.0.5.0.&160; Lawson has indicated that we can upgrade to v9.0.3.1.&160;&160;My understanding is that this version was released in 2006.&160; Is anyone&160;with this configuration&160;using a different version&160;of MS Add-ins&160; Thanks&160;
7 3778
by  Michael BarronJump to last post
5/1/2009 5:08 PM
3 Replies and 3934 Views Field size limitation in query???  3934  3 Started by  Sherry Shimek &160; Does MS&160;Addins and or Excel&160;have a size limit to the amounts to be extracted in a query&160; We have a number we have queried from a table that appears to have lost the last two digits of a $3trillion gl amount.
3 3934
by  Sherry ShimekJump to last post
4/27/2009 2:56 PM
6 Replies and 8080 Views BN32 - hidden key...  8080  6 Started by  Shane Jones Anyone have the structure for BN32 Add-ins.&160;&160; I thought I had it but it is not working....&160;&160; I think I need help with the Hidden Key.... Any ideas
6 8080
by  BrendaHJump to last post
4/17/2009 6:03 PM
0 Replies and 4230 Views Issue with Add-Ins for AP20.7, does not add first record  4230  0 Started by  desichet Most of our Invoice have one line distribution.We are building AGS call to add records to AP20.7&160; to&160; occur few days&160; after Invoice header was created and Invoice is approved.&160; Running into issue with adding one record to AP20.7 OR AP20.2 (distribution). First record does not get added through AGS call OR Add-In. Return message -Message>No More Records For Given Key. Once we enter first one using portal screen, same AGS call and MS-AddIn can add more records as needed.&16...
0 4230
3/27/2009 9:05 PM
2 Replies and 3895 Views Creating a report from MS Access  3895  2 Started by  Deleted User Hi I am new to using Lawson and have not been trained on the software. I am used to using Peoplesoft. I have access to the back tables to run queries in MS Access. That ebing said,&160; I was told by Lawson support that there is not a report that will produce this report.&160; The report need to include a breakdown of the unemployment report breaking it down by worksite location which is the location code located on the HR11 Assignment tab. The report need to reflect by company, by lo...
2 3895
by  Phil SimonJump to last post
3/17/2009 2:52 PM
2 Replies and 4080 Views Product Lines Disappearing  4080  2 Started by  JonA Anyone else experiencing this&160; Occasionally, when I use the Upload Wizard, my product lines are not showing.&160; I have to re-install addins for them to appear again.&160; I'm not having any issues with the query wizard. Lawson S3 Add-Ins version; MS Excel 2003 version 11.6560.6568 (SP2); Windows XP Pro version 2002 SP2
2 4080
by  JonAJump to last post
3/17/2009 8:21 AM
3 Replies and 8669 Views PO20.1 Add-In - Release PO  8669  3 Started by  Ken Ptak I'm attempting to create an Add-In for the PO20.1 that will perform a 'Release' from the 'Action' menu. I&160;have three fields mapped (Company, PO Number, and Save&160;FC) on the attached spreadsheet and .uwf.&160; When I&160;run the Add-In the result is 'Change Complete -&160;Continue'.&160; However, if I&160;inquire on that&160;PO on PO20, the Revision still states 'Unreleased'. We're on Apps 8.1, LSF9, Add-Ins Any ideas/thoughts/suggestions would be greatly appreciated. ...
3 8669
by  John HenleyJump to last post
3/4/2009 4:43 PM
5 Replies and 5924 Views Lawson Advanced Add-ins query document - only available from CUE  5924  5 Started by  jeremy.zerr Just had a Lawson support person help me out with debugging some edits on a PA55 upload, they sent me a document that is only available to Advanced Add-ins class attendees at CUE. Figured I would share it.&160; Its attached to this post. Has a really great section on how to debug edits from uploads. That was the info I have been looking for quite a while, and I'm totally excited to finally have something to be able to help myself. Jeremy Running shoes website
5 5924
by  SrinivasJump to last post
2/16/2009 9:22 AM
3 Replies and 6940 Views AP Invoice Comments  6940  3 Started by  Meghan I am trying to set up a query that will pull down AP invoice information including any comments attached to the invoice.&160; Since invoices are included as an attachment, is there any way to include them in the query
3 6940
by  John HenleyJump to last post
1/30/2009 10:56 PM
6 Replies and 5078 Views GLTRANS query returns no results  5078  6 Started by  Sherry Shimek We recently created a new data level security class expanding the data accessible to a current security class., but still not allowing full data access.&160; Lawson data level security class testing passed with no exceptions.&160; However, due to the intense MS Addins query usage of the users in the two classes we decided to test MS Addins queries. They primarily run queries on GLTRANS. Queries worked fine in the test environment except for queries of the GLTRANS table.&160; Queries of...
6 5078
by  k-rockJump to last post
1/28/2009 8:10 PM
2 Replies and 3356 Views Product line access  3356  2 Started by  GailC I have a user with a RM setup identical to my test user. The user can only see 1 of our 2 product lines in the addin. Any idea why
2 3356
by  John HenleyJump to last post
1/14/2009 6:08 PM
1 Replies and 3958 Views addins template for hr04.7 value listing?  3958  1 Started by  Deleted User Can anyone share the secret to doing an upload for HR codes, but the actual values list (hr04.7). We have a new hr code with a bunch of values and would hate to manually input. I think that there are hidden fields involved. Any help is appreciated. &160; &160;
1 3958
by  John HenleyJump to last post
1/6/2009 7:20 PM
0 Replies and 4454 Views Deleting a GL Budget via Excel Add-Ins  4454  0 Started by  John Henley I recently was asked if you could use the Add-Ins to delete records, particularly in the GL 'Flex Budgeting' module. The answer, of course, is yes! The ability to delete records on forms was added to the Upload Wizard some time ago, and you can use it with just about any form to which you can map for adding and/or changing. And since you're just changing the way you interact with Lawson (in other words, you're using Excel as a 'front-end' instead of LID or Portal), you're still making use of ...
0 4454
12/27/2008 10:35 AM
2 Replies and 4327 Views AM20 security error  4327  2 Started by  GailC We are new to Lawson using the new LS security. I have security working for all addins except AM20. When my user runs it with here SuperAdmin security, it fails. When she uses Lawson (CheckLS = 'N') it works. The only thing I can find in the logging is that 'It can't execute script ModLocalAdmin.bat'. This is from the xls log. Any ideas were I can look
2 4327
by  GailCJump to last post
12/19/2008 6:55 PM
0 Replies and 3232 Views MS Addins and Environment Form Ids  3232  0 Started by  des123 I am&160;in the planning stages for installing MS Addins and setting up LAUA security accordingly. According to the 'Lawson Administration: LAUA Security', page 25, step 5, the security class for the users who will use the Addins must not include access to environment forms. Why is it necessary to&160;NOT include access to environment forms for Addins users
0 3232
12/10/2008 5:30 PM
10 Replies and 7836 Views Add-Ins Query - Unattended  7836  10 Started by  William Saltmarsh Is there a functionality/mechanism that will allow an Add-Ins query to run completely unattended, that is, with no operator intervention for entering login credentials and deleting duplicate output files
10 7836
by  MARCO3535Jump to last post
12/10/2008 5:08 PM
11 Replies and 24951 Views Automating Excel Add-In JE Import with VB  24951  11 Started by  Deleted User Our company is trying to automate journal entry and AP uploads to Lawson using the add-in wizard. We would like to use macros and visual basic but have not found any documentation on how to call the Lawson add-in object. Can someone point us in the right direction
11 24951
by  joel_fJump to last post
12/5/2008 3:18 PM
1 Replies and 4341 Views New feature to insert a column in Excel Upload Wizard  4341  1 Started by  John Henley For years, one of the Lawson tips I’ve been sharing with users has been how to add a new column to an upload mapping you’d previously saved. This is often needed when you add a new column to a spreadsheet and include it in your upload. Read New feature to insert a column in Excel Upload Wizard.
1 4341
by  Joseph Van DenburgJump to last post
12/1/2008 12:44 PM
2 Replies and 4270 Views How to Stop Addins Query  4270  2 Started by  cmarcous Query We are using Addins V2.0.3.0 with Apps 8.03&160; Is there a more efficient way of stoping the query once it is started.&160; Like for example in Access Ctrl Break will stop the query after the run command anywhere from the start to the x minutes its time to kill this now moment Upload Same question for uploads, sometimes the 1st 100 rows go fine and then there is a repeated error on everyline like 'account does not exist' and options are go for lunch or close the wizard or excel. ...
2 4270
by  michael2Jump to last post
11/4/2008 8:39 PM
2 Replies and 5578 Views Uploading Assets-AM20  5578  2 Started by  itsjustme We have a need to upload about 700 assets. The upload for AM20.1 only allows 8 at a time and each different&160;asset data is in another column of one row rather than a row for each asset data. Does anyone know of a way to upload this information more efficiently Thanks Dave
2 5578
by  itsjustmeJump to last post
8/8/2008 6:54 PM
2 Replies and 5725 Views PR13.1  5725  2 Started by  Deleted User When attempting to load to the PR13.1 screen through Lawson add-ins, I&160;am receiving the message 'Addtional pages exist - use page down' &160; Has anyone encountered and resolved this
2 5725
by  sjacobsJump to last post
8/1/2008 6:11 PM
1 Replies and 7743 Views Upload secondary position pay rates in PA52.5  7743  1 Started by  jeremy.zerr Uploading to the PA52.5 has posed quite a few problems for me.&160; It took a lot of work just to get any upload to work, then it took 4 months of Lawson Support help to get the 'Warning pay rate out of range' error to go away. Here is how to upload pay rate changes to secondary positions using PA52.5 just as easily as we can do primary changes with PA52.1.&160; Pay rate is usually a great example because of the soft edits to override. Here is how I was able to upload to the form.&160; Init...
1 7743
by  John HenleyJump to last post
7/15/2008 6:33 PM
2 Replies and 4696 Views ADDins-Microsoft 2007  4696  2 Started by  Deleted User I need to add Upload Wizard to my Microsoft ADDInx for lawson.&160; I have access to Query Wizard , etc.. but I need this one.&160;How do I do that..
2 4696
by  John HenleyJump to last post
6/24/2008 12:43 AM
4 Replies and 6802 Views monitoring addins use  6802  4 Started by  Matt Sherwood Does anyone know how to monitor addins use on 8.1 apps 9.0.4 environment&160; Trying to troubleshoot a problem and we think it may be caused by heavy addins use during month end close.&160; Right now the only thought we have is to use the webserver access logs.&160;
4 6802
by  itsjustmeJump to last post
5/8/2008 11:05 AM
1 Replies and 4796 Views HS03 Addin  4796  1 Started by  Jodi Kruesel Has anyone been sucessful in creating an HS03 addin&160; So far, I have not been able to get in to work.&160; If you have, would you be willing to share a sample of your addin
1 4796
by  Jodi KrueselJump to last post
4/23/2008 6:26 PM
2 Replies and 5607 Views AP20.1  5607  2 Started by  Deleted User We are experiencing a problem uploading data to the AP20.1 basic invoice form in that if the AP company is different than the Distribution company the upload won't recognize the Accounting Unit and Account combination.&160; We've created a work around to upload the basic header information out of balance with an add only upload and then add the distribution information with a change only upload but it seems like the functionality should exist to upload all at once.&160; Has anyone else experie...
2 5607
by  Deleted UserJump to last post
4/9/2008 12:35 PM
4 Replies and 5534 Views Uploading to PO20.1  5534  4 Started by  Roxianne I am having an issue upload to po20.1.&160; I get my columns all mapped, but when I upload using Add then Change option it only does the header info and the first item line.&160; Can someone please!!!!&160; tell me how to fix this or what I am doing or not doing.&160; thanks
4 5534
by  RoxianneJump to last post
3/17/2008 10:29 PM
7 Replies and 5367 Views Max Records Loaded into HR55.2  5367  7 Started by  kadkins What is the maximum number of records you can load into an Employee Group using Add-Ins&160; Just curious as I've heard conflicting answers from various sources.
7 5367
by  John HenleyJump to last post
2/29/2008 1:33 PM
1 5013
by  John HenleyJump to last post
2/22/2008 10:06 PM
7 Replies and 6035 Views Error to HR11 User Fields  6035  7 Started by  Deleted User See attached date errors I receive with the UWF for HR11 user fields... I have tried several date formats (MMDDYY, YYYYMMDD, YYMMDD, etc) and still get this error. See attached...HELP!
7 6035
by  John HenleyJump to last post
2/22/2008 1:37 PM
2 Replies and 5724 Views PO20 Add-In Help  5724  2 Started by  Ken Ptak The manual action that is taken is enter the company and PO , and inquire. Then click 'Actions' from the menu bar and then select 'Cancel Remaining'. Then a pop-up window appears asking if it's OK to proceed. I click 'OK' and the bottom of the form shows 'Cancel Remaining Complete-Continue'. I have thousands of POs that I need to perform this on, which is why I'm trying to create an Add-In for the PO20 but am not having much luck. When I have an excel file with Company, PO, and SaveFC c...
2 5724
by  Ken PtakJump to last post
2/6/2008 1:12 PM
1 Replies and 9972 Views pr11 add ins  9972  1 Started by  Deleted User we are trying to add in GTL info and moving expenses for the w2's and cannot figure out the addins for pr11..we get an error 'cannot execute transaction'...I suspect that hidden fields could be the culprit or something else that is tricky. any suggestions would be appreciated.
1 9972
by  Deleted UserJump to last post
1/24/2008 6:42 PM
2 Replies and 15062 Views Is Query wizard useful?  15062  2 Started by  Deleted User Our GL group writes some queries with 'report writer' and states that it is complicated to some extent. They want to run the Addins for some things. I'm not an add-in fan (could not easily figure out how to join tables, etc). I write queries by the SQL language from scratch. Could the GL people utilize the query wizard for queries involving more than one table Is it reliable Is it best for simple queries or is it robust (I know that with the upload wizard, we had issues where it...
2 15062
by  k-rockJump to last post
12/28/2007 6:15 PM
0 Replies and 12530 Views Receipt Uploads  12530  0 Started by  Deleted User Anyone got mapping for PO30/PO33 I know I need a hidden key to pull in the PO lines on PO30 and the receipt lines on PO33. I even figured out the CtrlShiftV -> Required to find the fields. What do you put in them
0 12530
12/28/2007 4:55 PM
1 Replies and 13135 Views PA16... Hidden Key  13135  1 Started by  Shane Jones Help.... Lawson has an issue with the ADD button on PA16. I am sure that they will disagree but we had someone entering data and they entered a line of data and clicked ADD instead of CHANGE.... This duplicated property for the associate. Now I have associates with the same property listed as much as 10 times. I wanted to disable the ADD button for the user but they need it to enter the first record for an associate. Now I have over 75 pages of duplicate records and I ...
1 13135
by  Joseph Van DenburgJump to last post
12/12/2007 12:34 PM
3 Replies and 14191 Views PA31 Subform HR15.1 (User Fields)  14191  3 Started by  Rebecca Rivera I'm in the process of writing an Add-In (Upload)that will write to PA31 but also write to the custom user fields stored in the associated HR15.1 form. Does anyone know the hidden key that will allow me to do this, or have any suggestions on how to accomplish this Thank you, Rebecca
3 14191
by  John HenleyJump to last post
11/19/2007 7:28 PM
0 Replies and 12066 Views AP16 Change VEN-BANK-ENTITY  12066  0 Started by  Deleted User I am making a AGS call through VB(should be roughly the same as the addins) to try to change bank information in AP16.1. I can change the account number and account type. However when I try to change the VEN-BANK-ENTITY I am getting a must inquire first. I however am doing the inquire first. The AP16.1 form itself says 'Must inquire first' even when I have already inquired but it still saves the data. The ags call, even when I do several inquirers first, does not want to save the data. What...
0 12066
11/2/2007 7:46 PM
1 Replies and 13301 Views IC12.2 Error 105  13301  1 Started by  itsjustme Get the following when trying to use Addins to Query the IC12.2: Error 105 Item Location Does not exist Field _f0 There is no Field _f0 (unless it's hidden somewhere) I get no records returned. When I query using the database table-ITEMSRC it goes fine. Trying to get an upload set to make some mass changes and can't seem to get it to work using the Application Form method. Any help would be appreciated. Thx Dave
1 13301
by  John HenleyJump to last post
10/23/2007 1:45 PM
1 Replies and 16134 Views Query Wizard  16134  1 Started by  Deleted User Unable to extract the data using query wizard.Is this related to access rights or users/groups of the user in anyway Will upgrading LawMSAddins.exe will resolve this issue or is there any alternative for this. Please help me out in this.
1 16134
by  Deleted UserJump to last post
8/21/2007 2:14 PM
5 Replies and 20647 Views Upload Wizard Add-in inquire first?  20647  5 Started by  Seth Is there a way to generate an 'inquire' action from the spreadsheet Scenario: Trying to add lines to an agreement using PO25.6 Results of 'Add first, then change' are I | 12345 (item number) Manually entering information from form returns 'Must inquire before using that function' in portal Used formdef to find 'key' to this form and included it on spreadsheet Thanks for any help.
5 20647
by  SethJump to last post
6/22/2007 2:26 PM
1 Replies and 12321 Views Deleting records using upload wizard in FB module  12321  1 Started by  Deleted User Can you use Lawson Upload Wizard to delete records in the FB budgeting module Thanks for any help you can offer.
1 12321
by  John HenleyJump to last post
6/20/2007 3:03 PM
3 Replies and 12383 Views AddIns launch multiple times on Menu Excel03  12383  3 Started by  Deleted User This is a good one for everyone... We've stumped GSC and they keep pointing to Microsoft but I know they are going to tell me the problem is with Lawson Add-Ins. The problem is after installing AddIns v205 or the v9 in Excel 2003 SP2 in our environment you cannot get the Lawson Query Wiz, Upload Wiz or Dril to display on the menu without a runtime error. If I comment out the line of code in VB that adds Lawson to the menu it produces it to the menu the next time you launch excel. However, ...
3 12383
by  John HenleyJump to last post
3/30/2007 7:46 PM
0 Replies and 14412 Views Excel Query Wizard problem  14412  0 Started by  Deleted User We are seeing every Lawson file listed under each system code when using the Query Wizard. When a file is selected then the wrong fields are displayed in the fields pick list. This is against a Windows Lawson 9.0 new installation. When we use the Query Wizard against the AS400 old installation, it works as it should. Any info is appreciated, Eric Davis
0 14412
11/15/2006 8:50 PM
3 Replies and 17006 Views Lawson Add-in upload/download errors  17006  3 Started by  Deleted User We have a remote IOS set-up with apache 2.0/tomcat 4.1, HPUnix 11.11, lawson env 8.0.3 esp5, oracle 10G (installed at the same box where apache/tomcat reside). Our problem with add in when uploading or running queueries is we constantly received the error 'The server returned an invalid or unrecognized response' then after clicking ok to continue (on uploads) we eventually get the final message “Return “mesg” line was not found. The Server may not be responding”. Has anyone seen this pr...
3 17006
by  John HenleyJump to last post
3/31/2006 8:43 PM
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 3 << < 123

RSS Feed Available