Skip to Content
avatar image
Former Member

Electronic bank statement GL clearing

Hello

I have a fairly simple requirement but I am struggling to get it to work.

We have transactions coming in, that post like this-

DR Store £100

CR Cash in transit £100

When the bank statement comes in, it is correctly posting the following-

DR Bank

CR Cash in transit £100

What I want to happen is for the cash in transit GL to clear off automatically when the bank statement is processed. Surely this is possible? I thought this would happen based on amount only, which is what I need. In reality we get several hundred postings to the account each day, then several hundred to the bank account the following day. The amounts are all different.

I have attached a photo showing the config I have done in Define Posting Rules. posting-rules.png

In the step assign external transaction types to posting rules, I have assigned my Z001 posting rule to transaction type N925 and with interpretation algorithm 001. The GL postings are working correctly, but the clearing posting is not, and I am getting the error that the difference is too large for clearing.

What am I doing wrong here?

Thanks in advance

Herb

posting-rules.png (11.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 14, 2016 at 05:29 PM

    Hi Herbert,

    You can try it by FF.5 and SM35 batch input foreground execution.

    When you set posting type 5 the system all transaction FB05 with position 2 as 1st line item. Then it calls the GL accounts entries to be cleared.

    Once you have no item in position 2 (40-ACC159600 / 50-??????? ) will impacts in this process.

    This works right when you post bank statement like:

    CO02 0001 40 CO-EBSTRANSIT 50 CO-MAINBANK CO02 0002 40 CO-CHECKOUT - CO-EBSTRANSIT

    Have you tried twist 1st line over the 2nd?

    Add comment
    10|10000 characters needed characters exceeded