EBS - Search String for Electronic Bank statement

[Former Member]

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

[Paulo_Vitoriano · Accepted solution]

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

[Former Member · Accepted solution]

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.

[Former Member]

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.