Define Search String for Electronic Bank Statement in Cloud?

[Expert]

We need to define search strings for Electronic Bank Statement in Norway but it seems that this functionality is not available in Cloud yet, do you have any suggestions on how we can solve this and still get an automatic clearing of customer invoices?

As it is now, the SD invoice is 90000005, but on the SD invoice, the reference of which the customers will pay with contains an extra check number in the end (for example 900000057). That means that without setting up Search strings we will not be able to clear the customer invoices automatically.

[Expert · Accepted solution]

Search strings are not supported in S/4HANA Cloud. Instead we have new functionality called Bank Reprocessing Rules which can be used to automate the reprocessing of bank statement items. You can find more information on this on the help portal using the below link along with some guidance on how these work:

https://help.sap.com/viewer/918bca53037f408f91a2295d04ac16bc/2011.500/en-US/d6fe6526b26f46e59d9d1dd0...

[Michal_Pandosca]

Hi there!

What kind of bank statement do you use?

In the case of MT940 there is a way how to cherry-pick (subtag, length, offset) the information from the :86: structured information.

https://blogs.sap.com/2019/10/25/structured-format-for-field-86-in-mt940-bank-statement/

if not could you describe in more detail why you receive different payment references comparing to the information which you have in SD?

Best regards,

Michal

[former_member132363]

Here are some SAP resources you may review based on your topic "define | of | electronic bank statement | invoice | sd invoice | customer invoices"

Partner Bank Type for multiple supplier bank accounts

Nov 14, 2018 ... Hence, there should be a way by which the Invoice processor should be able to earmark the supplier payee bank account for payment of invoices?...

https://blogs.sap.com/?p=141

Best Practices for SAP S/4HANA Cloud

Group Account Preparation for Financial Consolidation - This scope item provides ... the customer payments solution, which handles electronic bill presentment and ... the definition and creation of recurring fees (billing plans) in the invoicing?...

https://support.sap.com/en/product/best-practices-s4hana-cloud.html

Finance ERP

KW-LOG: New Support package for Letter of Credit and Bank Guarantee ... and vendors include the VAT amount as separate line in their quotations and invoices . ... SAP S/4HANA Cloud edition: Deliver to existing customers using hotfix procedure. ... Specific Billing form template ?SDBIL_CI_STANDARD_AE? is delivered in?...

https://support.sap.com/en/product/globalization/fi-erp.html