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
- File upload either either via Bank Statements view or File Management - Inbound Files view.
- Maintain the mandatory data as to Company, House Bank, Import Format.
- Under Attachments press Add- File.
- Find the file that you want to upload and press Add.
- Start File Upload.
- 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.
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
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