Skip to Content
0

Electronic bank statement GL clearing

Oct 14, 2016 at 11:59 AM

126

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Marssel Vilaça
Oct 14, 2016 at 05:29 PM
0

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?

Share
10 |10000 characters needed characters left characters exceeded