Skip to Content
0

Search String using 3 fields in Electronic Bank Statement

Jul 18, 2017 at 12:42 PM

46

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

Hi

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

Regards

Srini

Share
10 |10000 characters needed characters left characters exceeded