cancel
Showing results for 
Search instead for 
Did you mean: 

Electronic Bank Statement - Clearing outgoing payments using Clearing Doc number

jaytee
Explorer
0 Kudos
1,396

Hi All, I need some help getting the Electronic Bank statement to automatically clear outgoing payments. Have trawled many posts on this but getting nothing seems to work!

Currently when vendor payments are made the SAP Clearing Document number (ie. The 2000nnnnnn ZP document number from F110) is provided to the house bank for each payment and this number is then returned on the CAMT53 XML bank statement.

I have completed the first step which was to tweak the XML transformation used by FF_5 in order to retrieve the Clearing Doc number and add it to the Note to Payee.

It should then be straightforward to use this number to make the bank GL posting (Credit Main Bank Debit Bank Clearing account) and clear the credit in the Bank Clearing account on the ZP document at the same time. However for some reason it is not working.

Key Steps carried out to enable clearing (note that basic bank statement setup was already in place):

· Map external transaction PMNTICDTDMCT to Posting Rule 0001 with algorithm 020 (Doc Number search)

· Posting Rule 0001 set up as below – Posting Type 4 has been used as this seems to be the correct one based on online posts I’ve read:

0001 1 OUTGOING TRANSF 50 BANK ZV 4

· Account Symbols mapped (this does seem to be working OK from what I can see in FEBAN).

· Created a Search String to pull out the Clearing Doc number from the string “PMNTICDTDMCT2000nnnnnn” in the Note to Payee (even though this should be performed by the algorithm and hence unnecessary?!). Tested the Search String and it works fine.

Does anyone know what might be missing? I have tried various permutations in the config and then re-tried scanning for the items in FEBAN but nothing seems to work.

Accepted Solutions (0)

Answers (1)

Answers (1)

Bohdan
Active Contributor

Hi jaytee,

I think you're trying to build an overcomplicated solution. I'd approach this requirement a bit differently. If you've already decided to adjust the XSLT-transformation, why don't save the clearing document number (i.e. 2000nnnnnn, ZP) directly into field FEBEP-ZUONR ? Furthermore, I would also recommend not to use posting type 4 for posting rule, but posting type 1. This way, bank statement will generate a posting, where the Assignment for both items will be filled with the clearing document number (i.e. 2000nnnnnn).

Next, you also need to make sure that payment program is also filling the Assignment for bank (out) sub-account with the same number. To ensure that, I'd suggest to define a custom sorting key that will be based on BKPF-BELNR field. This sort key should be configured for bank (out) sub-account. This configuration will ensure that the payment program is also filling the same clearing document number (i.e. 2000nnnnnn).

The last step, you can setup a background job for bank sub account that will clear the items.

Regards,

Bohdan

ajitkumar
Active Contributor
0 Kudos

when i saw the question, your blogs are the first thing that came to my mind. i have learnt a lot from those !

jaytee
Explorer

Hi Bohdan,

Thanks for your input here. I think your approach would work but I was keen to find a solution where the bank statement would auto-clear the open item from the ZP document without the need for a clearing job.

I managed to get this working using the steps outlined in my post (including using posting type 4), although the search string was not required in the end (as I added more logic to the XSLT transformation to output the clearing document in the Note to Payee on its own rather than as part of a string). I also realised you need to specify a document number range in the BELNR selection in FF_5!

Regards,

Jeremy