EBS Issue with MT940 format

[former_member191939]

Dear Experts,

I have done all the configuration required for EBS and when I am trying to upload the file nothing is happening.

And when i am executing this nothing is happening but when i execute the program RFEBKA96 there I can see file has been generated but there is no data.

Kindly suggest where is the error.

Regards

Eugene

[Former Member]

check you configuration in

[former_member191939]

Thanks for your reply but all configuration is in place.

Regards

[Former Member]

what is the error  the?

[former_member191939]

There is no error.That is the main problem.

When i execute after giving input then nothing happens but when i execute it again then i get error which is

Acct : Statement 00000 already exists; entry ignored

Message No. FB771

When i check the tables then there are no entries.

Regards

Eugene

[Former Member]

Are they any Transaction in Bank statement and please untick the Sepatare list tick when you upload the bank stamen . Also check FEBA/FEBAN

[former_member191939]

I did what you suggested but of no use.

There is nothing in FEBA/FEBAN

Regards

Eugene

[Former Member]

why do you have account balance tick active in FF_5

[former_member191939]

I tried without the tick but I am getting error.

Regards

Eugene

[Former Member]

can you click ? and gives us more detail on error .and also check your MT940 whether its structure or not

[Former Member]

Hi Ranu,

I think u have already upload the statement, so system  through this message when u want to upload it again.So first check in FEBKO table and You can also check the program RFEBKA96 that deletes loaded EBS files.So delete the statement Id through which bank data already uploads and again run ff_5.

Pls let me know any issue u found then..

Regards,

Pk

[former_member191939]

Please find the attached file of Error message and MT940 file below.

