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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Kalim,

As to my knowledge, the use of search string is of no help in this matter since. Please explain how a search string could help me with this.

Regards,

MH

[Former Member]

Hi M H,

Create Account Symbol.

Assign it to GL account.

Create transaction type for posting rule.

Create new posting rule with this symbol.

Assignment of external transaction type with other posting rule is already exist in your system for NTRF payment, skip this step.

Go to Search String OTPM.

Define Search string as per the screenshot.

Define Search string through which system can read the file and enter your posting rule in target field. See in test run once system will read NTRF85962 from the file, will call posting rule Y25.

I have given one example for defining search string with NTRF85962, You can define more dynamically according to your need.

Define Search String Use.

Here algorithm should be same which you maintained in OT83 for this external transaction code.

Hope it should help.

Regards,

Kalim

[Former Member]

Hello Kalim,

I am am currently blocked on a similar issue with NTRF.

My situation is the following :

I have already created the following with NTRF

But now I want to link 2 more posting rules (DT07 and DT08) with NTRF.

How can I do that ? I tried to use your solution mentioned above. But I wasn't successful. Perhaps I am missing some wild card or special character within the search string.

Any help will be appreciated.

Regards,

Sanjay

[former_member251898]

Hi Sanjay,

Would you like to elaborate on what is the key identifier that should post using different posting rule from DT01/02 with NTRF?

The above thread is concerned with the situation where you receive a certain "textual key identifier" in note to payee field in the bank statement and by means of search string, you can divert the posting differently.

Would you like to share with us what is the strign you would like the system to search and post with different posting rules?

cheers

taro

[Former Member]

Hi Taro,

Thanks for your quick response.

So currently I am using NTRF +/- only for EURO currency with posting rule DT01 (NTRF -) and DT02 (NTRF+). But as  there are bank accounts which are managed in USD, I need to create at least 2 more rules with key identifier NTRF.

Screenshot below :

So I looked at the forum and tried to use the search string logic which Kalim has described. But I always get the error message 66 : which says posting rule DT01 which is currently used for NTRF cannot be duplicated. It means NTRF by default selects posting  rule DT01 even I have created a search string with NTRF/ cCode /

Hope I have been able to explain you my requirement.

Regards,

Sanjay

[former_member251898]

Hi Sanjay,

Thanks for the clarification.

If I understand it correctly, you have some bank accounts in USD that by assigning different posting rules for NTRF, you would like to post into different GL accounts from the ones posted by DT01/DT02, correct?

If this is your case, simply you would create a copy of transaction type and assign them to those USD bank accounts. Since posting rule assignment to external transaction code is per transaction type, you can then assign different posting rule to the newly created trasaction type for USD bank accounts.

This should work if USD bank accounts and non USD bank accounts are seperate account ID in your house bank.

Hope that this helps

taro

[Former Member]

Hi Taro,

Apparently it is not possible to use  the same transaction type (in this case NTRF) with same symbol for another posting rule. I do have house bank with two different account id (EURC1 and USD1)

I am getting this  error message.

Regards,

Sanjay

[former_member251898]

Hi Sanjay,

yes, indeed, you cannot assign more than one posting rule in one unique combination within the same transaction type.

Now you need to copy the existing transaction type LU into, let's say LU2, then assign this transaction type to Bank account details of USD1. if you change the posting rule assignment of NTRF in LU2, I believe you can achieve what you require.

hope that this helps

taro

[Former Member]

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

[Former Member]

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