on 12-02-2008 12:35 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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 ->
->
-> #
-> #
-> #
And the second with search string "CHECK ####" and the following mapping:
C ->
H ->
E ->
C ->
K ->
->
-> #
-> #
-> #
-> #
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
Another option to the mapping prefix would be to set up the search string mappings as:
C ->
H ->
E ->
C -> 0
K -> 0
-> 0
-> #
-> #
-> #
And
C ->
H ->
E ->
C ->
K -> 0
-> 0
-> #
-> #
-> #
-> #
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.
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.
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
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
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.