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

EBS (Electronic Bank Statement) - Not Clearing automatically in FI

Hi Experts,

I am having an unique problem. I have uploaded the Electronic Bank Statement for my client in BAI2 Format in FF_5. I have used External Transaction 195 (Incoming Money Transfer) and Algorithm - 001 in my configuration settings. The Posting Rule defined was as follows -

PA 1, 40 Bank, 50 Bank Sub account, P Type 1.

PA 2, 40 Bank Sub account, 50 No entry, P Type 8 Clear Credit Sub ledger account.

The statement upload triggered the following entry:

1) Bank a/c Dr

To Bank Sub account

2) Bank Sub account Dr

To Customer a/c

It had cleared the open item in Customer Ledger, I could see Green indicator in FBL5N (Customer Line Item). But in G/L in Bank Sub account. The Credit (resulting from entry no 1) and the debit (resulting from entry no 2) remains as uncleared open item with Red Indicator in FBL3N.

But when I do a test run of F.13 by selecting the G/L Account option, am getting these items in list of clearing transaction and finding no error message.

My question to the forum experts is

1. I assume that if upload of Electronic Bank statement can clear the open customer line item, it should also clear the open GL Line items and there is no need for running F.13.

2. If answer to question no 1 is yes, then what could be an possible fix for my issue.

Thanks in advance!

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Posted on Jun 09, 2009 at 02:50 PM

    Hello,

    The first question answer is NO. You need to run F.13 to clear your bank sub account entries. Your bank statement will not automatically clear the bank sub account entries. You need to run F.13. Check your settings in OB74

    Though the following text is for manual bank statement, how this may be useful to you.

    GO THROUGH SAP NOTE 48854 for algorithms.

    Have you completed the configuration.

    Please follow the following steps:

    IMG => Financial Accounting => Bank Accounting > Business Transactions => Payment Transactions => Manual Bank Statement

    Create and Assign Business Transactions: Here you give your external ID provided by the Bank, is it a plus or minus to your bank account, posting rule and Text. (Make sure before you have posting rules in place)

    Define Bank Keys and Posting rules for your Manual Bank Statement: Give your chart of account.

    1. Create Accounts Symbols (Freely definable)

    2. Assign Accounts to Accounts symbols (Account symbol / Account modifier, normally +, your currency, masking rule of the GL account)

    Hope you are familiar with Masking rule. Means, if you have bank main account ending with 0, for example 180000, cheque outgoing with 180001 and check incoming with 180002, then outgoing symbols you need to maintain +++++0 and for incoming symbols you need to maintain +++++0, by which your sub account and main account gets linked when you upload bank statement.

    3. Create Posting Keys - Freely definable

    4. Define posting rules - Most important, based on which your postings get happened.

    Posting Rule, Posting area, Posting Key, Account Dr, Posting Key, Account Cr, Document Type, Posting Type.

    The most important things are posting area, document type and posting type.

    Posting area 1 - means that it gets posted to GL Accounting Posting area 2 means it get posted to Bank Sub Ledger Accounting

    Document Type: this is important when you are posting to posting area 2, use KZ for vendors and DZ for customers, when using posting area 1, use normal document types or customized document type like ZR.

    Drop down Posting Type: Configure based on your requirement. 1, 2, 3 is for posting 4,5,7,8 for clearing and 8 is for reset & reverse clear.

    Hope this is useful to you.

    Regards,

    Ravi

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 04, 2009 at 02:58 PM

    I was able to get the direction to solve the issue and understood the cocept of automatic clearing with respect to EBS Posting

    Add comment
    10|10000 characters needed characters exceeded