3541049 - Error When Uploading Bank Statement File in CSV Format.

• An error occurs when attempting to upload a Bank Statement file in CSV format.
• The error message displayed is: "No bank account active on YYMMDD for account number XYZ, national bank code ABC, and currency DEF found".
• The issue persists despite the bank details appearing to be correct.

(XYZ represents the Bank Account ID)

(ABC represents the National Bank Code)

(DEF represents the currency)

SAP Business ByDesign

1. Attempt to upload a Bank Statement file in CSV format either via Bank Statements view or File Management - Inbound Files view.
2. Maintain the mandatory data as to File Type, Company, Bank ID, Import Format.
3. Under Attachments press Add- File.
4. Find the file that you want to upload and press Add.
5. Start File Upload.
6. Error message appears:

No bank account active on YYMMDD for account number XYZ, national bank code ABC, and currency DEF found.
Bank account missing or cannot be determined
Bank statement ID $1 for bank account ID rejected

The 'My Bank Account ID' field in the CSV file has been filled with "XYZ", which is not a valid in SAP Business ByDesign. This leads to the system's inability to identify a bank account.

To resolve this issue, the "Bank Account Number" must be used in "My Bank Account ID" field in CSV file.

1. Open the CSV file and locate the 'My Bank Account ID' field.
2. Replace the incorrect "XYZ" value with the correct Bank Account Number "AAA" (AAA represents the Bank Account Number).
3. Save the changes to the CSV file.
4. Attempt to upload the corrected CSV file again.

KBA: 3167595 - Error: No bank account active on YYMMDD for account number XYZ, national bank code ABC, and currency DEF found

Bank Statement, CSV file, Upload error, Bank Account ID, Incorrect value, Bank Account Number, Bank account missing or cannot be determined. , KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To