Bank Statement - Search String - Clear Open item

[Former Member]

Dear SAP Experts,

In the client I am currently working on, for incoming payments when we upload bank statements, it is only generated posting area 1 ( debit main bank account and credit transit bank account) and posting area 2 is generated manually ( debit transit bank account, credit customer open item)

We think that via "search string" functionality that SAP offers once the bank statement is uploaded posting area 2, could be posted too.

In the payment note that we have on the bank statement (:86) we have the company code followed by the billing document, let's say something like "AAAA009xxxxxxx", where AAA is the company code and 009xxxxxxx is the billing document and we have made the setting in the search string as follow:

1) Search String definition

-Name: no relevant

-Description: no relevant

-Source: 009#######

-Mapping: 009#######

2) Search string use

Positive value

Interpretation: 0021 "Reference document number search"

Based on the setting just mentioned, we understand that once bank statement is uploaded, posting area 1 will be uploaded ( as usual) and posting area 2 too, with debit in transit bank account and credit on the customer open item related to the billing document that appear on the payment note of the bank statement.

Unfortunately, it does not work, and only posting area 1 is generated, for the posting area 2, we receive the following error: "Error (F5 263) the difference is too large for clearing". We believe that this message error is because system is not able to find the customer open item related to the billing document that appear on the bank statement.

We have defined the posting rule as follows:

DT02 1 40 DT BANK                  50 DT INCOMING BK 1

DT02 2 40 DT INCOMING              DZ                          8

Is there anything wrong in our settings?

I look forward hearing from you when possible?

Apologies for the inconvenience.

Yours Sincerely,

Javier

[henk_hoogerbrug]

Hi Javier,

Maybe it's too late for you, but have you already used the search string test transaction FEBSTS (you can also find it in SPRO just after the search string definition)?

If there is a document in the system, this transaction will find it and returns the number. If so, the search string is OK (then you have to take a look at the clearing customizing), if not, you have to check the search string.

Kind Regards,

Henk

[Former Member]

Hi Henk

Thank you for your response, i have the EBS in the system, but when is use the test transaction you adviced, it cant find the EBS.

It says the following, when i try to simulate using the EBS number.

BSPS_PATTERN_SETUP: No active search string selected

[henk_hoogerbrug]

Hi Anders,

It means that you must activate the search strings.

Please navigate to customizing transaction: Financial Accounting > Bank Accounting > Business Transactions > Payment Transactions > Electronic Bank Statement > Define Search String for Electronic Bank Statement and then the folder "Search string use", there you have to mark the checkbox for the search strings you want to use (the field is called "Active").

Kind Regards,
Henk

[Former Member]

I have a similar issue, does anyone know how to proceed?

[Former Member]

This message was moderated.