Skip to Content

Search String using 3 fields in Electronic Bank Statement

Hi Team,

We are having a requirement to post customer payment automatically. The actual process is:

1) APP for Direct Debit - where it posts to Bank Clearing & Main Bank Account

2) Received Bank statement (Electronic) based on few fields and verification users are now manually adding Customer Number and Reconciliation account manually in FEBAN.

Now business informed that there are 3 fields which they generally verify in FEBAN and post a sub-ledger entry. We thought of automating this solution by a search string function but they have 3 fields to be verified. For example in Note to payee we need to find three different fields as below:

a.Batch booking

b.1*********

c.SEPA LASTSCHRIFT B2B

In short, how can I make a search string with 3 different fields mapping to a single Posting Rule.

Regards,

Santosh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 31, 2017 at 09:26 AM

    Hi

    after define search string definition. you need to define under search string use. BDC Field Values for all these 3 criteria.

    Regards

    Srini

    Add comment
    10|10000 characters needed characters exceeded