cancel
Showing results for 
Search instead for 
Did you mean: 

Bank - electronic BAI statement upload & deleting entries from FEBKO

Former Member
0 Kudos

Hello

I am loading an electronic bank statement. I am then deleting entries from FEBKO using ABAP RFEBKA96 - identifying the statement ID and application then processing on the subesequent screen to fully delete these values. When I check the table by selecting against application and company code, no statements display.

When I go to upload a statement again, it says 'statement is already uploaded'.

Any ideas?

Regards

squirrel

Accepted Solutions (1)

Accepted Solutions (1)

former_member194797
Active Contributor
0 Kudos

Please give the exact message number of 'statement is already uploaded'.

Former Member
0 Kudos

Hello

Acct 123456789: Statement 00001 already exists; entry ignored

Message no. FB771

is the message I receive.

Former Member
0 Kudos

So, I'm going to reply to my own post here...

I'm still confused about this...

I have deleted entries from FEBKO using RF*96 program (can't remeber off the top of my head) and had a successful message when deleted.

I can validate the deletion by displaying FEBKO entries for the company code. After the deletion program, there are no entries for the company code, so they are deleted.

So, why when I start to load again via FEBA do I get a message saying the statement already exists?

thanks & regards

former_member182098
Active Contributor
0 Kudos

Hello,

This note may help you.

Note 492131 - Electr.acct statement,MT940/Multicash: dupl.import after put

Regards,

Ravi

Former Member
0 Kudos

Hello Ravi

thanks for looking - that's helpful note, but not applicable to my situation.

Here's why: the note describes symptoms where SAP displays account statements as new even though they have been imported already. This applies to multi-cash etc formats where FEBKO-ABSND is not populated with an alternative account number. In my system there is no need to populate this as one account number is not held in different currencies. Also, I am loading BAI2 format.

What my SAP system is doing is this:

The symptom I am experiencing is that I receive a 'statement already exists' message - this is after deleting entries from FEBKO, and being able to verify they are deleted both from the confirmation report that happens after running RFEBKA96 as well as checking the FEBKO manually.

Some further information:

The existing SAP EBS process running now performs a load on a daily basis that is complete automated. In testing I am now loading a monthly statement using RFEBKA00. Do you think the existence of a number of days data is causing this problem? I think I will try after breaking the statement into days and then see whether that helps.

Arm.

Former Member
0 Kudos

Hi

Please recheck the program RFEBKA96 again if your statement is coming. Or else try with other statement number (not in sequence of the existing number) it will except your statement .

Mukta

former_member581688
Active Contributor
0 Kudos

Is the date of the statement you deleted and are trying to re-load before the date of another statement you have loaded? I.e. if the date of the statement you are trying to load is June 1, does a statement exist with a date of June 2 or later? I've had issues in the past loading BAI statements out of date order.

At one time, I debugged the standard EBS program and found some interesting logic around dates and the generation of statement ID's. I believe the logic was something like this: the program finds the statement ID for the last statement loaded for the account with a date prior the date of the statement you are loading. It adds 1 to the statement ID and assigns that as the ID for the statement being loaded. If another statement has already been loaded with a later date, this logic would have produced the same ID number at that time and assigned it to that statement. As a result, you get an error that the statement ID already exists. Basically this logic means that you must load statements in order of date.

Regards,

Shannon

Former Member
0 Kudos

Shannon - bang on! That's fabulous... here's what was happening:

- monthly statement was in reverse date order

- as soon as I looked at FEBKO using the dates and statement ID it made sense.

- re-sorted a couple of entries from the statement manually & posted

- Eureka! success!

Nice work, big thanks! have a good weekend!

Squirrel

Former Member
0 Kudos

Hi Secret_Squirrel,

Can you please let me know what exactly did you change to the upload file for EBS. I am getting the same error as I tried to load the files in an incorrect order.

Thanks,

G

Answers (2)

Answers (2)

former_member194797
Active Contributor
0 Kudos

You are receiving message "Acct 123456789: Statement 00001 already exists; entry ignored". It means that there is already a statement for this account with number 00001 and the system is unable to store another statement with the same number (there is a duplicate key when trying to store the data in FEBKO).

If the new statement has the same contents as the previous one, you may ignore the new one.

If it is another statement, but it has the same number as the previous one, I think that the only workaround is changing the statement number inside de file, replacing 00001 by 00002 or by 01001 for example. But I'm afraid you will have the same problem with the next staements, since the bank is using a stement number already used for the same account inside the same year.

former_member194797
Active Contributor
0 Kudos

Its is difficult to help you without viewing the contents of FEBKO. If you don't find any entry when searching by company code, maybe there is a wrong link between account and company code. You should search with other keys:

- by account number: search by field FEBKO-ABSND, putting the account number between 2 stars (*).

- by HBKID/HKTID

or search in FEBEP with the amounts, or try other keys.