3573108 - Switch excel format is not available when exporting data in App Display G/L Account Balances - Summary/Journal Entry Views - SAP S/4HANA Cloud Public Edition

Currently, XLS format files can only export up to 60,000 records. In cases where the data exceeds 60,000 records, how to export all the data at once? Is it possible to switch the format to XLSX in the App Display G/L Account Balances - Summary/Journal Entry Views?

SAP S/4HANA Cloud Public Edition

1. Go to App Display G/L Account Balances - Summary/Journal Entry Views.
2. Fill in the mandatory fields and click 'Go'.
3. Click 'Export'.

Due to the following technical limitations, SAP currently only provides the XLS version and does not support switching the format during export. We recommend adding filters to reduce the data volume before exporting.

Technical limitations: 
The XLS format is converted from HTML, which is relatively easier. The XLSX format, however, is a ZIP file and is much more complex to convert directly. Additionally, it involves issues with merged cells, which appear simple but are very challenging to implement. 

Export, XLS, XLSX, Display G/L Account Balances - Summary/Journal Entry Views, switch format , KBA , FI-LOC-FI-CN , China , How To