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 212 > >>
Topics
 Replies
 Views
 Last Post
6 Replies and 1144 Views Mass PO20 Line Cancellation Through Add-Ins  1144  6 Started by  vuleab Hello, I am trying to do an upload through add-ins to cancel PO lines in PO20.  I am getting a message 'Hit change again to confirm line cancellation.'  I would run change again, but the lines are still not cancelled. Does anyone know how to get this to work through Lawson add-ins  I have hundreds of lines.    I am on version 10.0.7.0.       Thank you! vuleab
6 1144
by  PdudowJump to last post
01/15/2019 3:38 PM
0 Replies and 166 Views BR40.1 Upload Help  166  0 Started by  andrusa Hello everyone,    Hoping you can help me create a BR40.1 (and/or BR40.3) upload template (especially mapping the fields). Currently, I'm reclassifying expenses from one task to another via BR40.1 - marking for transfer, then clicking on 'Transfer,' which takes me to BR40.3. In BR 40.3 I specify the new activity, category, vendor, amount, etc. I do this for every expense line item - a very time consuming task. I'm trying to create an excel upload to speed up the process. I'm a littl...
0 166
10/30/2018 12:37 PM
1 Replies and 2287 Views PO21.3 Distributions  2287  1 Started by  JonA I've got 132 distribution lines I want to upload to a PO line in PO21.3.  When I try it I get 'Purchase Order doesn't exist' These are the fields I'm using. (H),_f3,MMD-COMPANY (H),_f4,MMD-SYSTEM-CD (H),_f6,MMD-DOC-NUMBER _f9,MMD-LINE-NBR _f35:0,LINE-FC1 _f36:0,MMD-ACCT-UNIT1 _f37:0,MMD-ACCOUNT1 _f39:0,MMD-DIST-COMPANY1 _f42:0,MMD-DIST-QTY1
1 2287
by  DianaJump to last post
09/27/2018 8:18 AM
1 Replies and 456 Views Office 2010 and Lawson 10.0.7.0??  456  1 Started by  Tim S Our organization is using XexDesktop Windows 7 (32 bit) Office 2010 Plus (32bit) Lawson ver 10.0.1073 Office Add-in We need to get our teams to the Lawson 10.0.7.0 Office Add-in. My question is, and my vm testing supports these results, that Lawson 10.0.7.0 Office Add-in is NOT compatible with Office 2010.   Test Results: Windows 10 (64 bit) / Office 2016 (32bit) Lawson 10.0.4.0 - OK Lawson 10.0.7.0 - OK Lawson 10.0.8.0 - OK Windows 7 (32 bit) / Offic...
1 456
by  AlanKJump to last post
06/29/2018 6:04 PM
6 Replies and 1612 Views PO25.6 Line cost changes with add-ins  1612  6 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
6 1612
by  JonAJump to last post
06/21/2018 3:20 PM
2 Replies and 366 Views How do we find field numbers in lawson for MS Addins?  366  2 Started by  Nicholas Elliott Any help would be great
2 366
by  jamesracesonJump to last post
06/19/2018 7:58 AM
8 Replies and 4958 Views Add-Ins for Office 2016  4958  8 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....
8 4958
by  JuliaT1Jump to last post
05/21/2018 2:59 PM
2 Replies and 3257 Views AP10.5 Add In Upload Help  3257  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 3257
by  Carol SJump to last post
02/13/2018 11:24 AM
1 Replies and 795 Views upload reconciliation on CB80 error  795  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 795
by  Carol SJump to last post
02/12/2018 6:54 PM
2 Replies and 1085 Views PO30 & PO35 Addins  1085  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 1085
by  bruppJump to last post
02/06/2018 7:44 AM
19 Replies and 7938 Views RQ10 Upload Challenge  7938  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 7938
by  Kat VJump to last post
12/27/2017 7:51 AM
11 Replies and 2631 Views Addins Performance doubled with upgrade  2631  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 2631
by  drewlewis15Jump to last post
12/19/2017 3:57 PM
7 Replies and 2421 Views Add-Ins Peformance Issues  2421  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 2421
by  drewlewis15Jump to last post
12/19/2017 3:56 PM
0 Replies and 448 Views deleting values on AC13 via add-ins  448  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 448
11/08/2017 10:36 AM
0 Replies and 793 Views Help Needed: How to uninstall Spreadsheet Designer  793  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 793
08/09/2017 2:07 PM
1 Replies and 2095 Views Fatal Error: File FILERELFLD is secured  2095  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 2095
by  JimYJump to last post
04/05/2017 5:48 AM
2 Replies and 4053 Views PO25.8 Upload Error  4053  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 4053
by  cmjsJump to last post
12/02/2016 11:31 AM
9 Replies and 8548 Views Add-ins for Office 2013....  8548  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 8548
by  JimYJump to last post
11/16/2016 7:26 AM
4 Replies and 3166 Views Addin Templates  3166  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 3166
by  Tanya_DJump to last post
11/09/2016 3:40 PM
2 Replies and 1430 Views IC99.2 addins required fields  1430  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 1430
by  CherieOJump to last post
10/03/2016 7:21 AM
4 Replies and 1854 Views PO20 header comment  1854  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 1854
by  JonAJump to last post
08/16/2016 2:19 PM
0 Replies and 770 Views Lawson Query Wizard - How to return max value only  770  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 770
08/15/2016 1:32 PM
1 Replies and 1374 Views PO13 Inactivate Add-In  1374  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 1374
by  Kat VJump to last post
08/02/2016 3:28 PM
0 Replies and 1220 Views VBA code to launch lawson add-in 10.0.7  1220  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 1220
07/19/2016 7:42 AM
0 Replies and 798 Views Lawson 8 Copy Paste  798  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 798
07/12/2016 3:42 PM
10 Replies and 6342 Views Lawson Add-Ins query for RW100 report  6342  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 6342
by  vinayJump to last post
07/05/2016 8:49 AM
0 Replies and 773 Views Calling Employee Business Class DME  773  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 773
07/04/2016 10:26 AM
1 Replies and 2110 Views Add-ins error: New value must be spaces because line has no item  2110  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 2110
by  KelciJump to last post
06/22/2016 3:26 PM
14 Replies and 7966 Views Add-ins Resource  7966  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 7966
by  AndreaJump to last post
06/18/2016 5:07 PM
1 Replies and 1500 Views PO20 upload add-in  1500  1 Started by  NatalieD Would anyone be willing to share their upload wizard for PO20 creation Much appreciated!
1 1500
by  Kat VJump to last post
06/10/2016 8:56 AM
1 Replies and 2016 Views Add in Query for AP Data  2016  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 2016
by  JonAJump to last post
04/14/2016 12:56 PM
20 Replies and 15228 Views Query PO Comments Fields  15228  20 Started by  Freer Howdy, Does anyone know how to qurey the comments to print on purchase orders
20 15228
by  JonAJump to last post
03/29/2016 10:03 AM
1 Replies and 2050 Views 'Authorisation' for Addins  2050  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 2050
by  JonAJump to last post
01/26/2016 10:49 AM
3 Replies and 2275 Views Add-in PO25.6 trouble  2275  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 2275
by  Oscar SJump to last post
01/05/2016 3:27 PM
1 Replies and 1779 Views AR28 upload  1779  1 Started by  liz Upload to AR28. Keep getting an error 'Payment does not exist'. But payment is there. Any ideas
1 1779
by  lizJump to last post
11/13/2015 10:17 AM
1 Replies and 1767 Views Addins query for AC295 data  1767  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 1767
by  JonAJump to last post
11/11/2015 9:35 AM
6 Replies and 2033 Views Add-In not uploading to vendor master maintenance?  2033  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 2033
by  BethJump to last post
10/22/2015 9:40 AM
0 Replies and 1683 Views Add-ins ver 10.0.5 install problem (with Office 2013)  1683  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 1683
10/02/2015 2:24 PM
0 Replies and 1192 Views Add-ins for PO31  1192  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 1192
09/23/2015 1:59 PM
0 Replies and 1044 Views Uasing Addins To Load PO Match Invoices  1044  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 1044
09/21/2015 11:56 AM
0 Replies and 878 Views Uploading Employee Groups  878  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 878
09/01/2015 5:41 AM
1 Replies and 1886 Views Missing MAP COLUMNS in Upload Wizard  1886  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 1886
by  JonAJump to last post
08/21/2015 11:38 AM
1 Replies and 1682 Views Upload for SSN on HR13.1  1682  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 1682
by  Colleen BertagnolliJump to last post
08/19/2015 8:43 AM
0 Replies and 1204 Views Error 1404 when installing add-ins  1204  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 1204
08/17/2015 3:15 PM
1 Replies and 1852 Views GL Distrib and Vendor Details  1852  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 1852
by  JonAJump to last post
08/17/2015 8:16 AM
3 Replies and 2295 Views MS Addins Query GLAMOUNTS amounts in excel as text  2295  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 2295
by  dcaianiJump to last post
06/12/2015 1:32 PM
0 Replies and 951 Views automated scheduled uploads  951  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 951
06/08/2015 1:20 PM
0 Replies and 1190 Views MS Add Ins Upload Template for BN36.1  1190  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 1190
06/01/2015 9:20 AM
1 Replies and 1825 Views GLTRANS attributes  1825  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 1825
by  JonAJump to last post
05/15/2015 6:51 AM
0 Replies and 1678 Views Add-Ins upload in MS Excel 2010  1678  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 1678
04/08/2015 8:29 AM
2 Replies and 3108 Views Add-Ins FATAL ERROR  3108  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 3108
by  Therese ChaplinJump to last post
04/07/2015 2:30 PM
1 Replies and 1578 Views Add-ins for AR33.6  1578  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 1578
by  Todd MitchellJump to last post
03/31/2015 8:38 AM
8 Replies and 21890 Views Using add-ins with Excel 2010  21890  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 21890
by  MarkJump to last post
03/23/2015 10:43 AM
4 Replies and 3012 Views AddIns not loading properly  3012  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 3012
by  agershJump to last post
03/04/2015 12:59 PM
3 Replies and 2429 Views IC11.1 Add-In  2429  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 2429
by  Kat VJump to last post
02/24/2015 12:46 PM
1 Replies and 2134 Views Query  2134  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 2134
by  JonAJump to last post
02/19/2015 2:38 PM
0 Replies and 1443 Views Add In for Microsoft Office  1443  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 1443
02/19/2015 11:04 AM
1 Replies and 2084 Views BN32 and BN72 Uploads (Add-Ins)  2084  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 2084
by  David BrittonJump to last post
01/28/2015 10:29 AM
0 Replies and 1335 Views Add-ins for Smart Office  1335  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 1335
12/05/2014 12:44 PM
2 Replies and 1661 Views PR35.2 Upload multiple messages returns add complete continue  1661  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 1661
by  The.Sam.GrovesJump to last post
11/12/2014 9:44 AM
1 Replies and 1853 Views Does anyone have an Add-in Template for AM20.4?  1853  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 1853
by  mgreggJump to last post
11/04/2014 5:58 PM
2 Replies and 1823 Views Upload comments to IC18.1  1823  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 1823
by  JonAJump to last post
11/04/2014 2:35 PM
0 Replies and 900 Views PR35.2 Upload multiple messages returns add complete continue  900  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 900
11/04/2014 11:02 AM
2 Replies and 2456 Views Using Add-ins or Spreadsheet Designer for non-Lawson applications  2456  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 2456
by  Kat VJump to last post
10/02/2014 10:20 AM
12 Replies and 5987 Views upload RQ10  5987  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 5987
by  Kat VJump to last post
09/09/2014 3:19 PM
0 Replies and 1330 Views Upload to HR55.2  1330  0 Started by  BrianP Does anyone have a working template they are willing to share  We are using Lawson 9.1. Thanks, Brian
0 1330
09/08/2014 10:05 PM
2 Replies and 2356 Views Add in for benefit rates?  2356  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 2356
by  Terry PJump to last post
08/12/2014 7:28 PM
3 Replies and 7016 Views Invalid One To Many Filtering  7016  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 7016
by  jwilcoxsonJump to last post
07/10/2014 4:24 PM
1 Replies and 1919 Views PO25.7 Upload to Change Cost on Lines  1919  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 1919
by  JonAJump to last post
05/27/2014 1:42 PM
2 Replies and 1750 Views Add-ins Speed  1750  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 1750
by  Gary StoneJump to last post
05/02/2014 8:26 AM
4 Replies and 3285 Views Add-Ins Login  3285  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 3285
by  MetrazalJump to last post
02/11/2014 2:05 PM
6 Replies and 4527 Views Upload to HR55.3  4527  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 4527
by  Michelle OlsonJump to last post
02/10/2014 1:50 PM
2 Replies and 3094 Views Self contained GL40 JE upload template  3094  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 3094
by  Display NameJump to last post
02/06/2014 8:03 AM
2 Replies and 2483 Views Upload for IC12.1 and IC12.2  2483  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 2483
by  JimYJump to last post
02/02/2014 5:31 PM
7 Replies and 5034 Views Uploading Budgets (FB20.1) using Add-Inns  5034  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 5034
by  LorraineJump to last post
01/16/2014 11:19 AM
2 Replies and 2374 Views HR11 Addins template  2374  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 2374
by  ReemaJump to last post
12/23/2013 1:30 PM
1 Replies and 2094 Views template for AC10 ms addins upload  2094  1 Started by  jennifer does anyone have a template for AC10 ms addins upload template
1 2094
by  Jimmy ChiuJump to last post
12/10/2013 11:11 AM
3 Replies and 2483 Views Addins query for IC11.7  2483  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 2483
by  JonAJump to last post
11/08/2013 12:45 PM
2 Replies and 1758 Views Invoice changes and modifications  1758  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 1758
by  TomJump to last post
10/28/2013 8:11 AM
1 Replies and 1862 Views Need Help Pulling in UOM pricing in PO28  1862  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 1862
by  LauraJump to last post
10/17/2013 6:39 AM
0 Replies and 1182 Views S3 Upload Wizard won't always open saved mappings  1182  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 1182
10/15/2013 2:55 PM
7 Replies and 4429 Views AP16.2 must inquire first  4429  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 4429
by  darwin collinsJump to last post
10/03/2013 3:23 PM
12 Replies and 2638 Views Help..Not getting anywhere with Lawson Support...DME no data  2638  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 2638
by  RonnieJump to last post
09/23/2013 8:11 AM
6 Replies and 3078 Views uploading to HR15.2  3078  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 3078
by  Dave CurtisJump to last post
09/19/2013 12:55 PM
1 Replies and 1958 Views MS Addins LAUA security  1958  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 1958
by  John HenleyJump to last post
08/28/2013 12:18 PM
2 Replies and 1828 Views Query string from AddIns?  1828  2 Started by  George Graham Anyone know how to display/extract the query string from an Add Ins query
2 1828
by  George GrahamJump to last post
08/14/2013 9:35 AM
5 Replies and 1949 Views Add-Ins Performance Impacted by Upgrade  1949  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 1949
by  Greg MoellerJump to last post
08/05/2013 10:43 AM
4 Replies and 7503 Views Upload to HR11 User Fields with Excel Add-In  7503  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 7503
by  Dave CurtisJump to last post
07/22/2013 8:49 AM
2 Replies and 3284 Views Getting an error - anybody know the cause?  3284  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 3284
by  Greg MoellerJump to last post
07/12/2013 1:36 PM
16 Replies and 2927 Views Query with OR criteria timing out with Lawson 9.0.1  2927  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 2927
by  LauraJump to last post
06/19/2013 2:47 PM
0 Replies and 1522 Views AM20.3 add-ins upload to add serial number on each line  1522  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 1522
05/15/2013 12:01 PM
4 Replies and 9032 Views MS-Addins with Microsoft Excel 2007  9032  4 Started by  JohnS Does MS-Addins work with Excel 2007
4 9032
by  JohnSJump to last post
05/09/2013 4:46 AM
2 Replies and 10138 Views URL Connection and Login information not retained  10138  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 10138
by  KevinYJump to last post
05/01/2013 10:38 AM
2 Replies and 3316 Views Addins for 2013 ?  3316  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 3316
by  Greg MoellerJump to last post
04/11/2013 3:58 PM
0 Replies and 1292 Views Problem Uploading Large GL65 Files  1292  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 1292
04/05/2013 12:51 PM
1 Replies and 1958 Views Unable to create a new Add-In Upload  1958  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 1958
by  Greg MoellerJump to last post
03/27/2013 1:01 PM
3 Replies and 2232 Views HR02 Add-in to change to Inactive  2232  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 2232
by  Deleted UserJump to last post
03/21/2013 5:03 PM
3 Replies and 3947 Views Lawson add ins active x error  3947  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 3947
by  GeorgetteJump to last post
03/04/2013 1:56 PM
0 Replies and 1477 Views AM30.1 Asset Transfer  1477  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 1477
01/29/2013 12:53 PM
7 Replies and 5706 Views Webuser or Profile error  5706  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 5706
by  J.ConnellyJump to last post
01/16/2013 3:58 PM
0 Replies and 1420 Views Mass changing benefits  1420  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 1420
01/04/2013 8:46 AM
4 Replies and 4471 Views PA02 Mapping File Error  4471  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 4471
by  Deleted UserJump to last post
12/19/2012 4:06 AM
0 Replies and 1357 Views Query Wizard - slow response moving thru tabs  1357  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 1357
11/09/2012 3:24 PM
0 Replies and 1351 Views Add-Ins no longer support semi-colons  1351  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 1351
10/18/2012 3:13 PM
8 Replies and 4002 Views Add-ins - after log in - no Query Wizard popup screen?  4002  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 4002
by  CindyWJump to last post
10/11/2012 12:13 PM
0 Replies and 1288 Views PA71 Job Budget upload  1288  0 Started by  Deleted User Can MS Addins be used to upload job budgets to PA71  I have a spreadsheet of records to be add and to expire existing ones.
0 1288
09/06/2012 7:27 AM
0 Replies and 1834 Views Using Addins to Set-up New Hires PR12  1834  0 Started by  MattH Hi, We receive a file from an onboarding web site as our employees are hired which contains their PR12/direct deposit information.     Each employee may have up to 3 deposit records. Has anyone done much with the PR12 upload for new hires   It seems to be working very well for me with a single upload record, but, when I get multiple, it always wants to make the first record the Default Account and I haven't found away to have it auto-assign ACH Distribution Number. Also, w...
0 1834
09/04/2012 5:45 PM
5 Replies and 2555 Views Update to HR11 works in LID but not Add-Ins  2555  5 Started by  Dennis Setliff We are still using LAUA/LID. I can directly update the Phone Number on HR11 in our Dev and Prod environments/product lines. I can us Add-Ins to update the Phone Number through HR11 in our Dev environment/product line but I get a 'Security violation' return message in our Prod environment/product line. I copied the security class from Dev to Prod thinking there may be a difference in LAUA but still get the same message. Any suggestion on where or how I could track down the 'Securit...
5 2555
by  Dennis SetliffJump to last post
08/21/2012 2:55 PM
2 Replies and 4003 Views DME Query String  4003  2 Started by  AJ I am trying to go through the DME query wizard in MS Addins to produce a DME query for an infoset that I want to create.  I am using the S3 query wizard and selecting database tables as the query source.  I go through and select the tables and fields that I want to return and add the criteria under the criteria tab.  However, when I click the view string icon at the top of the dialog box, the entire query string is not being shown. I do not see the fields that I selected or any of...
2 4003
by  AJJump to last post
08/09/2012 12:23 PM
4 Replies and 2802 Views Query brings back dates, but excel 2010 displays as a number  2802  4 Started by  Terrie We were on Windows XP, Office 2010, and when I did a query, it brought back the data in excel and displayed correctly.  We recently upgraded laptops to Windows 7.  Now when I do same query, it brings back data and displays dates as number. It only does this for me.  It doesn't do that on another person laptop who was give Windows 7. Has anybody seen or experienced this  Any suggestions on what I can do to stop this Thanks
4 2802
by  TerrieJump to last post
07/25/2012 1:37 PM
2 Replies and 2246 Views Special Characters Introduced through AddIns  2246  2 Started by  Allison Terry Hello, I'm new to Lawson. I work with addins while maintain the Item/Vendor Masters... Every once in a while a special character gets loaded into the Lawson database that is not on our excel worksheet or it is hidden.  We make every effort to copy and paste using Puretext and we remove spaces but these characters are still introduced.  I wanted to know if anyone else has had this issue and what they did to resolve the problem. Thanks. Allison
2 2246
by  Allison TerryJump to last post
07/03/2012 3:17 PM
5 Replies and 2916 Views Blanking Out a Field (GL20.7)  2916  5 Started by  Dave Mitchell I've tried everyting I can think of, excepting any 'special characters', from a space, to multiple spaces, to a hyphen, and nothing seems to work. We're on Lawson 9.01 with Lawson S3 Add-In's (version 9.0.3.1) using Excel 2010 on Windows XP. If anyone has an idea, my email is Mitchell.Dghc.org 
5 2916
by  Dave MitchellJump to last post
06/21/2012 9:22 AM
9 Replies and 6186 Views Add Ins Error  6186  9 Started by  Deleted User Can someone tell me what this addins error may mean - Filter cannot begin with '&' or '|' We just moved to apps v901, and queries that have never had problems are now returning this error.  Seems to happen most often if I try to use criteria that is any option other than '='.  I'm on the most recent add-ins version Thanks in advance - I'm almost bald from pulling my hair out over this one!!
9 6186
by  Sherry ShimekJump to last post
06/06/2012 10:41 AM
1 Replies and 2154 Views HOLD CODE Query Assistance  2154  1 Started by  Katfra Hello, Could someone give me a little assistance in writing a query in AP that would give me HOLD CODES  I've tried different combinations with tables to achieve this but failed each time.  I'm trying to produce a query that give me the following: Company, Invoice, Invoice DTE, Invoice Description, Process Level, Vendor, Vendor-Vname, Vendor Group, Tran Inv Amt.  I've used the APINVOICE and APPAYMENT tables and was able to pull in the HOLD CODE fields due to relationshi...
1 2154
by  JonAJump to last post
05/18/2012 6:47 AM
0 Replies and 1706 Views Upload in ZQ20 Contact Tab  1706  0 Started by  upasana Hello, Could anyone please help me in knowing the process if any field is required to be changed in ZQ20 what should be the parameters of excel file to be uploaded and what should be the process to be followed. I need to make changes in ZQ20 Contact 4 MISC details. Please let me know about the upload function and the relevant field name that is to be used. Thanks in Advance Upasana Mehra
0 1706
05/11/2012 11:12 AM
1 Replies and 2101 Views All Position in a Process Level  2101  1 Started by  upasana Hello, Could anyone please help me in writing a query to provide positions with their respective Job Codes in a Process Level using Lawson AddIns. I need this information for various clients. Thanks in Advance Upasana Mehra
1 2101
by  WoozyJump to last post
04/16/2012 4:36 PM
0 Replies and 2159 Views Upload Multi-Line invoice to BL20?  2159  0 Started by  katsmily Hello! My company uses the Lawson Excel Add-In to upload into Lawson.  One of the things we upload are invoices into BL20.  We are able to upload a number of different invoices and even invoices with up to 4 lines.  But we're unsure how to create an excel file to upload invoices with more than 4 lines.  Right now our 4 line invoice upload file has the difference lines listed horizontally across the columns in excel, using fields F100:0,F102:0,F103:0,F107:0, etc through F100:...
0 2159
04/11/2012 1:13 PM
1 Replies and 2680 Views Trying to create DME query that returns blank and/or constants  2680  1 Started by  David Britton I am trying to build a DME query that will return a variety of fields from the EMPLOYEE and PAEMPLOYEE tables, but I need to include a number of either Constant fields (such as 'P') or blank fields. For the blank fields I could try to find a table field that is always blank that that seems kind of tacky and dangerous. Any suggestions. I tried just including constants in both single quotes and double quotes in the DME string but always got an error. The record format is: 'P' ,' ' , 'City...
1 2680
by  Robert SpurrJump to last post
03/19/2012 3:20 PM
0 Replies and 1425 Views BN81 Upload  1425  0 Started by  Jodi Kruesel Has anyone been able to use/create an upload to BN81  I'm able to add records to BN81 but am still trying to get the Release function to work.   Any help would be appreciated.
0 1425
03/12/2012 4:26 PM
2 Replies and 2297 Views Moving employees into new company with add-ins  2297  2 Started by  BL I have created a new company and added the accounting untits with add-ins, but now I am challenged with adding all the old company employees into the new company.  I thought I could extract the data from the Employee table, but there are so many lines that add-ins pul 100 lines at a time and not I'm not so sure that is the right route to go. Does anyone have any ideas either about using add-ins or a Lawson template to expedite the process
2 2297
by  BLJump to last post
03/06/2012 5:11 PM
1 Replies and 2906 Views PR35.2 Change fields on 2nd page  2906  1 Started by  ISO Dan Hello, I am doing a DME to retrieve information from the TIMERECORD table and want to make changes to the second page using the PR35.2 Lawson Add Ins.  Since the PR35.2 only has 10 lines, how would you make a change to a field on line 12 (need to page down to get to the second page) Thank you,
1 2906
by  John HenleyJump to last post
01/05/2012 11:46 AM
2 Replies and 2660 Views Various reports needed related with EE History  2660  2 Started by  upasana Hi, I am currently working on an analysis of our clients and I need below details from Lawson. It will be great if anyone of you can help me in getting the details using Lawson / Lawson Add Ins. 1. For every New Hire entered in Lawson during a period. Employee ID, Process Level, GBU, Processor Id (who entered the Employee in Lawson), Time of entering the Employee in Lawson. 2. For every Personnel Action processed in Lawson during a period including changes in PA52, PR12, ...
2 2660
by  Greg MoellerJump to last post
12/09/2011 2:09 PM
0 Replies and 3469 Views Citrix and MOA  3469  0 Started by  Greg Moeller Sorry for the double-post, but I felt this was applicable to both System Admin, and MOA. When we run a particular query from our MOA install on Citrix, we notice that there are some missing records returned. Just for grins, I tried running the MOA query from a local install.  This returned all records that qualified.  (*There were 5 records returned on the local install that just never were for the Citrix install.) Question:  What have others been doing  There is no...
0 3469
12/06/2011 10:56 AM
2 Replies and 4437 Views addin upload error  4437  2 Started by  Lynda User is getting FATAL ERROR when trying to upload file to BN31.1 'Incident_Id1321623691888-0000 An error occured outside of IOS while accessing Lawson Security Any help would be greatly appreciated, thanks Lynda
2 4437
by  mark.cookJump to last post
11/22/2011 9:06 AM
3 Replies and 3979 Views AM20.5 MS Add-In Template  3979  3 Started by  Whitney Johnson Trying to develop a MS Add-In template for AM20.5 to upload new entries. We haven’t been successful due to hidden keys. Does anyone have any suggestions on how to resolve this
3 3979
by  Dave MitchellJump to last post
10/13/2011 8:46 AM
1 Replies and 2295 Views Add Ins Query of Open Checks  2295  1 Started by  Beth This seems to me it would be a simple query, but I can't pull all of the info that I need.  I want a simple list of any open checks for a particular cash code, along with the vendor Name and address for mailing due diligence letters.  Does anyone have any suggestions
1 2295
by  Sam SimpsonJump to last post
09/21/2011 3:14 PM
1 Replies and 1840 Views Special Actions  1840  1 Started by  Srini Rao Hello - How DO I use Special functions in MOA's upload wizard. For eaxmple, PO31 has special functions like copy, cancel etc.  We are working on inventory clearence and I may need to upload more then 10,000 records to PO31 using special actions.   
1 1840
by  John HenleyJump to last post
09/20/2011 10:47 AM
3 Replies and 3021 Views HR06 upload  3021  3 Started by  Karen Sheridan We need to upload salary range values to HR06 and are using the HR06 upload template from the MyLawson Market Place. We are getting the error: Employees exist for this job code; OK to change currency If the 'Ignore' box is checked on the upload tab - no return message is given There are a number of hidden fields including a hidden key. WHen I use the HK field with company job code, I get the 'You must inquire first' error; no ignore and no message with ignore checked. Anyone have ...
3 3021
by  Shane JonesJump to last post
07/29/2011 8:55 AM
2 Replies and 2158 Views IC24 release  2158  2 Started by  TracyO I have created an add-in upload for IC24, that adds the headers then I go back and do a change only to add all the lines but now need to do a mass release.  I tried to add another upload to do a change with the FC code of R and that does not work.  Any one doe this or something on a similar screen that needs a header, details, then needs to be released
2 2158
by  JonAJump to last post
07/26/2011 7:20 AM
3 Replies and 5896 Views Upload Wizard does not launch - 9.0.3.1  5896  3 Started by  David Hi all, hoping someone can help me! We have the Lawson add-ins, 9.0.3.1.1387 (latest patch) installed on Excel 2003, XP SP3 and we are experiencing an issue with the Lawson Upload Wizard.  When a user tries to log on, they are met the with logon dialog box displaying the server, username and password fields as expected.  When they click ok, the logon screen disappears and then nothing happens.  The Upload Wizard does not display and no error is produced.  The Query Wi...
3 5896
by  DavidJump to last post
07/20/2011 9:52 AM
5 Replies and 3460 Views Data extract field  3460  5 Started by  Jeff in PA I'm currently trying to use MS Add-In to extract data from the Payroll system.  Specifically I am looking to get employee information including those employees whose bi-weekly hours are set to a fixed distribution.  I've looked high & low and cant seem to find a field.    HM-ACCT-UNIT is no problem, I get their home department but I cant find the other field I've mentioned.  Does such a field exist & if so where  Thanks Jeff
5 3460
by  Jeff in PAJump to last post
07/18/2011 1:01 PM
3 Replies and 4726 Views Upload Error - new value must be spaces  4726  3 Started by  Amy Sweek Trying to change salary class (H instead of S) for employees.  My upload is returning an error message stating 'new value must be spaces because line has no item'.  Been doing uploads for a few years and haven't seen this message before.  Anyone have guideance on how to proceed
3 4726
by  AngiePJump to last post
07/12/2011 10:39 AM
0 Replies and 1813 Views Addin for LP80  1813  0 Started by  Paul Berkowitz Is there a why to use LP80 to perform a mass transfer to manual PTO plans. LP80 requires Transfer Actions, the Transfer 'T' is is assigned to F1 however the LP80 addins does no thave F1 as an options. Is there another way Thank you Paul
0 1813
07/05/2011 2:58 PM
2 Replies and 2109 Views Add-Ins Upload 903  2109  2 Started by  This_Guy So I have a spreadsheet ready to upload to a form, however there are no PDLs / Forms to select from when I try to Map the columns We are LSF9017 / Apps 901 MSP5, SQL2008, Windows 2003 Any ideas Is it something is LS
2 2109
by  JonAJump to last post
06/30/2011 12:49 PM
8 Replies and 15019 Views Timeout in ADDINS  15019  8 Started by  Jim Howerton The size of our tables seems to have reached a point where most queries run through ADDINS times out. Does anyone know of a setting that controls the amount of time a query may run before it fails with a timeout This also occurs using the OLEDB drivers and Crystal.
8 15019
by  Greg MoellerJump to last post
05/20/2011 3:53 PM
3 Replies and 2550 Views Addins Query no pulling all data  2550  3 Started by  JonA Trying to query POVAGRMTLN and I'm not getting all the lines for a particular agreement. Even when I specify the VEN-AGRMT-REF in the index the query gives me only 227 lines when I can see 371 in PO25.6.  Any ideas why this is happening
3 2550
by  JonAJump to last post
05/05/2011 7:17 AM
7 Replies and 8484 Views Anyone using Add-ins with Windows 7?  8484  7 Started by  CindyW We are having a problem with users that have just upgraded to Windows 7 and can no longer log in to the Lawson Add-ins.  They are using the same version of Office/Excel as before (2007).  I opened a case with Lawson and they state that Add-ins is 'not certified to run with Windows 7 or VISTA.  Well I have VISTA (and Office 2007), and I can user the add-ins fine.  So I'm curious if there are any other folks out there have been successful in running the add-ins on a W...
7 8484
by  CindyWJump to last post
04/29/2011 4:02 PM
0 Replies and 2009 Views Query and upload to Comments fields  2009  0 Started by  Sherry Shimek Hello.  We are are making multiple distribution adjustments to change the accounting unit and activity/account category for a major project.  To provide a cleaner audit trail, we would like to add a standard comment indicating the change was made for this project and a reference for further documentation. Is it possible to upload to the AP Distribution or Invoice Comments fields  And is it possible to query them Thank you, Sherry Shimek
0 2009
04/29/2011 10:26 AM
3 Replies and 2436 Views Lawson Webinar today at 10: am CST on how to Constructing Efficient Data Queries Using Lawson Add-Ins  2436  3 Started by  Ruma Malhotra Topic: Constructing Efficient Data Queries Using Lawson Add-Ins for Microsoft Office Host: Lawson Webinars Date and Time: Thursday, April 28, 2011 10:00 am, Central Daylight Time (Chicago, GMT-05:00) Event Number: 665 619 705 Event Password: This event does not require a password Registration ID: This event does not require an enrollment ID
3 2436
by  Ruma MalhotraJump to last post
04/28/2011 11:09 AM
1 Replies and 2320 Views Add Stop Date in PR12 via AddIns  2320  1 Started by  upasana Hi, Can anyone please confirm how to use Upload Wizard (via AddIns)for adding stop Direct Deposit date for all the employees terminated through Mass Uploadation. In our company we are having a big client where 'n' number of employees were terminated by using AddIns, but we find that Direct Deposit is still Active in PR12 screen. A Stop Date needs to be entered for all those employees in PR12, Is there a query that can be uploaded to add end date in PR12 Screen. Thanks in advance. Upasana M...
1 2320
by  upasanaJump to last post
04/26/2011 5:25 AM
0 Replies and 1759 Views GL20 Query with LSF Security  1759  0 Started by  Wade-T Hello, We currently have a program that performs manual tasks for us that is currently logging on as a termed user that has LID security.  I am working on getting these tasks moved over to a non-employee account and set up LSF security locked down to only the data the program needs to complete the task. The first one being GL20.1 inqueries. I have given access to the 7 fields that need to be pulled, as well as the program, token, files, data source, and some elements with Unconditiona...
0 1759
03/31/2011 9:11 AM
4 Replies and 3100 Views MAI & PA52.1/PA56.1 comments  3100  4 Started by  kadkins Is there a way, either using a Lawson Conversion Report or MAI's, to load comments tied to a personnel action at the time the action is updated Thanks in advance!
4 3100
by  Carl.SeayJump to last post
02/23/2011 1:48 PM
3 Replies and 2619 Views PO 25 Upload  2619  3 Started by  Boyd Does anyone have any templates, that they are willing to share, that would assist in uploading standing orders to PO 25  
3 2619
by  Dave MitchellJump to last post
02/10/2011 8:53 AM
2 Replies and 1871 Views AR addins wont return all the rows  1871  2 Started by  Deleted User Hello, I'm using the Excel Addins to query a form (AR90.1) and while I&160;do receive data, I only return 11 rows.&160; I know the data query should return a few hundred rows.&160; I've set the number of rows limit to 9999 and still not difference.&160; Any ideas
2 1871
by  JonAJump to last post
02/02/2011 12:16 PM
3 Replies and 7177 Views Query wizard  7177  3 Started by  prav Hi all, I am trying to write a query to get a list of all the vendors and their addresses that had payments in 2010 with the total payment above $600. My idea is to use APPAYMENT as the main file and then use the relation to APVENMAST to get the vendor related info. Now when I am entering selection criteria, how can I enter something like sum(TRN-CHK-AMT) > 600 Does the query wizard allow to use column functions Greatly appreciate your help in this.
3 7177
by  JonAJump to last post
02/02/2011 11:38 AM
3 Replies and 2063 Views Connect Lawson 8 Environment  2063  3 Started by  Rajantonyv When trying to connect using MS Add in to a Lawson 8 (Office 2007/Office 2010), what are the steps  Does the user need to be given appropriate permission  Does anyone have any docs that can be applicable to Lawson 8 please
3 2063
by  mark.cookJump to last post
12/30/2010 7:36 AM
1 Replies and 3448 Views Change Issue Method on PO20.2  3448  1 Started by  LouP We are trying to change the issue method on PO 20.2. I created a uwf file sometime earlier this year which worked fine. Now I cannot find the file and do not remember the format...Help!!
1 3448
by  Vijay SJump to last post
12/29/2010 12:08 AM
1 Replies and 1362 Views Optional processing of blank field!  1362  1 Started by  Vijay S I have a requirement In MS ADDINS. It says that If Cell is kept blank on the Excel template for that column it should not change that corresponding field value in the Lawson form (such as AP30.1) but if some value is entered in that cell the corresponding field value in Lawson form should be changed. Is it possible via Lawson MS Addins
1 1362
by  JonAJump to last post
12/27/2010 7:23 AM
3 Replies and 1668 Views Help Uploading to HR54  1668  3 Started by  hussey1213 The problem I'm having is identifying the record that needs to be updated. The upload is assuming that the first record is the record being updated but that's not the case. Is there a way around this
3 1668
by  Shane JonesJump to last post
11/24/2010 3:03 PM
3 Replies and 2202 Views Upload to BL34 Inquire then change  2202  3 Started by  TracyO I am trying to create an upload wizard for BL34.&160;When in Portal you must first inquire on this screen with the Company, Frequency, Cycle COde &&160;AOC description, then you can enter the line-fc C and the amount.&160;&160;I had read on an old post here that Add-Ins automataically does an inquire before it trys to do the change function that I am uploading. &160;When I try to procees my upload I get the error message:&160; Customer recurring invoice does not exist.&160; I&160;als...
3 2202
by  Karen PloofJump to last post
11/10/2010 12:31 PM
8 Replies and 3446 Views List of Process Level in a Process Group  3446  8 Started by  upasana Hi, Can anyone please confirm me how to get list of all the process level in a Process group. Currently I am working for a company with many clients having different process level. We have set up such clients with Process Group. Now I want to know all the existing Process Group with their respective Process Level. Please confirm. Thank you for the feedback.
8 3446
by  upasanaJump to last post
09/09/2010 1:15 AM
1 Replies and 2675 Views PO header comments  2675  1 Started by  Deleted User Does anyone know if it is possible to upload information into the PO comments fields on PO20(the PO header comments)
1 2675
by  Ruma MalhotraJump to last post
09/02/2010 10:24 AM
0 Replies and 2963 Views Add Ins not showing in Excel  2963  0 Started by  mark.cook Do you guys know why Excel, when opened by VB code or from email attachments doesn't include the Lawson macro button on the toolbar
0 2963
09/01/2010 1:45 PM
1 Replies and 1937 Views Lawson ADODB - Update a form field defined as VS Problem  1937  1 Started by  RayB I am attempting to set the value of the AMD-ORIG-AMT defined as a VS (17 length, 2 decimals) field type on form AR21.3. What would the format string for updating this field I assumed '0.00;0.00-' but this failed! BTW I am attempting to upload data from an excel worksheet using vba/adodb. Thanks, Ray
1 1937
by  RayBJump to last post
08/27/2010 2:58 PM
9 Replies and 6058 Views Add-Ins issue with Excel 2007? Limited to 65k lines?  6058  9 Started by  MBJH Is it a known issue that add-ins&160;Query&160;Wizard&160;only returns 65521 lines even when used with Excel 2007 Excel 2007 allows many more lines than that, but my query results still max at 65k. Any ideas
9 6058
by  MBJHJump to last post
08/24/2010 4:24 AM
3 Replies and 8014 Views Speadsheet Designer  8014  3 Started by  Lisa Stewart Any one heard of a Lawson Product called spreadsheet designer that is supposed the take the place of excel add-ins If so could you share what you know about it
3 8014
by  John HenleyJump to last post
08/20/2010 12:40 PM
4 Replies and 2654 Views Get Field Translation in DME Query  2654  4 Started by  Woozy I'm building a DME query against the LOGAN WFWORKUNIT table. I want to include the description of the WF-STATUS field values (which are setup in dbdef), but I can't figure out how to do it. Is there some trick to including the descriptions in the query /servlet/Router/Data/ErpPROD=LOGAN&FILE=WFWORKUNIT&FIELD=WORKUNIT;WORK-TITLE;PROCESS-NAME;WF-STATUS;WF-RM-ID;&OUT=XML Thanks! Kelly
4 2654
by  WoozyJump to last post
07/08/2010 9:30 AM
4 Replies and 2793 Views ERROR... can't use Selection Criteria...Related Table Fields and Parenthesis  2793  4 Started by  FireGeek21 Hi Everyone, We are receiving the following error when attempting to create output using MS Addins: ERROR. You cannot use Selection Criteria that contains both Related Table Fields and Parenthesis. Not sure how to resolve this... We are building output to include the following: -Dependent's Name -Benefit Plan Type (HL; DN) -Benefit Start-Date -Benefit Stop-Date -Dependent's Relationship -Dependent's Consent -Employee's Date of Hire -Employee's Name -Employee's Company ...
4 2793
by  FireGeek21Jump to last post
06/14/2010 3:45 PM
6 Replies and 4284 Views ACTRANS, APDISTRIB, CBDISTRIB, & GLTRANS Query with duplicates  4284  6 Started by  Sherry Shimek One of our users has queries set up by a former consultant that uses ACTRANS as the base table and fields from related tables APDISTRIB, CBDISTRIB, and GLTRANS. Prior to running the queries this month, the user was getting correct data.&160; She doesn't remember making any changes to the query and now she is getting multiple duplicate records.&160; The file was only 6k lines last month and now is 60k. Are there indices or other parameter settings that restrict the data to not pull duplicates...
6 4284
by  Sherry ShimekJump to last post
03/19/2010 3:03 PM
0 Replies and 2255 Views LSF 901/Apps 901 Add-Ins Issues  2255  0 Started by  MattD Gurus, We just upgraded to LSF 9015 and Apps 9012.&160; We are now having issues with our MS Add-Ins.&160; Lawson has provided us with several updated versions of Add-Ins to correct different issues, but we are still receiving the below error.&160; The biggest issue is that there is no good way to track what is going wrong.&160; I&160;have reviewed the system logs including ios, the Websphere logs, and the log generated by Add-Ins itself.&160; None have shown any issues.&160; Any ideas o...
0 2255
03/17/2010 1:33 PM
1 Replies and 2450 Views License question  2450  1 Started by  pmeckes Does anyone know if the licenses for ms add ins are by concurrent users The license information for ms addins only states 'Named Users' .&160;How is everyone handling the&160;installs&160;&160;
1 2450
by  mark.cookJump to last post
03/08/2010 7:10 AM
6 Replies and 3723 Views Lawson Addins LSF9 'Time out' problems  3723  6 Started by  Deleted User Since the upgrade to LSF9 (and patches that were since installed) I am experiencing problems running large queries using Lawson addins. I am getting a 'time out' message regularly or a 'Fatal error' message very occasionally. The IS department is telling me that this is causing problems with slowing down the users of Lawson Portal but I cannot understand why this did not happen previously as I have been using the same query regularly for almost 4 years. I have to run large data sets regularly an...
6 3723
by  Dave MitchellJump to last post
02/19/2010 10:44 AM
11 Replies and 5193 Views Server Resources for Addins  5193  11 Started by  itsjustme Has anyone had their Admins or Server folks complain about the resources that queries are taking up Does anyone restrict users to predefined queries and ensure that any new queries are created in a test environment to prevent odd table joins from hitting production Either we have some tuning to do or our users are building their queries wrong. Thank you for any response or organizational direction that can be provided. &160;LSF9, 8.0.3 MSP11 Apps, UNIX server w/websphere etc all on same b...
11 5193
by  itsjustmeJump to last post
02/12/2010 10:20 AM
6 Replies and 7172 Views Attach .uwf file for users in Word document  7172  6 Started by  Sherry Shimek I have created a Word document for our users that I easily attached a Excel template for uploading into Lawson.&160; However, I haven't found a good way to attach the .uwf file so the user can save it to their computer and upload the data. Any suggestions
6 7172
by  Dave MitchellJump to last post
02/09/2010 3:05 PM
4 Replies and 11651 Views Lawson query wizard not showig up in MS Excel  11651  4 Started by  RobertL I use Tools-->&160;Add-Ins menu in Excel to add Lawson query wizard. It works but after I close Excel and re-open it, the query wizard Add-In does not show up in Excel. I have to go to Tools-->&160;Add-Ins menu to add the Lawson query wizard everytime when I open Excel. Please advise. Thanks.
4 11651
by  RobertLJump to last post
02/01/2010 1:55 PM
2 Replies and 1940 Views Where does the APVENBAL(MA95) table get its data?  1940  2 Started by  willz06jw Hi and thanks for your help, I am trying to use the APINVOICE and APPAYMENT tables to calculate similar results as what shows up in the PURCH section of the&160; APVENBAL&160;table (this is where MA95 is grabbed)...but they are always too high.&160; Any ideas Thanks, Will
2 1940
by  willz06jwJump to last post
02/01/2010 1:41 PM
4 Replies and 4012 Views Using Lawson Queries to pull the transmission type from PO20 data (EDI or FAX?)  4012  4 Started by  willz06jw Thanks for your help, &91;I am using Lawson 9.0&93; I am trying to use Lawson Queries in Excel to pull the transmission type from the data for PO20.&160;&160; For example: I need to know if the POs for last year were sent via fax, edi, or paper.&160;&160; Thanks again for your help, Will
4 4012
by  JonAJump to last post
12/17/2009 2:04 PM
1 Replies and 2470 Views po20 only loads first 5 lines  2470  1 Started by  TimD I down loaded the PO20.1 upload from http://solutions.lawson.com/lu/addins/main.htm When I try to use it, it will only load the first five lines of the po and then I get the error message : Cannot enter vendor item different from existing This message appears after every five records beyond the first five that worked. What is causing this issue I'm trying to upload 100 lines to a po. If I&160;change the temp po number after every 5...
1 2470
by  JonAJump to last post
12/17/2009 1:51 PM
12 Replies and 2797 Views Add-ins very slow after LSF 9 upgrade  2797  12 Started by  Linda Wilson We just upgrade to LSF&160;9, and are on 8.1 apps.&160; Add-in queries are painfully slow now and many times won't finish (queries that ran in less than a minute are now running 30 minutes).&160;&160; Any ideas what might be causing this&160; Seems to be particularly with add-in queries that are using more than one table.&160; Thanks
12 2797
by  tamJump to last post
12/01/2009 3:13 PM
2 Replies and 3556 Views Invalid Date using Upload Wizard  3556  2 Started by  Staci B Hello, My goal is to delete the medical plan for a group of ee's and add it back.&160; I used Lawson's KB 521719 to determine the required fields for mapping, but I get the following message: Invalid Date: BEN-STOP-DATE1.&160; I've changed the format of the date from YYYYMMDD to MMDDYY to MMDDYYYY and nothing is working.&160;
2 3556
by  Brad SchauerJump to last post
11/30/2009 2:31 PM
2 Replies and 2667 Views Query Help Needed  2667  2 Started by  Harry I'm looking for assistance with an Lawson excel query. The query pulls employee information (name, work location, pay rate). My problem is trying to get pay rate information 'as of' a defined date. My query currently pulls information on employees that were employed on the defined date (i.e. 12/31/2008) but its downloading the employees current rate of pay, not their rate of pay on the defined date (i.e. 12/31/2008). Any idea on the query criteria that would solve this problem Thanks
2 2667
by  AdamJump to last post
11/24/2009 2:50 PM
1 Replies and 2645 Views AP20 Invoice Hold Code  2645  1 Started by  Deleted User I am looking for the Hold Code field.&160;The field is located at f115_API_HLD-CODE but I can't find it in Addins at the API&160;table or in Process Flow.&160; Is it hiding in another table that I can connect using a relationship
1 2645
by  John CrudeleJump to last post
11/04/2009 3:31 PM
3 Replies and 3002 Views PR36 add-in upload  3002  3 Started by  Phil Simon Hello All I'm trying to create the upload for the PR36.&160; I have mapped the fields below and have read:&160; Finding Splat or Hidden Key (HK) Fields for use with Lawson Add-ins for Microsoft Office &160; Article ID:1054552 &160; For some reason, I&160;can't get to the formdef to find the hidden field(s).&160; Anyone&160; Thanks. field...
3 3002
by  Phil SimonJump to last post
10/20/2009 9:07 AM
0 Replies and 2944 Views MA236 (Invoiced Not Received) Available as Lawson Query DME?  2944  0 Started by  Lorenda Just wondering whether anyone has a DME written to mock the output of the MA236 report in Lawson. We are needing to run it across companies, so I&160;was hoping to get a 'tweakable' query to run this using ADODB.
0 2944
09/23/2009 11:43 AM
4 Replies and 3038 Views PO25 Vendor Release?  3038  4 Started by  willz06jw Let me start by saying thanks for the help, Is there a way to automatically release all unreleased vendor agreements in PO25 Also, what are the effects of not re-releasing a revised vendor agreement Thanks again, Will
4 3038
by  willz06jwJump to last post
09/18/2009 12:51 PM
1 Replies and 1797 Views Any Monarch users out there?  1797  1 Started by  Deleted User I'm new to the forum and&160;not sure this is the appropiate forum for this question&160; Anyone ever used the tool from Datawatch called Monarch&160; I use daily for all kinds of Lawson tasks.&160; It has been one of the best software investments I've ever made. Joanna Bledsoe joanna.bledsoejhsmh.org
1 1797
by  NormJump to last post
09/17/2009 3:10 PM
2 Replies and 2380 Views Table where I can query Full name and Login username (Using Lawson ADDINS)?  2380  2 Started by  willz06jw Thanks for your help, I am trying to find a table where I can query the username (that people log in with) and the full name attached to it. I am trying to pull this in&160;Excel using Lawson Addins. Thanks for your help, Will
2 2380
by  willz06jwJump to last post
09/17/2009 8:44 AM
1 Replies and 2729 Views Using Perl to query Lawson DME revisited with LSF9 environment  2729  1 Started by  jeremy.zerr So we just got the LSF9 environment, and I just found out that one of the things that changed is the method of authentication for DME&160;queries. In the 8.0.3 environment, basic HTTP authentication was used, which is very easy to navigate using perl. However, in the LSF9 environment, the DME authentication switched to the Lawson server side auth, which is basically requiring a login to the same login form that normal users have to log into Portal with. This means to access LSF9 DME&160;wit...
1 2729
by  jeremy.zerrJump to last post
08/23/2009 9:17 PM
3 Replies and 2144 Views Addins is too quick...  2144  3 Started by  BrianP I know it is hard to believe (and i can't believe i am asking) but, I need to slow down the Addins upload to&160;one entry per second.&160; The reason behind it... APAUDIT has a time field (APA-TRANS-TIME) that is updated during a delete load I am working on in AP10.6 and the process aborts with a duplicate record error due to the time (HHMMSS).&160; So far I have been able to insert several lines of old data between&160;the rows that could cause a failure and it appears to be working fine, ...
3 2144
by  NormJump to last post
07/20/2009 1:03 PM
0 Replies and 1781 Views ed810 not pulling tax  1781  0 Started by  linda phillips we are currently 8.03 sitting on 9.0lsf and use Ghx as our provider for EDI. We currently became a tax company and we seem to have a problem at month end with out of balance for AP due to tax. WHen you look the tax is not be added to the invoice and we run the ap126 which matches and were done. Has anyone set up edi for tax &160; I'm begining to think that this is the problem. If not and anyone has a great suggestion on how to fix this I would greatly appreciate your help. The only one we ...
0 1781
07/02/2009 11:40 AM
6 Replies and 4421 Views AP10.6 Company Codes (lsf9, 803apps)  4421  6 Started by  BrianP Has anyone had&160;success using Lawson Add-Ins against AP10.6.&160; My user would like to&160;delete Company Codes.
6 4421
by  Brad SchauerJump to last post
06/29/2009 9:44 AM
4 Replies and 6932 Views Vendor Query  6932  4 Started by  Boyd Does anyone have any thoughts on creating a Query that will Pull in Vendor, Vendor ID, GL coding (A/U, Acct. etc.) and Payment number&160; I&160;have been able to pull in all the information I need except for the Payment number.&160; Boyd
4 6932
by  BoydJump to last post
06/26/2009 1:47 PM
1 Replies and 2116 Views Addins for PA22-creating duplicate records  2116  1 Started by  thanef I am trying to upload a file from CE&160;Broker to PA22 Certifications but I am getting duplicate records for some reason.&160; LIS does not support this function when I asked them for help.
1 2116
by  John HenleyJump to last post
06/03/2009 6:43 PM
7 Replies and 8156 Views Unreleased AP invoice - APDISTRIB & APINVOICE tables Activity field not filled?  8156  7 Started by  Sherry Shimek &160; Help - We need to see Activity field information for unreleased AP invoices to determine which activity is overbudget and not allowing the batches to post. Set-up a query of APDISTRIB and APINVOICE tables including Activity and Account Category field from APDISTRIB.&160; Allowed Multiple OTM&160;Values for multiple invoice lines.&160;On AP20 screen confirmed that on invoices queried there were activities entered, but nothing was included in the Actvitiy field of the query. Thanks!&1...
7 8156
by  Sherry ShimekJump to last post
05/18/2009 1:44 PM
3 Replies and 2219 Views MS Addins install that limits to Query only capability  2219  3 Started by  Michael Barron As part of our LSF 9.0 implementation we are upgrading MS&160;Addins. We would like to allow query only capability without providing the Upload even when some people may have update rights to the screen in Portal. I know by removing the 2 upload wizard files you can prevent uploads from being done but I was curious how you bundled that process to provide users or people to install MS&160;Addins and ensure these wizards are not installed.
3 2219
by  Michael BarronJump to last post
05/01/2009 2:30 PM
7 Replies and 2704 Views MS Add-ins version level with LSF9 env/8.03 aps  2704  7 Started by  Deleted User We are upgrading to LSF9, but remaining on 8.03 applications until next year.&160; We are currently on MS Add ins v2.0.5.0.&160; Lawson has indicated that we can upgrade to v9.0.3.1.&160;&160;My understanding is that this version was released in 2006.&160; Is anyone&160;with this configuration&160;using a different version&160;of MS Add-ins&160; Thanks&160;
7 2704
by  Michael BarronJump to last post
05/01/2009 1:08 PM
3 Replies and 2511 Views Field size limitation in query???  2511  3 Started by  Sherry Shimek &160; Does MS&160;Addins and or Excel&160;have a size limit to the amounts to be extracted in a query&160; We have a number we have queried from a table that appears to have lost the last two digits of a $3trillion gl amount.
3 2511
by  Sherry ShimekJump to last post
04/27/2009 10:56 AM
6 Replies and 6143 Views BN32 - hidden key...  6143  6 Started by  Shane Jones Anyone have the structure for BN32 Add-ins.&160;&160; I thought I had it but it is not working....&160;&160; I think I need help with the Hidden Key.... Any ideas
6 6143
by  BrendaHJump to last post
04/17/2009 2:03 PM
4 Replies and 2998 Views Addins to bring multiple distributions into AP20  2998  4 Started by  Joe O'Toole We import some of our invoice files with IMPORTDB, but would like to develop an interface&160;using Addins. I was looking to hear how others have faired creating an Addin's template for bringing in invoices with multiple details lines (some in excess of 100) into AP20.1. Thanks.
4 2998
by  Ruma MalhotraJump to last post
03/31/2009 3:42 PM
0 Replies and 2678 Views Issue with Add-Ins for AP20.7, does not add first record  2678  0 Started by  desichet Most of our Invoice have one line distribution.We are building AGS call to add records to AP20.7&160; to&160; occur few days&160; after Invoice header was created and Invoice is approved.&160; Running into issue with adding one record to AP20.7 OR AP20.2 (distribution). First record does not get added through AGS call OR Add-In. Return message -Message>No More Records For Given Key. Once we enter first one using portal screen, same AGS call and MS-AddIn can add more records as needed.&16...
0 2678
03/27/2009 5:05 PM
2 Replies and 2757 Views Creating a report from MS Access  2757  2 Started by  Deleted User Hi I am new to using Lawson and have not been trained on the software. I am used to using Peoplesoft. I have access to the back tables to run queries in MS Access. That ebing said,&160; I was told by Lawson support that there is not a report that will produce this report.&160; The report need to include a breakdown of the unemployment report breaking it down by worksite location which is the location code located on the HR11 Assignment tab. The report need to reflect by company, by lo...
2 2757
by  Phil SimonJump to last post
03/17/2009 10:52 AM
2 Replies and 2899 Views Product Lines Disappearing  2899  2 Started by  JonA Anyone else experiencing this&160; Occasionally, when I use the Upload Wizard, my product lines are not showing.&160; I have to re-install addins for them to appear again.&160; I'm not having any issues with the query wizard. Lawson S3 Add-Ins version 9.0.3.1380; MS Excel 2003 version 11.6560.6568 (SP2); Windows XP Pro version 2002 SP2
2 2899
by  JonAJump to last post
03/17/2009 4:21 AM
3 Replies and 6074 Views PO20.1 Add-In - Release PO  6074  3 Started by  Ken Ptak I'm attempting to create an Add-In for the PO20.1 that will perform a 'Release' from the 'Action' menu. I&160;have three fields mapped (Company, PO Number, and Save&160;FC) on the attached spreadsheet and .uwf.&160; When I&160;run the Add-In the result is 'Change Complete -&160;Continue'.&160; However, if I&160;inquire on that&160;PO on PO20, the Revision still states 'Unreleased'. We're on Apps 8.1, LSF9, Add-Ins 9.0.3.1. Any ideas/thoughts/suggestions would be greatly appreciated. ...
3 6074
by  John HenleyJump to last post
03/04/2009 11:43 AM
5 Replies and 4566 Views Lawson Advanced Add-ins query document - only available from CUE  4566  5 Started by  jeremy.zerr Just had a Lawson support person help me out with debugging some edits on a PA55 upload, they sent me a document that is only available to Advanced Add-ins class attendees at CUE. Figured I would share it.&160; Its attached to this post. Has a really great section on how to debug edits from uploads. That was the info I have been looking for quite a while, and I'm totally excited to finally have something to be able to help myself. Jeremy Running shoes website
5 4566
by  SrinivasJump to last post
02/16/2009 4:22 AM
3 Replies and 5127 Views AP Invoice Comments  5127  3 Started by  Meghan I am trying to set up a query that will pull down AP invoice information including any comments attached to the invoice.&160; Since invoices are included as an attachment, is there any way to include them in the query
3 5127
by  John HenleyJump to last post
01/30/2009 5:56 PM
6 Replies and 3872 Views GLTRANS query returns no results  3872  6 Started by  Sherry Shimek We recently created a new data level security class expanding the data accessible to a current security class., but still not allowing full data access.&160; Lawson data level security class testing passed with no exceptions.&160; However, due to the intense MS Addins query usage of the users in the two classes we decided to test MS Addins queries. They primarily run queries on GLTRANS. Queries worked fine in the test environment except for queries of the GLTRANS table.&160; Queries of...
6 3872
by  k-rockJump to last post
01/28/2009 3:10 PM
2 Replies and 2271 Views Product line access  2271  2 Started by  GailC I have a user with a RM setup identical to my test user. The user can only see 1 of our 2 product lines in the addin. Any idea why
2 2271
by  John HenleyJump to last post
01/14/2009 1:08 PM
1 Replies and 2966 Views addins template for hr04.7 value listing?  2966  1 Started by  Deleted User Can anyone share the secret to doing an upload for HR codes, but the actual values list (hr04.7). We have a new hr code with a bunch of values and would hate to manually input. I think that there are hidden fields involved. Any help is appreciated. &160; &160;
1 2966
by  John HenleyJump to last post
01/06/2009 2:20 PM
0 Replies and 3102 Views Deleting a GL Budget via Excel Add-Ins  3102  0 Started by  John Henley I recently was asked if you could use the Add-Ins to delete records, particularly in the GL 'Flex Budgeting' module. The answer, of course, is yes! The ability to delete records on forms was added to the Upload Wizard some time ago, and you can use it with just about any form to which you can map for adding and/or changing. And since you're just changing the way you interact with Lawson (in other words, you're using Excel as a 'front-end' instead of LID or Portal), you're still making use of ...
0 3102
12/27/2008 5:35 AM
2 Replies and 3202 Views AM20 security error  3202  2 Started by  GailC We are new to Lawson using the new LS security. I have security working for all addins except AM20. When my user runs it with here SuperAdmin security, it fails. When she uses Lawson (CheckLS = 'N') it works. The only thing I can find in the logging is that 'It can't execute script ModLocalAdmin.bat'. This is from the xls log. Any ideas were I can look
2 3202
by  GailCJump to last post
12/19/2008 1:55 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 212 > >>


RSS Feed Available