Clearing based on record :86 in MT940 in EBRS

[former_member470479]

Dear Experts,

Can we do clearing in EBRS based on information available in record :86 ???

In bank statement MT940, in record :86 we are getting concatenate of company code, payment document & fiscal year e.g. 2000430000000116 and we want to use algorithm to clear payment document based on this reference.

Please guide.

[former_member470479]

Hi,

Sample file:-

{1:F01HDFCINBBADEL0000000000}

{2:I940AIRCELLMXXXXN}

{4:

:20:00030310014326

:25:00030310014326

:28C:9

:60F:C160401INR193851387,37

:61:1604120412DR100000,00NTRF4440U16103474618//41

4440U16103474618

:86:Test BCM Vendor 2 2000200500012416

:62F:C160401INR193751387,37

-}

Here in line 86: we have 2000200500012416 which is concatenate of

2000 -> company code(4)

2005000124 -> Payment document number(10)

16 - > last two digit of Fiscal year (2)

When we are giving only document number 200500012416 in place of 2000200500012416 system is clearing the document. But when we are giving 2000200500012416 system is not clearing the document.

[former_member198450]

Hi,

Please share screen shot of payment document too with reference field screen shot.

Regards,

Jain

[former_member470479]

Hi,

PFB the relevant screen shot... Reference field is blank, we are doing clearing based on BELNR.

[former_member198450]

HI Sarvottam,

By seeing system details i can feel that only implemented this your client.

Let me check and get back to you.

Regards,

Jain

jjainvarghese@gmail.com

[former_member198450]

Dear Sarvottam,

Current logic will work only determine  till 10digit document number hence to fulfill our requirement. Please try to follow below instruction to resolve this issue..

Exit FEB00004 is called at the import of SWIFT MT940 in program

RFEKA400."

I would recommend you to use the Exit FEB00004. This Exit FEB00004 is

called at the import of SWIFT MT940 in program RFEKA400 and this Exit

processes Raw Data. Here you can modify the input file as per your

business requirement. The modified data will then be passed on for

further processing.

Regards,

Jain

[former_member198450]

Dear Sarvottam,

Yes, Its possible. Please select algorithm 20 and 21 in OT83 for your external transaction code.

say for example NTRF for bank transfer.

Regards,

Jain

[former_member470479]

We tried but failed to do so. Necessary details are refer below:-

{1:F01HDFCINBBADEL0000000000}

{2:I940AIRCELLMXXXXN}

{4:

:20:00030310014326

:25:00030310014326

:28C:9

:60F:C160401INR193851387,37

:61:1604120412DR100000,00NTRF4440U16103474618//41

4440U16103474618

:86:Test BCM Vendor 2 2000200500012416

:62F:C160401INR193751387,37

-}

[former_member198450]

Hi,

When you tried to execute FF_5 did you selected reference option in it?

Also, Please share the sample file i will do it for you. I Have done same in last implementation.

Regards,

Jain