FF_5 Bank Statement upload error

[Former Member]

Hello Friends,

I can’t upload the Bank statement into SAP as its giving me the message "Statement 56 already exists. ENtry Ignored"...and the thing is that statement that i have uploaded for july 24th had statement number 56..and then i uploaded one statement after that manually which gave me statement number 57..but now when i try to upload the statement forJuly17th, its still looking for Statement number 56..could anyone telll me where in the system statement number is defined as i know its SAP generated number.

or any other advices would be appreciated. its urgent. thanks

[Former Member]

Here is the solution from SAP:

Dear Customer,

The error FB771 occurs in the following circumstances:

1. If you trying to import the same file which was already imported? If

yes then this error is due to the fact that the statement with the

same details are already in the system..i.e. it does not allow to

post the same statements twice.

Statements are stored in table FEBKO for the header info, and you

might review the statements stored there. The 'key' is dependant upon Bank number/Account as well as the year/'bank provided statement

number' (stored in field febko-azidt.) Review the entries and source data

You may want to use RFEBKA96 (See note 15759) to delete prior

bank loads (delete per ID number) ** This has to be done carefully ** . Please remember to use program RFEBKA96 only after CAREFULLY

examining the statements and lists. When deleted, they are

irretrievably removed from the bank data memory.

2. This is exactly your case:

Else please let me know if you are importing statements in their

chronological order?? Please note that since BAI-format doesn't

provide the statement number SAP allocates the number internally.

So it looks for the latest statement in the particular bank account

and will add 1 to the statement number. Hence you must not mix up the import of the bank statements you have to import them according to

their statement dates. If this is the case then please let me know.

This system behaviour was changed since Release ERP2005. If you need to

revert back to old system behaviour, please note that our development

has released note 946299 to undo the changes and this is a

PILOT release. Please understand that this is a modification note as we

will need more time to check if we can take over this in standard again.

As this is a very urgent case, I'm releasing this note to you, so

please test this and let me know.

[Former Member]

The following note will fix the issue if you have posted.

SAP NOTE: 1025077

Context Block:

SELECT * FROM  febko INTO TABLE i_febko                   "HW139804

         WHERE anwnd       = febko-anwnd                   "HW139804

         AND ( absnd       = febko-absnd                   "HW407675

           OR ( absnd       = febko-absnd(45)               "HW407675

             AND waers      = febko-waers ) )               "HW407675

         AND ktonr       = febko-ktonr                   "HW139804

         AND emkey       = space                         "HW139804

Delete Block:

*        ORDER BY aznum DESCENDING.                         "HW139804

         ORDER BY azdat DESCENDING.                         "HW139804

Insert Block:

ORDER BY aznum DESCENDING.                         "mod_1025077

[Former Member]

My client is also running into the FB771 error message “Acctxxx: Statement 00094 already exists, entry ignored” after processing 2 bank statements out of sequence (we are on ECC 6.0). Has anyone logged a message or found a resolution? We've tried the suggestions listed in this thread and still cannot process the new bank statement.

[Former Member]

Hello everybody I have some problem with upload as well but other art. Maybe you culd give some sugestion. The problem is:

I was unable to import the bank statement file. The error says that the beginning balance of statement number 136 isn't the same as the closing balance of account number 135. I checked the statement file and the balances seems to be ok. The balance is always zero in the morning and at the end of the day because of the sweeps.I checked G/L account as well and ther was no transactions on this day!!! The next bank staytment 137 I could upload without any problem. Now in the system is missing 1 bank statement 136.

what can be reason of this?

Thank you in advance

[Former Member]

Hi Paul,

We are using BAI format.

Thanks

Prashanth

[Former Member]

Hi Parshant,

I also worked on BAI. send me your both the files which you uploaded successfully and the second one.

paul_sraan2@yahoo.com

-Paul

[Former Member]

you can repocess the statement using transaction FEBA_BANK_Statement.

[Former Member]

I have faced the same problem before about a year ago but never was able to get an answer regarding how to correct the statement number assigned in the system. We use the BAI file format type. If I understand your problem correctly, as a work around, you can combine the activity for July17 into another day's file.

Is it possible that you already imported the file for the 17th but did not post it? If so you can subsequently post it using FEBP. Can you pull up the file for the 17 in FEBA? Was there a statement uploaded in error (that should be deleted) that threw the statement numbering off?

[Former Member]

what file fomat you are using? Make sure the date and time is different in your files (may be it is appearing more than one time in the file) and also you need to change the batch number of the file.

-Paul

[Former Member]

Hi Chand,

My client upgraded from 4.7 to ECC 6.0, and i am facing the same issue with FF_5 with the same error message.

"Unable to load bank statement for 2007/09/13. Error message Statement 00324 already exists; entry ignored (Message no FB771)"

If you have solved please let me know the solution.

Thanks

Prashanth