Incoming payments with auto-clearing of customer open items based on the payment reference number

[Jan_L_]

The challenge is to perform the auto-clearing of customer open items based on the unique payment reference number contained in the bank statement format camt.053. This is something essential in the Nordic countries like Finland and Norway.

The bank statements contain customer payments, using the payment reference number as a key to identify open items and clear them. The linkage of the external transaction type (delivered by the bank statement), the posting rule F001 and the interpretation algorithm supposed to find customer open items and match them according to the clearing rules.

This does not work in any test scenario tried so far.

SAP’s support support suggested the algorithm 027 for Finland, but it is not in the position to find the payment reference number that is provided in the bank statement. This might be due to a linkage to a bank statement format that is outdated.

Since S4HANA Cloud does not provide access to create (or even investigate an interpretation algorithm), users can only rely on the given tools and potentially work with the bank statement item reprocessing features.

Unfortunately, these lack the option to search for a payment reference number too (like a valid allocation algorithm or new processing rule).

What is the setting/configuration required to make this work?

Thanks

-Jan-

[JulianoRomanato]

Hello janliedtke.

How are you? I have excluded the Tag "SAP S/4HANA Cloud" and included the Tag "SAP S/4HANA Cloud for Finance" for this question, as Bank Statement is an Object of Finance Line of Business.

Regards.

Juliano Romanato.

[Aswathi_Menon · Accepted solution]

Hi Jan,

As per your reply, I believe you are able to resolve the issue by using the interpretation algorithm "028: Reference Number Using MULTICASH Conversion Programs”. I will take your comments has feedback and will discuss with our development team for improving the EBS process.

Thanks & Regards,

Aswathi

S/4HANA Cloud Financials | PM CIE

SAP Support

[Aswathi_Menon]

Hi Jan,

Please refer to the SAP Help Portal documentation for Interpretation algorithms in the below link:

Receivables Management - Interpretation Algorithms at: https://help.sap.com/docs/SAP_S4HANA_CLOUD/918bca53037f408f91a2295d04ac16bc/4dc5efb40c381c36e1000000...

For Finland, interpretation algorithm 027 (Reference number TITO) should work. This algorithm searches for the Payment Reference supplied by the Finnish TITO bank statement format.

Are you getting any errors in the bank statement log? Can you please share the screenshot of logs for the bank statement from the app Reprocess Bank Statement Items?

Thanks & Regards,

Aswathi

S/4HANA Cloud Financials | PM CIE

SAP Support

[Jan_L_]

Thank you for your feedback, Aswathi!

The link and answer you have provided are known to me. Unfortunately, algorithm 027 is maintained for a bank statement format that is no longer in user in Finland and it does not do the job.

The link that addresses this challenge is How to Adjust Your Format Mapping | SAP Help Portal and the usage of “028: Reference Number Using MULTICASH Conversion Programs”.

Although the format in use is camt.053 (ISO 20022), and the name of the algorithm is misleading, it is the one that works with the external transaction PMNTRCDTVCOM.

Thanks

-Jan-