SAP Knowledge Base Article - Public

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

Symptom

You get 'No bank account active on DD.MM.YYYY for account number XYZ, national bank code XX, and currency A found' error when uploading an Incoming Bank Statement file.

(XYZ stands for the account number); (XX stands for the national bank code number).

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Liquidity Management work center.
  2. Go to the Bank Statements view.
  3. Select the relevant Bank Account.
  4. Click on the New button and select Bank Statement Upload.
  5. Upload the Incoming Bank Statement file.

    Error 'No bank account active on DD.MM.YYYY for account number XYZ, national bank code XX, and currency A found' is displayed.

Cause

The Incoming Bank Statement file contains a mix of numbers and letters for the Bank Account ID information in tag 25.
SAP Business ByDesign system supports a Bank Account ID containing only numbers, therefore, when the Incoming Bank Statement file is uploaded, as Bank Account ID information in the file differs from the one maintained in the system, the system cannot find the correct Bank Account. 

Resolution

You can maintain an Alternative Account Number that matches the one in the Incoming Bank Statement file.

1.  Go to the Liquidity Management work center.
2.  Select the Master Data view. Select the My Banks subview.
3.  Select the relevant Bank.
4.  Click the Edit button and select Bank Accounts option.
5.  Select the relevant Bank Account ID.
6.  Under Account tab go to the Alternative Account Number box, enter the Bank Account ID as shown in the Incoming Bank Statement file.
7.  Save the changes.

See Also

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

Keywords

Incoming Bank Statement File
Alternative
Account Number
Bank Account
National Bank Code
Currency
Liquidity , KBA , SRD-FIN-ERM , Travel and Expense Management , Problem

Product

SAP Business ByDesign all versions