SAP Knowledge Base Article - Public

2120390 - Automatic Allocation Fails when There Are One or More Payments Showing the Same Amount

Symptom

An electronic payment (e.g. outgoing bank transfer) has been created for a business partner in the system and its transfer effected. This payment is confirmed in a bank statement of type MT940. Based on payment - and house-bank account details your expectation is that an automatic payment allocation will be posted against this payment. After uploading the Bank Statement you notice that Postprocessing is showing as Required. When opening the Payment Allocation you see that you have one or more payments with the same amount which are not being allocated automatically.

Reproducing the Issue

  1. Go to Liquidity Management Work Center.
  2. Go to Bank Statements View.
  3. Click on New button and then Bank Statement Upload.
  4. Fill out the Company, Bank ID, Import Format and add the file provided by the bank.
  5. Click on Start File upload button.
  6. Go back to Bank Statements View.
  7. You will see that new Bank Statement was created with Postprocessing status as Required.
  8. Click on Required.
  9. You will see that payments with same amount are not being allocated automatically.

Cause

Payment - and house-bank details are not sufficient to identify a unique payment transaction for automatic allocation in case similar candidate payments are recorded in the system. Additional references, clearly identifying the candidate payment transaction, are necessary in order to effect an automatic payment allocation.

Here the file provided by the house-bank does not have the ID of the payment maintained.

In 61 of the file NSTONONREF is maintained, suggesting no particular payment reference.

Example: 

:61:DDMMYY0DXXXX,XXNSTONONREF

Resolution

In order to resolve this issue you have to get in contact with your bank and request them to include the Payment ID in the file to be uploaded in the system.

Example:

:61:DDMMYY0DXXXX,XXNMSCYY

- where YY represents the Payment ID.


Similar references in order to clearly identify confirmed payments apply for statement type other than MT940.

Keywords

KBA , automatic payment allocation , AP-PAY , Payment Processing , How To

Product

SAP Business ByDesign all versions