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"

SAP Knowledge Base Article - Public

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"

Symptom

When you try to upload an electronic bank statement you receive the following error message 'No bank account active on DD.MM.YYYY for account number X, national bank code Y, and currency ZZZ found' eventough every thing is active in the system.

Reproducing the Issue

  1. Go to WorkCenter Liquidity Management
  2. Subview Bank Statements
  3. Click New-Bank Statement Upload
  4. Maintain all your data
  5. Click Start File Upload

Error message: No bank account active on DD.MM.YYYY for account number X, national bank code Y, and currency ZZZ found

Cause

Customer maintained two different Bank IDs for one Bank. The first is in status Obsolete while the other Bank ID is in status Active.

The system cannot differentiate which Bank ID is the correct one - hence it picks the Bank ID which was maintained first in the system. The same data such as Account Number, Description is the same in both Banks

Resolution

To solve this issue you can either set the status from Obsolete to Active or maintain the data in new Bank entry and update it accordingly

  1. Go to WorkCenter Liquidity Management, Subview Master Data - My Banks
  2. Select the respective bank
  3. Click View All and navigate to General tab
  4. See Bank ID XYZ - Bank Name
  5. Double click
  6. Bank Directory Entry for XYZ is in status Obsolete
  7. Click on the selection icon in the Bank ID field
  8. Search for bank entry with the exact same name
  9. Select bank ID ABC- Bank Name
  10. Double click on Bank ID
  11. Status is Active
  12. Account details are the same in both Bank entries

 

Keywords

KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To

Product

SAP Business ByDesign all versions