SAP Knowledge Base Article - Public

2948635 - Change the format cell of Quantity (MENGE) in Upload General Journal Entries App

Symptom

The app Upload General Journal Entries ends with error message: 'Enter a valid value (line X, column Y, value 2,2 )' (example for Quantity 2,2 entered in Excel file).

logdetails.png



"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

S/4 HANA CLOUD

Reproducing the Issue

  1. Open Upload General Journal Entries

  2. Choose Download Template

  3. Enter required data including value for technical MENGE (Quantity), in this case example value of 2,2

quantity.png




Cause

Bug, issue fixed in CE2011 & OP2020

Resolution

Workaround for release CE2005 & CE2008:

  1. In the uploading file, change the format cells to 'Text', for a single cell if there are not many lines, or change for the whole column.
  2. And change the value to 2.2, using dot as the decimal point which can be recognized by the database. The maximum decimal length is 2 digital.


TEXT.png

See Also

Upload General Journal Entries
Adding Field Columns in Template

Keywords

Upload General Journal Entries, F2548 , KBA , FI-FIO-GL-TRA , Transaction Apps , FI-FIO-GL , Fiori UI for General Ledger Accounting , Problem

Product

SAP S/4HANA Cloud 2005 ; SAP S/4HANA Cloud 2008