SAP Knowledge Base Article - Public

2775038 - Amount can't uploaded correctly in fiori app F2548

Symptom

When uploading an excel template in fiori app F2548 ("upload general journal entries"), it ends up with error "Enter a valid value (line "XX", column "X", value "XX.XXXXXXXX")".

Environment

SAP S/4HANA Cloud

Reproducing the Issue

1. Start fiori app "Upload General Journal Entries".
2. Select an excel template file and upload it.
3. Error shows up saying "Enter a valid value (line "XX", column "X", value "XX.XXXXXXXX")".

Cause

The amount fields in the template excel file are not in plain text format.

Resolution

Transformat the amount fields in the excel into plain text format and upload it again.
For the detail conversion steps, please see the attachment in this KBA.

Keywords

F2548, "Upload General Journal Entries", Format, Amount. , KBA , FI-FIO-GL , Fiori UI for General Ledger Accounting , Problem

Product

SAP S/4HANA Cloud all versions

Attachments

ConversionSteps.docx