SAP Knowledge Base Article - Public

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

Symptom

 Upon Bank Statement file upload an error appears as: "No bank account active on YYMMDD for account number XYZ, national bank code ABC, and currency DEF found."

(XYZ represents the Bank Account ID)

(ABC represents the National Bank Code)

(DEF represents the currency)

Environment

SAP Business ByDesign

Reproducing the Issue

  1. File upload either either via Bank Statements view or File Management - Inbound Files view.
  2. Maintain the mandatory data as to Company, House Bank, 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 Messages appears: "No bank account active on YYMMDD for account number XYZ, national bank code ABC, and currency DEF found."

Cause

This error points at an inconsistency in determining a valid bank account based on file format, content and maintained bank master data.
Hence multiple causes can result in this error.

Resolution

The following list details pertinent KBAs addressing this error based on the underlying root cause.

2399474 - Error Message When Uploading Bank Statement "No bank account active on DD.MM.YYYY for account number XXX, national bank code YYY, and currency ZZZ found"

2780248 - Error Message No bank account active on DD.MM.YYYY for account number 1000, national bank code XYZ, and currency XXX found 

2654852 - Spain - CSB 43 file format Error Message No bank account active on DD.MM.YYYY for account number ABC, national bank code XYZ, and currency WWW found

2590226 - Bank Account Upload Error Received as Letters in Bank Account Number Not Allowed 

2558477 - Bank Statement Upload: Bank Account Missing or Cannot be Determined 

2089501 - MT940 UK Bank Statement Upload Date Not Valid

2669287 - How to Solve Bank Statement File Upload Failed Errors 

1940792 - Error Message: No Bank account active on DD.MM.YYYY for account number, national bank code, and currency XYZ

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

Keywords

Bank Account, Active, Account Number, National Bank Code, Currency, Bank Statement file upload. , KBA , SRD-FIN-GL , General Ledger , Problem

Product

SAP Business ByDesign all versions