Skip to Content
avatar image
Former Member

FF_5 Bank Statement upload error

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

8 Answers

  • avatar image
    Former Member
    Sep 19, 2007 at 04:26 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 19, 2007 at 08:17 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 19, 2007 at 08:53 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 19, 2007 at 09:36 PM

    you can repocess the statement using transaction FEBA_BANK_Statement.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 19, 2007 at 11:44 PM

    Hi Paul,

    We are using BAI format.

    Thanks

    Prashanth

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 22, 2007 at 02:03 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 20, 2007 at 03:27 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 27, 2007 at 06:13 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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