Is Search String for Electronic Bank Statement still not available for SAP Public Cloud?

[Vanessa]

Bank Reprocessing Rules is not able to cater our requirement, which is to add leading zeroes to Reference field. The bank sends them without leading zeroes, while our Reference field contains additional 2 leading zeroes.

[Edrilan_Berisha · Accepted solution]

Hi,

no the processing rule is not capable of doing that. Have you tried it using a REGEX function in the additional conditions?

Let's say your assignment numbers have a 10 digits length, then your REGEX should be this one:

^(?!0+$)0\d{10}$

If it's longer or shorter than 10, please adjust the red highlighted 10 in my REGEX function.

If you add this to your processing rule, it will match.

Best,

Edrilan Berisha

[Vanessa · Accepted solution]

Hello,

[Vanessa · Accepted solution]

Hello, I added the REGEX as additional condition. Didnt have to change anything as the no. of digits is exactly 10. However, the memo line did not match. There are other prefix aside from the 10 digit reference, hence maybe that's why it was not captured. Another question is if interpretation algorithm 421 (processing instruction 11) is the right algorithm to use in our issue (where the bank does not send the references with leading zeroes, and leading zeroes are maintained in our document references.). From my research it seems that interpretation algorithm 26 (Search for ref doc with leading zeros if <10) seems to be a good one to use, but is not available in the processing rules app or reprocess bank statements app, only in CBC.

[Edrilan_Berisha · Accepted solution]

Hi Vanessa,

then you have to adjust the REGEX function and add whatever prefix could be there. If you have issues to create such a REGEX, please use LLM models out there (ChatGPT etc.) to generate a REGEX function for you. It's really not that hard. The algorithm 421 should be fine.

Best, Edrilan Berisha