Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
User Experience
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Chad Mac
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5185
People Online:
Visitors:
194
Members:
1
Total:
195
Online Now:
Orlando Gray
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3291
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1360
Roger French
1315
mark.cook
1244
Forums
Filtered Topics
Unanswered
Unresolved
Announcements
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Forums
User Experience
Forum:
Lawson Add-Ins for Microsoft Office
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.
Search this forum:
78
Subscribed to this forum
Page 1 of 10
1
2
3
4
5
>
>>
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
25616
1
by
NJN
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 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
19697
1
by
Rani Ilapa
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. 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...
4
6437
2
by
Belma
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
19863
0
by
jefriedman
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
20432
0
by
John Henley
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
27182
0
by
sbridenstine
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
26567
0
by
Rani Ilapa
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
17844
0
by
JimY
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 separate entries so it assigns JE 1 to Sample 1 and JE 2 to S...
0
4302
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
18259
0
by
Elmer Madarang
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 data required, and whe...
1
17769
0
by
Ragu Raghavan
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'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
18763
0
by
JonA
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
3551
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
17412
0
by
Ragu Raghavan
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'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
19410
0
by
Kat V
6/9/2021 3:03 PM
Cost Adjustment Report
Started By
TerriS
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
1
13875
0
by
Kat V
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
14974
0
by
Ann
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 resolution It ...
2
14714
0
by
TerryB
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
2798
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
19583
0
by
John Henley
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
3615
0
by
berban35
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
7211
0
by
James.Moore
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
1585
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's location
2
10061
0
by
humansince1982
9/12/2023 6:22 PM
Lawson 10.1 PO20.1 Comment Upload
Started By
Jon S
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...
1
1505
0
by
John Henley
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 10
1
2
3
4
5
>
>>
General
--Dealing with Lawson / Infor
--SOx Compliance
--Career Development
--Staffing
--Hosting / Cloud
--User Group Announcements
Infor / Lawson Platforms
--Lawson Landmark
--S3 Systems Administration
S3 Security
--M3 Application Foundation
--M3 Workplace Foundation
--Infor CloudSuite
User Experience
--Lawson Portal
Lawson Design Studio
--Lawson Smart Office
Mashup Designer
--Infor Workspace
--Infor Social Space
--Lawson Add-Ins for Microsoft Office
--Mobility
--Lawson Enterprise Search
Integration / Customization
--IPA/ProcessFlow
--Infor ION
--S3 Interfaces/Conversion
--S3 Customization/Development
--S3 Application Upgrades
Human Capital Management
--Lawson S3 HR/Payroll/Benefits
--Infor Global HR (GHR)
Financial Management
--Infor CloudSuite Financials
--Lawson S3 Financials
--Lawson M3 Financials
--Infor FMS
--Lawson Services Automation (PSA/SA)
--Lawson Budgeting & Planning
Expense Management
--Infor Expense Management
--Lawson Time & Expense
Enterprise Resource Planning & Manufacturing
--Lawson S3 Procurement
--Lawson M3 Manufacturing Operations
--Infor ERP (Syteline)
Supply Chain Management
--Infor SCM
--Lawson S3 Supply Chain
--Lawson M3 Supply Chain
Enterprise Asset Management
--Infor EAM
--M3 Enterprise Asset Management
Performance Management
--Lawson Business Intelligence/Reporting/Crystal
Smart Notification
--Lawson M3 Business Performance Warehouse
--Lawson Opportunity Analyzer
Lawson Healthcare
--Cloverleaf
--Lawson MediSuite
--Analytics for Healthcare
Job Fair
--Positions Available
--People Available
LawsonGuru.com
--LawsonGuru.com Support