Electronic Bank statement

[Former Member]

Hello Experts,

I have completed the settings for Electronic bank statement,but I want to know once we upload the bank statements if we check in fFEBA we will get to posted and success and Donot overwrite.Can I know what does it mean.

And I want to know the balance of to be posted.And how the atatement identifies the data.

Thanks

Edited by: Konduru_Raju on Jun 20, 2011 3:40 PM

[Former Member]

Hi

Lets take it one at a time, for example in case of AR clearing you will use the below rule,

Posting Rule, Posting Area, DR PK, DR line item, CR PK, Credit line item, Posting Type, Doc type

1) XXX1, 1, 40,Bank Account, 50, AR Clearing Account, 1, SA

2) XXX2, 2, 40, AR CLearing Account, blank, blank, 8, DZ.

Note the items posted in AR clearing account will be opened and will have to be cleared through F.13, later.

In case of AP where the payment doc is already posted through F110

3) XXX3, 1, blank ,AP Clearing Account, 50, Bank Account, 4, SA

For normal GL posting you can refer rule 1.

Here you will need to use Algo 001 standard algo and you use Account number or Reference number for clearing the AR subledger.

You can also refer the below link for more details. Here you will get sample example as well,

http://help.sap.com/saphelp_46c/helpdata/en/43/0bd40843de11d1896f0000e8322d00/frameset.htm

Thanks

Nikhil

Edited by: Nikhil Kothari on Jun 25, 2011 12:15 AM

[Former Member]

Hi Konduru_Raju

Can you specify exactly what is the client requirement, and the posting rules, interpretation algorithm you are using in EBS. In that way, it will easier to solve your query faster.

Thanks

Nikhil

[Former Member]

Hello Nikhil,

Posting rule what I am using is

L001 Customer recpts with clrg,L002 Customer recpt without clrg,L003 GL recpt with clearing,L004 GL recpt with clearing,L005 Vendor recpts with clrg,L006 endor recpt without clrg and External transaction are Bankers Draft-,Bulk Pay Contra,Cash Cheque-,Cheque-,Chq collection-,Cm Cheque retn,cm_credit,commission-,Draft cancellation,ecs debit-,edn cess-,etax outward-,house transfer.What will be the posting rule I will use and Algorithm.

Please guide me.

Thanks

[Former Member]

Hi

Check out the below link,

http://help.sap.com/saphelp_46c/helpdata/en/43/0bd87b43de11d1896f0000e8322d00/frameset.htm

Thanks

Nikhil

[Former Member]

This message was moderated.

[Former Member]

Hello Anil,

Thanks for the reply.

But I want to know how the system identifies the Amount which is uploaded from bank statement and which is in our system.

Thanks

[Former Member]

HI,

The system will search for the open items based using the reference provided in the bank statement. The bank statement will have details of either the customer, vendor or invoice and the system will then do a search based on this with the amount. If you hgave defined search strings it will use this. Also it will look at the sternal transaction codes that are mapped in configuration.

You can look at tcode febsts this will simulate the search.

[Former Member]

Hello Experts,

Can you please explain in detail as to how EBS works and Tables to see the updated statements.

Thanks

[Marssel700]

Dear,

check OT83 to define EBS postings and rules.

regards

[Former Member]

Hello Experts,

Any Inputs please.

Thanks

[Former Member]

Hi,

As suggested above, all the configuration related to EBS is done in OT83, Now when you upload a bank statement there is a check assignment field, due to which the system clears off the same document.

In other case when there has been no check assignment. And you post it Via ff_5 the statement will get uploaded but will not get posted.

Now go to FEBAN, there you can see the amount is next to red box (means not posted) here comes the concept of "Forceful Match"

Goto "Statement Items on the top" and click on "Post" the system will open all the Open items with the same amount,

Deselect all and select the one which u want to post and save it. Recheck FEBAN it will be green (Posted).

System needs some assignment field to recognize the document automatically, if not specified then the documents can be posted via "forceful match"

Regards,

Prashant Goel

[Former Member]

Hello Prashanth,

Thanks for the reply.Where can we find that Assignment filed.

Thanks

[Former Member]

The check number will be there on the .txt file you are uploading or on the macros via which you creating the header and details files to upload. just check the same field in FB03 for a specific document whether in the assignment field you have maintained that particular check number or not. If both are same system will automatically recognize and clear that document.

Regards