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 Public Edition
Reproducing the Issue
- Open "Manage Bank Statements" app.
- Click on "Create" button.
- Click on "Import" button.
- 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
- Change the "Decimal Format" setting maintained in the "Maintain Business Users" app.
- 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