SAP Knowledge Base Article - Public

3350365 - Wrong Payment Method is Picked when a New Bank Statement is Uploaded

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

  1. Open Liquidity Management work center
  2. Select related bank statement
  3. Open it and check transactions
  4. Click on 'Required' postprocessing status of the line item
  5. 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

Product

SAP Business ByDesign all versions