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:
Wayne
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5120
People Online:
Visitors:
354
Members:
0
Total:
354
Online Now:
New Topics
Lawson S3 Financials
PO Matched Dollars and Matched Quantity
5/10/2024 6:51 PM
Can anyone share the Lawson calculation to determi
S3 Customization/Development
COBOL CSV file
5/10/2024 2:36 PM
We have a custom Cobol program ZU200 that creates
S3 Systems Administration
Using MFA for Lawson S3 Access
5/8/2024 1:23 PM
Does anyone use Multi Factor Authentication when u
Lawson Landmark
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
IPA/ProcessFlow
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1357
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Forums
User Experience
Forum:
Lawson Add-Ins for Microsoft Office
Search this forum:
77 Subscribed to this forum
Page 9 of 10
<<
<
6
7
8
9
10
>
>>
Topics
Replies
Rating
Status
Views
Subscribers
Last Post
AP10.6 Company Codes (lsf9, 803apps)
Started by
BrianP
Has anyone had&160;success using Lawson Add-Ins against AP10.6.&160; My user would like to&160;delete Company Codes.
6
6277
2
by
Brad Schauer
6/29/2009 1:44 PM
Vendor Query
Started by
Boyd
Does anyone have any thoughts on creating a Query that will Pull in Vendor, Vendor ID, GL coding (A/U, Acct. etc.) and Payment number&160; I&160;have been able to pull in all the information I need except for the Payment number.&160; Boyd
4
10368
2
by
Boyd
6/26/2009 5:47 PM
Addins for PA22-creating duplicate records
Started by
thanef
I am trying to upload a file from CE&160;Broker to PA22 Certifications but I am getting duplicate records for some reason.&160; LIS does not support this function when I asked them for help.
1
3998
2
by
John Henley
6/3/2009 10:43 PM
Unreleased AP invoice - APDISTRIB & APINVOICE tables Activity field not filled?
Started by
Sherry Shimek
&160; Help - We need to see Activity field information for unreleased AP invoices to determine which activity is overbudget and not allowing the batches to post. Set-up a query of APDISTRIB and APINVOICE tables including Activity and Account Category field from APDISTRIB.&160; Allowed Multiple OTM&160;Values for multiple invoice lines.&160;On AP20 screen confirmed that on invoices queried there were activities entered, but nothing was included in the Actvitiy field of the query. Thanks!&1...
7
11980
3
by
Sherry Shimek
5/18/2009 5:44 PM
MS Addins install that limits to Query only capability
Started by
Michael Barron
As part of our LSF 9.0 implementation we are upgrading MS&160;Addins. We would like to allow query only capability without providing the Upload even when some people may have update rights to the screen in Portal. I know by removing the 2 upload wizard files you can prevent uploads from being done but I was curious how you bundled that process to provide users or people to install MS&160;Addins and ensure these wizards are not installed.
3
4021
1
by
Michael Barron
5/1/2009 6:30 PM
MS Add-ins version level with LSF9 env/8.03 aps
Started by
Deleted User
We are upgrading to LSF9, but remaining on 8.03 applications until next year.&160; We are currently on MS Add ins v2.0.5.0.&160; Lawson has indicated that we can upgrade to v9.0.3.1.&160;&160;My understanding is that this version was released in 2006.&160; Is anyone&160;with this configuration&160;using a different version&160;of MS Add-ins&160; Thanks&160;
7
4736
1
by
Michael Barron
5/1/2009 5:08 PM
Field size limitation in query???
Started by
Sherry Shimek
&160; Does MS&160;Addins and or Excel&160;have a size limit to the amounts to be extracted in a query&160; We have a number we have queried from a table that appears to have lost the last two digits of a $3trillion gl amount.
3
4845
1
by
Sherry Shimek
4/27/2009 2:56 PM
BN32 - hidden key...
Started by
Shane Jones
Anyone have the structure for BN32 Add-ins.&160;&160; I thought I had it but it is not working....&160;&160; I think I need help with the Hidden Key.... Any ideas
6
9011
5
by
BrendaH
4/17/2009 6:03 PM
Issue with Add-Ins for AP20.7, does not add first record
Started by
desichet
Most of our Invoice have one line distribution.We are building AGS call to add records to AP20.7&160; to&160; occur few days&160; after Invoice header was created and Invoice is approved.&160; Running into issue with adding one record to AP20.7 OR AP20.2 (distribution). First record does not get added through AGS call OR Add-In. Return message -Message>No More Records For Given Key. Once we enter first one using portal screen, same AGS call and MS-AddIn can add more records as needed.&16...
0
5276
1
3/27/2009 9:05 PM
Creating a report from MS Access
Started by
Deleted User
Hi I am new to using Lawson and have not been trained on the software. I am used to using Peoplesoft. I have access to the back tables to run queries in MS Access. That ebing said,&160; I was told by Lawson support that there is not a report that will produce this report.&160; The report need to include a breakdown of the unemployment report breaking it down by worksite location which is the location code located on the HR11 Assignment tab. The report need to reflect by company, by lo...
2
4700
1
by
Phil Simon
3/17/2009 2:52 PM
Product Lines Disappearing
Started by
JonA
Anyone else experiencing this&160; Occasionally, when I use the Upload Wizard, my product lines are not showing.&160; I have to re-install addins for them to appear again.&160; I'm not having any issues with the query wizard. Lawson S3 Add-Ins version 9.0.3.1380; MS Excel 2003 version 11.6560.6568 (SP2); Windows XP Pro version 2002 SP2
2
4856
1
by
JonA
3/17/2009 8:21 AM
PO20.1 Add-In - Release PO
Started by
Ken Ptak
I'm attempting to create an Add-In for the PO20.1 that will perform a 'Release' from the 'Action' menu. I&160;have three fields mapped (Company, PO Number, and Save&160;FC) on the attached spreadsheet and .uwf.&160; When I&160;run the Add-In the result is 'Change Complete -&160;Continue'.&160; However, if I&160;inquire on that&160;PO on PO20, the Revision still states 'Unreleased'. We're on Apps 8.1, LSF9, Add-Ins 9.0.3.1. Any ideas/thoughts/suggestions would be greatly appreciated. ...
3
9835
1
by
John Henley
3/4/2009 4:43 PM
Lawson Advanced Add-ins query document - only available from CUE
Started by
jeremy.zerr
Just had a Lawson support person help me out with debugging some edits on a PA55 upload, they sent me a document that is only available to Advanced Add-ins class attendees at CUE. Figured I would share it.&160; Its attached to this post. Has a really great section on how to debug edits from uploads. That was the info I have been looking for quite a while, and I'm totally excited to finally have something to be able to help myself. Jeremy Running shoes website
5
6824
3
by
Srinivas
2/16/2009 9:22 AM
AP Invoice Comments
Started by
Meghan
I am trying to set up a query that will pull down AP invoice information including any comments attached to the invoice.&160; Since invoices are included as an attachment, is there any way to include them in the query
3
7962
3
by
John Henley
1/30/2009 10:56 PM
GLTRANS query returns no results
Started by
Sherry Shimek
We recently created a new data level security class expanding the data accessible to a current security class., but still not allowing full data access.&160; Lawson data level security class testing passed with no exceptions.&160; However, due to the intense MS Addins query usage of the users in the two classes we decided to test MS Addins queries. They primarily run queries on GLTRANS. Queries worked fine in the test environment except for queries of the GLTRANS table.&160; Queries of...
6
5909
1
by
k-rock
1/28/2009 8:10 PM
Product line access
Started by
GailC
I have a user with a RM setup identical to my test user. The user can only see 1 of our 2 product lines in the addin. Any idea why
2
4164
0
by
John Henley
1/14/2009 6:08 PM
addins template for hr04.7 value listing?
Started by
Deleted User
Can anyone share the secret to doing an upload for HR codes, but the actual values list (hr04.7). We have a new hr code with a bunch of values and would hate to manually input. I think that there are hidden fields involved. Any help is appreciated. &160; &160;
1
4778
0
by
John Henley
1/6/2009 7:20 PM
Deleting a GL Budget via Excel Add-Ins
Started by
John Henley
I recently was asked if you could use the Add-Ins to delete records, particularly in the GL 'Flex Budgeting' module. The answer, of course, is yes! The ability to delete records on forms was added to the Upload Wizard some time ago, and you can use it with just about any form to which you can map for adding and/or changing. And since you're just changing the way you interact with Lawson (in other words, you're using Excel as a 'front-end' instead of LID or Portal), you're still making use of ...
0
5376
0
12/27/2008 10:35 AM
AM20 security error
Started by
GailC
We are new to Lawson using the new LS security. I have security working for all addins except AM20. When my user runs it with here SuperAdmin security, it fails. When she uses Lawson (CheckLS = 'N') it works. The only thing I can find in the logging is that 'It can't execute script ModLocalAdmin.bat'. This is from the xls log. Any ideas were I can look
2
5153
1
by
GailC
12/19/2008 6:55 PM
MS Addins and Environment Form Ids
Started by
des123
I am&160;in the planning stages for installing MS Addins and setting up LAUA security accordingly. According to the 'Lawson Administration: LAUA Security', page 25, step 5, the security class for the users who will use the Addins must not include access to environment forms. Why is it necessary to&160;NOT include access to environment forms for Addins users
0
4002
1
12/10/2008 5:30 PM
Add-Ins Query - Unattended
Started by
William Saltmarsh
Is there a functionality/mechanism that will allow an Add-Ins query to run completely unattended, that is, with no operator intervention for entering login credentials and deleting duplicate output files
10
8793
2
by
MARCO3535
12/10/2008 5:08 PM
Automating Excel Add-In JE Import with VB
Started by
Deleted User
Our company is trying to automate journal entry and AP uploads to Lawson using the add-in wizard. We would like to use macros and visual basic but have not found any documentation on how to call the Lawson add-in object. Can someone point us in the right direction
11
26149
3
by
joel_f
12/5/2008 3:18 PM
New feature to insert a column in Excel Upload Wizard
Started by
John Henley
For years, one of the Lawson tips I’ve been sharing with users has been how to add a new column to an upload mapping you’d previously saved. This is often needed when you add a new column to a spreadsheet and include it in your upload. Read New feature to insert a column in Excel Upload Wizard.
1
5203
0
by
Joseph Van Denburg
12/1/2008 12:44 PM
How to Stop Addins Query
Started by
cmarcous
Query We are using Addins V2.0.3.0 with Apps 8.03&160; Is there a more efficient way of stoping the query once it is started.&160; Like for example in Access Ctrl Break will stop the query after the run command anywhere from the start to the x minutes its time to kill this now moment Upload Same question for uploads, sometimes the 1st 100 rows go fine and then there is a repeated error on everyline like 'account does not exist' and options are go for lunch or close the wizard or excel. ...
2
5101
2
by
michael2
11/4/2008 8:39 PM
Uploading Assets-AM20
Started by
itsjustme
We have a need to upload about 700 assets. The upload for AM20.1 only allows 8 at a time and each different&160;asset data is in another column of one row rather than a row for each asset data. Does anyone know of a way to upload this information more efficiently Thanks Dave
2
6531
1
by
itsjustme
8/8/2008 6:54 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 9 of 10
<<
<
6
7
8
9
10
>
>>
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 O...
--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 (PS...
--Lawson Budgeting & Planning
Expense Management
--Infor Expense Management
--Lawson Time & Expense
Enterprise Resource Planning & Manufacturing
--Lawson S3 Procurement
--Lawson M3 Manufacturing Operat...
--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/R...
----Smart Notification
--Lawson M3 Business Performance...
--Lawson Opportunity Analyzer
Lawson Healthcare
--Cloverleaf
--Lawson MediSuite
--Analytics for Healthcare
Job Fair
--Positions Available
--People Available
LawsonGuru.com
--LawsonGuru.com Support