Forum: Lawson Add-Ins for Microsoft Office

 77 Subscribed to this forum
Page 5 of 10 << < 34567 > >>


Last Post

Need Help Pulling in UOM pricing in PO28    

Started by  David M
Hello, I need to build an Excel query or application that will pull in all Units of Measure and there pricing for all 'active' items. The direct screen that I know I can find this info for 'manually' is PO28. I can't find a report in Lawson that will do this and I have tried to build the query and applicaton from Excel addins myself and have had no luck. expanded description of problem-- If i pull in the item master data, it only will pull in the base cost which is usually the highest unit of ...
1 18914 0
by  LauraJump to last post
10/17/2013 10:39 AM

S3 Upload Wizard won't always open saved mappings    

Started by  Eric
When I try to open a saved upload mapping, sometimes (7 out of every 8) it doesn't load. Occasionally it does. I can't intentionally recreate it, so I can't be certain under what circumstances the saved upload mapping opens and what circumstances it doesn't. Here's what I expect to see: Here's what I see when it doesn't work: Has anyone experienced anything like this before Can I provide more information to help you help me Lawson AddIns MS Office 2010 Lawson Environ...
3618 0
10/15/2013 6:55 PM

AP16.2 must inquire first    

Started by  Linda3
I'm trying to upload to AP16.2&160; I keep getting a message 'Vendor bank exists must inquire first'.&160; Does anyone have a resolution for this
7 22959 1
by  darwin collinsJump to last post
10/3/2013 7:23 PM

Help..Not getting anywhere with Lawson Support...DME no data    

Started by  Ronnie
We recently had our environment updated from to and suddenly DME queries that we run that have always worked and pulled data are suddenly running and returning a message of the specified query returned no data. This only happened after our update. support has had me update our IOSconfig.xml file with record count number limit, and recycle websphere etc. So far this seems to be when we are doing this on the PRTIME table. Why would we now get no results when we always have in the p...
12 19895 0
by  RonnieJump to last post
9/23/2013 12:11 PM

uploading to HR15.2    

Started by  Ronnie
I have a spreadsheet my HR department has given me that has column A (company number) found in PA02 col B (pos number) found in PA02 col C (effect date) found in PA02 col D (pos desc) found in PA02 col E (add flag) need add in HR15.2 col F (badge title) need add in HR15.2 col G (badge title desc) defined in PA04.5 So the only things i need to do is really use column E and F for the upload, but need the other columns so that the spreadsheet can determine what position gets what badge ti...
6 18871 0
by  Dave CurtisJump to last post
9/19/2013 4:55 PM

MS Addins LAUA security    

Started by  Sherry Shimek
Where does Lawson explain LAUA security for MS Addins  I had understood and proven through over 5 years of security class testing that the access a user has in the Lawson application is the same access the user will have in MS Addins for form functions and data level service. We encountered one instance where MS Addins is not returning all the data that should be allowed and our tech team doesn't understand MS Addins.  They are trying to present the case that be...
1 17379 1
by  John HenleyJump to last post
8/28/2013 4:18 PM

Query string from AddIns?    

Started by  George Graham
Anyone know how to display/extract the query string from an Add Ins query
2 12060 0
by  George GrahamJump to last post
8/14/2013 1:35 PM

Add-Ins Performance Impacted by Upgrade    

Started by  CDCummins
We just upgraded our Lawson systems as follows:  LSF Environment to, Portal to and Applications to   Since that time, however, we have experienced a major slowdown in our add-in uploads.  We do not see these issues in our test environment, however.  I have seen other posts in the forums regarding similar issues, but the tips/resolutions discussed do not work for us.   We run our Lawson system on Windows 2003 R2, and use the ver...
5 11460 0
by  Greg MoellerJump to last post
8/5/2013 2:43 PM

Upload to HR11 User Fields with Excel Add-In    

Started by  John Henley
One of the things I keep hearing about the Lawson Excel Add-In is that you can’t use it to upload to the user fields tab on the HR11 Employee form--particularly to update user fields that are not displayed on the first page (i.e. you have to PageDown to get to them). So, I decided it was time to give it a try. Read Upload to HR11 User Fields with Excel Add-In .
4 17158 0
by  Dave CurtisJump to last post
7/22/2013 12:49 PM

Getting an error - anybody know the cause?    

Started by  Mindy
Hi all!  I am new to Lawson, and a user has been set up with ADDINS attribute to ALLOW, and assigned the GEN profile as LawsonQueryToolsRole as required in the Lawson manual.  The user is showing in the Resource Manager, but she gets the error in the Summary.  Is it something on the Excel 2007 side, or a server permissions thing
2 10704 0
by  Greg MoellerJump to last post
7/12/2013 5:36 PM

Query with OR criteria timing out with Lawson 9.0.1    

Started by  Laura
We are upgrading to 9.0.1 this weekend and during testing have run across several queries we use on a regular basis where we have 'OR' criteria.  There's a fairly simple one that is just pulling 3 fields from APINVOICE and the criteria is: {invoice1} OR {invoice2}.  When we query on 9.0.0, that takes less than 2 seconds.  Running the same query against 9.0.1, even after rebuilding it, it takes over a minute. Has anyone else encountered this  Is it just the ...
16 9221 1
by  LauraJump to last post
6/19/2013 6:47 PM

AM20.3 add-ins upload to add serial number on each line    

Started by  Laura
We need to be able to add serial numbers to specific line items on an asset in AM20.3.  Does anyone know how to do this with add-ins since the field name for serial is always row0  We have assets that can have up to 100 line items and each one needs its own serial number.  I haven't tried it yet but the user did and was unsuccessful so I figured I would start here    Thanks!
0 3938 1
5/15/2013 4:01 PM

