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:
LynneB
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5123
People Online:
Visitors:
208
Members:
0
Total:
208
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 8 of 10
<<
<
6
7
8
9
10
>
>>
Topics
Replies
Rating
Status
Views
Subscribers
Last Post
Add-Ins issue with Excel 2007? Limited to 65k lines?
Started by
MBJH
Is it a known issue that add-ins&160;Query&160;Wizard&160;only returns 65521 lines even when used with Excel 2007 Excel 2007 allows many more lines than that, but my query results still max at 65k. Any ideas
9
8598
2
by
MBJH
8/24/2010 8:24 AM
Speadsheet Designer
Started by
Lisa Stewart
Any one heard of a Lawson Product called spreadsheet designer that is supposed the take the place of excel add-ins If so could you share what you know about it
3
14050
2
by
John Henley
8/20/2010 4:40 PM
Get Field Translation in DME Query
Started by
Woozy
I'm building a DME query against the LOGAN WFWORKUNIT table. I want to include the description of the WF-STATUS field values (which are setup in dbdef), but I can't figure out how to do it. Is there some trick to including the descriptions in the query /servlet/Router/Data/ErpPROD=LOGAN&FILE=WFWORKUNIT&FIELD=WORKUNIT;WORK-TITLE;PROCESS-NAME;WF-STATUS;WF-RM-ID;&OUT=XML Thanks! Kelly
4
5158
2
by
Woozy
7/8/2010 1:30 PM
ERROR... can't use Selection Criteria...Related Table Fields and Parenthesis
Started by
FireGeek21
Hi Everyone, We are receiving the following error when attempting to create output using MS Addins: ERROR. You cannot use Selection Criteria that contains both Related Table Fields and Parenthesis. Not sure how to resolve this... We are building output to include the following: -Dependent's Name -Benefit Plan Type (HL; DN) -Benefit Start-Date -Benefit Stop-Date -Dependent's Relationship -Dependent's Consent -Employee's Date of Hire -Employee's Name -Employee's Company ...
4
5152
0
by
FireGeek21
6/14/2010 7:45 PM
ACTRANS, APDISTRIB, CBDISTRIB, & GLTRANS Query with duplicates
Started by
Sherry Shimek
One of our users has queries set up by a former consultant that uses ACTRANS as the base table and fields from related tables APDISTRIB, CBDISTRIB, and GLTRANS. Prior to running the queries this month, the user was getting correct data.&160; She doesn't remember making any changes to the query and now she is getting multiple duplicate records.&160; The file was only 6k lines last month and now is 60k. Are there indices or other parameter settings that restrict the data to not pull duplicates...
6
6824
3
by
Sherry Shimek
3/19/2010 7:03 PM
LSF 901/Apps 901 Add-Ins Issues
Started by
MattD
Gurus, We just upgraded to LSF 9015 and Apps 9012.&160; We are now having issues with our MS Add-Ins.&160; Lawson has provided us with several updated versions of Add-Ins to correct different issues, but we are still receiving the below error.&160; The biggest issue is that there is no good way to track what is going wrong.&160; I&160;have reviewed the system logs including ios, the Websphere logs, and the log generated by Add-Ins itself.&160; None have shown any issues.&160; Any ideas o...
0
4441
0
3/17/2010 5:33 PM
License question
Started by
pmeckes
Does anyone know if the licenses for ms add ins are by concurrent users The license information for ms addins only states 'Named Users' .&160;How is everyone handling the&160;installs&160;&160;
1
4891
0
by
mark.cook
3/8/2010 12:10 PM
Lawson Addins LSF9 'Time out' problems
Started by
Deleted User
Since the upgrade to LSF9 (and patches that were since installed) I am experiencing problems running large queries using Lawson addins. I am getting a 'time out' message regularly or a 'Fatal error' message very occasionally. The IS department is telling me that this is causing problems with slowing down the users of Lawson Portal but I cannot understand why this did not happen previously as I have been using the same query regularly for almost 4 years. I have to run large data sets regularly an...
6
6026
4
by
Dave Mitchell
2/19/2010 3:44 PM
Server Resources for Addins
Started by
itsjustme
Has anyone had their Admins or Server folks complain about the resources that queries are taking up Does anyone restrict users to predefined queries and ensure that any new queries are created in a test environment to prevent odd table joins from hitting production Either we have some tuning to do or our users are building their queries wrong. Thank you for any response or organizational direction that can be provided. &160;LSF9, 8.0.3 MSP11 Apps, UNIX server w/websphere etc all on same b...
11
8293
2
by
itsjustme
2/12/2010 3:20 PM
Attach .uwf file for users in Word document
Started by
Sherry Shimek
I have created a Word document for our users that I easily attached a Excel template for uploading into Lawson.&160; However, I haven't found a good way to attach the .uwf file so the user can save it to their computer and upload the data. Any suggestions
6
11052
2
by
Dave Mitchell
2/9/2010 8:05 PM
Lawson query wizard not showig up in MS Excel
Started by
RobertL
I use Tools-->&160;Add-Ins menu in Excel to add Lawson query wizard. It works but after I close Excel and re-open it, the query wizard Add-In does not show up in Excel. I have to go to Tools-->&160;Add-Ins menu to add the Lawson query wizard everytime when I open Excel. Please advise. Thanks.
4
14995
3
by
RobertL
2/1/2010 6:55 PM
Where does the APVENBAL(MA95) table get its data?
Started by
willz06jw
Hi and thanks for your help, I am trying to use the APINVOICE and APPAYMENT tables to calculate similar results as what shows up in the PURCH section of the&160; APVENBAL&160;table (this is where MA95 is grabbed)...but they are always too high.&160; Any ideas Thanks, Will
2
4141
0
by
willz06jw
2/1/2010 6:41 PM
Using Lawson Queries to pull the transmission type from PO20 data (EDI or FAX?)
Started by
willz06jw
Thanks for your help, &91;I am using Lawson 9.0&93; I am trying to use Lawson Queries in Excel to pull the transmission type from the data for PO20.&160;&160; For example: I need to know if the POs for last year were sent via fax, edi, or paper.&160;&160; Thanks again for your help, Will
4
6714
2
by
JonA
12/17/2009 7:04 PM
po20 only loads first 5 lines
Started by
TimD
I down loaded the PO20.1 upload from http://solutions.lawson.com/lu/addins/main.htm When I try to use it, it will only load the first five lines of the po and then I get the error message : Cannot enter vendor item different from existing This message appears after every five records beyond the first five that worked. What is causing this issue I'm trying to upload 100 lines to a po. If I&160;change the temp po number after every 5...
1
4797
0
by
JonA
12/17/2009 6:51 PM
Add-ins very slow after LSF 9 upgrade
Started by
Linda Wilson
We just upgrade to LSF&160;9, and are on 8.1 apps.&160; Add-in queries are painfully slow now and many times won't finish (queries that ran in less than a minute are now running 30 minutes).&160;&160; Any ideas what might be causing this&160; Seems to be particularly with add-in queries that are using more than one table.&160; Thanks
12
5210
3
by
tam
12/1/2009 8:13 PM
Invalid Date using Upload Wizard
Started by
Staci B
Hello, My goal is to delete the medical plan for a group of ee's and add it back.&160; I used Lawson's KB 521719 to determine the required fields for mapping, but I get the following message: Invalid Date: BEN-STOP-DATE1.&160; I've changed the format of the date from YYYYMMDD to MMDDYY to MMDDYYYY and nothing is working.&160;
2
6090
1
by
Brad Schauer
11/30/2009 7:31 PM
Query Help Needed
Started by
Harry
I'm looking for assistance with an Lawson excel query. The query pulls employee information (name, work location, pay rate). My problem is trying to get pay rate information 'as of' a defined date. My query currently pulls information on employees that were employed on the defined date (i.e. 12/31/2008) but its downloading the employees current rate of pay, not their rate of pay on the defined date (i.e. 12/31/2008). Any idea on the query criteria that would solve this problem Thanks
2
4581
1
by
Adam
11/24/2009 7:50 PM
AP20 Invoice Hold Code
Started by
Deleted User
I am looking for the Hold Code field.&160;The field is located at f115_API_HLD-CODE but I can't find it in Addins at the API&160;table or in Process Flow.&160; Is it hiding in another table that I can connect using a relationship
1
4567
0
by
John Crudele
11/4/2009 8:31 PM
MA236 (Invoiced Not Received) Available as Lawson Query DME?
Started by
Lorenda
Just wondering whether anyone has a DME written to mock the output of the MA236 report in Lawson. We are needing to run it across companies, so I&160;was hoping to get a 'tweakable' query to run this using ADODB.
0
5680
1
9/23/2009 3:43 PM
PO25 Vendor Release?
Started by
willz06jw
Let me start by saying thanks for the help, Is there a way to automatically release all unreleased vendor agreements in PO25 Also, what are the effects of not re-releasing a revised vendor agreement Thanks again, Will
4
5693
2
by
willz06jw
9/18/2009 4:51 PM
Any Monarch users out there?
Started by
Deleted User
I'm new to the forum and&160;not sure this is the appropiate forum for this question&160; Anyone ever used the tool from Datawatch called Monarch&160; I use daily for all kinds of Lawson tasks.&160; It has been one of the best software investments I've ever made. Joanna Bledsoe joanna.bledsoejhsmh.org
1
3468
0
by
Norm
9/17/2009 7:10 PM
Table where I can query Full name and Login username (Using Lawson ADDINS)?
Started by
willz06jw
Thanks for your help, I am trying to find a table where I can query the username (that people log in with) and the full name attached to it. I am trying to pull this in&160;Excel using Lawson Addins. Thanks for your help, Will
2
4551
2
by
willz06jw
9/17/2009 12:44 PM
Using Perl to query Lawson DME revisited with LSF9 environment
Started by
jeremy.zerr
So we just got the LSF9 environment, and I just found out that one of the things that changed is the method of authentication for DME&160;queries. In the 8.0.3 environment, basic HTTP authentication was used, which is very easy to navigate using perl. However, in the LSF9 environment, the DME authentication switched to the Lawson server side auth, which is basically requiring a login to the same login form that normal users have to log into Portal with. This means to access LSF9 DME&160;wit...
1
4811
2
by
jeremy.zerr
8/24/2009 1:17 AM
Addins is too quick...
Started by
BrianP
I know it is hard to believe (and i can't believe i am asking) but, I need to slow down the Addins upload to&160;one entry per second.&160; The reason behind it... APAUDIT has a time field (APA-TRANS-TIME) that is updated during a delete load I am working on in AP10.6 and the process aborts with a duplicate record error due to the time (HHMMSS).&160; So far I have been able to insert several lines of old data between&160;the rows that could cause a failure and it appears to be working fine, ...
3
3941
1
by
Norm
7/20/2009 5:03 PM
ed810 not pulling tax
Started by
linda phillips
we are currently 8.03 sitting on 9.0lsf and use Ghx as our provider for EDI. We currently became a tax company and we seem to have a problem at month end with out of balance for AP due to tax. WHen you look the tax is not be added to the invoice and we run the ap126 which matches and were done. Has anyone set up edi for tax &160; I'm begining to think that this is the problem. If not and anyone has a great suggestion on how to fix this I would greatly appreciate your help. The only one we ...
0
4017
0
7/2/2009 3:40 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 8 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