EBS - Bank Statement Number

[sachin_thombre]

Hello All,

I am doing EBS testing in test environment. Every time I process a testing file I get error msg - Opening Bal is not same as pervious closing bal, File ignored statement already exists etc.

Can you please let me know how easy way to check closing bal of previously posted statement and how to see the last statement number...

Regards,

Sachin

[Former Member · Accepted solution]

To find the last statement number select on table FEBKO in SE16 and look for the highest KUKEY number. Usually when testing I add 2 to the statementnumber, you get the message regarding the previous statement not found but you can test really fast.

[sachin_thombre · Accepted solution]

Thanks all for your response. If you can please answer my 2 more questions related to this

1. Each time I get msg - Difference it too large for clearing. Why do I get this msg and how to avoid this

2. What is the use of Algorithms -

BELNR number interval

XBLNR number interval

[Former Member · Accepted solution]

You can add the algorithms at the customizing where you link the external operationcode to the posting rule. After that you enter the relevant intervals on the selectionscreen in FF_5. If numbers are found in the decription of the received payment the system tries to match them to open items in the system and clears them (you have to set up special posting rules)

https://archive.sap.com/discussions/thread/3554036

you can find the numbers derived by the algorithms in table FEBCL using KUKEY as key which is found in the FEBKO table

[sachin_thombre · Accepted solution]

Thank you Bastiaan

[pankajypatil]

Hi Shinas,

The best way to test statements is change the statement number in bank statement everytime before uploading.

Also you can delete the statement and upload it again.

Regards,

Pankaj

[nico_dewaele]

hi,

the opening balance is a warning, which you can ignore.

you can delete the booked statement via program RFEBKA96 based on the short key (which you can see on FEBAN)

kr

Nico

[shinas_rh]

Hi,

To Solve this issue, what you can do is,

go FF67

Select OVERVIEW Button.

Select You House bank and then Click on New Statement. It will then automatically pick the Opening balance as per last reconciliation.

Then you may go ahead with your EBS.

This simple method i have mentioned here cause you mentioned its testing System. It mean there will be lots of Junk data and may be balance also not correct.