77 Subscribed to this forum
Search this forum:
Search
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 1 of 3123 > >>
Topics
 Replies
 Views
 Subscribers
 Last Post
4 Replies and 24630 Views and 1 Subscribers Invalid One To Many Filtering  24630  4  1 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
4 24630 1
by  NJNJump to last post
1/14/2022 8:36 PM
14 Replies and 32429 Views and 1 Subscribers Add-ins Resource  32429  14  1 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 32429 1
by  AndreaJump to last post
6/18/2016 9:07 PM
10 Replies and 23460 Views and 3 Subscribers Lawson Add-Ins query for RW100 report  23460  10  3 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 23460 3
by  vinayJump to last post
7/5/2016 12:49 PM
5 Replies and 18671 Views and 1 Subscribers Addins to bring multiple distributions into AP20  18671  5  1 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.
5 18671 1
by  Rani IlapaJump to last post
5/19/2021 7:25 PM
6 Replies and 20586 Views and 3 Subscribers Upload to HR55.3  20586  6  3 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 20586 3
by  Michelle OlsonJump to last post
2/10/2014 6:50 PM
19 Replies and 26056 Views and 1 Subscribers RQ10 Upload Challenge  26056  19  1 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 26056 1
by  Kat VJump to last post
12/27/2017 12:51 PM
7 Replies and 21644 Views and 3 Subscribers Uploading Budgets (FB20.1) using Add-Inns  21644  7  3 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 21644 3
by  LorraineJump to last post
1/16/2014 4:19 PM
8 Replies and 39552 Views and 2 Subscribers Using add-ins with Excel 2010  39552  8  2 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 39552 2
by  MarkJump to last post
3/23/2015 2:43 PM
20 Replies and 55854 Views and 2 Subscribers Query PO Comments Fields  55854  20  2 Started by  Freer Howdy, Does anyone know how to qurey the comments to print on purchase orders
20 55854 2
by  JonAJump to last post
3/29/2016 2:03 PM
12 Replies and 23034 Views and 0 Subscribers upload RQ10  23034  12  0 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 23034 0
by  Kat VJump to last post
9/9/2014 7:19 PM
1 Replies and 18878 Views and 0 Subscribers PO21.3 Distributions  18878  1  0 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 18878 0
by  DianaJump to last post
9/27/2018 12:18 PM
2 Replies and 20993 Views and 1 Subscribers PO25.8 Upload Error  20993  2  1 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 20993 1
by  cmjsJump to last post
12/2/2016 4:31 PM
2 Replies and 18971 Views and 0 Subscribers Add in for benefit rates?  18971  2  0 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 18971 0
by  Terry PJump to last post
8/12/2014 11:28 PM
2 Replies and 20349 Views and 0 Subscribers AP10.5 Add In Upload Help  20349  2  0 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 20349 0
by  Carol SJump to last post
2/13/2018 4:24 PM
4 Replies and 19543 Views and 1 Subscribers AddIns not loading properly  19543  4  1 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 19543 1
by  agershJump to last post
3/4/2015 5:59 PM
1 Replies and 18318 Views and 0 Subscribers Need Help Pulling in UOM pricing in PO28  18318  1  0 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 18318 0
by  LauraJump to last post
10/17/2013 10:39 AM
2 Replies and 18494 Views and 0 Subscribers Invoice changes and modifications  18494  2  0 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 18494 0
by  TomJump to last post
10/28/2013 12:11 PM
3 Replies and 19170 Views and 0 Subscribers Addins query for IC11.7  19170  3  0 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 19170 0
by  JonAJump to last post
11/8/2013 5:45 PM
1 Replies and 18445 Views and 0 Subscribers template for AC10 ms addins upload  18445  1  0 Started by  jennifer does anyone have a template for AC10 ms addins upload template
1 18445 0
by  Jimmy ChiuJump to last post
12/10/2013 4:11 PM
2 Replies and 19264 Views and 0 Subscribers HR11 Addins template  19264  2  0 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 19264 0
by  ReemaJump to last post
12/23/2013 6:30 PM
2 Replies and 19144 Views and 0 Subscribers Upload for IC12.1 and IC12.2  19144  2  0 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 19144 0
by  JimYJump to last post
2/2/2014 10:31 PM
4 Replies and 21072 Views and 0 Subscribers Add-Ins Login  21072  4  0 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 21072 0
by  MetrazalJump to last post
2/11/2014 7:05 PM
2 Replies and 21020 Views and 0 Subscribers Self contained GL40 JE upload template  21020  2  0 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 21020 0
by  Display NameJump to last post
2/6/2014 1:03 PM
9 Replies and 26765 Views and 1 Subscribers Add-ins for Office 2013....  26765  9  1 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 26765 1
by  JimYJump to last post
11/16/2016 12:26 PM
2 Replies and 17915 Views and 0 Subscribers Add-ins Speed  17915  2  0 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 17915 0
by  Gary StoneJump to last post
5/2/2014 12:26 PM
1 Replies and 18038 Views and 0 Subscribers PO25.7 Upload to Change Cost on Lines  18038  1  0 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 18038 0
by  JonAJump to last post
5/27/2014 5:42 PM
0 Replies and 3448 Views and 0 Subscribers Upload to HR55.2  3448  0  0 Started by  BrianP Does anyone have a working template they are willing to share  We are using Lawson 9.1. Thanks, Brian
0 3448 0
9/9/2014 2:05 AM
2 Replies and 19159 Views and 0 Subscribers Using Add-ins or Spreadsheet Designer for non-Lawson applications  19159  2  0 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 19159 0
by  Kat VJump to last post
10/2/2014 2:20 PM
1 Replies and 18412 Views and 0 Subscribers Does anyone have an Add-in Template for AM20.4?  18412  1  0 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 18412 0
by  mgreggJump to last post
11/4/2014 10:58 PM
2 Replies and 17904 Views and 0 Subscribers Upload comments to IC18.1  17904  2  0 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 17904 0
by  JonAJump to last post
11/4/2014 7:35 PM
0 Replies and 2584 Views and 0 Subscribers PR35.2 Upload multiple messages returns add complete continue  2584  0  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 2584 0
11/4/2014 4:02 PM
2 Replies and 17969 Views and 0 Subscribers PR35.2 Upload multiple messages returns add complete continue  17969  2  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 ...
2 17969 0
by  The.Sam.GrovesJump to last post
11/12/2014 2:44 PM
0 Replies and 3479 Views and 0 Subscribers Add-ins for Smart Office  3479  0  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 3479 0
12/5/2014 5:44 PM
1 Replies and 18230 Views and 0 Subscribers BN32 and BN72 Uploads (Add-Ins)  18230  1  0 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 18230 0
by  David BrittonJump to last post
1/28/2015 3:29 PM
3 Replies and 18588 Views and 0 Subscribers IC11.1 Add-In  18588  3  0 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 18588 0
by  Kat VJump to last post
2/24/2015 5:46 PM
1 Replies and 18917 Views and 0 Subscribers Query  18917  1  0 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 18917 0
by  JonAJump to last post
2/19/2015 7:38 PM
0 Replies and 3285 Views and 0 Subscribers Add In for Microsoft Office  3285  0  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 3285 0
2/19/2015 4:04 PM
3 Replies and 18794 Views and 0 Subscribers MS Addins Query GLAMOUNTS amounts in excel as text  18794  3  0 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 18794 0
by  dcaianiJump to last post
6/12/2015 5:32 PM
1 Replies and 17828 Views and 0 Subscribers Add-ins for AR33.6  17828  1  0 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 17828 0
by  Todd MitchellJump to last post
3/31/2015 12:38 PM
2 Replies and 20067 Views and 0 Subscribers Add-Ins FATAL ERROR  20067  2  0 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 20067 0
by  Therese ChaplinJump to last post
4/7/2015 6:30 PM
0 Replies and 3473 Views and 0 Subscribers Add-Ins upload in MS Excel 2010  3473  0  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 3473 0
4/8/2015 12:29 PM
1 Replies and 18637 Views and 0 Subscribers GLTRANS attributes  18637  1  0 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 18637 0
by  JonAJump to last post
5/15/2015 10:51 AM
0 Replies and 3286 Views and 0 Subscribers MS Add Ins Upload Template for BN36.1  3286  0  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 3286 0
6/1/2015 1:20 PM
0 Replies and 3041 Views and 0 Subscribers automated scheduled uploads  3041  0  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 3041 0
6/8/2015 5:20 PM
6 Replies and 18424 Views and 0 Subscribers Add-In not uploading to vendor master maintenance?  18424  6  0 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 18424 0
by  BethJump to last post
10/22/2015 1:40 PM
4 Replies and 21386 Views and 0 Subscribers Addin Templates  21386  4  0 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 21386 0
by  Tanya_DJump to last post
11/9/2016 8:40 PM
1 Replies and 18152 Views and 0 Subscribers GL Distrib and Vendor Details  18152  1  0 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 18152 0
by  JonAJump to last post
8/17/2015 12:16 PM
0 Replies and 3369 Views and 0 Subscribers Error 1404 when installing add-ins  3369  0  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 3369 0
8/17/2015 7:15 PM
1 Replies and 18142 Views and 0 Subscribers Upload for SSN on HR13.1  18142  1  0 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 18142 0
by  Colleen BertagnolliJump to last post
8/19/2015 12:43 PM
1 Replies and 18383 Views and 0 Subscribers Missing MAP COLUMNS in Upload Wizard  18383  1  0 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 18383 0
by  JonAJump to last post
8/21/2015 3:38 PM
0 Replies and 2707 Views and 0 Subscribers Uploading Employee Groups  2707  0  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 2707 0
9/1/2015 9:41 AM
4 Replies and 18790 Views and 0 Subscribers Uasing Addins To Load PO Match Invoices  18790  4  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.
4 18790 0
by  jefriedmanJump to last post
1/28/2020 9:22 PM
0 Replies and 3096 Views and 0 Subscribers Add-ins for PO31  3096  0  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 3096 0
9/23/2015 5:59 PM
0 Replies and 3693 Views and 0 Subscribers Add-ins ver 10.0.5 install problem (with Office 2013)  3693  0  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 3693 0
10/2/2015 6:24 PM
1 Replies and 18155 Views and 0 Subscribers Addins query for AC295 data  18155  1  0 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 18155 0
by  JonAJump to last post
11/11/2015 2:35 PM
1 Replies and 18332 Views and 0 Subscribers AR28 upload  18332  1  0 Started by  liz Upload to AR28. Keep getting an error 'Payment does not exist'. But payment is there. Any ideas
1 18332 0
by  lizJump to last post
11/13/2015 3:17 PM
3 Replies and 19572 Views and 0 Subscribers Add-in PO25.6 trouble  19572  3  0 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 19572 0
by  Oscar SJump to last post
1/5/2016 8:27 PM
1 Replies and 19680 Views and 0 Subscribers 'Authorisation' for Addins  19680  1  0 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 19680 0
by  JonAJump to last post
1/26/2016 3:49 PM
1 Replies and 19231 Views and 0 Subscribers Add in Query for AP Data  19231  1  0 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 19231 0
by  JonAJump to last post
4/14/2016 4:56 PM
7 Replies and 20148 Views and 0 Subscribers Add-Ins Peformance Issues  20148  7  0 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 20148 0
by  drewlewis15Jump to last post
12/19/2017 8:56 PM
1 Replies and 18059 Views and 0 Subscribers PO20 upload add-in  18059  1  0 Started by  NatalieD Would anyone be willing to share their upload wizard for PO20 creation Much appreciated!
1 18059 0
by  Kat VJump to last post
6/10/2016 12:56 PM
1 Replies and 19502 Views and 0 Subscribers Add-ins error: New value must be spaces because line has no item  19502  1  0 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 19502 0
by  KelciJump to last post
6/22/2016 7:26 PM
0 Replies and 2689 Views and 0 Subscribers Calling Employee Business Class DME  2689  0  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 2689 0
7/4/2016 2:26 PM
0 Replies and 2993 Views and 0 Subscribers Lawson 8 Copy Paste  2993  0  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 2993 0
7/12/2016 7:42 PM
2 Replies and 19364 Views and 0 Subscribers VBA code to launch lawson add-in 10.0.7  19364  2  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
2 19364 0
by  John HenleyJump to last post
7/24/2020 2:34 PM
4 Replies and 19361 Views and 0 Subscribers PO20 header comment  19361  4  0 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 19361 0
by  JonAJump to last post
8/16/2016 6:19 PM
1 Replies and 17900 Views and 0 Subscribers PO13 Inactivate Add-In  17900  1  0 Started by  Me Looking to see if anyone has an add-in for inactivations in PO13 they're willing to share.  We're on V10.
1 17900 0
by  Kat VJump to last post
8/2/2016 7:28 PM
0 Replies and 3091 Views and 0 Subscribers Lawson Query Wizard - How to return max value only  3091  0  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 3091 0
8/15/2016 5:32 PM
11 Replies and 19639 Views and 0 Subscribers Addins Performance doubled with upgrade  19639  11  0 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 19639 0
by  drewlewis15Jump to last post
12/19/2017 8:57 PM
9 Replies and 25940 Views and 0 Subscribers Add-Ins for Office 2016  25940  9  0 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....
9 25940 0
by  sbridenstineJump to last post
11/11/2019 3:39 PM
2 Replies and 18729 Views and 0 Subscribers IC99.2 addins required fields  18729  2  0 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 18729 0
by  CherieOJump to last post
10/3/2016 11:21 AM
1 Replies and 17129 Views and 0 Subscribers upload reconciliation on CB80 error  17129  1  0 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 17129 0
by  Carol SJump to last post
2/12/2018 11:54 PM
1 Replies and 20325 Views and 0 Subscribers Fatal Error: File FILERELFLD is secured  20325  1  0 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 20325 0
by  JimYJump to last post
4/5/2017 9:48 AM
6 Replies and 19301 Views and 0 Subscribers PO25.6 Line cost changes with add-ins  19301  6  0 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 19301 0
by  JonAJump to last post
6/21/2018 7:20 PM
0 Replies and 4020 Views and 0 Subscribers Help Needed: How to uninstall Spreadsheet Designer  4020  0  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 4020 0
8/9/2017 6:07 PM
0 Replies and 2822 Views and 0 Subscribers deleting values on AC13 via add-ins  2822  0  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 2822 0
11/8/2017 3:36 PM
2 Replies and 18660 Views and 0 Subscribers PO30 & PO35 Addins  18660  2  0 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 18660 0
by  bruppJump to last post
2/6/2018 12:44 PM
2 Replies and 17684 Views and 0 Subscribers How do we find field numbers in lawson for MS Addins?  17684  2  0 Started by  Nicholas Elliott Any help would be great
2 17684 0
by  jamesracesonJump to last post
6/19/2018 11:58 AM
11 Replies and 25205 Views and 0 Subscribers Mass PO20 Line Cancellation Through Add-Ins  25205  11  0 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
11 25205 0
by  Rani IlapaJump to last post
12/9/2020 5:59 PM
1 Replies and 17532 Views and 0 Subscribers Office 2010 and Lawson 10.0.7.0??  17532  1  0 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 17532 0
by  AlanKJump to last post
6/29/2018 10:04 PM
0 Replies and 2777 Views and 0 Subscribers BR40.1 Upload Help  2777  0  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 2777 0
10/30/2018 4:37 PM
2 Replies and 18553 Views and 0 Subscribers Office 2016 Load Behavior  18553  2  0 Started by  JDPowell I have a user who's add-ins are not loading. When I go to the Add-ins, the Load Behavior says 'Unloaded'. When I check them to load them, that still does not work. I have checked the registry at HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Excel\Addins\Lawson.LawsonMOA and the LoadBehavior is correct at '3'. The Manifest also lists the file as 'C:\Program Files (x86)\Lawson Software\Office Add-ins\LawsonMOA.vsto|vstolocal'   I have uninstalled with Revo Uninstall that supposed...
2 18553 0
by  JDPowellJump to last post
2/26/2019 2:11 PM
1 Replies and 16821 Views and 0 Subscribers Header format in MOA  16821  1  0 Started by  Erik G. Good Morning all,   I have an end user asking if there is a way to change the heading format so it no longer bolds the headers, puts a line under the header row, and freezes the line in place   We have tried playing round with it in the format tab but was not able to get it to change.   Example of what she is talking about is below.   Thanks,   Erik   ------------------------------------------------------------------------------------------
1 16821 0
by  JimYJump to last post
5/13/2019 3:17 PM
0 Replies and 3146 Views and 0 Subscribers GL65 JE Number  3146  0  0 Started by  JohnDoe I tried to use GL65.1 to upload 2 separate journal entries in 1 workbook. While the upload was successful, Lawson assigned the same JE number to both entries. Is there a way to tell Lawson that they are separate JEs As example: 1) Sample1 Reclass 26,500     Sample1 Reclass -26,500 2) Sample2 Reclass 30,000     Sample2 Reclass -30,000   Lawson is assigning JE 1 to each of these entries. Is there a way to tell Lawson they are sep...
0 3146 0
6/7/2019 9:06 PM
2 Replies and 17264 Views and 0 Subscribers AP40.1 query (ADDINS) on Comments  17264  2  0 Started by  Elmer Madarang I am building a query to indentify invoices that were put on hold in AP40.1 and pull out the comments under invoice notes(reason why the invoice was put on hold).  I don't know where those comments reside and I can't map it to pull out of the query. Please help   thanks!    
2 17264 0
by  Elmer MadarangJump to last post
12/26/2019 5:54 PM
1 Replies and 16764 Views and 0 Subscribers Help needed! ADDins - are all key fields required on the spreadsheet?  16764  1  0 Started by  CindyW I am trying to create an add-in for GL25.1 (I know very little about Add-ins) and was reading the Lawson documentation that states to use the .scr file (the $TRANS section) to show the required fields.  So I checked that .scr file, but there are 6 keys on this table (GLINTCO) and only 2 of those key fields are shown in the $TRANS section.    This is from the documenation:   The $TRANS section of the .scr file contains a list of all fields on a form, the type of da...
1 16764 0
by  Ragu RaghavanJump to last post
1/24/2020 4:09 PM
2 Replies and 17760 Views and 0 Subscribers AP45.1 Query  17760  2  0 Started by  Elmer Madarang I want to build a query to pull reportable amount in Ap45.1 Field name is: REPINCAMT - I can&39;t seem to find which table this belongs to Does any one know and how can I pull that via a .dme thanks! Elmer    
2 17760 0
by  JonAJump to last post
3/19/2020 3:57 PM
0 Replies and 2585 Views and 0 Subscribers Currency Upload  2585  0  0 Started by  Boyd Does anyone have an upload template they would like to share that will allow up to upload about 25 currencies on a daily basis to Lawson   Thank you
0 2585 0
3/12/2020 4:03 PM
4 Replies and 16063 Views and 0 Subscribers .uwf template for AP20  16063  4  0 Started by  Jennifer Fluharty Looking to see if anyone would be willling to share their .uwf template file if you have already created one to upload invoices into AP20.  I also have read on here about AP52 / AP520 but not sure I understand how that one works yet, so would love it if someone could or would be willing to share their template file.   Bottom line, looking for a way to increase our productivity without vouchering one by one.
4 16063 0
by  Ragu RaghavanJump to last post
8/23/2023 6:10 PM
1 Replies and 18406 Views and 0 Subscribers Excel crashing after exiting Query Wizard and Upload Wizard.  18406  1  0 Started by  Boyd_Gaming_Tech I have two users whose Excel 365 client (64-bit) crashes whenever they exit the Query and Upload Wizards. After exiting either wizard, Excel immediately closes / crashes.  When they reopens Excel, they get that menu to recover what they were last working on.   I&39;ve tried uninstalling the Office suite and Lawson add-ins, updating Windows and re-installing the Lawson add-ins.  That did not resolve the issue for either user.
1 18406 0
by  Kat VJump to last post
6/9/2021 3:03 PM
1 Replies and 12716 Views and 0 Subscribers Cost Adjustment Report  12716  1  0 Started by  TerriS I&39;ve been trying to come up with a report that will show the dollar amount of the MA64 cost adjustment.  I&39;ve checked the canned reports and tried creating a custom report through Add-Ins, but nothing I run actually shows the dollar amount of the adjustments.  They only show if a cost adjustment exists, but no cost. Any ideas on how I can create a report that will show all the data I need
1 12716 0
by  Kat VJump to last post
11/8/2021 10:50 PM
2 Replies and 13748 Views and 0 Subscribers PO20 - How to Create a PO with MS Addins?  13748  2  0 Started by  Ann Is there a workaround in MS Addins that will create both the PO Header and Lines using one MS Addins Upload Query  Currently we manually create the header in S3, and then input the PO on the Addin upload to add lines.  Wondering if anyone has been able streamline this process
2 13748 0
by  AnnJump to last post
12/1/2021 10:54 PM
2 Replies and 13570 Views and 0 Subscribers MOA Version 10.0.x and HR11 Issue  13570  2  0 Started by  TerryB A template for HR11 adds/updates that we have been using reliably for many years with Version 9.0.3.1926 of MS Office Add--Ins (MOA) does not work correctly in Version 10.0.7 or higher when we attempt to add a new HR11 employee. The upload runs to completion without issuing any errors, the message "Add Complete - Continue" is listed to the right of the new record, but no record is actually added to the Employee table. Has anyone else had this experience and found a resoluti...
2 13570 0
by  TerryBJump to last post
2/17/2022 1:57 AM
0 Replies and 1692 Views and 0 Subscribers Finding field identifier  1692  0  0 Started by  Bev Edwards It has been a few years since I have been in the Lawson arena. I do remember when using Add-ins, there was a way to plug the error into a browser, hit enter and the code would build into a text file.  If you scrolled all the way to the bottom, the error would indicate what Field you needed to address.    ......or something like that.  Does anyone have any information on this
0 1692 0
5/23/2022 8:53 PM
1 Replies and 18313 Views and 0 Subscribers Select multiple forms to query from Add-Ins?  18313  1  0 Started by  NH is it possible to select 2 forms i.e. BL20.1 and called form BL20.2 to query from Add-Ins
1 18313 0
by  John HenleyJump to last post
7/28/2022 6:22 PM
4 Replies and 2619 Views and 0 Subscribers Add-ins report.  2619  4  0 Started by  berban35 what table gives me all this report. EMPLOYEE LAST-NAME FIRST-NAME MIDDLE-INIT JOB TITLE DEPARTMENT UNION EMPLOYEE STATUS TERM DATE DATE_STAMP
4 2619 0
by  berban35Jump to last post
4/25/2023 1:06 PM
5 Replies and 6014 Views and 0 Subscribers best way to run in Lawson  6014  5  0 Started by  berban35 Hello, what is the best way to run a report in Lawson other than Add-ins
5 6014 0
by  James.MooreJump to last post
5/1/2023 10:44 PM
0 Replies and 578 Views and 0 Subscribers Missing Multi-Stream Upload Option  578  0  0 Started by  Mark Petereit Our IS department has made the server configuration changes to turn on multi-stream uploads in Microsoft Add-Ins. Several of my coworkers now see the multi-stream option, but I dont. My security admin insists my profile is identical to theirs. What are they missing
0 578 0
7/12/2023 11:09 PM
2 Replies and 5647 Views and 0 Subscribers What is the file name that stores the URLs that you chose in the drop down when you are signing into Addins?  5647  2  0 Started by  Bill Riordan I am trying to get rid of a few old URLs from the drop down when I sign into MS addins. Does anyone know the name of the file and it&39;s location 
2 5647 0
by  humansince1982Jump to last post
9/12/2023 6:22 PM
1 Replies and 40 Views and 0 Subscribers Lawson 10.1 PO20.1 Comment Upload  40  1  0 Started by  Jon S Hi y&39;all,   I have recently built an upload for some pretty repetitive POs that I make regularly, and I&39;ve ran into an issue. Currently, we add a trailer comment to each of these POs that is unique to each PO, which means comment codes can&39;t be used. I was wondering if anyone knew where in the upload wizard I could find the PO comments I know that they are stored seperatly and merely linked to the PO, but for the life of me I have not been able to find where that is...
1 40 0
by  John HenleyJump to last post
9/26/2023 10:34 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 1 of 3123 > >>


RSS Feed Available