Search string for Electronic Bank Statement

[Former Member]

Hai ,

The requirement is that customer account number should be identified from customer bank key and bank account number which are available in the bank statement .I need to configure search string and assign it to interpretation algorithm.How i need to define and assign search string for bank key,bank account number .Example :AC-250-208762-20

The problem is that the length of bank key and bank account number for each customer is different

Example 1:Customer 100000

AC-25-45275865-333

Example 2 :customer 100001

AC-215-115275865-11

I need to post entries to customer account and no clearing is required . How search string can be defined for this ?

Note:Search string should be defined for customer bank account no because statement has no reference number

Regards,

Kumar

[former_member318765]

Dear Kumar,

Regarding your issue reported, you have mentioned that

"I need to post entries to customer account and no clearing is required . How search string can be defined for this ?"

Please see the documentation available next to SPRO node for defining search strings. As mentioned there:

"Define Search String for Electronic Bank Statement

When importing an electronic bank statement, the system identifies the business transactions and uses the settings you have already made to determine how each should be recorded. In most cases, the system uses the document number entered in the "note to payee" lines of the bank statement to determine the appropriate clearing transaction. For example, a cash receipt clears customer open items.

The information in the note to payee may be incomplete - for example, the first characters in the document number may be cut off or new characters may be added. The interpretation algorithm then reaches the limits and cannot find the appropriate document numbers. This means the document cannot be cleared and you must post- process the transactions manually.

In addition to the search for clearing information, you can use the the search string to fill other fields (such as the cost center or posting rule, depending on the content of the note to payee.

..."

So as you can see above, when interpretation algorithm cannot uniquely find open items to be cleared based on available clearing information, search string is used as advance option to fine tune the clearing information in the file to find the open item

uniquely in your case your requirement is not to do any clearing but only posting..is it that you want to find an open item and then do not clear it but just do a posting to that account? This is not very clear can you explain your requirement in detail?

In any case the search string to be created to meet above 2 bank account number formats would be something like

Srch strg name SAPTEST

Description SAP-diff bank number

Search string ACC-###-########-##( |$)|ACC-####-##########-##( |$)

Please try and let me know.

Kind Regards

Soumya

[shanid_mp]

Dear Kumar,

Can you let me know whether bank key and bank account number is coming in one note to payee field in the bank statement?

Example: 030502;022382900;11627;16.12.11;;;;;;0000000;-1000.00;;;16.12.11;;;;;AC-250-208762-20;;;;;;;;;;;;;;;FGR;;

Regards

SM

[Former Member]

Hi SM,

Bank key and bank account number come in one note to payee.The issue is that length of bank key and bank account number are different .So search string can not be used.

I want to use user exit for this .Which user exit i can use ? how customer number found from user exit should be used in the main program?

Regards,

Kumar

[shanid_mp]

Dear Kumar,

You can derive the customer account number through search string with reference (Bank key and account number) from bank statement.

You will have to create the search string for each customer with bank key and account number combination and please make sure that for each customer there will be a unique bank key and account number combination in transaction file.

Please follow below steps.

Please create a posting rule with posting area 2, PK,bank clearing account symbol, customer PK and posting type - 2.

Assign "No interpretation" to external business transaction as there is no clearing here.

Example of transaction file:

030502;022382900;11627;16.12.11;;;;;;0000000;-1000.00;;;16.12.11;;;;;AC-250-208762-20;;;;;;;;;;;;;;;FGR;;

Bank key and account number: AC-250-208762-20.

Corresponding customer created in SAP: 600001.

Search string creation.

Search string definition

Srch strg name-ARBB

Description-Automatic Payment for customer-Big Blue Ltd

Search string-(^ |#| *)AC-250-208762-20( |#|$)

Make target field as blank.

Search string use

Ext: FGR

+

Interpretation: No interpretation

Search string name: ARBB

Target field: Account type

Activate

Mapping prefix: D

Create one more as below in search string use.

Ext: FGR

+

Interpretation: No interpretation

Search string name: ARBB

Target field: Account number

Activate

Mapping prefix: 600001

Regards

SM

[Former Member]

Dear SM,

Thanks for your reply.

Will your solution work even for bank key and bank account number of different length.

Example :

Customer 12456

ACC-252-45875464-22

Customer 78965

ACC-2542-2222222222-44

Regards,

Kumar

[shanid_mp]

Hi,

It is just identification in the bank statement to pick the customer account number, no problem with that.

Please try my solution and let me know if you face any issues.

Regards

SM

[Former Member]

Hi SM,

Your solution is not working .System does not find customer numbers.

Regards,

Kumar

[shanid_mp]

Dear Kumar,

I tried in my system with multicash format(example below) and it is working perfectly.

030502;022382900;11628;27.12.11;;;;;;0000000;-1000.00;;;27.12.11;;;;;ACC-2542-2222222222-44;;;;;;;;;;;;;;;AP0;;

Please see the each steps again and check whether anything missed.

Regards

SM

[former_member318765]

Hi Kumar,

Can you check and try the search string provided by me above which should help.

Kind Regards

Soumya

[Former Member]

Hi All,

Hi SM,

Thanks for your help.

As per your solution,i need to define search string for each and every customer ,which is not possible.

Hi Soumya ,

Thanks for your help.

The main issue is that length of bank key and bank account number .Bank key and bank account number do not have fixed length .

For one customer , the length is 10 .For another it is 12 .For third customer , the length is 8 and so on ......

If i am right i need to go for user exit FEB00001 .i can find customer number in the table KNBK from it's bank account number .My doubt is that to which table this customer number should be passed for postings to happen.

Regards,

Kumar .

[Former Member]

Hai SM,

Can you clear my doubts?

Regards,

V.Kumaraguru

[Former Member]

Hi All,

Hi SM,

Thanks for your help.

As per your solution,i need to define search string for each and every customer ,which is not possible.

Hi Soumya ,

Thanks for your help.

The main issue is that length of bank key and bank account number .Bank key and bank account number do not have fixed length .

For one customer , the length is 10 .For another it is 12 .For third customer , the length is 8 and so on ......

If i am right i need to go for user exit FEB00001 .i can find customer number in the table KNBK from it's bank account number .My doubt is that to which table this customer number should be passed for postings to happen.

Regards,

Kumar .

[Marssel700]

Dear,

you may use a user exit for table KNBK. It will be a from/to for convert Customer Number to Bank Account.

Let me know.

regards

[Former Member]

Hi Marssel,

Thanks for your reply .

Do you mean to say customer number should be identified from customer bank account number . ?

How can this be done ,please answer elaborately.

Regards,

V.Kumaraguru.

[Former Member]

Hai Friends,

I want to know whether i can use enhancement FEB00001 for this .What i need to select for 1. interpretation algorithm 2.Search string 3.Target Field in search string use configuration

Regards,

Kumar