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.
78 Subscribed to this forum
Page 3 of 10 << < 12345 > >>


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 20235 0
by  KelciJump to last post
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! Have a great day
14 33301 1
by  AndreaJump to last post
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 18825 0
by  Kat VJump to last post
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.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 19905 0
by  JonAJump to last post
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 57306 2
by  JonAJump to last post
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 20467 0
by  JonAJump to last post
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 20351 0
by  Oscar SJump to last post
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 18918 0
by  lizJump to last post
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
18755 0
by  JonAJump to last post
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 19126 0
by  BethJump to last post
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 4296 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 3648 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 3349 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 19027 0
by  JonAJump to last post
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 18775 0
by  Colleen BertagnolliJump to last post
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 4087 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 18787 0
by  JonAJump to last post
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 19501 0
by  dcaianiJump to last post
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 3691 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 3966 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 19274 0
by  JonAJump to last post
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 4112 0
4/8/2015 12:29 PM


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 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 20737 0
by  Therese ChaplinJump to last post
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 18573 0
by  Todd MitchellJump to last post
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 40265 2
by  MarkJump to last post
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 << < 12345 > >>

RSS Feed Available