SAP Knowledge Base Article - Public

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

Symptom

The system rejects the upload of a bank statement with the following error message: 'No Bank account active on DD.MM.YYYY for account number, national bank code, and currency XYZ.'

(XYZ represents the currency)

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Liquidity Management work center.
  2. Navigate to the File Management view and choose Inbound Files.
  3. Select New and Inbound File.
  4. Select the file containing the bank statement(s) via Add for the selected house bank.
  5. Press Start File Upload.

Cause

The error is an indication that the house bank master data as maintained in the system conflicts with the house bank information as recorded in the bank file. Depending on the specificity of the error message, discrepancies can occur in relation to validity definitions, bank account number, national bank identifiers and currencies.

Resolution

Check the validity of the house bank definition for a relevant bank statement date.

  1. Go to the Liquidity Management work center.
  2. Enter the Master Data view and choose My Banks.
  3. Edit the relevant house bank and access the Bank Accounts via Edit. Here you can check the validity of a particular bank account in terms of time intervals and currency restrictions.
  4. Take a note of the Bank Account Number.
  5. From the tab General you can access the Bank ID and the information as maintained in the Bank Directory. Here take a note of the National Bank Code.

Compare these definitions with the data contained in the bank file either by editing the file or by employing a pertinent file reader. Depending on the result either the described definitions have to be adapted or the bank issuing the file has to be consulted.

Keywords

Bank Statement, account number, national bank code, currency, bank account, Upload, Inbound File, , KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To

Product

SAP Business ByDesign all versions