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 looks like she logs in, but no screen appears. ...

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.

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, we get a substan...

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 'Security violation' ...

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 the selection ...

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

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

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

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!!

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 relationships but each tim...

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

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

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:3, etc.  Should I ju...

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...

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.

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

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,

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, PR13. E...

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 not a lot of choice/in...

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

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

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

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.

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 ...

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