Symptom
- During the upload of a bank statement from Excel using the Manage Bank Statements functionality, a warning message is displayed stating that the external transaction could not be found.
- The system then uses the default posting rule, which results in incorrect posting values during Electronic Bank Statement (EBS) postings.
- The issue persists even after verifying the external transaction types available as part of Trans. TypeCAMT053 and updating the upload file with the same transaction types.
Environment
SAP S/4HANA Cloud Public Edition - Finance - Treasury Management - Payments and Bank Communications - Bank Statement (Public Cloud)
Reproducing the Issue
- Open Fiori App - Manage bank statements.
- Fill in the header with house Bank Account.
- Upload the template file.
- The file gets uploaded successfully.
- Fill in the opening balance and closing balance as prompted by the system.
- Click create. A warning message appears stating that the External Transaction type could not be found and the default posting rule will be applied.
Cause
The sign of the amount in the Excel sheet is different from the sign in the external transaction type in the SSCUI Make Global Settings for Electronic Bank Statements.
Resolution
- Verify the sign of the amount in the Excel sheet.
- Ensure it matches the sign in the external transaction type in the SSCUI 101024 - Make Global Settings for Electronic Bank Statements.
- If the signs do not match, adjust the sign in the Excel sheet to match the external transaction type in the SSCUI 101024.
Keywords
SAP S/4HANA Cloud Public Edition, Finance, Treasury Management, Payments and Bank Communications, Bank Statement, EBS, Electronic Bank Statement, Posting Rule, Default Posting Rule, External Transaction Type, SSCUI, Excel Sheet, Sign of Amount. , KBA , FI-BL-PT-BA-2CL , bank statement (Public Cloud) , Problem