Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Integration / Customization
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Wayne Willis
Past 24 Hours:
1
Prev. 24 Hours:
1
Overall:
5190
People Online:
Visitors:
271
Members:
0
Total:
271
Online Now:
New Topics
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
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
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
1351
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Forums
Integration / Customization
Forum:
S3 Customization/Development
Search this forum:
77 Subscribed to this forum
Page 4 of 23
<<
<
2
3
4
5
6
>
>>
Topics
Replies
Rating
Status
Views
Subscribers
Last Post
Using current date in if statement
Started by
Jessica M
I am hoping someone can help me with a COBOL statement. I haven't touched cobol in quite a while and my co-worker that usually works with our custom cobol is out of the office for a bit. I have a custom program that was excluding any employee with a term date in a file. They now want to change it to include anyone termed that day. The current statement is: IF (EMP-TERM-DATE > '00000000') GO TO 1040-NEXT-EMP...
2
40312
0
by
Jessica M
6/22/2016 6:38 PM
calculate the last day of any month
Started by
Chesca
Is there an API I could use to calculate the last day of any month
6
68402
0
by
kim
6/16/2016 4:20 PM
Compile Error
Started by
Judy Longo
I created AR15M from AR150, reentered all of the workfiles in workdef and get following error PrcWRKFILE(): AR15M Not Found In WsGrp
1
66308
0
by
jaherb
6/13/2016 7:15 PM
0 instead of blanks in CSV file
Started by
pgallucci12
When a 4GL program creates a CSV file, and numeric fields defined in that CSV contain ZERO values, BLANKS are substituted. Is there a way to force a ZERO instead Is there a setting in a configuration file that can do that Example: CSV file contains 2 fields, NAME and COUNT. The value in NAME = 'J.Jones' The value in COUNT = 0 Currently the CSV record for the above looks like... 'J.Jones', I need it to look like... 'J.Jones',0
6
68592
2
by
David@SOM
6/3/2016 5:12 PM
Web service calls *FROM* Lawson
Started by
MBond
How would one call a web service on another machine FROM lawson&160; The call would need to be made in the background without opening a new window.&160;&160; The web service can accept either a POST or GET request.&160; For this request, the response is not processed but future request probably would need to process the response.&160;I think the xmlhttp request is the answer but have no documentation on it's use. I've seen a lot of posts on calling into Lawson web services from external a...
6
70500
4
by
Jason Beard
5/26/2016 1:29 AM
New custom program
Started by
Greg Moeller
I have developed a custom program that just calls a shell script.... When I try to add the job with the custom form in it, I get an error that says 'The value {1} is invalid for the parameter _TKN' Any clues what is happening here
3
65843
1
by
Jason Beard
5/26/2016 1:04 AM
Portal Page for Workunits
Started by
LauraBryant
I have a design studio portal page that displays all the AP workunits. I would like to filter the results to only include the accounting units that the users requester code has access to. I get the requester code and I get the account units from the RQAcctU table. How can I filter the results from the WFWORKUNIT table to only select the rows that have an accounting unit allowed.
0
3957
1
5/18/2016 5:56 PM
tsBeginDBTransaction error is Operation illegal while in transaction (20).
Started by
Lilyb
I'm developing a custom program (update job) to invoke a copy of AP30.3, and keep getting the following error: File SYSTEST/TXTAXTABLE. tsBeginDBTransaction error is Operation illegal while in transaction (20). Does anyone know what this means and how to fix it Thank you
2
67665
0
by
Lilyb
5/12/2016 10:52 PM
Best practice of copying a program
Started by
Vijay S
Dear All, I have to copy a standard program having around 10 workfiles. We all know that Lawson doesn't change the name of workfile and WS-Field ID in work file definition while copying , It changes the same in PD (like wherever I am using WH130, it will change it to ZZ130 in PD/WS, The workfile name starting from WH130 doesn't change). It seems like I have to manually go into PD and change the name of all the Workfiles and other field. I had done it earlier also where there were like couple of...
3
69136
0
by
jaherb
5/12/2016 1:53 PM
Best (certified) Lawson Development Partner for S3 and/or M3
Started by
AvaTax Calc for Lawson/Infor
I am seeking a third-party shop who is certified by Lawson/Infor to develop 'Connectors' with S3 and/or M3. Avalara is an Infor Partner, supporting eight (8) different Infor ERP platforms. I hope to find the A1 certified development partner for S3 and/or M3. Thank you for your help!
1
69439
2
by
shahzad
5/3/2016 7:01 AM
Comment Attachment Processing compile error
Started by
John Desmarais
I'm trying to do something that should be very simple - determine the existence of Comments on Invoice Messages, just like MA66 does when it needs to determine what text to put in the Message Button on the screen. Simple, no I looked through the API manual to see if there was any voodoo involved - looked pretty easy. copied the code right out of MA66PD and dropped it into my program. INITIALIZE &...
2
65989
0
by
John Desmarais
4/7/2016 2:49 PM
Extract File Issues
Started by
jaherb
I am not sure why I am not seeing the issue with a simple extract program... but I am at a loss at this point. We have an extract file being produced as a 250 byte fixed length file. There are 3 record types... a typical Header, Detail and Trailer record. Each record must be delimited by CR/LF characters. The logic writes the records to an intermediate sequential file and then at the end of the job it is reformatted by a cnvexp -f filename 250 ...
14
68288
2
by
jaherb
4/1/2016 3:52 PM
Lawson Portal automated access and session handling
Started by
andrewwalk
Hello, Is there a way to automatically send to Lawson a bunch of requests to a specified form via a Java http client Actually I am able to do this, but it is very slow as I have to programmatically logon and logoff for each request. I need to be able to log in once, and then send all the requests I need to. Any time I send a request after the session has timed out, then I want to be able to detect this and re login, then send my requests. Is there an API for this in e...
0
3448
1
3/29/2016 6:18 PM
Oracle SQL reformat date
Started by
Chesca
I am writing an SQL statement to select dates from a table and creates a file. I want to convert date to string mm/dd/yyyy. Any help would be greatly appreciated. select startdate from table; this date is displayed as 31-MAY-15 so I want it displayed as 05-31-2015
3
69635
2
by
Chesca
3/1/2016 8:23 PM
Input date validation
Started by
Chesca
We have a custom batch program that validates input date from a csv file. The date is never formatted properly and sometimes could be mddyy, mmddyy, or mmdyy. We want the date to be reformatted as mmddyyyy. If the input date is 8 digits and mmddyyyy. then continue processing. Otherwise, check if the date length and fix it. Is there a Lawson API I can use to reformat the input date to be mmddyyyy
4
67855
1
by
Chesca
2/10/2016 12:39 PM
Cannot replace my own custom form
Started by
mikeP
Working on my first update form in PGMDEF and have run into a number of issues. Currently, I can’t seem to get rid of the previous version of my form. Ideally it will have multiple PRDISTRIB records and allow just the account field to be updated. At this point, it’s just and “online inquiry” that shows a few fields from the file. The problem is that I created a new version but Lawson won’t display it. Here’s the sequence: Create form in PGMDEF....
6
71960
0
by
John Henley
2/5/2016 7:07 PM
SQL question on APINVOICE, APDISTRIB, APPAYMENT
Started by
Karl Kemp
I am trying to write a query that will return APINVOICE, APDISTRIB, APVENMAST, and APPAYMENT information. Basically the user wants the Paid invoice detail information including vendor name and check number & date. I created the following query but it doesn't seem to completely work the way I would like it to do. It pulls the same invoice & distrib twice for each combination. In other words, if there is a single invoice with 2 distribution records, instead of the query returning 2 r...
2
79612
1
by
Chesca
1/28/2016 7:52 PM
lawson 10 ESS theme 10.3 override
Started by
KellyB
Hi, is there a way to add 'themes' I found the xhrnet/xml/config - emss_config_xml where it says themes but I am not sure where this is getting the theme files I can manually change the css link in the header.htm file to refer to a custom style sheet but wanted to know if there is a better way using themes I am running lawson 10 on webshere not via sharepoint.
0
11877
0
1/27/2016 7:49 PM
Windows script to do rnddbdump to file
Started by
tambrosi
Hi all, I am looking for some help on scripting in Lawson, I am new to the software, looking to run a script to dump a table to csv file. I can run the rngdbdump –c gen queuedjob > jqstat.csv from the server and it will run clean and dump the data to the csv file. When I apply the same code in a script, nothing gets dumped to the csv file, the file is created but no records in the file. I also tried the jqstatus same issue. ...
6
68544
1
by
pbelsky
1/19/2016 9:36 PM
Missing data in modified CSV error report after promotion
Started by
Woozy
Hi Gurus - I'm stumped, and I need some ideas. We have a custom batch program that includes an error report. I recently modified the program and the error report to add additional columns. With the new columns, the report is too wide for the printed report but works fine in the CSV export in DEV. However, after promoting the changes to PROD, the report compiles and runs without errors in PROD, but some of the new columns are blank in the CSV including the error message column (from...
12
67496
2
by
pbelsky
1/7/2016 10:46 PM
RECDEF
Started by
Chesca
Can I create a paintscreen program to access recdef
4
67373
1
by
Kwane McNeal
11/30/2015 6:06 PM
Scheduling job automatically with dynamic date range
Started by
Vijay S
Is there a way to schedule a job automatically in 'recdef' and passing job parameters automaticcaly like To & From date range. They have to be from the past 7 days . Like for today's run , From-date=today, to-date=today-7 days....... Thanks, Vijay
3
68877
0
by
Vijay S
11/25/2015 7:35 AM
Database reads INTO a unique working storage area
Started by
Todd Mitchell
Curious if anyone has done a database read (find) where the read places the data into a separate or unique working storage section. Example READ VENMAST INTO VENMAST-PAY-VENDOR.
2
65861
1
by
Todd Mitchell
11/19/2015 8:53 PM
Add columns to report csv beyond the print report width limit
Started by
Woozy
Hi Everyone, I have a 4GL custom program that includes a work file with lots of fields. I want to create a secondary report for the job based on the work file (so it shows in Print Manager), but there are more columns than will fit on the print report. I really would prefer to include only a couple of rows on the print report, but have all the columns show on the csv version of the report. I've tried adding additional fields to the report group $FIELDS section without including them in t...
5
67250
1
by
jaherb
11/17/2015 9:21 PM
Best Way to add spaces in Header of a CSV file via batch Program
Started by
Vijay S
Dear All, What is the best way to add spaces in a Header for a CSV file which is generated via a Lawson 4GL batch program while using 800-WRITECSV-. I also need to add a field 'Debit/Credit Separator' in the file with spaces and '/'. what is the best and simple way to achieve this. CSV files doesn't take spaces and '/' when defining it in workdef. Thanks Vijay
6
67500
1
by
Vijay S
11/17/2015 10:07 AM
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 4 of 23
<<
<
2
3
4
5
6
>
>>
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