SAP Knowledge Base Article - Public

3274734 - Error "Enter a valid value" received while uploading Journal Entries via App Upload General Journal Entries - S/4HANA Cloud

Symptom

When uploading a file in App Upload General Journal Entries (F2548), the following error is received for cell Exchange rate: "Enter a valid value".

Environment

S/4HANA Cloud

Reproducing the Issue

  1. Open App Upload General Journal Entries (F2548)
  2. Click 'Browse'
  3. Message appears: "Correct errors and repeat the upload. To view the status of journal entries, choose Show Log"
  4. Click 'Show log'
  5. Select Item
  6. Error: "Enter a valid value"

Cause

This is a known data conversion issue in App Upload General Journal Entries (F2548).

Decimal number like 0.07 is converted to scientific notation in MS Excel, which cannot be parsed correctly in SAP.

Resolution

There is a workaround for this issue:

Add ' before the numbers, save ‘0.07 in Excel. Then it will be saved as text in the Excel.

Keywords

Enter a valid value, App Upload General Journal Entries, F2548, decimal number , KBA , FI-FIO-GL-TRA , Transaction Apps , FI-FIO-GL-TRA-2CL , Transaction Apps (Public Cloud) , How To

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions