Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
User Experience
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Chad Mac
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5185
People Online:
Visitors:
230
Members:
0
Total:
230
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3291
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1363
Roger French
1315
mark.cook
1244
Forums
Filtered Topics
Unanswered
Unresolved
Announcements
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Forums
User Experience
Forum:
Lawson Add-Ins for Microsoft Office
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.
Search this forum:
78
Subscribed to this forum
Page 5 of 10
<<
<
3
4
5
6
7
>
>>
Topics
Replies
Rating
Status
Views
Subscribers
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
19251
0
by
Laura
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 10.0.0.2 MS Office 2010 Lawson Environ...
0
3939
0
10/15/2013 6:55 PM
AP16.2 must inquire first
Started By
Linda3
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
7
23310
1
by
darwin collins
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 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...
12
20199
0
by
Ronnie
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
19182
0
by
Dave Curtis
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 because we do not use the Securi...
1
17675
1
by
John Henley
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
12329
0
by
George Graham
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 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...
5
11768
0
by
Greg Moeller
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
17496
0
by
Dave Curtis
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
11031
0
by
Greg Moeller
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 version of add-ins we are using (9....
16
9497
1
by
Laura
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
4226
1
5/15/2013 4:01 PM
MS-Addins with Microsoft Excel 2007
Started By
JohnS
Does MS-Addins work with Excel 2007
4
13691
1
by
JohnS
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
14079
1
by
KevinY
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.
2
6318
1
by
Greg Moeller
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 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
0
3841
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 appreciated. T...
1
4348
0
by
Greg Moeller
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. Thanks
3
5663
0
by
Deleted User
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, Oliver
3
7559
0
by
Georgette
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
4045
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
9457
2
by
J.Connelly
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. [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!
0
4091
1
1/4/2013 1:46 PM
PA02 Mapping File Error
Started By
Deleted User
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.
4
7852
2
by
Deleted User
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 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...
0
3954
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
4179
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
<<
<
3
4
5
6
7
>
>>
General
--Dealing with Lawson / Infor
--SOx Compliance
--Career Development
--Staffing
--Hosting / Cloud
--User Group Announcements
Infor / Lawson Platforms
--Lawson Landmark
--S3 Systems Administration
S3 Security
--M3 Application Foundation
--M3 Workplace Foundation
--Infor CloudSuite
User Experience
--Lawson Portal
Lawson Design Studio
--Lawson Smart Office
Mashup Designer
--Infor Workspace
--Infor Social Space
--Lawson Add-Ins for Microsoft Office
--Mobility
--Lawson Enterprise Search
Integration / Customization
--IPA/ProcessFlow
--Infor ION
--S3 Interfaces/Conversion
--S3 Customization/Development
--S3 Application Upgrades
Human Capital Management
--Lawson S3 HR/Payroll/Benefits
--Infor Global HR (GHR)
Financial Management
--Infor CloudSuite Financials
--Lawson S3 Financials
--Lawson M3 Financials
--Infor FMS
--Lawson Services Automation (PSA/SA)
--Lawson Budgeting & Planning
Expense Management
--Infor Expense Management
--Lawson Time & Expense
Enterprise Resource Planning & Manufacturing
--Lawson S3 Procurement
--Lawson M3 Manufacturing Operations
--Infor ERP (Syteline)
Supply Chain Management
--Infor SCM
--Lawson S3 Supply Chain
--Lawson M3 Supply Chain
Enterprise Asset Management
--Infor EAM
--M3 Enterprise Asset Management
Performance Management
--Lawson Business Intelligence/Reporting/Crystal
Smart Notification
--Lawson M3 Business Performance Warehouse
--Lawson Opportunity Analyzer
Lawson Healthcare
--Cloverleaf
--Lawson MediSuite
--Analytics for Healthcare
Job Fair
--Positions Available
--People Available
LawsonGuru.com
--LawsonGuru.com Support