Does MS-Addins work with Excel 2007

Does anyone have the mapping for PA02, I 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  New pay Grade and with Hidden key. anyone have solution for this issue Appreciate  your help.

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 .

I'm trying to upload to AP16.2  I keep getting a message 'Vendor bank exists must inquire first'.  Does anyone have a resolution for this

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.

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 9.0.3.1387 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 anyone s...

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

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...

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.  [1] Does anyone have an addin template for changing benefits and [2] 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!

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

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, Oliver

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.  Thanks

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 appreciated. T...

Hi All;   We are on the Iseries (AS/400) using Lawson v 9.0.0.9, 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 the performance of the tool.    Jean

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.

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 version of add-ins we are using (9....

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!

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

We just upgraded our Lawson systems as follows:  LSF Environment to 9.0.1.11, Portal to 9.0.1.11 and Applications to 9.0.1.9.   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 9.0.3.1 version of Add-Ins.   Our datab...

Anyone know how to display/extract the query string from an Add Ins query

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 because we do not use the Securi...

We recently had our environment updated from 9.0.1.5 to 9.0.1.9 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...

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...

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 10.0.0.2 MS Office 2010 Lawson Environ...

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 ...