Skip to Content
avatar image
Former Member

Search string for Electronic Bank Statement

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 20, 2011 at 02:16 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • Dec 26, 2011 at 07:44 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Shanid MP

      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 .

  • avatar image
    Former Member
    Dec 26, 2011 at 01:14 PM

    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

    Add comment
    10|10000 characters needed characters exceeded