Skip to Content
author's profile photo Former Member
Former Member

Electronic Bank Statements With Assignment field update

Good day,

We process a daily Electronic Bank Statement file in BAI format using program t-code FF.5. Currently the bank sends only clearing information 88 records (note to payee) using BAI code 466 . As such, using with we are trying to do auto-clearing with Assignment field.

For that i have created search string as below.

I tried to using searching string in EBS process, to populate the Assignment field from 88 record in BAI file. The bank return back some clearing information in 88 record " NISSAN CORP USA" now i have tried to populate this in Assignment field with using of search string. The below is our example record in BAI file and second one is search string setup in SAP.

1. 88,;REMARK : ;ORIG CO NAME: NISSAN CORP USA

2. Company code : 2177

House bank id: CHS04

Account id: CHT08

Int algthm : 015 - selection using assignment field

Strg name: NISSAN CORP USA

Target field: Note to payee

Active: on

when excuted FF.5 transaction with BAI file the posted document does not populate the data in Assignment field. where i did mistake to define the search string.

Edited by: Veerababu Rekha on Jun 23, 2011 12:04 PM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 25, 2011 at 07:27 AM

    Hi

    Hi Change the Target field to Assignment field. Refer the Help document for the Search String node in SAP for more details.

    This change should work for you.

    Just to confirm the document which you are trying to clear should contain :NISSAN CORP USA" in the assignment field otherwise the clearing functionality wont work for you.

    Thanks

    Nikhil

    Edited by: Nikhil Kothari on Jun 25, 2011 12:58 PM

    Edited by: Nikhil Kothari on Jun 25, 2011 1:00 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 25, 2011 at 08:42 AM

    Addking to my earlier thread, you can use below settings in the search string,

    For populating the assignment field with value "NISSAN CORP USA", you can use the below steps,

    1) BDC Field Value 1 = "NISSAN CORP USA"

    2) BDC Field Name 1 = BSEG-ZUONR -


    Assignment field

    3) BDC Account Type 1 = 0 (depends on the requirement),

    The options for step 3 are,

    0: First line, posting area 1

    1: First line, posting area 2

    2: Second line, posting area 1

    3: Second line, posting area 2

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Nikhil/veerababu,

      I am having the same issue in finding the customer through assignment field,I created the posting rules and created one search string with Mapping 008#######,Since we are placing 2 zeros before teh 8 series number that is provided from the note to payee.

      Below is how I assigned the search string to CCode accoring to your notes from June 2011

      015: Clearing transaction: selection using assignment ZWIREA BDC Account Type 1 1 (8#######) 8#######

      015: Clearing transaction: selection using assignment ZWIREA BDC Field Name 1 BSEG-ZUONR (8#######) 8#######

      015: Clearing transaction: selection using assignment ZWIREA BDC Field Value 1 0080000000 (8#######) 8#######

      In the define Interpritation Algorithm,I gave the code and Gave 015 in EBS config. But still the system is not able to find teh customer.

      Could you please tell me how to correct my serch string?Is any one sucessfull in populating the data in the assignment field?

      Please suggest

      Thanks

      Edited by: Shirisha Kambham on Sep 1, 2011 8:58 PM

  • author's profile photo Former Member
    Former Member
    Posted on Jul 06, 2011 at 02:24 PM

    Hi rekha,

    Can you please confirm that whether you have maintinaed seach string defination.

    if not please define and and assign to 015 as under

    seach string name 'Test'

    search strng 'Nissan############################' (set as much as the string will will be asssgn same as target field

    then goto serach string use and assign above defined string to your compnay code and interpret as 015 and target as 'check-dme/assignment'

    then try to run ur statement'

    Regards,

    Atul

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.