Automatic clearing of bank interim account for outgoing payments with reference number

[HolleBolle]

Dear Community,

I certainly need some help from expert:

1. We have posted two normal vendor invoices to two different vendor accounts. After that we executed normal payment run. The open items on the vendor accounts are cleared with clearing document number 2000000006:

2. The payment run posted outgoing payments on bank interim account for outgoing payments:

3. The DME file is being send to the bank including the reference number which is also included in xml file:

4. Bank statement from bank is coming in and is being uploaded via FIORI App “Manage Incoming Payment Files”. It returns the reference number from payment run (in this case as MsgID and PmtInfId). As of my understanding it is sufficient if reference number is in field PmtInfId.

5. However, SAP will not automatically clear Bank against interim account for outgoing payments (bank ledger posting only:  De Bank interim outgoing – Cr Bank). Error protocol is telling me that “The difference is too large for clearing”. For me it looks like that SAP is not really finding the corresponding postings with DME information from payment run to clear the open item.

6. When I manually enter corresponding DME reference number in FEBAN, SAP will find the Open Items and can be cleared directly.

Question: Why is SAP not finding the correct open items or DME information from the payment run during automatic electronic bank statement processing? What might I be overlooking?

[Edrilan_Berisha]

Hi,

can you have a look on the Reprocess Bank Statement Item, if the DME number is saved in the field Check? If not, this is the reason why the 019 interpretation algorithm doesn't work. My proposal is to use the 419 algorithm instead, as it has a better fallback logic, which would also check the memo line for the DME number. But also in this case, you need the number to be either in the memo line or the check field.

You find an overview about the algorithms here: https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/3cb1182b4a184bdd93f8d62e3f1f0741/4dc5efb40c381c36e10...

Best,

Edrilan Berisha

SAP S/4HANA Cloud Financials Development

[HolleBolle]

Hi,

thanks for your supply.

1) Interpretation Algorithm 419 seems not to be available? Any hints?

2) Which exact fields need to contain the DME reference number in the electronic bank statement when using 019 DTA?

Thanks  @Edrilan_Berisha 

[Edrilan_Berisha]

Hi, on which release are you? You have to use the 419 algorithm with our new rule framework Processing Rules for Bank Statements. https://help.sap.com/docs/SAP_S4HANA_CLOUD/918bca53037f408f91a2295d04ac16bc/d6fe6526b26f46e59d9d1dd0...

[HolleBolle]

Hi,

we are on S4CORE 107, SAP S/4HANA 2022. However, it looks like Advanced Bank Statement Automation (scope item 4X8) is not activated/available.

Nevertheless, I have used algorithm 019 (Data Medium Exchange) to extract reference number from memo line. For me it seems like this is working but not automatically. In transaction FEBAN SAP is identifying those two open items but only after hitting the "allocate open items" button. Why is this not happening automatically in background?

As of my understanding posting rule is correctly setup?:

Thanks

[Edrilan_Berisha]

Hi HolleBolle,

actually, this is how algorithm 019 works. If you execute it within our fiori app reprocess bank statement item, we use in the background a fallback logic to also check for the DME reference in the memoline. This is never used, when you run the 019 in a posting rule. It will check only in the field CHECK, memo line is ignored. This is also mentioned in the official documentation on the help portal.

Btw if you would upgrade to OP2023 FPS 2 the scope item 4X8 becomes for free, you can read on my latest blog post: https://community.sap.com/t5/enterprise-resource-planning-blogs-by-sap/future-of-electronic-bank-sta...

Only the algorithm 419, will use the "fallback logic" to also check in the memoline for a DME reference.

Best,

Edrilan