Symptom
You are adding additional External Transaction Codes for bank statement files that are based on SWIFT bank statement format MT940 DE (Germany).
- Business Configuration work center.
- Activity: Automatically Generated Bank Statements / Edit import formats for automatic generated bank statements.
- Format: 01 - MT940 DE
Here, for example, External Transaction Code XYZ has been assigned Debit/Credit 'Decrease' and is mapped to Payment Method 'Payment Processing - Of Outgoing Bank Transfer'.
When processing the bank statement, however, the derived Payment Method shows as Other Outgoing Payments.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Liquidity Management work center.
- Navigate to the uploaded bank statement via Bank Statements view.
- Select the relevant bank statement and transaction.
Cause
The problem is not the application of a custom External Transaction Code and mapping to a designated payment method per se - but the conformity of the content of payment explanation blog :86: in format MT940 DE.
Here fields are delineated by characters ?00 ?20 ?30 and others.
The first field is reserved for a 3-digit External Transactions Code, others for memo-text, Payer IBAN, Business Partner Names and others.
If this is not followed and instead of ?00 any other or special character is provided - the External Transaction Code will not be interpreted and the Payment Method Mapping will not take effect.
In the absence of a mapped payment method the only information available is the Payment Direction and Amount, hence Other Incoming/Outgoing Payment.
For example:
The following content will not parse External Transaction Code XYZ in format MT940 DE:
:86:XYZ^00Text
Resolution
Adhere to pertinent specifications for SWIFT format MT940 DE.
The following content will parse External Transaction Code XYZ and the payment method mapping will take effect.
:86:XYZ?00Text
You can verify/maintain the External Transaction code as follow:
- Go to Business Configuration Work Center > Implementation projects view
- Select your Implementation Project and click Open Activity List
- Search for the "Automatically Generated Bank Statements" activity and open it
- Click Edit import formats for automatic generated bank statements
- Select the Import Format, i.e.: 01 - MT940 DE
- Check if the External Transaction Code is maintained, if not, click Add Row and enter the new External transaction code
- Click Save
Keywords
Bank Statement MT940 DE External Transaction Code , KBA , SRD-FIN-CLM , Cash and Liquity Managment , Problem
SAP Knowledge Base Article - Public