Forum: Lawson Add-Ins for Microsoft Office

 77 Subscribed to this forum
Page 1 of 1012345 > >>

Topics

Replies
Rating
Status
Views
Subscribers
Last Post

Invalid One To Many Filtering    

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 25046 1
by  NJNJump to last post
1/14/2022 8:36 PM

Addins to bring multiple distributions into AP20    

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 19092 1
by  Rani IlapaJump to last post
5/19/2021 7:25 PM

PR36 add-in upload    

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...
4
5503 2
by  BelmaJump to last post
1/22/2024 5:59 PM

Uasing Addins To Load PO Match Invoices    

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 19249 0
by  jefriedmanJump to last post
1/28/2020 9:22 PM

VBA code to launch lawson add-in 10.0.7    

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 19818 0
by  John HenleyJump to last post
7/24/2020 2:34 PM

Add-Ins for Office 2016    

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 26507 0
by  sbridenstineJump to last post
11/11/2019 3:39 PM

Mass PO20 Line Cancellation Through Add-Ins    

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 25811 0
by  Rani IlapaJump to last post
12/9/2020 5:59 PM

Header format in MOA    

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 17246 0
by  JimYJump to last post
5/13/2019 3:17 PM

GL65 JE Number    

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 3602 0
6/7/2019 9:06 PM

AP40.1 query (ADDINS) on Comments    

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 17672 0
by  Elmer MadarangJump to last post
12/26/2019 5:54 PM

Help needed! ADDins - are all key fields required on the spreadsheet?    

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 17165 0
by  Ragu RaghavanJump to last post
1/24/2020 4:09 PM

AP45.1 Query    

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 18170 0
by  JonAJump to last post
3/19/2020 3:57 PM

Currency Upload    

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 2985 0
3/12/2020 4:03 PM

.uwf template for AP20    

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
16708 0
by  Ragu RaghavanJump to last post
8/23/2023 6:10 PM

Excel crashing after exiting Query Wizard and Upload Wizard.    

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 18835 0
by  Kat VJump to last post
6/9/2021 3:03 PM

Cost Adjustment Report    

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 13203 0
by  Kat VJump to last post
11/8/2021 10:50 PM

PO20 - How to Create a PO with MS Addins?    

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 14253 0
by  AnnJump to last post
12/1/2021 10:54 PM

MOA Version 10.0.x and HR11 Issue    

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 14082 0
by  TerryBJump to last post
2/17/2022 1:57 AM

Finding field identifier    

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 2186 0
5/23/2022 8:53 PM

Select multiple forms to query from Add-Ins?    

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 18841 0
by  John HenleyJump to last post
7/28/2022 6:22 PM

Add-ins report.    

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 3043 0
by  berban35Jump to last post
4/25/2023 1:06 PM

best way to run in Lawson    

Started by  berban35
Hello, what is the best way to run a report in Lawson other than Add-ins
5 6541 0
by  James.MooreJump to last post
5/1/2023 10:44 PM

Missing Multi-Stream Upload Option    

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 1029 0
7/12/2023 11:09 PM

What is the file name that stores the URLs that you chose in the drop down when you are signing into Addins?    

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 9473 0
by  humansince1982Jump to last post
9/12/2023 6:22 PM

Lawson 10.1 PO20.1 Comment Upload    

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


RSS Feed Available