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

EBS - Search String for Electronic Bank statement

Posted on Sep 16, 2009 at 08:37 PM 762 Views

I am trying to subsitute the Posting Rule if the String' Check' is found on the note To payee.. I am litte confused as to how to do this.

External transaction is say 100, posting rule currently is AB03 , if it finds the text 'Check' it should replace Posting Rule to AB01.

External transaction 100 is mapped to AB03.

External Tranasaction 200 is mapped to AB01

I am on ECC 6.0 and on the 'Search String Defination' i have given ' Check' as the search string. What do i need to give in Mapping ?

in the Search String Use , I have given the Company code and the Target as Posting Rule also algorithm as NO interpretation.

However it is not working.. When i try to upload a bank statement it does not change the posting rule.

Can you please tell me what i am missing here.

Thank you.

M

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Paulo Vitoriano
    Paulo Vitoriano
    Posted on Sep 16, 2009 at 08:54 PM
    2

    Hi Manjiri,

    Target field EBVGINT

    Mapping for the word "CHEQUE" (just as example, not sure what you got as exact spelling):

    C -> A

    H -> B

    E -> 0

    Q -> 1

    U ->

    E ->

    AB01 is the posting rule id.

    You can test how it works with transaction FEBSTS.

    BR,

    Paulo

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Sep 18, 2009 at 04:09 PM

      Hi Paulo,

      Thanks for the reply. However i have the following setting and it still does not work..

      Mapping -> AB01

      When i do the simulation it shows the Number and the hits and mapping.

      In the Seach String use i have following settings:

      CC 1000

      Interpretation : ALL Interpretation

      Search String : TEST1 ( this is the name that i gave to above search string)

      Target : Posting RUle

      Active checked.

      But still when i upload the bank statement it is posting to Rule AB03 and not AB01

      Also when i try FEBSTS it says no document hits ???

      Your answer is greatly appreciated.

  • author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2009 at 04:12 PM
    1

    Hi Paulo,

    I got it working!! . Frankly the only thing that i changed was the Algorith to ALL Algorithms .. ANd it posted to the correct Posting RUle the second time..!!!

    Thank YOu.

    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.