SAP Knowledge Base Article - Public

3577040 - Unable to display Japanese Date in the exported general ledger data file in app 'Display G/L Account Balances - Summary/Journal Entry Views' - SAP S/4HANA Cloud Public Edition

Symptom

The date format for items, such as Posting Date, in the exported file with the ".xls" extension is fixed to MM/DD/YYYY. It is not possible to display the 'Japanese Date' format in the exported file, even after changing the "Date Format" setting to 'GYY-MM-DD(Japanese Date)' before exporting the data in the app 'Display G/L Account Balances - Summary/Journal Entry Views'.

Environment

SAP S/4HANA Cloud Public Edition and above

Reproducing the Issue

  1. Fill in the fields and click Go in the app 'Display G/L Account Balances - Summary/Journal Entry Views'.
  2. Click Settings --> Language and Region ---> Date Format ---> GYY-MM-DD(Japanese Date).
  3. Click Export icon.

Resolution

This is the standard behavior in the SAP S/4HANA Cloud Public Edition 2408 version, and the behavior has changed in the SAP S/4HANA Cloud Public Edition 2502 version. The Posting Date/ Journal Entry date/ Value Date will displayed in "GYY-MM-DD(Japanese Date)" format in the exported file by clicking the Settings --> Language and Region ---> Date Format ---> GYY-MM-DD(Japanese Date). 

Keywords

date format, change format, export, Display G/L Account Balances - Summary/Journal Entry Views, Posting Date, Journal Entry date, Value Date, GYY-MM-DD, MM/DD/YYYY , KBA , FI-LOC-FI-CN , China , Problem

Product

SAP S/4HANA Cloud Public Edition all versions