Interpretation Algorithm in Electronic Bank statement.

[Former Member]

Dear Experts,

I am facing a very serious issue with electronic bank statement interpretation algorithm.

There are two internal transaction

KBCH - Bank charges

KBOC - outoing manual payments

External transaction - FTFR

In OT51 this configuration exists

FTFR - KBOC 000: No interpretation Dummy entry - not assignable

But for both the transaction bank has only one external transaction FTFR. Now the user facing issue while posting the transaction, he has to manualy change the KBOC to KBCH everytime for bank charges and want to default KBCH instead. The ext transaction FTFR appears in the electronic bank statement not only for bank charges but for other transactions as wel.

We have looked at a bank statement together and have established that part of the record for bank charges is always unique, is it possible to interpret this somehow using the "Interpretation Algorithm" in OT51?

A bank charges record in the file looks like :

61:1011181118DX3892,67FTFRNONREF// Note : this line for manual outgoing payments

:86:999/00TFRFTRFC MAR ASIA PTE LPET005450322

:61:1011151115DX6,00FTFRNONREF// Note :FTFR the external transaction

:86:999/00TFRFCHGBIB-3190533160*PET018744319 Note: TFRFCHGBIB the identifier for bank charges, the :86:999/00 always seems to be the same as well

So, can you help how to proceed either interpretation algorithm or any user exit ? Please reply asap.

Thanks in advance

Abhi

[former_member581688 · Accepted solution]

Abhi,

You can use a search string to change the internal transaction (posting rule) for the FTFR transactions that are for bank charges. The search string reads the text (note to payee) from the EBS transaction. If it finds the text that you've specified, it can be used to replace and/or populate values used for processing the transaction, including the posting rule.

You said you've identified TFRFCHGBIB as the common text in all bank charges transactions. Use TFRFCHGBIB as the search string value. Map that value to the posting rule for bank charges - KBCH. Then when you set up the search string use entry, set posting rule as the target field.

Regards,

Shannon

[Former Member · Accepted solution]

Hi Shanon,

Thanks for reply. I will do it by search string but can you tell me the procedure for doing that? What are steps to be done?

Reg

Abhi

[Former Member · Accepted solution]

Hi Shanon

I have entered (^")(TFRFCHGBIB)(&") in search string, but not able to understand how the system fetch the internal transaction KBCH, if for this string TFRFCHGBIB FTFR is in EBS.

I have defined the second step also Search string use also. Please help me in defining the search string and mapping for bank charges.

Abhi

[former_member581688 · Accepted solution]

Abhi,

First, you have to map your text to the internal transaction KBCH. For this search string, I wouldn't worry about begining or end of using any special characters - just enter TFRFCHGBIB. After you fill TFRFCHGBIB into the search string field and press Enter, SAP should populate that into the mapping section of the screen. In the mapping, replace the first 4 characters in the target column (column furthest to the right) with K in the first row, B in the second row, C in the 3rd row, and H in the 4th row. Then delete out the characters from the remaining rows in the target column.

Then in the search string use section, set up an entry for the relevant company code, house bank and account ID (or leave the values blank if the search string should apply to all companies and accounts). If you're on a later release of SAP, you'll have a field for External transaction - if so, you can set that to FTFR. If you don't have that field, don't worry, it will still work. Set the direction to Negative. Set the interpretation algorithm to the same value as the mapping in OT51 for FTFR - algorithm 000. Select the search string and set the target field to Posting rule. Check the Act. box to Activate.

With this configuration in place, when a bank statement is loaded for the relevant company code and house bank/account ID, if a transaction is negative (and has external transaction FTFR - if you were able to specify that), SAP will compare the text information from the transaction against the search string. If it finds TFRFCHGBIB, it will assign KBCH to the posting rule (internal transaction) and overwrite the internal transaction (KBOC) from OT51.

Please let me know if you have additional questions.

Regards,

Shannon

[Former Member · Accepted solution]

Hi Shanon,

Great thanks for your support. It really worked. Very useful answer.

Reg

Abhi

[Former Member · Accepted solution]

Hi Shannon,

I have coded this as suggested and it appears to work partially. However you say to set to negative and I don't inderstand this as I have to have both negative and positive postings.

I have NTRF for 2 postings. I have an algorithm that converts one to ZTRF and so 2 posting rules. However I now see that ZTRF goes directly to table T028D and so 1 posting rule . Any ideas would be appreciated.

kind regards,

Mary

[former_member581688 · Accepted solution]

Mary,

In Abhi's situation, there was only one posting rule to be mapped by the search string and it was a negative posting rule - so I suggested setting up the search string use entry with negative. However, not all search string use entries have to be negative - you can set to positive or blank (negative and positive) as needed.

Regards,

Shannon

[Former Member · Accepted solution]

Hi Shannon,

Thanks for getting back to me on this but I still don't see it.

Initially I thought I could overwrite NTRF with ZTRF and then automatically it would post to the correct rule (+ or -).

However when testing it went directly to table T028D so expected a posting rule. I then changed my string to overwrite NTRF with 008 and this works perfectly but it is only for postive payments.

Is there another way that I can direct this so that both postive and negative payments are dealt with.

Thanks for your help,

Mary

[former_member581688 · Accepted solution]

Yes, when you use a search string to assign a value to the posting rule field, the value assigned needs to be a valid posting rule.

If you need to post positive and negative transactions, then you will need 2 posting rules - one for negative and one for positive.

Then to assign 2 posting rules, there are 2 options:

Option 1 - create a second search string for the second (negative) posting rule. You would have the same search string text as the first search string, but the mapping would be the second (negative) posting rule. In the search string use, set up the new search string as negative.

Option 2 - use one search string with a blank mapping - that is all the characters on the right side of the mapping are blank. Then in the search string use, create one entry for the search string for positive transactions and assign the positive posting rule in the mapping prefix. Repeat for negative transactions with the negative posting rule.

Regards,

Shannon

[Former Member · Accepted solution]

Hi shannon,

I have read your reply here and i tried to apply but could not able to do that.

My issue is that i have to post the bank charges in a gl through bank statement and this gl has also a cost elemnt in the system so when it gets posted through FF.5 it require a cost center sure because it has a cost element fine.

But the issue is i have multiple BA and cost center to post against one bank charges gl bank statement will have the info of the of bank charges per business area

Can u please helpme in configuring search string for this issue..

Regards

[Former Member]

Hi Shannon,

I have coded this as suggested and it appears to work partially. However you say to set to negative and I don't inderstand this as I have to have both negative and positive postings.

I have NTRF for 2 postings. I have an algorithm that converts one to ZTRF and so 2 posting rules. However I now see that ZTRF goes directly to table T028D and so 1 posting rule . Any ideas would be appreciated.

kind regards,

Mary