Symptom
When trying to delete External Transaction Code: XX for Import Format YY in the Automatically Generated Bank Statements Activity, errors are raised:
"External transaction code XX can only be deleted after all uploaded bank statements using this code are posted."
"Error while checking table ABC"
"Save failed"
(XX stands for the External Transaction Code ID, YY for the Import Format number and ABC for the table ID)
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Business Configuration work center.
- Open Overview view.
- Search for Activity: Automatically Generated Bank Statements.
- Click on Edit import formats for automatic generated bank statements.
- Select Import Format YY.
- In the table below, choose External Transaction Code: XX and click on Remove.
- Errors are shown.
Cause
This error occurs when there are Bank Statements using Import Format YY not posted yet in the system.
It can be checked in the following path:
- Go to Liquidity Management work center.
- Open Bank Statements view.
- Click on the Advanced filter and select:
Bank Statement Origin: File Upload
Status: In Preparation - Hit Go.
There are one or more Bank Statements with status: "In Preparation" that use the Bank Statement Format described in Import Format YY, which is from the same Import Format where the External Transaction Code XX is trying to be deleted.
Resolution
In order to remove External Transaction Code XX from Import Format YY in the Activity: Automatically Generated Bank Statements, either post or delete all Bank Statements that are currently In Preparation and use Import Format YY.
Keywords
external transaction code, import format, bank statements, upload, automatically , KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To
SAP Knowledge Base Article - Public