When uploading a file in App Upload General Journal Entries (F2548), the following error is received for cell Exchange rate: "Enter a valid value".
Reproducing the Issue
- Open App Upload General Journal Entries (F2548)
- Click 'Browse'
- Message appears: "Correct errors and repeat the upload. To view the status of journal entries, choose Show Log"
- Click 'Show log'
- Select Item
- Error: "Enter a valid value"
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.
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.
Enter a valid value, App Upload General Journal Entries, F2548, decimal number , KBA , FI-FIO-GL-TRA , Transaction Apps , How To