EBS - MT940 - Auto Clearing with payment document number

[Former Member]

Hi

I am getting the MT940 bank statement with the payment document number alongwith company code and year at line 86.  For example:

900012345678902014?21

9000 - company code

1234567890 - Payment document number

2014 - Year

?21 - Not sure

I created a new search string as below:

( |^)#####################( |$)

At tag, I left only the 10 digits for the document number and removed the other values ie for company code, year etc

Assigned this search string for the bank account with interpretation algorithm 020 (document number search)and target field is Note to payee.

But, the system is not able to clear by looking at the payment document. Instead, it is trying to clear with the amount.

Could you please suggest me on this.

Thanks and Regards

Ashok

[Former Member]

HI Gurus

Any suggestions on this pl?

Thanks and Regards

Ashok

[former_member256697]

I have used an ABAPER to create me Auto clearing program. First I agreed with the bank that Tag 61 Subfield 7 is where they should put the Payment Document number. Then I have used the Logic that the sytem to read bank statement Tag 61 Subfield 7, take the number and go to BSIS table, if it matches,then it shoould Auto clear. It works like magic.

Fred.

[Former Member]

Hi

Thanks for your reply.

Is there anyway we can search string to configure?  I tried all the options and still it is not working.  I am not sure whether I am missing in Interpretation Algorithm or Mapping prefix.

If it is not going to work, as suggested by you, I may need to make code change.

Thanks and Regards

Ashok

[Former Member]

Hi Ashok,

Did you try with entring this BELNR number(1234567890) in FF_5 screen?

Regards,

Mohammed