Skip to Content
avatar image
Former Member

Electronic Bank Statement MT940 - NTRF + ref.number for account assignment

Hi all,

My client receives money transfers in his bank account. Those are classified as incoming payments with external transaction code NTRF in the MT940 file from the bank. These payments needs to be automatically posted to a specific account.

This would have been easily done by creating a posting rule allocated to the account, but there is a problem. Not all incoming payments with the external transaction code NTRF should be posted to this account, only the payments with a specifik reference number (58692) which is stated immediately after the NTRF-code in the statement.

How can I get only the incoming payments with NTRF and a reference number that begins with 58692 to be posted automatically to a specific account? Other incoming payments with NTRF and a different reference number should be posted to another account.

Thank you,

//MH

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 29, 2014 at 10:30 AM

    Dear MH,

    after transaction code NTRF is your bank transaction id or cheque no which would be use for clearing process and that reference no is unique. So you will get new reference no for every transaction. Hence it will not possible to assign different GL base on transaction code NTRF and reference no.

    Thanks,

    Aditya

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 29, 2014 at 10:47 AM

    Hello M H,

    You can achieve this requirment through EBS search string through T-code OTPM. Please check search string functionality in SAP help.

    Let me know if you have any further clarification.

    Regards,

    Kalim

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Taro Miyanishi

      Hi Taro,

      Yes it works.

      I had to link the bank accounts managed in USD with  the new ext transaction type (LU1).

      But the bottomline is, it works.

      Thanks a million.

      Appreciated.

      Regards,

      Sanjay