EBS Automatic Clearing

[Former Member]

Hi Experts,

Currently I'm configuring Electronic Bank Statements to automate the bank reconciliation process of our company. We receive the bank statements in Multicash format and there, we get the SAP FI document number in the "Note to payee 1" field for each payment transaction we did through automatic payment program with the bank.

Now we want to enable automatic clearing of these entries based on the SAP Document Number. For this I've configured the external transaction types for payments with interpretation algorithm "001: Standard Algorithm" and processing type "0 Dummy entry - not assignable". However, system doesn't clear the transaction automatically and it requires me to manually clear the transaction at the time of uploading and processing bank statements.

can any one tell me how to enable automatic clearing based on the document number.

Thanks in advance !

[former_member194797 · Accepted solution]

Hi,

choose algorythm 020 (Document number search) and when launching program RFEBKA00 don't forget to enter your payment document number range in the "BELNR number interval"

[Former Member · Accepted solution]

Thanks Henri. I was able to resolve the problem.

[Former Member]

Hi All,

In my case I my match ratio is very less as bank is sending ref number in correct place but in few cases I am getting two doc numbers separated by space. In such cases system applies payment for doc 1 but leaves second doc after space .

Please suggest is there any way I can force system to read entire content of file for that record ? I read about search string pattern but this pattern combination is different in my file like some times spaceDoc1spacespacedoc2 sometimes doc1spaceDoc2.

Please help.

[former_member194797]

Hi,

for outgoing payment, clearing should be done using a single reference: the payment document number.

[Former Member]

But Henri In my case bank is sending two invoice numbers separated by space so payment is getting applied for invoice 1 and getting skipped for invoice 2..

[former_member198032]

Hi Pradeep,

have this saved for you in the future:

Electronic Bank Statement - ERP Financials - SCN Wiki

Interpretation Algorithms - Electronic Account Statement (FI-BL) - SAP Library

Hope our answers were helpful for you.

Regards,

Cristiano

[Former Member]

Thanks Cristiano !