ACH CCD+ Implementation - Return file from Bank

[former_member212156]

My client has a requirement to implement ACH CCD+ using Payment Medium Workbench for payments to vemdors. i am new to this implementation and the only one working on it. So any help would be greatly appreciated.

Currently we have the check method and below procedure is followed:

1) Execute F110

2) A text file is created though a custom program ZFCHX: "Positive Pay File File: Check Extract Creation"

3) The file is uploaded to bank server

4) After some days, "check clearing.txt" file is downloaded from the bank. (BAI Format)

5) The downladed file is processed through transaction FF_5 "Bank Statement: Various Formats (SWIFT, MultiCash, BAI...)

(Clearing sub bank account with main bank account)

6) Then use transaction code FEBAN to process if anything didnt get posted.

ACH CCD+:

I have configured almost all of the settings ( i think so). In testing client, I made couple of invoices for 2 vendors, then executed F110 and was able to generate the DME file (txt format). For testing purpose, it was sent to the bank and was processed succefully. Now the bank has sent back 2 files.

According to the bank, one file is "transaction journal" and the other one is "return file".

Transaction Journal File:    L20TRNR

Return File:                         L20ARET

I have no clue what format are these. Whenever i open them it asks for the program and normally i am using notepad to open them. But once opened through notepad, the data looks messed up. So i dont know which program should i be using to open them.

After getting the 2 files from the bank, i am stuck now. Dont know how to proceed further.

What to do with these files? Do we have to upload them ; if yes then how? Are these to be converted to some other format and then uploaded in SAP? Or should i be expecting some other file? Will there be any file for bank reconciliation (for clearing sub bank and main bank account).

So i'll really appreciate if anyone can let me know ALL the steps to go further from here. I mean after receiving the files what steps need to be followed to finish the process. And if there is any configuration left, what is it. Any immediate help would be greatly appreciated.

Thanks.

[former_member182098]

Hi Adeel,

Are they in BAI format.

You can use FF_5 or FF.5 depending on the requirement. Some of the banks provide electronic bank statements to download from the sites in BAI format. For some formats you need to fill header, transactions and trailer, whereas for some formats it is only one file. Please ensure you have received the proper file from the bank, that should resolve your issue.

Regards,

Ravi

[former_member212156]

Ravi,

Thanks for your reply.

They are not in BAI format.

Yesterday I had small discussion with the bank and they said we'll be only getting a Transaction Journal File ; no Return file. We'll only get a return file if there was any issue like the payment could not be made, wrong bank details etc.

This time we got a return file only for testing purpose.

So in reality, if the payments to vendors were successful, then we would only get a transaction journal file ; nothing else. And transaction journal is just like a confirmation and has small details like our bank details, total payment etc.

Now my main concern is doing bank reco (sub bank with main bank). Any idea on how to go from here. Do we need to create some custom program? even if we create a custom program, which file do we use?