cancel
Showing results for 
Search instead for 
Did you mean: 

Search string for 3 digit check number?

Former Member
0 Kudos

For electronic bank statement,uploading file contains 3-digit check number eg;416

but in FCHI-Check lots we defined six-digit check numbers.

so system is not able match the check nos. as they are different, and auto reco is not happening.

we have gone through search strings documentation but

we dont know what to enter in search strings configuration.

Kindly help me what to enter for 3 digit check no?

Edited by: KUMAR on Dec 2, 2008 1:35 PM

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member581688
Active Contributor
0 Kudos

In the EBS file, are the check numbers in the note to payee information for the transactions?

Also, the 3 digits from the check numbers that are not included in the EBS file - are the three digits the same for all checks? Or are the 3 digits different depending on the check?

The answers to these questions will help determine if a search string is feasible in your situation.

Former Member
0 Kudos

Hi Moberg,

below is the multicash format.

40022 ;51022 ;2206;14.11.08; ; ; ;;; ;-101000.00;;;14.11.08;;; TRFR TO*PO ISS;; ; ;D ;

40022 ;51022 ;2206;14.11.08; ;4851; ;;; ; -6198.00 ;;;14.11.08;;; STUDIO KIR;; ; ;D ;

4851 is the check no.

when we upload check no comes in payment notes along with text description.

the problem is we defined check nos in FCHI from 000001 to 002000 for one bank and 000001 to 010000 for second bank.

in EBS file we see check nos as 456, 675,1234, 4851 etc without leading zeroes which can be one or two or three like 000456,004851,010000-we get with leading zeroes in SAP, so system not able to match check nos as zeroes are not there in EBS file.

former_member581688
Active Contributor
0 Kudos

You'll first need to create search strings to "find" the check numbers in the note to payee information. Then when you set up the search string use, you'll assign a mapping prefix of "000000" to format the check numbers with the leading zeros so they are 6-digits long.

To set up the search string, you'll need to look at the note to payee information at the text either before or after the check numbers. Let's say, for example, that the word "CHECK" always preceeds the check numbers in the note to payee:

CHECK 456

or

CHECK 1234

Because you have some check numbers coming through the bank statement as 3 digits and some as 4 digits, I'm thinking you'll need to set up two search strings, one with search string value "CHECK ###" and the following mapping:

C ->

H ->

E ->

C ->

K ->

->

  1. -> #

  1. -> #

  1. -> #

And the second with search string "CHECK ####" and the following mapping:

C ->

H ->

E ->

C ->

K ->

->

  1. -> #

  1. -> #

  1. -> #

  1. -> #

In the search string use, you assign each search string to the relevant company code, house bank and account ID. You can also leave these fields blank, in which case the search strings will be relevant for all company codes, house banks and accounts IDs. You'll also need to populate the interpretation algorithm with the same algorithm that you assigned in the Global EBS config for the external transaction for checks. The target field should be Check-/DME Reference-/Assignment number. Fill in the mapping prefix with 000000 - and be sure to check the Active indicator. If you are on ECC 6.0, you will also have fields for external transaction and +- (these fields may also be available in ECC 5.0 - but I know they are not available in 4.7 or prior). If you see these fields, you can fill them in to further limit when the search string is used - for example, only for Negative transactions or only for Negative transactions with a particular external transaction value.

Let me know if you have any other questions.

Regards,

Shannon

Edited by: Shannon Moberg on Dec 3, 2008 6:05 PM

former_member581688
Active Contributor
0 Kudos

Another option to the mapping prefix would be to set up the search string mappings as:

C ->

H ->

E ->

C -> 0

K -> 0

-> 0

  1. -> #

  1. -> #

  1. -> #

And

C ->

H ->

E ->

C ->

K -> 0

-> 0

  1. -> #

  1. -> #

  1. -> #

  1. -> #

Either option should work - although this option is dependent on the identifying text value (in this case, the word "CHECK") preceeding the check number. If the identifying text is after the check number you will have to use the mapping prefix.

Former Member
0 Kudos

Dear Shannon,

thanks for your answers. those are really very helpful for me.

for your information there is no word CHECK before or after the check no. in the file.

so I ignored word CHECK and created search string as ' ####' -


two spaces and 4 #.

because i have 4 digit check nos as of now with two leading zeroes missing i.e 4567.

it is working and entries are posting automatically.

in the same way i have search string for 3 digit check nos ' ###" three spaces and 3 #

for both, in mapping i have given zeroes in place of space .i.e two spaces and three spaces.

the problem is if i define two strings and assign to company codes, none of them works, means does not post entries automatically.

but if i give any one of them then system picks up and posts entries .

so cant i use two or more strings at a time ? because file may contain check nos in the following manner--

345, 23, 4786 665, 6767 etc.

Thanks,

Kumar.

former_member581688
Active Contributor
0 Kudos

Yes, I think you should be able to use two search strings.... Can you reply with examples of the note to payee information for these checks? An example of a note to payee for a 3-digit check and an example of a note to payee for a 4-digit check would be helpful.

Thanks!

Shannon

Former Member
0 Kudos

note to payee information is nothing but check no. in the format what we receive.As per this i have given interpretation algorithm as check no.

note to information for 3 digit check no is 456

note to information for 4 digit check no is 1199

the format we receive with every field is follows.the same i upload into SAP everyday.

40022 ;51022 ;2206;14.11.08; ; 456; ; ;; ; -101000.00 ;;; 14.11.08 ;;; TRFR TO*PO ISS;; ; ;D ;

40022 ;51022 ;2206;14.11.08; ; 1199; ;;; ; -6198.00 ;;; 14.11.08 ;;; STUDIO KIR; ; ; D ;

456,1199 are the check no.s

Thanks,

Kumar

Former Member
0 Kudos

Were you able to use two search string together, I have the same problem, I dont know whats the solution ???

Former Member
0 Kudos

no cathy. iam also not able to use two strings at a time.

former_member581688
Active Contributor
0 Kudos

Kumar,

Without any text in the note to payee in addition to the check numbers, I've not been able to determine search strings that will work in your case. I'm wondering if you might need to explore a user exit to resolve your issue. Try for example, EXIT_RFEBBU10_001 - INCLUDE ZXF01U01. In the user exit you could add logic to determine the length of the check number and then add the appropriate number of zeros.

Sorry I couldn't be of more help.

Regards,

Shannon

former_member182098
Active Contributor
0 Kudos

Hi Kumar,

Thanks for your postings.

If you have any documentation on search string functionality to clear the items in Bank Statement, you can please send to my address that is mentioned on my User in SDN.

Thanks in advance,

Regards,

Ravi

Former Member
0 Kudos

Hi Ravi

I have no documentation for search strings. Based on suggestions from SDN, I configured and tried.

I will provide you the same if I get it.

Thanks,

Kumar

Former Member
0 Kudos

Can you help me do a search string to input the cost center on one of the line items.