EBS payment document number vs invoice number

[Former Member]

Hi All,

We are configuring EBS, where we'd first like to make a payment using F110 and then run EBS to clear the outgoing GL account number.

However, MT940 statement from the bank would contain (KR) invoice document number in tag 61. However after making payment from F110 that KR document number would be paid by ZP document number hence I'm not able to get the logic as to how to get the EBS to uploaded by clearing the outgoing payment account and update the Main bank GL account

For example - if my invoice number is (KR) 3123456 / 2017 with the entry

Expense - Dr to Outgoing Payment Account (99901) - Cr

After I make the payment through F110 the document number generated is (ZP doc type) 8000456 / 2017 entry being

Outgoing Payment Account (99901) - DR to Vendor Account - CR

When I'm trying to use Algorithm - 020 and also tried using 012 in OT83 with no DR posting key and posting type 4 to clear the debit GL account (outgoing payment account) and credit Main bank account with "50" posting key - the system is looking to clear the ZP document type 8000456.

However, it is the invoice number of KR document type 3123456 that the bank sends in the EBS. I've tried using BELNR number range from 1 - 9999999999 in FF.5 so as to aid the EBS along with the IA - 020 for searching using document number.

Please suggest how can I get the achieve the above of clearing 99901 GL account between invoice document number and payment document number.

Regards - Somu.

[Former Member]

It's possible to post to account 99901 with ZUONR populated with VALUE DATE. So when you run F110 with value date 25-11-2017 (actual transaction) today the account is debited with outgoing payments. When you read the bank statement on 26-11-2017 the transactions are credited to 99901 with the transaction date of 25-11-2017. This way you can clear on totals on value/transaction date.

[former_member513101]

Hi Somu,

Make sure you pass the payment document no to Bank when you generate the payment medium file. If you are using DMEE to generate the payment medium file, you can check link below.

https://blogs.sap.com/2013/12/11/ebs-autoclearing-process-for-multiple-ach-payments-in-sap/

Also i believe it is typo, Invoice should cr to vendor not Outgoing Payment Account (99901)

For example - if my invoice number is (KR) 3123456 / 2017 with the entry

Expense - Dr to Vendor account - Cr

Thanks.