3372093 - Payment Run Export File is Not Opening in Microsoft Excel

You create a Payment Run for Payables or Receivables and you want to export the results to Microsoft Excel, however there is an Error appearing in the Excel file explaining that the Payment File is corrupt. 

You have exported other Payment Runs to excel with similar amounts of data, and these worked as expect.

SAP Business ByDesign 

1. Go to the Payables or Receivables Work Center - Payment Runs View.
2. Show Active Payment Runs, search for Run ID XXX (XXX represents the Payment Run ID).
3. Under Execution Details select all Logs and click on the View Payment Proposals.
4. Select all Payment Proposals from the Drop Down Menu and press Execute Search.
5. Press Export - to Microsoft Excel and download the Excel File to the Hard Disk.
6. Open the File in Excel.
7. Press Yes.

Now an Error Message appears: "The file is corrupt and cannot be opened". 

A value in the column "External Reference" of Payment ID YYY (YYY represents the Payment ID) contains an unsupported/corrupted ASCII character. If you export all the data apart from the Payment ID YYY everything is working fine. You need to remove this character from the Payment ID YYY. 

1. Go to the Payables or Receivables Work Center - Payment Runs view.
2. Show Active Payment Runs, search for the Run ID XXX (where XXX is the Payment Run ID).
3. Under Execution Details select all Logs and click on view Payment Proposals.
4. Select all Payment Proposals from the Drop Down Menu and press Execute Search.
5. Filter after the Payment ID YYY.
6. Search for the column "External Reference".

You can see that it contains an unsupported and corrupted ASCII character.

Please remove or change this value, execute the Payment Run again and export the results to Microsoft Excel. 

Export to Microsoft Excel, Payment Run file, Payables, Receivables, corrupt file, error in Excel file , KBA , SRD-FIN-ACP , Payables , Problem