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

We import some of our invoice files with IMPORTDB, but would like to develop an interface 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.

Hello All I'm trying to create the upload for the PR36.  I have mapped the fields below and have read:  Finding Splat or Hidden Key (HK) Fields for use with Lawson Add-ins for Microsoft Office   Article ID:1054552   For some reason, I can't get to the formdef to find the hidden field(s).  Anyone  Thanks. field name da...

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.

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

Anyone know if Add-Ins will work with Office 2016 I don't see anything in the docs that 'officially' says support for 2016....

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

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

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 separate entries so it assigns JE 1 to Sample 1 and JE 2 to S...

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!

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 data required, and whe...

I want to build a query to pull reportable amount in Ap45.1 Field name is: REPINCAMT - I can't seem to find which table this belongs to Does any one know and how can I pull that via a .dme thanks! Elmer

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

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.

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

I've been trying to come up with a report that will show the dollar amount of the MA64 cost adjustment.  I'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

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

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

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

is it possible to select 2 forms i.e. BL20.1 and called form BL20.2 to query from Add-Ins

what table gives me all this report. EMPLOYEE LAST-NAME FIRST-NAME MIDDLE-INIT JOB TITLE DEPARTMENT UNION EMPLOYEE STATUS TERM DATE DATE_STAMP

Hello, what is the best way to run a report in Lawson other than Add-ins

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

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's location

Hi y'all,   I have recently built an upload for some pretty repetitive POs that I make regularly, and I'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'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 in the upload wi...