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:
Sytelineuser
Past 24 Hours:
1
Prev. 24 Hours:
0
Overall:
5196
People Online:
Visitors:
197
Members:
0
Total:
197
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
1369
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 3 of 10
<<
<
1
2
3
4
5
>
>>
Topics
Replies
Rating
Status
Views
Subscribers
Last Post
Add-ins error: New value must be spaces because line has no item
Started By
Kelci
I'm hoping someone can assist with this, because I'm stumped! I'm testing out a mass upload of pay increases in our test environment and encountering an error when I attempt to upload the changes: 'New value must be spaces because line has no item' This is a template that I've used successfully in years past, but had to update a handful of the fields after we upgraded Lawson to v9. The template as it currently exists (after my edits) is: _f0 ...
1
20486
0
by
Kelci
6/22/2016 7:26 PM
Add-ins Resource
Started By
Deleted User
Forgive me because I didn't read every post on this forum (so I don't know if it's already been posted), but just an FYI - this is a great link for pre-defined add-ins uploads, many have been updated for 9.0. Pre-defined spreadsheet - I've found it to be a lifesaver! http://solutions.lawson.com/lu/addins/main.htm Have a great day
14
33540
1
by
Andrea
6/18/2016 9:07 PM
PO20 upload add-in
Started By
NatalieD
Would anyone be willing to share their upload wizard for PO20 creation Much appreciated!
1
19049
0
by
Kat V
6/10/2016 12:56 PM
Add in Query for AP Data
Started By
AaronH
I have written an add in query for AP data with the below fields. This query works but due to a condition within the criteria it is excluding non-PO invoices. I need to see both PO and non-PO invoices. Is there a work around for this query or another way to write it such that I can get both Fields: mmdist.company, mmdist.acct_unit, mmdist.account, vendor, apvenmast.vendor-sname, po-number, invoice, apinvoice.tran.inv.amt, apinvoice.invoice.dte, distrib_date, item, item-desc, ent_uom, ent_unit...
1
20135
0
by
JonA
4/14/2016 4:56 PM
Query PO Comments Fields
Started By
Freer
Howdy, Does anyone know how to qurey the comments to print on purchase orders
20
57757
2
by
JonA
3/29/2016 2:03 PM
'Authorisation' for Addins
Started By
Lorraine
Hi we have a user who cannot access Lawson Addins on his machine though they are all there. We have raised with IT but they believe the access is correct. The login screen comes up (and the login is fine on portal) but the following pops up when trying to log in: 'You do not have authorisation to use the Lawson addins. Please contact your administrator' Does anyone have any idea what this means If IT are saying access is fine, I am not sure where else ot look. Next option is to remove...
1
20722
0
by
JonA
1/26/2016 3:49 PM
Add-in PO25.6 trouble
Started By
Oscar S
Hi! I am trying to update the priority for several agreements' lines (PO25.6) through Add-ins. I am receiving a 'Cannot update already assigned vendor item' error for each line. This looks like a dumb error but I couldn't find out what I am doing wrong. Any thoughts These are the columns I am using:
3
20603
0
by
Oscar S
1/5/2016 8:27 PM
AR28 upload
Started By
liz
Upload to AR28. Keep getting an error 'Payment does not exist'. But payment is there. Any ideas
1
19124
0
by
liz
11/13/2015 3:17 PM
Addins query for AC295 data
Started By
Sherry Shimek
Hello. Does anyone have a MS Addins query that provides the same data as the AC295. I have queried the ACCommit and ACCommitX tables but cannot tie to the AC295. I need to know how to derive the ACTRANS part fo the AC295 report. Thank you, Sherry Shimek Catholic Health Initiatives
1
18965
0
by
JonA
11/11/2015 2:35 PM
Add-In not uploading to vendor master maintenance?
Started By
Ronnie
We have a user who is trying to do an upload to the vendor master using excel add ins. She has rebuilt her add-in and tried without success. When she runs the upload it states upload complete but the data doesnt add or change, and no results post on the excel spreadsheet. She tried another type of upload just for fun (a journal header) and this one worked fine and updated the spreadsheet with the result. Any thoughts
6
19334
0
by
Beth
10/22/2015 1:40 PM
Add-ins ver 10.0.5 install problem (with Office 2013)
Started By
CindyW
Trying to install ver 10.0.5 of the Lawson Add ins, to use with Office 2013. This user had not used the add-ins since last year, when she used an older version (with O ffice 2010), but has since upgraded to 2013 and her old version would not work. So she downloaded the 10.0.5 version, and tried to install it (run as admin) and is getting this error: Error 2755. Error Attempting to apply permissions to object 'CURRENT_USER\Software\Lawson Software\Office Add-ins'. System error: The syste...
0
4464
0
10/2/2015 6:24 PM
Add-ins for PO31
Started By
Michelle
Has anyone ever successfully added a line in PO31 using add-ins that actually tied to the original PO number and PO line number I have been able to add the line with all the other relevant data, but for some reason I cannot get the upload to recognize those fields. I am using: f56 PTL-ORIG-PO-NR1, f57 PTL-PRIG-PO-REL1, f58 PTL-ORIG-PO-CODE1, and f59 PTL-ORIG-PO-LN-NBR1.
0
3844
0
9/23/2015 5:59 PM
Uploading Employee Groups
Started By
vjc
has anyone successfully moved employee groups from one environment to another using the add-ins is there another way to move employee groups from one environment to another
0
3546
0
9/1/2015 9:41 AM
Missing MAP COLUMNS in Upload Wizard
Started By
carriermc
Periodically, when I log into my Lawson Upload Wizard the MAP COLUMNS piece is blank that allows me to select the service and screens. Each time I need to build a new upload, I have to have my add-ins repaired. Is this a common issue Is there a more permanent 'fix' available
1
19238
0
by
JonA
8/21/2015 3:38 PM
Upload for SSN on HR13.1
Started By
Colleen Bertagnolli
I am trying to create an HR13.1 upload to add dependent social securty numbers. I process as a change and get the message: Social Nbr differs from country US format; OK to Continue. I know I am missing something....
1
18961
0
by
Colleen Bertagnolli
8/19/2015 12:43 PM
Error 1404 when installing add-ins
Started By
Judi Sims
I am a local admin of the workstation. I am right clicking and choosing: Run as administrator. During the install, this error comes up: 'Error 1404. Could not delete key \software\classes. Verify that you have sufficient access to that key, or contact your support personnel.' Options appear of Abort, Ignore, Retry. If I ignore, the add-ins appear to install and show up in Excel, but not accessible. Runing Word 2010, and addins for version 10. Assistance appreciated.
0
4298
0
8/17/2015 7:15 PM
GL Distrib and Vendor Details
Started By
Boyd
I am having trouble pulling a GL query that includes vendor details. I am being asked to pull information that reconclies to a GL balance but it needs to include vendor , vendor name and invoice on the query. I have found a way to get vendor and invoice on the query but I can't seem to get the vendors name on the query. Any assistance is appreciated.
1
18993
0
by
JonA
8/17/2015 12:16 PM
MS Addins Query GLAMOUNTS amounts in excel as text
Started By
Sherry Shimek
We are querying the GLMAMOUNTS table using Lawson MS Addins MS Excel is treating all the monthly gl amounts as text. We have tried setting the format tab to Accounting1-4 and applying to all rows, but this doesn't affect the amounts only the other fields such as the company and other accounting string numbers. Is there a way in either MS Addins query wizard or excel to default these to numbers. In large queries, using excel to change convert to numbers takes quite a bit of time. Thanks, Sh...
3
19716
0
by
dcaiani
6/12/2015 5:32 PM
automated scheduled uploads
Started By
NG
I am a new user and currently in the implementation stage of Lawson HR system. We have been told that we can automate the HR daily nightly scheduled uploads using VB or javascript. Can someone point us in that direction like any example, documentation or anything which might be helpful for us to understand or start on the correct path Thanks a lot in advance.
0
3880
0
6/8/2015 5:20 PM
MS Add Ins Upload Template for BN36.1
Started By
kvetro60
Hi - Does anyone have a MS Add Ins template for BN36.1 We are eliminating one of our current investment vendors and adding that distribution to our one existing vendor. So, if an employee has any distribution in vendor A, we want to end that plan and now give the employee 100 distribution in Vendor B.
0
4162
0
6/1/2015 1:20 PM
GLTRANS attributes
Started By
Sherry Shimek
We have 3 source codes that post to the General Ledger with GLTRN object attribute values. One has one attribute; this is easy. The other two use the maximum three attributes. Is there a way to run a GLTRANS query with all three attributes without triplicating the records (Using OTM set at 3 we can get all three attributes in the query but it provides the actual records once for each attribute. This results in triplicate data if the transaction had all three attributes for that system code.)...
1
19477
0
by
JonA
5/15/2015 10:51 AM
Add-Ins upload in MS Excel 2010
Started By
Dave Humphrey
We are using Infor Lawson 10.0.5. In the past we were able to successfully use MS Excel 2010 for add-in uploads. It never used to matter what order the columns were in on the spreadsheet because you defined the fields to use for the upload. We are now being told that you have to have the columns in the sequential order of the fields to be uploaded. Apparently now when they are not in the 'right' order we get a fatal error on the upload. Does anyone have any experience with this issue
0
4308
0
4/8/2015 12:29 PM
Add-Ins FATAL ERROR
Started By
Therese Chaplin
Our users are experiencing a FATAL ERROR: UNKNOWN ERROR when trying to use the Add-ins tool. About a year and a half ago, we had this same issue and had to apply patch JT-453953, which corrected the issue. Our Add-ins was working until we applied the following patches to the Lawson environment and Websphere: LSF 9.0.1.13 7.0.0-WS-WASSDK-HpuxIA64-FP0000033.pak 7.0.0-WS-WAS-HpuxIA64-FP0000033.pak Has anyone run into this issue and found a solution We have opened a ticket with Infor. Thei...
2
20941
0
by
Therese Chaplin
4/7/2015 6:30 PM
Add-ins for AR33.6
Started By
Todd Mitchell
Has anyone had any experience with creating an Addins for AR33.6 or an add-ins for doing write-offs of credits/payments I have successfully built an Add-in for the Invoices, but am struggling with the Credits/Payments.
1
18809
0
by
Todd Mitchell
3/31/2015 12:38 PM
Using add-ins with Excel 2010
Started By
Eddie Smith
Our IT department is planning to upgrade our company from Office 2007 to Office 2010 and from Windows XP to Windows 7. I know that the add-in is not certified to run on Excel 2010; but I've been testing it and it seems to work except for the fact that the login dialog box does not retain the server and username. Has anyone else found this as well
8
40478
2
by
Mark
3/23/2015 2: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 3 of 10
<<
<
1
2
3
4
5
>
>>
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