Electr. bank statement different text string

[former_member211711]

Hello experts

Is it possible using strings and without ABAP to post to a different G/L account depending on the text found in the EBS file?

example

if text is "FEE 1" post to expense account 1201

if text is "FEE 2" post to expense account 1203

Thanks everyone

Aleksey

[former_member211711 · Accepted solution]

We have had great success using the standard text strings.

It is possible to do the above and create as many strings with different conditions as desired, which are mapped to the external transaction code. Only if the string condition is satisfied will the configured actions be taken.

Thanks,

[Former Member · Accepted solution]

Hello Aleksey,

yes it is.....

1. Global settings for EBS

1a Create Account symbol FEE

1b Assign accounts

    FEE Acctmod + +  ??????

    FEE Acctmod 1     1201

    FEE Acctmod 2     1202

1c Create posting rule i. e. FEE Account symbol FEE debit Bank credit

2 Define search strings

2a Define the strings

  FEE 1

  please take care that the highlightened datafields in "Mapping box" are empty otherwise it will not work

  FEE 2

  please take care that the highlightened datafields in "Mapping box" are empty

2b Assign search strings to housebank

1 001: Standard algorithm FEE1    EBVGINT Posting Rule  FEE                         

1 001: Standard algorithm FEE1    EBKFMOD Account modification Acctmod 1

1 001: Standard algorithm FEE2    EBVGINT Posting Rule  FEE                         

1 001: Standard algorithm FEE2    EBKFMOD Account modification Acctmod 2

Works really perfect in our system...

Hope this gives a clue...

Best regards

  Horst