Skip to Content
avatar image
Former Member

EBS

Dear All

I am new to Electronic Bank Statement and tried to configure the same but not able to capture desired check number

61:1509110911D7227,00NMSC000193630220//31

CMS/000193630220/569481/5555

86:NOIDA

CMS/000193630220/569481/555556/KNS20150901SALARYA

I want to capture check number 569481 to clear out going bank clearing account. In my outgoing clearing account check number is assigned in assignment field.

For NMSC i have selected  0 000: No interpretation in interpretation algorithm  and processing type 0 Dummy entry - not assignable


In Search String Use i have selected



and in Search String Definition i have configured as below in screen attached


As apparant system is picking all the digits but i want only 569367 to be picked for clearing. What wrong is been done


please suggest whats been done wrong


Regards and Thanks

Capture1.JPG (39.4 kB)
Capture2.JPG (94.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 08, 2015 at 10:14 AM

    Hi Ajay,

    Please check this article - EBS: configuration of search string, part 1

    If you only want to map 569367, you should use blank on your first few characters.


    Hope this helps.

    Jayj

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ajay,

      Your mapping from CMS onwards on the left side - just put blank so that it will not be mapped.

      C -> (blank)

      M -> (blank)

      S -> (blank)

      / -> (blank)


      until


      # -> #

      # -> #

      # -> #

      # -> #

      # -> #

      # -> #


      Hope this helps.


      Jayj

  • avatar image
    Former Member
    Sep 30, 2015 at 07:23 AM

    Hi Ajay,

    For outgoing check you have to use one of the following algorithms:

    1. 11: "Check number different of payment document number"
    2. 12: "Check number same as payment document number"
    3. 13: "Check number same or different from payment document number"

    Search strings may help in same case but are not mandatory.

    Good luck

    Th.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Dear Thomas

      Moreover in PAYR table check number  569481 is updated in CHECT which is correct .  In  FEBEP table in field CHECT 000193630220 is getting updated. In FEBRE table in field VWEZW NOIDA

      CMS/000193630220/569481/555556/KNS20150901SALARYA is getting updated

      Please suggest

      Thanks & Regards

  • avatar image
    Former Member
    Oct 08, 2015 at 06:49 AM

    Hi All

    Please anyone came through such requirement please suggest how to overcome the issue

    Add comment
    10|10000 characters needed characters exceeded