cancel
Showing results for 
Search instead for 
Did you mean: 

Bank Reconciliation

Former Member
0 Kudos

Hello All,

Once the payments have been uploaded the reconciliation key is closed and data is sent to R/3. During Bank Reconciliation if the entry matches the item gets closed, but strangely it is not working for one of the banks. The items remain open only. What could be the reason. Please anyone can help.

Charvi

Edited by: CharviS on May 27, 2011 8:02 AM

Accepted Solutions (1)

Accepted Solutions (1)

former_member213733
Active Contributor
0 Kudos

Hi ,

in OT43 the varient for bank statement is cinfigured , based on which the reconcilliation takes place .

Kindly check the varient as to what all fields are considered for doing the reconcilliation , for eg. date , amount , assignment field value etc .

Also kindly check what is getting updated in the assingment field when the document is passed to FI - FPG1 , then do check the fields as to what all things does the statement contains . if the statement contains the LOT no or RECO key then do check the same in the FI document assignment fields ( ZOUNR ) that is being created during the transfer .

Hope it helps .

Cheers ,

Dewang

Former Member
0 Kudos

Hello Devang,

Thanks for the reply, but my concern is if the reconciliation is working fine with one bank, how can it not work for the other. The settings are not for individual banks.

Regards,

Charvi

former_member213733
Active Contributor
0 Kudos

Hi Charvi ,

There and few things which needs to be checked for the same .

1. Have you used the event 940 for customozing the ZOUNR field in the document that is being created in FI .

2. Is the BTE 1120 being used for transfer to data to FI .

What are the details that you are getting from your bankers is it RECO KEY or LOT NO. if it is so , then the same has to be updated in ZOUNR field in the FI document ( above 2 things can be used to customize as per custom requirements ) .

Finally also check the SORT KEY in GL account for the bank that you are using , is it having the "Allocation number " as sort key ?

Kindly go through the details above and check the amount in the bank statement v/s the amount of the document , as if there are any differences then also system wont be able to recognize the enry for reconcilliation .

Cheers ,

Dewang

Answers (0)