Search this forum:
Search
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
Topics
 Replies
 Views
 Last Post
10 Replies and 5515 Views Add-Ins Query - Unattended  5515  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 5515
by  MARCO3535Jump to last post
12/10/2008 12:08 PM
11 Replies and 21439 Views Automating Excel Add-In JE Import with VB  21439  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 21439
by  joel_fJump to last post
12/05/2008 10:18 AM
1 Replies and 2727 Views New feature to insert a column in Excel Upload Wizard  2727  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 2727
by  Joe Van DenburgJump to last post
12/01/2008 7:44 AM
2 Replies and 3000 Views How to Stop Addins Query  3000  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 3000
by  michael2Jump to last post
11/04/2008 3:39 PM
2 Replies and 4055 Views Uploading Assets-AM20  4055  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 4055
by  itsjustmeJump to last post
08/08/2008 2:54 PM
2 Replies and 4130 Views PR13.1  4130  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 4130
by  sjacobsJump to last post
08/01/2008 2:11 PM
1 Replies and 5967 Views Upload secondary position pay rates in PA52.5  5967  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 5967
by  John HenleyJump to last post
07/15/2008 2:33 PM
2 Replies and 3428 Views ADDins-Microsoft 2007  3428  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 3428
by  John HenleyJump to last post
06/23/2008 8:43 PM
4 Replies and 5167 Views monitoring addins use  5167  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 5167
by  itsjustmeJump to last post
05/08/2008 7:05 AM
1 Replies and 3507 Views HS03 Addin  3507  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 3507
by  Jodi KrueselJump to last post
04/23/2008 2:26 PM
2 Replies and 4269 Views AP20.1  4269  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 4269
by  Deleted UserJump to last post
04/09/2008 8:35 AM
4 Replies and 4068 Views Uploading to PO20.1  4068  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 4068
by  RoxianneJump to last post
03/17/2008 6:29 PM
7 Replies and 3855 Views Max Records Loaded into HR55.2  3855  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 3855
by  John HenleyJump to last post
02/29/2008 8:33 AM
1 Replies and 3584 Views PR82 AUTOMATED METHOD?  3584  1 Started by  Deleted User WE HAVE A LOT OF ADJUSTMENTS WHERE WE HAVE TO BACK OUT CHECKS FOR INCORRECT PROCESS LEVEL AND PUT IN CORRECT PROCESS LEVEL. IS THERE AN AUTOMATED WAY OF DOING THIS I WAS HOPING THAT AN ADD IN WOULD BE POSSIBLE W/O HAVING THE NIGHTMARE OF HIDDEN FIELDS, ETC... ANYONE SEEN SUCH A THING &160;
1 3584
by  John HenleyJump to last post
02/22/2008 5:06 PM
7 Replies and 4371 Views Error to HR11 User Fields  4371  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 4371
by  John HenleyJump to last post
02/22/2008 8:37 AM
2 Replies and 4195 Views PO20 Add-In Help  4195  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 4195
by  Ken PtakJump to last post
02/06/2008 8:12 AM
1 Replies and 8602 Views pr11 add ins  8602  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 8602
by  Deleted UserJump to last post
01/24/2008 1:42 PM
2 Replies and 13280 Views Is Query wizard useful?  13280  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 13280
by  k-rockJump to last post
12/28/2007 1:15 PM
0 Replies and 10925 Views Receipt Uploads  10925  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 10925
12/28/2007 11:55 AM
1 Replies and 11692 Views PA16... Hidden Key  11692  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 11692
by  Joe Van DenburgJump to last post
12/12/2007 7:34 AM
3 Replies and 12808 Views PA31 Subform HR15.1 (User Fields)  12808  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 12808
by  John HenleyJump to last post
11/19/2007 2:28 PM
0 Replies and 10551 Views AP16 Change VEN-BANK-ENTITY  10551  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 10551
11/02/2007 3:46 PM
1 Replies and 11555 Views IC12.2 Error 105  11555  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 11555
by  John HenleyJump to last post
10/23/2007 9:45 AM
1 Replies and 13575 Views Query Wizard  13575  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 13575
by  Deleted UserJump to last post
08/21/2007 10:14 AM
5 Replies and 16893 Views Upload Wizard Add-in inquire first?  16893  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 16893
by  SethJump to last post
06/22/2007 10:26 AM
1 Replies and 11038 Views Deleting records using upload wizard in FB module  11038  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 11038
by  John HenleyJump to last post
06/20/2007 11:03 AM
3 Replies and 11256 Views AddIns launch multiple times on Menu Excel03  11256  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 11256
by  John HenleyJump to last post
03/30/2007 3:46 PM
0 Replies and 12652 Views Excel Query Wizard problem  12652  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 7.2.2.7 old installation, it works as it should. Any info is appreciated, Eric Davis
0 12652
11/15/2006 3:50 PM
3 Replies and 14758 Views Lawson Add-in upload/download errors  14758  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 14758
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