Symptom
Date fields are exported wrongly into excel in App Manage Recurring Journal Entries (F1598).
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Enter App Manage Recurring Journal Entries (F1598).
- Enter necessary parameters (Company Code, Recurring Journal Entry, Next Posting Date etc.).
- Export the list into excel.
- 'Next Posting Date' has wrong date format.
Cause
With CE2208 release an issue is fixed that the date field could display the wrong date if time zone is less than UTC (for example, American Center time zone UTC -5). It is taking this side-effect on exporting function.
Resolution
The issue will be fixed in next release.
Possible workaround FOR THIS CASE EXAMPLE: convert the date with formula “=MID(G2, 7, 10) / 86400 + DATE(1970, 1, 15)” in excel.
Keywords
Manage Recurring Journal Entries, F1598, Next Posting Date, wrong formula, export, excel, spreadsheet, export to excel , KBA , FI-FIO-GL-TRA , Transaction Apps , FI-FIO-GL-TRA-2CL , Transaction Apps (Public Cloud) , Problem