MS-Addins with Microsoft Excel 2007    

Started by  JohnS
Does MS-Addins work with Excel 2007
4 13384 1
by  JohnSJump to last post
5/9/2013 8:46 AM

URL Connection and Login information not retained    

Started by  ScottDesart
on a windows 7 machine - using Excell Add ins we are seeing that the connection information is no longer retained and must be keyed in every time a user wants to use the addins. In Windows XP the Sever URL was retained and the User Name so the user only had to key in their password. Does anyone know if there is a way to fix this
2 13838 1
by  KevinYJump to last post
5/1/2013 2:38 PM

Addins for 2013 ?    

Started by  Greg Moeller
Does anyone out here know if Addins are compatible with Office 2013 --  If so, any gotchas for installing them I see the compatibility matrix only mentions 2010 so far.
6017 1
by  Greg MoellerJump to last post
4/11/2013 7:58 PM

Problem Uploading Large GL65 Files    

Started by  Deleted User
Hi All;   We are on the Iseries (AS/400) using Lawson v, Lawson Addins 9.0.3.  When 2 or 3 users try to upload a GL65 File simultaneously using Addins and the file has between  3,000  - 4,500 rows, Lawson comes to a crawl.  One time, I had to shut down everything and restart Websphere. The users are using MS Excel 2007 and 2010.    At the moment am having them upload large files 1 at a time. Would appreciate any recommendation on enhancing ...
0 3543 2
4/5/2013 4:51 PM

Unable to create a new Add-In Upload    

Started by  Austin
I am a bit new to the Lawson world & was hoping someone maybe able to lend a little knowledge on this issue we seem to be encountering randonmly with some of our Addin users. We have some individuals that are unable to create a new upload. The are able to to run ones that they previously defined, but seem to encounter an issue when they are trying to create a new upload. I double checked their security settings & they do have this ability. Any thoughts or suggestions would be much a...
1 4121 0
by  Greg MoellerJump to last post
3/27/2013 5:01 PM

HR02 Add-in to change to Inactive    

Started by  Deleted User
We are changing our HR Process Level and Department structure so I need to inactivate hundreds of HR02 departments.  I've tried creating an add-in to do this but I don't get any results.  No changes are made and no errors display in my spreadsheet.  There must be some hidden field or code I need to pass to make the current record in my spreadsheet the current record in the form, but I don't know what field/s or codes to use.  Any advice would be appreciated.  Tha...
3 5302 0
by  Deleted UserJump to last post
3/21/2013 9:03 PM

Lawson add ins active x error    

Started by  amerz100
Hello,   I have come across this issue other times with windows 7 32 bit machines.  When the lawson add ons are installed and I go to excel -> add ins tab -> and try to select an add in, I get an active x warning message and when I hit ok, a window pops up with visual basic code. I have used a registry cleaner and it has not worked and I have received no response from the lawson support on this. If anybody has any ideas, it would be greatly appreciated Thank you, ...
3 7255 0
by  GeorgetteJump to last post
3/4/2013 6:56 PM

AM30.1 Asset Transfer    

Started by  John Crudele
I am doing an upload to the AM30.1 asset rasnfer screen. The message I receive for the lin is memo entry exist, accept entry to add. I remember that there was a way to accept the entry but i cannot remember. Any help woul dbe appreciated Thanks JC
0 3810 0
1/29/2013 5:53 PM

Webuser or Profile error    

Started by  J.Connelly
I've got a user in my office who is getting this error when trying to login to lawson addins in Excel: 'WEBUSER OR PROFILE ERROR. Web User has been inactivated, please contact your administrator' The PC is using Windows XP and Office 2007 This only occurs on ONE workstation, with ANY user account. When the same users try to login on another workstation, everything functions just fine. I'm currently working on getting a Fiddler log for the error, and will post it when I can. We've be...
7 9144 2
by  J.ConnellyJump to last post
1/16/2013 8:58 PM

Mass changing benefits    

Started by  jph826
For hundreds of records (not all), I need to change the 403 contributions (DC Plan) from zero to 3.  I've tested using a BNBATCH file and running the BN531 but I keep getting 'Cannot enter amount or percent for zero contribution.  &91;1&93; Does anyone have an addin template for changing benefits and &91;2&93; What are your recommendations on how I can either change the existing 403 zero contribution records to 3 or delete and re-add in a mass way  Thanks!
0 3796 1
1/4/2013 1:46 PM

PA02 Mapping File Error    

Started by  Deleted User
Does anyone have the mapping for PA02, I&160;want to change Only Pay Grades for all Positions with new effective date, When i am uploading this with Add action or change action , i am receving 'Field is required' message. i am supplying Company,Position,new Effective date,'Update Employees flag' with&160; New pay Grade and with Hidden key. anyone have solution for this issue Appreciate &160;your help.
4 7477 2
by  Deleted UserJump to last post
12/19/2012 9:06 AM

Query Wizard - slow response moving thru tabs    

Started by  Alassiel
The Query Wizard is ridiculously slow when I move from  tab to tab, e.g., from Welcome to Fields, from Fields to Column Headings, etc. It takes more than a minute for the next tab to display; I actually go and do something else while waiting. Once the query has been built, the actual data retrieval is very fast. I'm running S3 Addins ver and Excel 2007 SP3 all on Win 7. I'm the only Win 7 user in our organization so I can't compare performance with anyone else here. Has any...
0 3662 0
11/9/2012 8:24 PM

Add-Ins no longer support semi-colons    

Started by  brooke
Has anyone else had an issue with existing Add-Ins queries after upgrading to ESP10  We have queries that no longer run or return the wrong results.
0 3862 1
10/18/2012 7:13 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 5 of 10 << < 34567 > >>

RSS Feed Available