SAP Knowledge Base Article - Public

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

Symptom

Date fields are exported wrongly into excel in App Manage Recurring Journal Entries (F1598).

Environment

SAP S/4HANA Cloud

Reproducing the Issue

  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.

MRJE1

MRJE2

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 , Problem

Product

SAP S/4HANA Cloud 2208