Automatic clearing with Incoming bank statement

[Former Member]

Hi,

We have the requirement in which we need to clear bank sub Gl with Incoming bank statement. The issue is we cannot do the clearing based on assignment field as in assignment field different details are populated as the data is coming from the Interface. Can the text field be used to clear the information coming from the incoming bank statement. Please suggest me few ideas to get the clearing done.

Thanks

Mukesh

[Former Member]

Hi

Can anybody checks this and provide your valuable inputs on this.

Thanks

Mukesh

[former_member198450]

Hello Mukesh,

There are many algorithm available in system, as i'm able to recall like 020 for document number number search or check number etc.

You can try with any of those, but the point what details you are getting in bank statements example( check number or document etc) based on these criteria you can configured the system to clear the bank sub ledger account.

Regards,

Jain

[Former Member]

Hi

We are getting Customer number and UTR (unique transaction number in the tag 86 of the bank statement in MT 940 format. How we can have automatic clearing while uploading bank statement.

Thanks

Mukesh

[former_member198450]

Hello Mukesh,

Please make setting in OT83 specifically for customer

Posting area 1

40 Main Bank a/c

50 Incoming bank

posting type - 1

Posting area 2

40 Incoming bank

15 blank             

posting type-3

Refer below link for more details document.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20d2f203-4959-2e10-239f-bce48eef8... 

[Former Member]

Hi Varghese,

The link shared is not working can you please share the correct link.

Thanks

Mukesh