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 2 of 2 << < 12
 Last Post
10 Replies and 5669 Views Add-Ins Query - Unattended  5669  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 5669
by  MARCO3535Jump to last post
12/10/2008 12:08 PM
11 Replies and 21853 Views Automating Excel Add-In JE Import with VB  21853  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 21853
by  joel_fJump to last post
12/05/2008 10:18 AM
1 Replies and 2807 Views New feature to insert a column in Excel Upload Wizard  2807  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 2807
by  Joe Van DenburgJump to last post
12/01/2008 7:44 AM
2 Replies and 3073 Views How to Stop Addins Query  3073  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 3073
by  michael2Jump to last post
11/04/2008 3:39 PM
2 Replies and 4166 Views Uploading Assets-AM20  4166  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 4166
by  itsjustmeJump to last post
08/08/2008 2:54 PM
2 Replies and 4211 Views PR13.1  4211  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 4211
by  sjacobsJump to last post
08/01/2008 2:11 PM
1 Replies and 6110 Views Upload secondary position pay rates in PA52.5  6110  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 6110
by  John HenleyJump to last post
07/15/2008 2:33 PM
2 Replies and 3487 Views ADDins-Microsoft 2007  3487  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 3487
by  John HenleyJump to last post
06/23/2008 8:43 PM
4 Replies and 5248 Views monitoring addins use  5248  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 5248
by  itsjustmeJump to last post
05/08/2008 7:05 AM
1 Replies and 3584 Views HS03 Addin  3584  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 3584
by  Jodi KrueselJump to last post
04/23/2008 2:26 PM
2 Replies and 4337 Views AP20.1  4337  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 4337
by  Deleted UserJump to last post
04/09/2008 8:35 AM
4 Replies and 4155 Views Uploading to PO20.1  4155  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 4155
by  RoxianneJump to last post
03/17/2008 6:29 PM
7 Replies and 3939 Views Max Records Loaded into HR55.2  3939  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 3939
by  John HenleyJump to last post
02/29/2008 8:33 AM
1 3674
by  John HenleyJump to last post
02/22/2008 5:06 PM
7 Replies and 4471 Views Error to HR11 User Fields  4471  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 4471
by  John HenleyJump to last post
02/22/2008 8:37 AM
2 Replies and 4321 Views PO20 Add-In Help  4321  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 4321
by  Ken PtakJump to last post
02/06/2008 8:12 AM
1 Replies and 8750 Views pr11 add ins  8750  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 8750
by  Deleted UserJump to last post
01/24/2008 1:42 PM
2 Replies and 13482 Views Is Query wizard useful?  13482  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 13482
by  k-rockJump to last post
12/28/2007 1:15 PM
0 Replies and 10995 Views Receipt Uploads  10995  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 10995
12/28/2007 11:55 AM
1 Replies and 11771 Views PA16... Hidden Key  11771  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 11771
by  Joe Van DenburgJump to last post
12/12/2007 7:34 AM
3 Replies and 12904 Views PA31 Subform HR15.1 (User Fields)  12904  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 12904
by  John HenleyJump to last post
11/19/2007 2:28 PM
0 Replies and 10637 Views AP16 Change VEN-BANK-ENTITY  10637  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 10637
11/02/2007 3:46 PM
1 Replies and 11647 Views IC12.2 Error 105  11647  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 11647
by  John HenleyJump to last post
10/23/2007 9:45 AM
1 Replies and 13668 Views Query Wizard  13668  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 13668
by  Deleted UserJump to last post
08/21/2007 10:14 AM
5 Replies and 17313 Views Upload Wizard Add-in inquire first?  17313  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 17313
by  SethJump to last post
06/22/2007 10:26 AM
1 Replies and 11102 Views Deleting records using upload wizard in FB module  11102  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 11102
by  John HenleyJump to last post
06/20/2007 11:03 AM
3 Replies and 11321 Views AddIns launch multiple times on Menu Excel03  11321  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 11321
by  John HenleyJump to last post
03/30/2007 3:46 PM
0 Replies and 12744 Views Excel Query Wizard problem  12744  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 12744
11/15/2006 3:50 PM
3 Replies and 14954 Views Lawson Add-in upload/download errors  14954  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 14954
by  John HenleyJump to last post
03/31/2006 3: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 2 of 2 << < 12

RSS Feed Available