Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Financial Management
Lawson S3 Financials
AP160 FORMAT - ONE LONG RECORD STRING
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Chris Radcliffe
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5187
People Online:
Visitors:
211
Members:
0
Total:
211
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
Prev
Next
Forums
Lawson S3 Financials
AP160 FORMAT - ONE LONG RECORD STRING
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
JPurvis
Posts: 5
10/3/2012 7:27 PM
We are attemping to setup a NACHA file format using AP160. Our file currently is outputting a file that puts the data in one long string. We wanted to get this type of format below.
Basically the normal NACHA looking format....any help or thoughts? Where are we missing a flag or parameter to get the output to look like this?
Thanks!
1 data
5 data
8 data
9 data
Vicki
Basic Member
Posts: 10
10/3/2012 7:45 PM
Do you have the option of FORMAT = 'I' on the Output Options tab?
JimY
Veteran Member
Posts: 510
10/4/2012 11:02 AM
There was a patch for that, but you could change the ORGANIZATION to LINE-SEQUENTIAL for ACHTAPE-FILE to solve your problem. I can't seem to remember which patch it was.
JPurvis
Posts: 5
10/4/2012 12:18 PM
Hi sorry, I only have P and C. I don't seem to have the format option of 'I'.
JPurvis
Posts: 5
10/4/2012 12:19 PM
[quote]
Posted By JimY on 10/04/2012 07:02 AM
There was a patch for that, but you could change the ORGANIZATION to LINE-SEQUENTIAL for ACHTAPE-FILE to solve your problem. I can't seem to remember which patch it was.
[/quote]
Hi, I'm pretty much a rookie with Lawson. Where would I go to see the Organization to Line-Sequential for ACHTAPE-FILE setting? Which form etc?
Thanks so much.
MattK
New Member
Posts: 5
10/4/2012 1:22 PM
We had the same issue so decided to use an ETL tool to read the file and put it into format, and it works rather nicely. We have to tweak some of the data in the file anyway to conform to what the bank need.
JimY
Veteran Member
Posts: 510
10/4/2012 2:34 PM
Hi JPurvis,
What I did is use the command bldsh which pulls all the source code together. It will place the program code in $LAWDIR/product_line/apsrc/. You can then find the select statement there. You cannot use the lawson compile scripts (qcompile,etc). I use the following:
hurcob='cob32 -C nolist -vW e -C warning=1 -C noalter -C vsc2' AP160.cbl -u
You will then have to move the resulting generated member AP160.gnt to $LAWDIR/product_line/obj/.
If you don't want to go through all this you could use the command cnvexp that will change a file from sequential to line sequential. you will have to know the length of the record. You could develop a script to do this and execute it after AP160 completes. Hope this helps.
John Henley
Senior Member
Posts: 3348
10/4/2012 3:41 PM
I recommend using a multi-step job created via jobdef. Step one runs the AP160, and then step two calls a script that includes the cnvexp command to post-process the file into the correct format.
JimY
Veteran Member
Posts: 510
10/4/2012 3:44 PM
I agree John. I do that when I have to run scripts that process files that have been created by the previous step or when I want to send emails to notify that a program has completed. I created a cobol program using 4GL that I edited to call the script. It works great for me. Thank you.
You are not authorized to post a reply.