cancel
Showing results for 
Search instead for 
Did you mean: 

EBS

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

jayj07
Active Participant
0 Kudos

Hi Ajay,

Please check this article -

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


Hope this helps.

Jayj

Former Member
0 Kudos

Hi  Joseph

Could you please elaborate a bit what should be kept blank as i read the attachment but was not able understand completly

Thanks and Regards

Ajay

shanid_mp
Active Contributor
0 Kudos

Please do the following.

1) Assign the interpretation algorithm as 011 (check)
2) Create a search string as below.

Assuming that text 'CMS/000193630220' will be constant in statement.

Regards

Shanid

Former Member
0 Kudos

Hi Shanid

Thanks for your reply I have done the configuration as suggested by you I am posting the screen shot below

Please guide what I am missing

Thanks & Regards

Ajay

jayj07
Active Participant
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi All

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

thomas_vanaken2
Active Participant
0 Kudos

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.

Former Member
0 Kudos

Dear Thomas

I have tried using algorithms suggested by you but its not working system is not clearing

Error: (F5 263) The difference is too large for clearing with due not able find BELNR field.

Thanks & Regards

Former Member
0 Kudos

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