{1:F01NIBLAEADAXXX1227001227}{2:O9401804160420NISLAEADAXXX12240012241604201804N}{4:

:20:1120335I

:21:120335I

:25:00701801800010

:28C:00001/00001

:60F:C160416AED0000,00

:61:160416CE125284240,91NMSC007SO01102870001//NONREF*

:86:007SO01102870001   -   SI - Sweeps  -  From Account : 00701801800021  GULFTAINER COMPANY LIMITED

:61:160416DE3882,96NMSC000OGCU161070009//NONREF*

:86:000OGCU161070009   -   Telegraphic Transfer   -   3882.96  AED  @5.37553  /AE630330000019000000897  OMAN INSURANCE COMPANY PSC

:61:160416DE75,00NMSC000OGCU161070009//NONREF*

:86:000OGCU161070009   -   Telegraphic Transfer Fee   -   3882.96  AED  @5.37553  /AE630330000019000000897  OMAN INSURANCE COMPANY PSC

:61:160416DE78,27NMSC000OGIT161070012//NONREF*

:86:000OGIT161070012   -   Internal Transfer - Debit   -   CORR BANK CHARGES  000OGCU161070009      /AE930520000701801800010  CUST/AE/NIB/0180180

:61:160416DE3900,00NMSC001ICP1161070026//NONREFIC16042016000028

:86:001ICP1161070026   -   Inward Clearing   -   CHEQUE No : 102807

:61:160416DE1000,00NMSC001ICP1161070250//NONREFIC16042016000267

:86:001ICP1161070250   -   Inward Clearing   -   CHEQUE No : 102683

:61:160416DE88683,99NMSC001ICP1161070558//NONREFIC16042016000604

:86:001ICP1161070558   -   Inward Clearing   -   CHEQUE No : 102737

:61:160416DE41922,70NMSC001ICP1161070727//NONREFIC16042016000791

:86:001ICP1161070727   -   Inward Clearing   -   CHEQUE No : 102783

:61:160416DE6380,00NMSC001ICP1161070747//NONREFIC16042016000814

:86:001ICP1161070747   -   Inward Clearing   -   CHEQUE No : 102781

:61:160416DE2100,00NMSC001ICP1161070769//NONREFIC16042016000837

:86:001ICP1161070769   -   Inward Clearing   -   CHEQUE No : 102808

:61:160416DE4900,00NMSC001ICP1161070770//NONREFIC16042016000838

:86:001ICP1161070770   -   Inward Clearing   -   CHEQUE No : 102716

:61:160416DE620,00NMSC001ICP1161070838//NONREFIC16042016000910

:86:001ICP1161070838   -   Inward Clearing   -   CHEQUE No : 102786

:61:160416CE31880,00NMSC008SO01141130001//NONREF*

:86:008SO01141130001   -   SI - Sweeps  -  From Account : 00801801800039  GULFTAINER COMPANY LIMITED-COLLECTION

:61:160416DE125162577,99NMSC007SO01102870001//NONREF*

:86:007SO01102870001   -   SI - Sweeps  -  To Account : 00701801800021  GULFTAINER COMPANY LIMITED

:62F:C160416AED0000,00

-}{1:F01NIBLAEADAXXX1227001227}{2:O9401804160420NISLAEADAXXX12270012271604201804N}{4:

:20:4120335I

:21:120335I

:25:00701801800010

:28C:00001/00001

:60F:C160419AED0000,00

:61:160419CE79490716,97NMSC007SO01102870001//NONREF*

:86:007SO01102870001   -   SI - Sweeps  -  From Account : 00701801800021  GULFTAINER COMPANY LIMITED

:61:160419DE2437,20NMSC000OGCU161100035//NONREF*

:86:000OGCU161100035   -   Telegraphic Transfer   -   2437.2  AED  @5.41601  /GB30NWBK60247728333098  PR INFORMATION SERVICES LIMITED

:61:160419DE75,00NMSC000OGCU161100035//NONREF*

:86:000OGCU161100035   -   Telegraphic Transfer Fee   -   2437.2  AED  @5.41601  /GB30NWBK60247728333098  PR INFORMATION SERVICES LIMITED

:61:160419DE19845,00NMSC001ICP1161100272//NONREFIC19042016000365

:86:001ICP1161100272   -   Inward Clearing   -   CHEQUE No : 102705

:61:160419DE8190,45NMSC001ICP1161100328//NONREFIC19042016000427

:86:001ICP1161100328   -   Inward Clearing   -   CHEQUE No : 102812

:61:160419DE99225,00NMSC001ICP1161100389//NONREFIC19042016000493

:86:001ICP1161100389   -   Inward Clearing   -   CHEQUE No : 102426

:61:160419DE6057,50NMSC001ICP1161100552//NONREFIC19042016000680

:86:001ICP1161100552   -   Inward Clearing   -   CHEQUE No : 102817

:61:160419CE188148,68NMSC008SO01141130001//NONREF*

:86:008SO01141130001   -   SI - Sweeps  -  From Account : 00801801800039  GULFTAINER COMPANY LIMITED-COLLECTION

:61:160419DE79543035,50NMSC007SO01102870001//NONREF*

:86:007SO01102870001   -   SI - Sweeps  -  To Account : 00701801800021  GULFTAINER COMPANY LIMITED

:62F:C160419AED0000,00

-}{1:F01NIBLAEADAXXX1227001227}{2:O9401804160420NISLAEADAXXX12260012261604201804N}{4:

:20:3120335I

:21:120335I

:25:00701801800010

:28C:00001/00001

:60F:C160418AED0000,00

:61:160418CE129048573,38NMSC007SO01102870001//NONREF*

:86:007SO01102870001   -   SI - Sweeps  -  From Account : 00701801800021  GULFTAINER COMPANY LIMITED

:61:160418DE80016,00NMSC008CWDC161090002//NONREF0081610900000019

:86:008CWDC161090002   -   Cash Withdrawal-By Cheque   -   CASA CHEQ WITHDRAWAL   -   CHEQUE No : 102830

:61:160418DE45059315,25NMSC000OGIT161090005//NONREF*

:86:000OGIT161090005   -   Internal Transfer - Debit   -   GULFTAINER SYNDICATION RECOVERY  OF PROFIT AMOUNT      /AE930520000701801800010  CUST/AE/NIB/0180180

:61:160418DE6750,00NMSC001ICP1161090105//NONREFIC18042016000114

:86:001ICP1161090105   -   Inward Clearing   -   CHEQUE No : 102777

:61:160418DE3359,30NMSC001ICP1161090344//NONREFIC18042016000379

:86:001ICP1161090344   -   Inward Clearing   -   CHEQUE No : 102793

Regards

Eugene

[Bohdan]

Hi Ranu,

I guess that the error is pretty clear here: there are a couple of bank statement in .txt file (at a first glance). But for the last one a record starting with 62F is missing. This is the field that is supposed to display the ending balance for the day. It is displayed in the following format:

:62F:C160419AED0000,00, where

- C or D - refer to credit / debit balance;

- 160419 - reference to bank statement date;

- AED - reference to currency;

- 0000,00 - amount.

Please add this record with correct ending balance and try to upload bank statement again.

Regards,

Bohdan

[former_member191939]

Hi Bohdan,

Thanks for your input and sorry for late reply,I did see the MT940 format shared by the bank and 62F is missing so have asked the bank to provide the right MT940 statement.

Once i receive the file will test and will come back.

Regards

Eugene

[former_member191939]

Hi Bodhan,

I got the clarity from bank,60F and 62F is there in the statement and it will always be zero because of the sweep of funds to another account on daily basis.

Can you please guide me how to incorporate this thing because when I am trying to upload then I am getting the same error as earlier,Termination in statement no. 00000 of acct  ;closing record 62F missing.

Regards

Eugene

[Bohdan]

Hi Ranu,

I suggest the following: try to add this line manually and retest the uploading of bank statement again. If it works - then you definitely have to discuss it with your bank and try to get them to introduce some changes. If it still doesn't work - then you can start looking for alternative ways.

But generally speaking, we should try to adhere to standard format of bank statement and upload it with correct requisites.

[Former Member]

Are you getting error that its can not be updated that's means you are missing any external transaction Type configuration in EBS

[former_member191939]

Hi Preeti,

I am not getting any error which is the main issue otherwise life would have been easy

Regards

Eugene