How can payment Advice email CSV file?

[former_member390971]

I want the ability to send the Payment Advice to Vendor email as a CSV or xml or excel file. Thinking the vendor would receive the file and load into their system to clear our open AR.

I am using Payment Medium Workbench for NACHA file creation from the payment medium in F110. I have been able to create Payment advice by specifying program RFFOAVIS_FPAYM in F110.

I have a pdf Payment Advice that RFFOAVIS_FPAYM creates. It emails to Vendor by using BTE 00002040 to specify the email address to send to. Also, I was able to change the subject using SAMPLE_PROCESS_00002050.

I have found one solution for creating a CSV file. I am creating the CSV file is by using a SAPSCRIPT to generate CSV like file. Then modifying c_finaa-textf = 'ASCII' in exit 00002040 to make it send a text file. But this solution has the following gotchas.

• Standard SAP has the filename be the same as the subject of the email. My email subject contains spaces thus file name contains spaces. I could put modification into RFF0RI06 to change the filename to solve this gotcha.
• The file comes gets sent with TXT extension instead of CSV. Another modification could solve this.

While my above hack gets around issues of sending a text file that a person could import into their system, but I am wondering if I missing an existing SAP solution to send Payment Advice as CSV, XML, or Excel file when processing the payment run in F110.

Any insight would be appreciated.

[MarekTurczynski]

Hi Matthew,

for CSV you already figured it out - output in Excel would also require modifications. However, in case of XML, there is a standard solution - a business function FIN_APAR_PAYMT_ADV. With this function you get an option to generate Payment Advice in form of an XML and send it (if a vendor/customer has a flag 'Payment Advice by XML' marked in company-code-dependent master data) via PI. This function is available since EHP5.

Here is a general information on the BF:

https://help.sap.com/erp2005_ehp_05/helpdata/EN/21/73640524e046c39bd3f8101508883a/frameset.htm

Here is a customizing note for PI:

1348137 - PI configuration: Payment advice notes via Enterprise Services

Regards,

Marek

[thomas_janssen]

Is there a newer URL that still works?

Thanks
Thomas

[former_member390971]

Marek,

Thanks for the reminder on business function FIN_APAR_PAYMT_ADV. I didn't really consider it in my earlier research because we don't have PI in our environment. But I will take a closer look to see if anything is possible without PI.

Thanks.

Matthew