2654852 - Spain - CSB 43 file format Error Message No bank account active on DD.MM.YYYY for account number ABC, national bank code XYZ, and currency WWW found

SAP Knowledge Base Article - Public

2654852 - Spain - CSB 43 file format Error Message No bank account active on DD.MM.YYYY for account number ABC, national bank code XYZ, and currency WWW found

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

  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 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:

  1. Go to the Liquidity Management work center.
  2. Select the Master Data view.
  3. Select the My Banks subview.
  4. Select the relevant Bank.
  5. Click the Edit button and select the Bank Accounts tab.
  6. Select the Relevant Bank Account ID.
  7. Maintain the Bank Account Number with the correct 10 digit Bank Account number.

Maintain the File Header record in the upload file.

  1. Go to the Liquidity Management work center.
  2. Select the subview File Management.
  3. Select the view Incoming File.
  4. Select the relevant File.
  5. Under the area Attachments, select the upload file hyperlink to open the file.
  6. The first line of the file should contain the File Header Record.
  7. 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
  1.  The File Header Record should look like the following example: 001234YYMMDD 

See Also

http://aeb.respuestaprofesional.com/files/norma_43_ingles.pdf

Keywords

CSB 43, Bank Statement, Upload File, No bank account active, , KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To

Product

SAP Business ByDesign all versions