How to Update Reconciliation Account in Vendor Cleared Items

[Former Member]

Hi Folks,

We have uploaded the vendor Opening balances with wrong reconciliation account (we are using alternate reconciliation accounts for posting). The opening balances of the invoices are already cleared by the payment with wrong reconciliation accounts.

Now we wants to corrects/ reconcile the G/L accounts with correct balances. What will be best approach to match the G/L balances or what will be best practice to update the correct reconciliation account in already posted/ cleared documents.

Thanks and Regards,

Sarvendra Singh

[former_member183378]

Hello Sarvendra,

Please go through these discussion threads which would be helpful to you to fix this issue.

http://scn.sap.com/thread/1907998

http://scn.sap.com/message/9992682#9992682

I hope it helps!

Thanks & Regards,

Lakshmi S

[Former Member]

Hi Friends,

Thanks for sharing the updates.

Just I would like to add more that how we can update the reconciliation account in already posted Open and cleared documents.

We had some balances as on previous year which user were supposed to update with alternate reconciliation account but most of the data user has posted with wrong reconciliation account. Now user wants to update the reconciliation account in all the posted Open and cleared item in order to match the data for Opening balance.

Kindly suggest.

Thanks!

[former_member183378]

Hello Sarvendra,

If it is for one vendor so please update the correct reconciliation account in vendor master data in XK02 manually. Else if you want to change the reconciliation accounts for a large amount of vendors so pls do the same by using mass update through MASS/XK99/LSMW approach or BDC process.

You can reset & reverse the already cleared documents through FBRA and do the clearing after making the necessary changes in vendor master data.

I hope it helps!

Thanks & Regards,

Lakshmi S

[Former Member]

Hi Lakshmi,

The issue is not related to updating the Recon. in Vendor Master.

We do not want to any update in master data and also do not want to reverse any of the data.

We require the alternate solution to update the Recon Account in already posted documents.

Thanks!

[former_member221220]

Hi,

As you already have some balance in the old / wrong Reconcillation Account, the balance has to be transferred to the new account.

The open items from the Old Reconciliation Account should be allocated to the new reconciliation account using adjustment accounts. This allocation is carried out automatically when you create a sorted list of receivables and payables using report SAPF101.

Before running SAPF101 you have to define the adjustment accounts for both (old and new) reconciliation accounts in transaction OBBW.

Path : Accounts Receivable and payable > Business Transactions > Closing >Regrouping > Define adjustments accounts for changes reconciliation accounts

SAPF101 is required to show the correct balances in the Balance Sheet.

If all open items on the old account are cleared your problem will be solved automatically.

As long as there are OI on this old reconcillation account ,SAPF101 must be executed at year end to  execute the adjustment postings.

1. Create a Vendor clearing account / Use a Vendor clearing and post the below entries

2. Change the Recon account in Vendor master

Regards,

Sravan.

[former_member270407]

Hi Negi,

please follow the snote

1710555 - SAP101 - change reconciliation account, adjustment entries

the content is:

Symptom

The reconciliation account has been changed in vendor / customer account master data.

The adjustment postings generated by SAPF101 / FAGL_CL_REGROUP do not change the balance of the old and new reconciliation account.

Environment

• General Ledger
• Periodic Processing
• Closing

Reproducing the Issue

Run SAPF101 / FAGL_CL_REGROUP to post adjustment entries on reconciliation accounts.

Cause

The open items from the old reconciliation account should be allocated to the new reconciliation account using adjustment accounts.

Resolution

Reconciliation account is changed in the master data of vendor or customer accounts (FK02, FD02) and the new open items will be posted to the new reconciliation account.

The open items from the old reconciliation account should be transferred to the new reconciliation account. As the reconciliation account can't be posted directly, the postings will be done on adjustment accounts.

This allocation is carried out automatically by the report SAPF101 / FAGL_CL_REGROUP. The report does not change the document itself, the old reconciliation account is stored in the original document like before.

The report also creates a posting to cancel this correction posting one day after year end / month end closing.

The adjustment accounts are defined in transaction OBBW (IMG Financial accounting  > Accounts Receivable and payable  > Business Transactions  > Closing > Regrouping  > Define adjustments accounts for changes reconciliation accounts).

The balance of the old reconciliation account will be set automatically to zero if all open items on this account are cleared.

As long as there are open items on this old reconciliation account, SAPF101 / FAGL_CL_REGROUP must be executed at year end to perform adjustment postings.

Example:

old reconciliation account:         140000

new reconciliation account:       141000

Customizing in OBBW:

Chart of Accounts    INT   Sample chart of accounts

Transaction            A00   Transfer postings: changed recon. acct

reconciliation account          adjustment account

    140000                                  140001

    141000                                  140002

- There are 3 open items (document 1-3) on the old reconciliation account.

- The reconciliation account was changed and  2 new open items (document 4-5) are posted on the new reconciliation account.

- Now the balance of documents 1-3 is shown on the old reconciliation account   and the balance of documents 4-5 is on the new reconciliation account:

  Balance of open items on the old reconciliation account  140000:      200 EUR

  Balance of open items on the new reconciliation account 141000:     -100 EUR

- At year end  SAPF101 / FAGL_CL_REGROUP is executed. This report checks if there was a change in reconciliation account . The report takes the balance of documents 1-3 and posts this balance at year end from old reconciliation account to new reconciliation account . Because reconciliation account can't be posted directly, the postings are done on adjustment accounts.

Adjustment posting at year end (31.12.2011):

  140001       adjustment account- recon.acc.  140000                          -200 EUR

  140002       adjustment account - recon.acc.  141000                          200 EUR

Reversal of adjustment entry at the beginning of next month/year  (01.01.2012):

  140001   adjustment account- recon.acc  140000                               200 EUR

  140002  adjustment account - recon.acc  141000                              -200 EUR

Final balances on the involved accounts:

  140000   - old reconciliation account   :                                             200 EUR  

  140001  - adjustment account for  140000:                                      -200 EUR

  141000  -  new reconcilation account  :                                            -100 EUR

  140002 - adjustment account for 141000:                                         200 EUR

Best regards,

[Former Member]

Hi Sarvendra Negi,

Option which I would like to suggest is:-

1) Get list of all the invoices which are posted / cleared in SAP

2) Read the accounting document in BSEG table and against these FI documents, check field AUGBL,(Clearing Document)

3) Get a list of all the clearing document which you want to reset,

4) Run transaction FBRA to reset the cleared items,

5) Then change the reconciliation account and clear again,

Another option for future is to use validation & substitution for posting to the alternate reconciliation account

Regards

Rishab

[cassio_goulart]

          Hi Savendra,

     Reading your post i was in the transaction XD02 (i know that your problem is with vendor but the process is the same) and changing the reconciliation account the SAP indicates that the carry out of balances of old reconciliantion accounts is do using the standard report SAPF101 by adjustment accounts.

     In this report (or transaction F101 -ABAP/4 Reporting: Balance Sheet Adj) in the folder "Parameters" u will see a check box call "changed rec.acct".

     I holpe that the advice up can help u.

Best Regards,

Cassio Goulart