Skip to Content
author's profile photo Former Member
Former Member

Electronic Bank Statemen (EBS): Allocation Field

Hi masters,

When importing the electronic bank statement I am trying to "clear" automatically as much transactions as possible.

In order to do that, I am trying to configure the "Allocation" field consistently at F110 and at EBS import. I hope that, if Allocation field of payments/collections made in F110 are consistent with allocation field in the transactions posted by EBS upload, I could expect that many transactions will be automatically cleared by SAP.

I thought that the definition about how the allocation field is populated for certain GL Account is defined at GL Master Data: control data "Short Key" field.

I have configured "005" (Loc.currency amount) for the "interim account" used for both payment/collections in F110 and in EBS upload, but the results were not correct (or not as expected).

Does anybody knows how to configure the Allocation field for F110 and EBS Upload?

Thanks a lot in advance, and I hope my message can be understood...English is not my strength 😊

Rafa

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 05, 2007 at 06:22 PM

    Hi Rafael

    As far as my knowledge goes ( I have worked on EBS for Spain, Portugal, Norway, FInland, Sweden and Denmark) the Allocation keys functionality is new.

    So far I have used the XBLNR field and KIDNO field as a link to the note to payee information that is coming in EBS. Also there is an interpretation algorithm in the EBS settings which makes this possible and clear most of the customer and vendor and GL postings.

    could you please let me know from where you got the info on Allocation key or if possible give me a link.

    Thanks

    Ashok

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi

      Normally when a customer billing document is created, the billing document plus customer account is updated in to the KIDNO filed.

      The customer when paying the amount intothe bank with reference to this KIDNO, we get bank statement with the info in the NOTETOPAYEE field and it will be used to automtically clear the customer open items.

      Thanks

      Ashok

      Assign points if this is useful

  • Posted on Oct 16, 2019 at 09:43 AM

    I am facing the same issue, my client want to clear EBS based on KIDNO field with 17 digit for Norway, please update if you any solution.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.