Search this forum:
Search
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 1 of 3123 > >>
Topics
 Replies
 Views
 Last Post
2 Replies and 2608 Views AP10.5 Add In Upload Help  2608  2 Started by  MelissaH I'm trying to upload information using Add Ins into AP10.5 (we need to create some default cash codes for vendors based on the GL company), but I keep getting a failure message - Company does not exist | Vendor default codes not defined for this company.  I'm hoping someone can give me some insight on what my problem is.  I'm using the hidden fields for Vendor Group, Vendor Group Holder and Vendor along with the company and cash code fields that we'...
2 2608
by  Carol SJump to last post
02/13/2018 11:24 AM
1 Replies and 527 Views upload reconciliation on CB80 error  527  1 Started by  harold_c The first line of the upload works but the rest has this error: This form action valid on open transactions only (_f51r0). Each transaction number is uniquely assigned.  I searched in Infor's KB but showed only 1 result; recommending to add a field 19 (Position to field).  However, I could not find that field in the currently available fields for upload (maybe it's renamed, possible fields: _f29,PT-CBT-TRANS-NBR; (H),_F0,TC; tried but to no avail) How do you upload your reconciliat...
1 527
by  Carol SJump to last post
02/12/2018 6:54 PM
2 Replies and 557 Views PO30 & PO35 Addins  557  2 Started by  brupp Hello - We need to do some mass receiving to clean up our INR report.  Would anyone be willing to share their addins for PO30 Add receiver & lines & the PO35 to release  I'd be most grateful.  Thanks in advance!!
2 557
by  bruppJump to last post
02/06/2018 7:44 AM
19 Replies and 7059 Views RQ10 Upload Challenge  7059  19 Started by  Jeff Hi all Upload wizards, We have been using the RQ10.1 Self-Contained Upload Worksheet from the site, http://hpsale37.lawson.com/lu/addins/main.htm, with a great deal of success this past week but today ran into a snag.&160; We have a 45 line Requisition that gets posted as 9 separate Requisitions with 5 lines each versus the desired one Requisitions with 45 lines. Here's the challenge, is it possible to create a 45 line Requisition via an Add-in or is there a limitation of just 5 lines due to ...
19 7059
by  Kat VJump to last post
12/27/2017 7:51 AM
11 Replies and 2037 Views Addins Performance doubled with upgrade  2037  11 Started by  Greg Moeller We've recently went live with Infor10.. and our Addins performance has doubled. Issue:  Upgrade from 9.0.1.x to Infor 10.0.8 and at the same time            Switched platforms from Unix to Windows (database and apps) Applied the newest version of MOA available per Infor support... and it is still taking twice as long to load a large payroll file. Any suggestions on where I should start troubleshooting this
11 2037
by  drewlewis15Jump to last post
12/19/2017 3:57 PM
7 Replies and 1922 Views Add-Ins Peformance Issues  1922  7 Started by  Greg Moeller Hi! We're upgrading to Infor10 and switching platforms from Unix to Windows. We're struggling because an Addins that should take no longer than 10 minutes tops has been running now for nearly 45 and isn't even half done. Any settings that I could look at TIA, -Greg
7 1922
by  drewlewis15Jump to last post
12/19/2017 3:56 PM
0 Replies and 150 Views deleting values on AC13 via add-ins  150  0 Started by  bblair trying to delete values for a specific attribute across all activities. i have used activityattribute (matrix cat)fc=d in change only mode. i have used activityattribute (matrix cat) current valuefc=d in change only mode. i have used activityattribute (matrix cat)fc=d in delete only mode. i have even tried to change the values to null using activityattribute (matrix cat) blank cell for valuefc=c in change only mode. also, i have tried using 'position to' for this change...
0 150
11/08/2017 10:36 AM
0 Replies and 325 Views Help Needed: How to uninstall Spreadsheet Designer  325  0 Started by  ddub I'm experiencing an error when installing 'infor Spreadsheet Designer' that tells me a version already exists on my machine and I need to uninstall it using 'Add/Remove Programs'. The problem I'm having is that no such entry for 'infor Spreadsheet Designer' exists under 'Add/Remove Programs'.   Does anyone know how to correct this   Additional information that may be useful is that the initial install was performed using the installation files on a network drive (not local machine...
0 325
08/09/2017 2:07 PM
4 Replies and 1027 Views PO25.6 Line cost changes with add-ins  1027  4 Started by  Dave Humphrey We have an existing PO25 vendor agreement with many lines on it and we want to change the cost of certain lines/items.  We are trying to use add-ins, but I just can not figure out the correct steps/fields to use to change only certain lines.  Does anyone have instructions
4 1027
by  Dave HumphreyJump to last post
06/23/2017 8:55 AM
7 Replies and 3169 Views Add-Ins for Office 2016  3169  7 Started by  Greg Moeller Anyone know if Add-Ins will work with Office 2016 I don't see anything in the docs that 'officially' says support for 2016....
7 3169
by  LeslieJump to last post
04/24/2017 5:20 PM
1 Replies and 1348 Views Fatal Error: File FILERELFLD is secured  1348  1 Started by  wvrcrowder Fatal Error: Item_secured.  I've looked in the moa.log file but I'm not finding anything to help figure out the issue.  Any help would be appreciated.
1 1348
by  JimYJump to last post
04/05/2017 5:48 AM
2 Replies and 3643 Views PO25.8 Upload Error  3643  2 Started by  Wayne Good morning all; I'm trying to do a mass upload to add future pricing to multiple VPA's (PO25) using add ins and I keep getting the error 'Window Changed - Update Form To Save.' Can someone tell me how to update the form using add-ins - I have tried everything and it's driving me insane. Thanks!
2 3643
by  cmjsJump to last post
12/02/2016 11:31 AM
9 Replies and 7521 Views Add-ins for Office 2013....  7521  9 Started by  Shane Jones Hello all: I know that right now Add-ins is not compatible with Office 2013 but I have not heard or seen anything on plans to make it work with Office 2013.    Has anyone heard or seen anything about a possible release date 
9 7521
by  JimYJump to last post
11/16/2016 7:26 AM
4 Replies and 2456 Views Addin Templates  2456  4 Started by  Kelly H Are addin templates available on inforxtreme  If so, any hint on how to search for them or find them  Thanks!!  
4 2456
by  Tanya_DJump to last post
11/09/2016 3:40 PM
2 Replies and 1085 Views IC99.2 addins required fields  1085  2 Started by  CherieO IC99.2 addins--what are the required field for a change, for example to the average cost   For an existing location, with no SOH and no average cost (need this for our cost defaulting hierarchy for new inventory order batch job) I tried the following unsuccessfully   f5 ITL-ITEM f3 ITL-COMPANY f4 ITL-LOCATION f24 ITL-AVERAGE COST   Any help would be appreciated  
2 1085
by  CherieOJump to last post
10/03/2016 7:21 AM
4 Replies and 1485 Views PO20 header comment  1485  4 Started by  NatalieD Does anyone have an upload wizard to share for uploading comments to a PO20 header I am trying to upload a comment for 'Comments to Print to Headers on Internal Documents' as well as 'Comments to Print on Purchase Orders.'
4 1485
by  JonAJump to last post
08/16/2016 2:19 PM
0 Replies and 496 Views Lawson Query Wizard - How to return max value only  496  0 Started by  JohnHoward I'm new to Lawson and the Query tool, which is all I have to work with.  I'm trying to query the HRHISTORY table and only return the max value of BEG_DATE for Field number 20 for each employee.  Is there a way to do this  I've used the subtotals but I don't want to return every row of data.
0 496
08/15/2016 1:32 PM
1 Replies and 999 Views PO13 Inactivate Add-In  999  1 Started by  Neil Allen Looking to see if anyone has an add-in for inactivations in PO13 they're willing to share.  We're on V10.
1 999
by  Kat VJump to last post
08/02/2016 3:28 PM
0 Replies and 874 Views VBA code to launch lawson add-in 10.0.7  874  0 Started by  harold_c Anybody knows the code to launch the Lawson add-in 10.0.7 from Excel   We used to be able to run it in the older version because we can see it in the VBA editor, but with the new version (VSTO), we could not see the code anymore and don't know how to call it.   Your help is appreciated. Thanks.   Harold
0 874
07/19/2016 7:42 AM
0 Replies and 583 Views Lawson 8 Copy Paste  583  0 Started by  LeviSheriff Just as the summary states: I have an Excel dump of components out of BOM screens in Lawson. I will then marry with a vlookup, prices, accounting codes, etc. Then each line in that excel spreadsheet gets into a clipboard, and then input into consecutive blanks per line in PO20.  In an automated script  
0 583
07/12/2016 3:42 PM
10 Replies and 5785 Views Lawson Add-Ins query for RW100 report  5785  10 Started by  srikanth Hello all, I m new to Lawson Add-Ins.. Any body have an idea on Lawson Add-Ins query for RW100 report &160; I&160;mean generating&160; the reports of RW100 using Add-Ins.. &160; Thanks in Advance.. &160; Srikanth
10 5785
by  vinayJump to last post
07/05/2016 8:49 AM
0 Replies and 588 Views Calling Employee Business Class DME  588  0 Started by  giesewendy When I try to call the Employee Business Class in a DME, in ISD, it takes forever (beyond minutes).  It ignores filters when I set them: like on the relationship status.  What can help this situation  When I try use SQL via an ODBC connection, and apply a link to that business class, it tells me I need indexes.  HELP!  I just want to easily pull lists on the employee business class that include relationship status, work types, etc....   Thank you.  ...
0 588
07/04/2016 10:26 AM
1 Replies and 1383 Views Add-ins error: New value must be spaces because line has no item  1383  1 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:   ...
1 1383
by  KelciJump to last post
06/22/2016 3:26 PM
14 Replies and 7462 Views Add-ins Resource  7462  14 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 -&160; 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 &160;
14 7462
by  AndreaJump to last post
06/18/2016 5:07 PM
1 Replies and 1173 Views PO20 upload add-in  1173  1 Started by  NatalieD Would anyone be willing to share their upload wizard for PO20 creation Much appreciated!
1 1173
by  Kat VJump to last post
06/10/2016 8:56 AM
1 Replies and 1636 Views Add in Query for AP Data  1636  1 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_...
1 1636
by  JonAJump to last post
04/14/2016 12:56 PM
20 Replies and 13514 Views Query PO Comments Fields  13514  20 Started by  Freer Howdy, Does anyone know how to qurey the comments to print on purchase orders
20 13514
by  JonAJump to last post
03/29/2016 10:03 AM
1 Replies and 1739 Views 'Authorisation' for Addins  1739  1 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. ...
1 1739
by  JonAJump to last post
01/26/2016 10:49 AM
3 Replies and 1923 Views Add-in PO25.6 trouble  1923  3 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 1923
by  Oscar SJump to last post
01/05/2016 3:27 PM
1 Replies and 1474 Views AR28 upload  1474  1 Started by  liz Upload to AR28. Keep getting an error 'Payment does not exist'. But payment is there. Any ideas
1 1474
by  lizJump to last post
11/13/2015 10:17 AM
1 Replies and 1437 Views Addins query for AC295 data  1437  1 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 1437
by  JonAJump to last post
11/11/2015 9:35 AM
6 Replies and 1740 Views Add-In not uploading to vendor master maintenance?  1740  6 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 1740
by  BethJump to last post
10/22/2015 9:40 AM
0 Replies and 1416 Views Add-ins ver 10.0.5 install problem (with Office 2013)  1416  0 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:...
0 1416
10/02/2015 2:24 PM
0 Replies and 977 Views Add-ins for PO31  977  0 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 977
09/23/2015 1:59 PM
0 Replies and 858 Views Uasing Addins To Load PO Match Invoices  858  0 Started by  JonA Any one doing this  I imagine it would have to be a two step process- AP20 then MA43.  AP is not my area so I'm asking for their supervisor.
0 858
09/21/2015 11:56 AM
0 Replies and 704 Views Uploading Employee Groups  704  0 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 704
09/01/2015 5:41 AM
1 Replies and 1523 Views Missing MAP COLUMNS in Upload Wizard  1523  1 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 1523
by  JonAJump to last post
08/21/2015 11:38 AM
1 Replies and 1392 Views Upload for SSN on HR13.1  1392  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 1392
by  Colleen BertagnolliJump to last post
08/19/2015 8:43 AM
0 Replies and 925 Views Error 1404 when installing add-ins  925  0 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. Assista...
0 925
08/17/2015 3:15 PM
1 Replies and 1535 Views GL Distrib and Vendor Details  1535  1 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 1535
by  JonAJump to last post
08/17/2015 8:16 AM
3 Replies and 2007 Views MS Addins Query GLAMOUNTS amounts in excel as text  2007  3 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 o...
3 2007
by  dcaianiJump to last post
06/12/2015 1:32 PM
0 Replies and 768 Views automated scheduled uploads  768  0 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 768
06/08/2015 1:20 PM
0 Replies and 988 Views MS Add Ins Upload Template for BN36.1  988  0 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 988
06/01/2015 9:20 AM
1 Replies and 1458 Views GLTRANS attributes  1458  1 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 att...
1 1458
by  JonAJump to last post
05/15/2015 6:51 AM
0 Replies and 1415 Views Add-Ins upload in MS Excel 2010  1415  0 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 exp...
0 1415
04/08/2015 8:29 AM
2 Replies and 2527 Views Add-Ins FATAL ERROR  2527  2 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 wi...
2 2527
by  Therese ChaplinJump to last post
04/07/2015 2:30 PM
1 Replies and 1318 Views Add-ins for AR33.6  1318  1 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 1318
by  Todd MitchellJump to last post
03/31/2015 8:38 AM
8 Replies and 20713 Views Using add-ins with Excel 2010  20713  8 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 20713
by  MarkJump to last post
03/23/2015 10:43 AM
4 Replies and 2638 Views AddIns not loading properly  2638  4 Started by  Claire My company has several AddIn reports that are supposed to update the PR14 deduction screen when our employees enroll through the Benefitfocus enrollment system.  We are having issues with these changes not uploading to PR14 for our voluntary benefits. I am thinking that it is due to the column FC that would be either an Add, Change or Stop.  I am not knowledgeable on add-ins but I am beginning to think that the AddIns are not loading because either the benefit is not there at all an...
4 2638
by  agershJump to last post
03/04/2015 12:59 PM
3 Replies and 2079 Views IC11.1 Add-In  2079  3 Started by  ardrao Would anyone be willing to share their IC11.1 upload  I am fairly new to Lawson and am having an issue uploading the UNSPC codes.  The problem is I am unable to find the FC in the IC11.1 table.  Any help would be greatly appreciated.   Thank you, Ardra
3 2079
by  Kat VJump to last post
02/24/2015 12:46 PM
1 Replies and 1842 Views Query  1842  1 Started by  Juarez Hello everyone, I am new to Lawson add-ins. I need to download vendor information and other related information. I'm getting some info from the table APVENMAST and from another query from items and related vendors. In the items master table (itemmast) I have found all items and related information, but I cannot see any vendor info. How should I do for getting that info That is: download all items with its related vendor. Another thing: is there a way to filter items only for my company is t...
1 1842
by  JonAJump to last post
02/19/2015 2:38 PM
0 Replies and 1214 Views Add In for Microsoft Office  1214  0 Started by  Bill B Hello, I have Microsoft Office 2010 installed on my laptop and workstation. I am currently using Lawson Add-ins for Microsoft Office 10.0.109. I can log into Lawson on both computers. I can log into the Add In on my workstation but cannot on my laptop. I keep receiving the following error when attempt to log in from my laptop : I have already confirmed with our IT department that it is not a log in or profile issue.  Has an update been pushed that may cause this  I am wo...
0 1214
02/19/2015 11:04 AM
1 Replies and 1681 Views BN32 and BN72 Uploads (Add-Ins)  1681  1 Started by  Dave Williams I use uploads for BN32 and BN72. Recently I noticed that my upload did not affect the correct benefit on an employee record. When mapping Excel columns to the correct LAWSON detail field, I have always used the 'r0' option. If the 'r0' option if selected (e.g., '_f24:r0,PTB-COV-OPTION1') then LAWSON will update detail row 0 (which is the 1st row of detail records). I have noticed that LAWSON displays the detail records in the following order: HL, DN, EL, followed by DC and RS (at least that's ho...
1 1681
by  David BrittonJump to last post
01/28/2015 10:29 AM
0 Replies and 1157 Views Add-ins for Smart Office  1157  0 Started by  Chesca Is there a different Add-ins or version for Smart Office One of my users told me there is a different version that needs to be downloaded. I put a ticket with Lawson and this is what they responded: No, it is delivered in Smart Office. Your certified installer should have installed it    
0 1157
12/05/2014 12:44 PM
2 Replies and 1367 Views PR35.2 Upload multiple messages returns add complete continue  1367  2 Started by  LeslieG We upload 1000s of transactions monthly for Payroll via addins to PR35.2. If a leave record is uploaded with a tr date prior to the master entry date on LP31 then two messages are returned ERR:EE46903 not in plan, LEAV WRN:EE46903 inactive, LEAVE LP:ECS LEAV. However, the addin itself returns add complete continue in the results field even though the record wasn’t uploaded. Because we have so many transactions we don't realize that some of these transactions actually were not uploaded. I ...
2 1367
by  The.Sam.GrovesJump to last post
11/12/2014 9:44 AM
1 Replies and 1571 Views Does anyone have an Add-in Template for AM20.4?  1571  1 Started by  maluhia1979 My company has several thousand existing assets in Lawson that need to have an additional book added to them. I was wondering if there was any way to upload this change via a MS Add-in. I've tried building a few upload templates but seem to be having issues with the hidden keys or transferring to AM20.9. Any suggestions
1 1571
by  mgreggJump to last post
11/04/2014 5:58 PM
2 Replies and 1549 Views Upload comments to IC18.1  1549  2 Started by  Jason Does anyone know of a way to upload comments to IC18.1 I have many items that need comments put in and I can use the Add-Ins wizard to create the comment in IC18 but do not see any way to actually upload the comments themselves. It is very time consuming to have to click on 'Has Comments' for every item and manually enter them. Any help would be greatly appreciated.
2 1549
by  JonAJump to last post
11/04/2014 2:35 PM
0 Replies and 740 Views PR35.2 Upload multiple messages returns add complete continue  740  0 Started by  LeslieG We upload 1000s of transactions monthly for Payroll via addins to PR35.2. If a leave record is uploaded with a tr date prior to the master entry date on LP31 then two messages are returned ERR:EE46903 not in plan, LEAV WRN:EE46903 inactive, LEAVE LP:ECS LEAV. However, the addin itself returns add complete continue in the results field even though the record wasn’t uploaded. Because we have so many transactions we don't realize that some of these transactions actually were not uploaded. I ...
0 740
11/04/2014 11:02 AM
2 Replies and 2093 Views Using Add-ins or Spreadsheet Designer for non-Lawson applications  2093  2 Started by  Terry P I think one of the nice things about Lawson/Infor is Microsoft Add-ins and Spreadsheet Designer. Is it at all possible to use these against other SQL databases to load tables
2 2093
by  Kat VJump to last post
10/02/2014 10:20 AM
12 Replies and 5451 Views upload RQ10  5451  12 Started by  wintergreen Anyway knows how to upload the RQ10  I have 2 excel files, one is the header for the RQ, another file is the lines' detail for each RQ.  How to do the upload if the lines have more than 5 items,  in fact,  we have 10 -50 lines for each RQ. Thank you for your help.
12 5451
by  Kat VJump to last post
09/09/2014 3:19 PM
0 Replies and 1023 Views Upload to HR55.2  1023  0 Started by  BrianP Does anyone have a working template they are willing to share  We are using Lawson 9.1. Thanks, Brian
0 1023
09/08/2014 10:05 PM
2 Replies and 2097 Views Add in for benefit rates?  2097  2 Started by  Sarah Just curious, is it possible to do an add-in on the BN18.1 Options Amount and\or BN19.1 Options Rate with open enrollment rates I just thought an add-in might be better than having a person key it. TIA, Sarah
2 2097
by  Terry PJump to last post
08/12/2014 7:28 PM
3 Replies and 6740 Views Invalid One To Many Filtering  6740  3 Started by  Deleted User I am building queries in Add Ins for the first time and I am having difficulty retrieving results when I chose more than one Criteria. The error message I am getting is INVALID ONE TO MANY FILTERING: An unknown error occurred. Please contact your system admin. I am not sure what I am doing wrong but I think I should be able to query using more than one filtering criteria. I retrieve data with only one filtering criteria but once I add another the query fails. Any suggestions
3 6740
by  jwilcoxsonJump to last post
07/10/2014 4:24 PM
1 Replies and 1606 Views PO25.7 Upload to Change Cost on Lines  1606  1 Started by  jj2020 Hello, I am trying to use add-ins to change the cost on multiple service agreement lines but keep receiving the message: Cannot chg max amt for Svc Agmt; Chg cost/qty to update. The fields I have mapped are: f3-Procure Group f5-Ven Agrmt Ref f12:0 Line Nbr f22:0 Base Cost f11:0 Line FC Does anyone have successful experience uploading changes to PO25.7 Thanks!
1 1606
by  JonAJump to last post
05/27/2014 1:42 PM
2 Replies and 1529 Views Add-ins Speed  1529  2 Started by  Jeremy I've worked in a few Lawson environments, but the one I'm currently in seems to be very slow when using add-ins for uploading things like GL entries or even simply changing a flag on AP10.1 records. I'm talking about 1.8 records per second. At my previous places, I've seen something like 7-10 per second. Can others chime in with what they're seeing as well as their system setup like database, Unix or Windows, version, etc... Thank you.
2 1529
by  Gary StoneJump to last post
05/02/2014 8:26 AM
4 Replies and 2900 Views Add-Ins Login  2900  4 Started by  Metrazal When I launch the login menu for Lawson add-ins, the server & user id information is not retained from my previous login.  (It can be rather annoying to have to type this information everytime I access add-ins.)  I would also like to retain the password also or avoid the login prompt, if possible.  Security is not an issue because the spreadsheet that I launch the add-ins from is stored on my local drive and password protected.    Any ideas or help ...
4 2900
by  MetrazalJump to last post
02/11/2014 2:05 PM
6 Replies and 4086 Views Upload to HR55.3  4086  6 Started by  Phil Simon Hello I've heard mixed things about this.&160; I've tried to upload to HR55.3 (after the group was established) but received a 'field is required' error -- sans the reference to that field. Anyone ever get this to work ps
6 4086
by  Michelle OlsonJump to last post
02/10/2014 1:50 PM
2 Replies and 2688 Views Self contained GL40 JE upload template  2688  2 Started by  Display Name Our finance department uses the GL40 upload template that was available on the mylawson download sight years ago. I am familiar with the typical requirements for URL/user id to be remembered between uses for Add-ins, however this template writes LoginCurr and LoginHist files to the C:\Program Files\Lawson Software\Common folder not the \Add-ins folder and doesn't use or require a LoginDir folder, though out of desparation I have added one anyway.  The issue I am having is only ...
2 2688
by  Display NameJump to last post
02/06/2014 8:03 AM
2 Replies and 2147 Views Upload for IC12.1 and IC12.2  2147  2 Started by  JimY I am trying to create an upload for IC12.1 and IC12.2, but I am getting an error when the Automatic Purchasing Flag is set to Y on IC12.1.  Is there a way to use the same upload to update both IC12.1 and IC12.2 or am I going to have to have separate uploads for each and then go back and update the flag on IC12.1  Does anyone have one that they would be willing to share  We are on version 10.0.2.  Thank you.
2 2147
by  JimYJump to last post
02/02/2014 5:31 PM
7 Replies and 4631 Views Uploading Budgets (FB20.1) using Add-Inns  4631  7 Started by  Saurabh All I am trying to create an upload routine to be allow the end users to Upload the Budget directly. Have been able to creat the Budget Header, but when trying to load the Budget detail (simulating FB20.1) keep getting 'Field Is Required' errors. Have tried to look for any hidden fields etc but no luck. Has anybody tried to upload Budgets using Add-Inns and if so are willing to share/provide tips on same. We are on LSF9.0.0.4, 8.1 MSP5 on Win2003R2 with SQL back end. Regards Saurab...
7 4631
by  LorraineJump to last post
01/16/2014 11:19 AM
2 Replies and 1997 Views HR11 Addins template  1997  2 Started by  Reema all my data fields are mapped fine. not sure what i am missing. Does anyone have an HR11 employee upload template i could use..need it really urgent!
2 1997
by  ReemaJump to last post
12/23/2013 1:30 PM
1 Replies and 1867 Views template for AC10 ms addins upload  1867  1 Started by  jennifer does anyone have a template for AC10 ms addins upload template
1 1867
by  Jimmy ChiuJump to last post
12/10/2013 11:11 AM
3 Replies and 2120 Views Addins query for IC11.7  2120  3 Started by  Lynette Thibeau We have started populating some GTIN information into Lawson IC11.7.  I am trying to query IC11.7 (ICITEMGTIN) to return those items that have a GTIN number and its UOM.  When i run the query, the only thing that returns in the GTIN and UOM Fields are hashmarks () for the number of digits in the field.  We are on Lawson 9.0.1.9.153 and Addidns version 9.0.3.1488.  What am i missing to have this information populate correctly I'm actually querying IC11 (ITEMMAST) wi...
3 2120
by  JonAJump to last post
11/08/2013 12:45 PM
2 Replies and 1523 Views Invoice changes and modifications  1523  2 Started by  Tom Looking at APInvoice, there is no modification date. Any ideas on how to figure out when an invoice was changed would this be resolved through APDistrib
2 1523
by  TomJump to last post
10/28/2013 8:11 AM
1 Replies and 1576 Views Need Help Pulling in UOM pricing in PO28  1576  1 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 1576
by  LauraJump to last post
10/17/2013 6:39 AM
0 Replies and 1000 Views S3 Upload Wizard won't always open saved mappings  1000  0 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 1000
10/15/2013 2:55 PM
7 Replies and 3998 Views AP16.2 must inquire first  3998  7 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 3998
by  darwin collinsJump to last post
10/03/2013 3:23 PM
12 Replies and 2299 Views Help..Not getting anywhere with Lawson Support...DME no data  2299  12 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 2299
by  RonnieJump to last post
09/23/2013 8:11 AM
6 Replies and 2657 Views uploading to HR15.2  2657  6 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 2657
by  Dave CurtisJump to last post
09/19/2013 12:55 PM
1 Replies and 1751 Views MS Addins LAUA security  1751  1 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 1751
by  John HenleyJump to last post
08/28/2013 12:18 PM
2 Replies and 1503 Views Query string from AddIns?  1503  2 Started by  George Graham Anyone know how to display/extract the query string from an Add Ins query
2 1503
by  George GrahamJump to last post
08/14/2013 9:35 AM
5 Replies and 1683 Views Add-Ins Performance Impacted by Upgrade  1683  5 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 ver...
5 1683
by  Greg MoellerJump to last post
08/05/2013 10:43 AM
4 Replies and 6705 Views Upload to HR11 User Fields with Excel Add-In  6705  4 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 6705
by  Dave CurtisJump to last post
07/22/2013 8:49 AM
2 Replies and 2739 Views Getting an error - anybody know the cause?  2739  2 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 2739
by  Greg MoellerJump to last post
07/12/2013 1:36 PM
16 Replies and 2535 Views Query with OR criteria timing out with Lawson 9.0.1  2535  16 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 2535
by  LauraJump to last post
06/19/2013 2:47 PM
0 Replies and 1317 Views AM20.3 add-ins upload to add serial number on each line  1317  0 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 1317
05/15/2013 12:01 PM
4 Replies and 8557 Views MS-Addins with Microsoft Excel 2007  8557  4 Started by  JohnS Does MS-Addins work with Excel 2007
4 8557
by  JohnSJump to last post
05/09/2013 4:46 AM
2 Replies and 9858 Views URL Connection and Login information not retained  9858  2 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 9858
by  KevinYJump to last post
05/01/2013 10:38 AM
2 Replies and 2978 Views Addins for 2013 ?  2978  2 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 2978
by  Greg MoellerJump to last post
04/11/2013 3:58 PM
0 Replies and 1014 Views Problem Uploading Large GL65 Files  1014  0 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 ...
0 1014
04/05/2013 12:51 PM
1 Replies and 1685 Views Unable to create a new Add-In Upload  1685  1 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 1685
by  Greg MoellerJump to last post
03/27/2013 1:01 PM
3 Replies and 1897 Views HR02 Add-in to change to Inactive  1897  3 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 1897
by  Deleted UserJump to last post
03/21/2013 5:03 PM
3 Replies and 3180 Views Lawson add ins active x error  3180  3 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 3180
by  GeorgetteJump to last post
03/04/2013 1:56 PM
0 Replies and 1263 Views AM30.1 Asset Transfer  1263  0 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 1263
01/29/2013 12:53 PM
7 Replies and 5070 Views Webuser or Profile error  5070  7 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 5070
by  J.ConnellyJump to last post
01/16/2013 3:58 PM
0 Replies and 1228 Views Mass changing benefits  1228  0 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 1228
01/04/2013 8:46 AM
4 Replies and 4136 Views PA02 Mapping File Error  4136  4 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 4136
by  Deleted UserJump to last post
12/19/2012 4:06 AM
0 Replies and 1155 Views Query Wizard - slow response moving thru tabs  1155  0 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 any...
0 1155
11/09/2012 3:24 PM
0 Replies and 1158 Views Add-Ins no longer support semi-colons  1158  0 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 1158
10/18/2012 3:13 PM
8 Replies and 3508 Views Add-ins - after log in - no Query Wizard popup screen?  3508  8 Started by  CindyW I have a user that constantly, well, okay, frequently has issues with her Add-ins.  I have had to reinstall it numerous times in the past few years.  She just got a new pc, and I installed our latest (same one that the rest of us use)  version of addins (9.0.3.1601).  She only uses the Query Wizard, so that is all I installed.  But when she logs in, she gets no popup screen - the 'Lawson Query Wizard for Excel' screen.  She gets nothing.  I mean it lo...
8 3508
by  CindyWJump to last post
10/11/2012 12: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 1 of 3123 > >>


RSS Feed Available