Symptom
You are trying to upload a Bank Statement using the File Format Spain - CSB 43 but you receive the following error messages:
-
No bank account active on DD.MM.YYYY for account number ABC, national bank code DEF, and currency GHI found (Where ABC represents the Bank Account number, DEF represents the national bank code, GHI represents the currency).
- Bank account missing or cannot be determined.
- Bank statement ID $1 for bank account ID rejected.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Liquidity Management work center.
- Navigate to the File Management view and choose Inbound Files.
- Select New and Inbound File.
- Select the file containing the bank statement(s) via Add for the selected house bank.
- Press Start File Upload.
Cause
The system is failing to find the 10 digit account. The Bank account number should be corrected for this function to work. The Correct Account number should contain 10 digits.
Also the header details should be maintained in the upload file. For file format CSB 43 - 00-FILE HEADER RECORD should be maintained as the first line on the file.
Resolution
To solve this issue, you must maintain the following:
Maintain the data in the Bank master data:
-
Go to the Liquidity Management work center.
- Select the Master Data view.
- Select the My Banks subview.
- Select the relevant Bank.
- Click the Edit button and select the Bank Accounts tab.
- Select the Relevant Bank Account ID.
- Maintain the Bank Account Number with the correct 10 digit Bank Account number.
Maintain the File Header record in the upload file.
- Go to the Liquidity Management work center.
- Select the subview File Management.
- Select the view Incoming File.
- Select the relevant File.
- Under the area Attachments, select the upload file hyperlink to open the file.
- The first line of the file should contain the File Header Record.
- The File Header Record should contain the following:
- Record Code, 2 positions 00
- Bank Code used in the file, 4 positions - 1234 (1234 represents the Bank Code)
- Accounting Date of the period to which the information corresponds YYMMDD
- The File Header Record should look like the following example: 001234YYMMDD
See Also
Keywords
CSB 43, Bank Statement, Upload File, No bank account active, , KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To