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

Account Modification in the Electronic Bank Statement

Hi Gurus,

I need your advice on this question related to Electronic Bank statement set-up in ECC. I am new to this area of Finance. Our existing set-up for the Bank statement has all incoming ACH payments being posted to the Bank sub-ledger account 10011 defined as ACH-in account. We have a new requirement that for incoming customer ACH payments, the payment should post to new GL account 10012 and all other ACH-in payments should keep on getting posted to the old ACH-in account 10011. Our payment file is in the Idoc format.

I have read many forum questions and SAP online help as well. What I understood so far is that the Account modification in the Assign accounts to Account symbol might be the place to accomodate this request but not sure if my understanding is correct and how should we do this set-up.

I would be thankful if you can guide me with this issue.

Thanks,

Best Regards,

Shalu

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 04, 2012 at 08:07 PM

    Hi Gurus,

    Can someone please help me with this issue?

    Thanks,

    Best Regards,

    Shalu

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 06, 2012 at 06:57 PM

    Hi there,

    Your question is quite confusing; I think you are mixing up payments and receipts; payment files and bank statement.

    I am assuming you are talking about customer receipts here, which are initiated by the customer itself (no direct debit) collected on a dedicated collections (bank) account.

    Second assumption is that the company receives an electronic end of day bank statement from the bank in the form of an MT940, containing all the receipts on the bank account for the previous day.

    In the old situation ALL mutations on this bank account were auto-posted to a single GL account. This was easy; just post all items (using UNALLOCATED) to a single posting rule and asign a GL account to this posting rule.

    In the new situation we need to post certain items to GL account X, other items to GL account Y.

    Really the first thing you need to do now is analyse the bank statements and look if you can find a structural difference between the two types of receipts. You should first look if you can discern the two types by Bank Transaction Codes (i.e. NMSC, NTRF etc.). If this is the case, you can assign two BTC codes to two posting rules and your issue is solved.

    If you cannot discern the two types by BTC code, you need to analyse if you can discern the two types of receipts by the text fields in the MT940 (i.e. field 61 or 86). If you can discern by static text you can setup a simple search string, looking for the text and assigning a posting rule from there.

    If you cannot discern by static text, but only by dynamic text (i.e. invoice number), you need to use one of the algorithms to let SAP analyse the items and try to determine which rule is appropriate.

    So depending on your analysis of the bank statement, different solutions should be implemented.

    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.