Skip to Content

Search Strings bank statement: reference field

Hi,

I am just trying to look for any invoice reference in the note a payee of the bank statement. As all the invoices have 5 digits I have inlcuded as search string parameter like #####. The program finds what I am looking for (perfect), but also is taking into account other numbers in the note a payee without 5 digits and it is also trying to clear them. Any idea?

Example:

CREDIT/ID//REMI/50312+50311+50313+50337+50362/ISDT/00000000/ULTD//NAME//ID//ULTB//NAME//ID/ /PURP//PRTRY//OCMT/EUR57278,54/EXCH/1.0000000

The program is finding 50312, 50311, etc (5 strings) but also is looking for references in the invoices numbers like "54" or "1". Any idea? Please let me know.

Regards,

Daniel

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Oct 22, 2015 at 05:16 PM

    Hi,

    I finally solve it with the refrence range in the FF_5.

    regards,

    daniel

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 22, 2015 at 04:14 PM

    Hi Daniel,



    review your configuration of search string. Use transactions below for configure and testing.

    You may need to create a separated search strings.

    If you use prefixed number like 50###?


    T-code FEBSTS - search string simulation

    T-code OTPM - set search string algorithm

    Look documentation again that says about start and finishes of search:

    Define Search String for Electronic Bank Statement - Bank Accounting - SAP Library

    Hope could be helpful.

    Regards,

    Cristiano

    Add comment
    10|10000 characters needed characters exceeded