SAP Knowledge Base Article - Public

2831944 - Error when importing the Excel file manually in "Manage Bank Statements" app

Symptom

When importing the bank statements from an Excel file in "Manage Bank Statements" app, below error occurs:
"Could not import file: &&&.xlsx
Reason: Excel line &: Enter a valid Amount/Payment Amount (for example, 1.234.567,89)."

Environment

SAP S/4HANA Cloud

Reproducing the Issue

  1. Open "Manage Bank Statements" app.
  2. Click on "Create" button.
  3. Click on "Import" button.
  4. Select the Excel file to import manually, and the error occurs.

Cause

The error occurs due to the "Decimal Format" setting maintained in the "Maintain Business Users" app.
Select the CB user used, under "Regional Settings" section, the decimal format maintained should be same as the one in the Excel file.

Resolution

  1. Change the "Decimal Format" setting maintained in the "Maintain Business Users" app.
  2. Or change the decimal format in the Excel file.

Keywords

Manage Bank Statements, Create, Import, Maintain Business Users, Decimal Format, F1303, F1564, Amount/Payment Amount, Could not import file , KBA , FI-FIO-AR , Fiori UI for Accounts Receivable , FI-BL-PT-BA , bank statement , FI-FIO-AR-2CL , Fiori UI for Accounts Receivable (Public Cloud) , Problem

Product

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