FF67 - Statement number zero (N° 0)

[marco_correa2]

Hi everybody:

We have the following problem.

The number of bank statement reached zero in the same year that statement number 999.

The Closing balance of the extract 999 is "X"

The Closing balance of the extract 000 is "X + 1000"

Then in ff67 when we are creating a new statement, this shows Opening balance "X". But SAP displays message warning FV058.

"Beginning balance does not match prior ending balance "X + 1000"

Message no. FV058

Diagnosis

The beginning balance from bank statement "X" does not match the ending balance "X + 1000" from statement 00001 2014.

Procedure

Check your entry"

We want to fill the amount "X + 1000" automatically in the opening balance field.

How do we can do that? Is it a setting or a program error?

Best Regards

Marco

[Former Member]

Hi Marco.

Please check this OSS note below.

1517167 - Defining FV058 as an error message

Kind Regards

Jandoval

[marco_correa2]

Hi Jandoval:

Thanks by your reply.

That note is about the message behavior.

My problem is how to fill automatically the opening balance field with the amount of closing balance field of the bank statement Zero, when I create a Bank Statement number 1.

Regards

Marco

[Former Member]

Marco

Did you try delete the bank statement and import it once more?

Kind Regards

Jandoval

[marco_correa2]

Hi Joseph and Marssel:

Thanks a lot by your answers, but I think I have explained wrong.

The problem is when I load a bank statement manually.

This are the steps to load the bank statement in SAP:

1. Go to FF67 and press overview button

2. Double click to select the bank

3. Then press statement button

4. This will bring automatically the opening balance (the closing balance of the last statement)

5. but the problem is SAP considers like last statement the statement number 999 with amount "X", instead the statement number 0 with amount "X+1".

How do I get that SAP fills the field automatically with amount "X+1" from statement number 0?

Or It is a program error?

Greetings

Marco

[Marssel700]

Marco,

You can't create BS = zero. Zero = "blank"

You want to create a statement 000 with value 1000+X after statement 999 = X?

Why don't you create statement 1000?

I am confusing. Could you please attach your screen shot over here?

[marco_correa2]

Dear Marssel:

Please, excuse my absense.

I have tried, with bank statement number 000, but system consider like Zero = "blank".

I'll explain something. I'm from Chile, and here each bank gives the bank statement number. Then Santander Bank works between Zero and 999.

That is the origin of the problem.

Greetings

Marco

Here are some images:

[Marssel700]

Marco,

The transaction follow sequence by Statement number.

The system recognizes Statement 924 as last entry and copies to new one.

Are you creating a bank statement 1 after other bank statement 1 (same)??

Since statement is a manual input I recommend you define your interval like 10000 to 10999. You may use first 2 characters as the number of new counting (20000 to 20999)

in order to solve current issue you have to reverse your statement and adjust the numbering. There is no other way.

please check

http://wiki.scn.sap.com/wiki/display/ERPFI/How+to+delete+an+Eletronic+Bank+Statement+-+RFEBKA96

[jayj07]

Hi Marco,

This might be a tricky explanation but based from my experience with FF67, you need to do it right the first time. What I mean is if that if on your first manual input you got the amounts wrong, the error will always pop-up the next few times regardless if you've corrected the amounts.

If you can share some more info, I'll try to be more of help.

Jayj

[Marssel700]

Hi,

What is the beginning balance of statement 000?

It should be X+1000 like end balance of 999.

Once you have so many Statement entries already written you could do a split in the overview screen.

In menu: Settings-> Specifications you unflag Int.Bank Determination. Then you will be able to manually create a statement account.

According Brazilian localization the followings bank key have same value:

3412938 = 34120938 = 341200938 = 3412000938 ...

Beyond fourth digit the left zeros are ok and the system will recognize as a new Statement Account.

Then you have a brand new account to be managed with no need care about last closed balance.

* I presumed you are from Brazil.

let me know your comments.

regards