Skip to Content
author's profile photo Former Member
Former Member

How to Update Reconciliation Account in Vendor Cleared Items

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2014 at 06:31 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 07, 2014 at 08:20 AM

    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,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 06, 2014 at 07:54 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 07, 2014 at 09:56 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.