Electronic Payments Register not exporting to Excel

[rmay]

Hi, I don't seem to be able to export the electronic payments register report (found in reports > banking)

- this is a problem across all clients and computers that I've tried it on

- I can export other reports to excel with no issues

- I can export this report to other formats such as csv (my current work-around but not ideal long term) 

- I do not get an error message. I see excel open, the export begins to process, then cuts out and shuts down the excel file. 

Any ideas? Can support fix this please?

[AliK607 · Accepted solution]

Hello @rmay ,

This is a known issue, please see the workaround below to successfully export this to Excel:

Electronic Payment Register Report does not send to excel

Summary

After displaying the Electronic Payments Register report the send to excel option does not open excel with the report. This has been logged with Product Development and a workaround is available below.

Workaround

If you send the report to excel from the index to reports menu the report will send to excel.

Regards,