• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

AP160 FORMAT - ONE LONG RECORD STRING

 8 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
JPurvis
Send Private Message
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 Send Private Message
Posts: 10
Basic Member
10/3/2012 7:45 PM
Do you have the option of FORMAT = 'I' on the Output Options tab?
JimY
Veteran Member Send Private Message
Posts: 510
Veteran Member
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
Send Private Message
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
Send Private Message
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 Send Private Message
Posts: 5
New Member
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 Send Private Message
Posts: 510
Veteran Member
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:
[code]hurcob='cob32 -C nolist -vW e -C warning=1 -C noalter -C vsc2' AP160.cbl -u [/code]

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
Send Private Message
Posts: 3351
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.
Thanks for using the LawsonGuru.com forums!
John
JimY
Veteran Member Send Private Message
Posts: 510
Veteran Member
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.