Collection ACH file to bank (Enhancement with ACH Reference Number)

[Former Member]

There is a standard ACH collections (NACHA) file format that can be generated via the CD payment program (FPY1). We need the ability to add a custom field (ACH Reference Number). This field will be utilized to send a unique number to the bank with the idea that when we receive an ACH return file from the bank, the bank will send this number back to us and a return lot will be created using this reference number to find the original payment..

Please help me how can I enhance ACH collections

[Tobias_Fioneer]

Hi Fayaz,

In general, you should copy format ACH to a custom specific format and use this for your enhancements.

You could use your own function modules to generate ACH file. Please check under Contract Accounts Receivable and Payable -> Business Transactions -> Incoming/Outgoing Payment Creation -> Payment Medium -> Define Payment Medium Formats for format ACH the event modules. You could use event 31 to add ACH Reference Number?

Best Regards,

Tobias

[chetan_bhatt3]

Hello SAP Expert,

ach-file-blank-records.jpg

My client is using ACH payment for sent payment to customer, vendor and payroll, normally every time ACH file successfully created with relevant information and sent to to bank after go live 2019 in S/4 HANA 1610. But some time when proposal run file was generated without any information and sent to bank and we received email from bank that file received without any information. This issue not frequently happed and due to company policy we can not debug this issue in production client -or- we can not replicate this issue in other clients. Could you please let me know how can I find out root cause of this issue. Please find attached AL11 report for ACH file.

Thank you,

Chetan Bhatt

[Tobias_Fioneer]

Hi Chetan,

please check job protocol in F110 payment run for root cause.

Kind Regards,

Tobias