Displa G/l account balance - summary/journal entry view APP export report is text

[HaoYuLong]

Display G/L account balance - summary/journal entry view APP export report is text, SAP can be changed to numbers? Can improve financial work efficiency.

[umasaral · Accepted solution]

In the Display G/L Account Balance - Summary/Journal Entry View app, exported reports are in text format by default.To change them to numerical format for better financial efficiency:

1. Use Excel Formatting: Convert text to numbers using Excel's "Text to Columns" or "VALUE()" function.
2. Adjust SAP Output Settings: Check SAP Fiori export options or use SAP Analysis for Office for better formatting.
3. Use Custom CDS Views: Create a Custom CDS View to export data in the desired format.

For official guidance, refer to SAP Help Portal or SAP Fiori documentation.

https://help.sap.com/docs/

[BobShen]

I have a testing in the system, and export to an excel, and found the amount can be added using formula, for example:B3+B4, SUM