Symptom
You upload a new Bank Statement, each transaction is created.
Few outgoing payments with the External Transaction Code example 116 or 191 are automatically assigned with payment method: "Outgoing Bank Transfer"
Few incoming payments have an External Transaction Code example 051 are created with payment method: "Other Incoming Payments" instead of "Incoming Payments"
You see the necessary configuration is already maintained in Business Configuration as well
Environment
SAP Business ByDesign
Reproducing the Issue
- Open Liquidity Management work center
- Select related bank statement
- Open it and check transactions
- Click on 'Required' postprocessing status of the line item
- Here the the problem is, that the payment method is 'other incoming payment', instead of 'incoming payment'
Cause
The reason why the codes 116 and 191 works, while the 005 or 051 does not is, the leading zeros in the configuration table of the customer.
In the parsing of the file the leading zeros are removed and the system expects the code 5 or 51 instead of 005 and 051 in the configuration to properly match the entries.
Resolution
You need to add the lines to the configuration with just 5 and 51 as External transaction Code in the configuration(Business Configuration - Activity: Automatically Generated Bank Statements)and then try to upload a bank statement to use these codes.
Keywords
Bank statement, External transaction code , KBA , AP-PAY-BS , Bank Statement , AP-PAY-PAL , Payment Allocation , Problem