Query Regarding UTR Number Capture and Clearing Functionality in EBRS in SAP Public Cloud

[YashpalChauhan]

Description of the Issue:

We are using the standard algorithm for EBS (Electronic Bank Statement) reconciliation in SAP Public Cloud for clearing and posting. However, we would like to inquire about the possibility of fulfilling two specific requirements:

1. Capture the UTR (Unique Transaction Reference) Number from the 86 field in the incoming bank statement.
2. Update the payment documents generated through the Automatic Payment Program (APP) with the UTR number.
3. Search for the reference documents that correspond to the payment documents and automatically perform clearing based on these reference documents.

We would like to know if there is an existing algorithm in SAP Public Cloud that can fulfill these requirements or if any configuration or custom development would be required.

Steps Already Taken:

1. Review of Standard Algorithm: We have reviewed the standard EBS reconciliation algorithm and observed that it does not automatically capture the UTR number from the bank statement or update the payment documents generated through the APP.
2. Manual Process: Currently, we manually capture the UTR number from the 86 field and update the payment documents.

Business Requirements:

1. UTR Capture: The system should automatically capture the UTR number from the 86 field in the bank statement.
2. Payment Document Update: The UTR number should be updated in the payment documents generated via the Automatic Payment Program (APP).
3. Reference Document Search: The system should automatically search for the reference documents that correspond to the payment documents.
4. Clearing: The system should automatically perform clearing based on the reference documents linked to the payment documents.

Questions/Clarifications:

Is there an existing algorithm or configuration in SAP Public Cloud that can automatically capture the UTR number from the 86 field of the bank statement and update the payment documents generated through the APP?

[Anita_Ahmadpour]

Hi @YashpalChauhan ,

I'm afraid I cannot answer all of your questions. However, I'd like to make you aware of the following two things that might be useful for you: 

• Have you considered using the Map Format Data for Incoming Files from Banks app to create and change/adjust data mapping for file formats? For more information, see How to Create a Format Mapping and the related links at the bottom.
  
  
• Instead of relying on the interpretation algorithms, have you considered working more with processing rules? You can use specific conditions and different processing instructions in processing rules in roder to process your bank statement items. For more information, see: Overview of All Predelivered Processing Instructions, and How to Create Processing Rules. 
  
  

I hope these resources help you.

Best regards,
Anita

[henk_hoogerbrug]

Hello,

Please investigate if algorithm 019 meets your requirements. With this algorithm you can automatically match the bank statement item with the outgoing payment (initiated by the payment program).

Best Regards,
Henk Hoogerbrug