3243714 - Manage Recurring Journal Entries - wrong date format in exported excel

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."

SAP S/4HANA Cloud

1. Enter App Manage Recurring Journal Entries (F1598).
2. Enter necessary parameters (Company Code, Recurring Journal Entry, Next Posting Date etc.).
3. Export the list into excel.
4. 'Next Posting Date' has wrong date format.

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.

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.

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