Skip to Content
avatar image
Former Member

Posting Journal to Reconciliation Accounts - AP AR & Asset Accounting

Hi All,

I am in a unique situation where I need to post a Journal Entry to Reconciliation Accounts in General Ledger. I was able to find the Transaction ABF1 with help of OSS Note 69225 to resolve the Asset Accounting Reconciliation Account. But I have been unable to find any such transaction available for AP & AR. Do you know of any similar solution available for posting to AP & AR Reconciliation Accounts in General Ledger?

I know that the first question that will be raised is why we need to post such an entry. Here is a summary explanation: This is required due to the fact that there are data inconsistencies in our client's database which were created due to a Carve Out Project when the company separated from its parent. The subsidiary's company code was the same Company Code as the parent company code. During the Carve Out, the parent company's IT Team used the SAP SLT Tool to delete data that was not relevant to the Subsidiary. However, the deletion process was not done at a holistic level and in my opinion, it created more problems. The team only deleted the Master Data without deleting the Transaction data. For example, they deleted the Vendor Masters without deleting the related data in BSIK & BSAK tables. They deleted Profit & Cost Center Masters without deleting related data in GLPCT & GLPCA Tables.

As a consequence of this, F.01 report does not display the correct data as it still shows all the $ values for the parent company also (Related to Non Existent Profit Centers). All this data keeps getting carried over to the next year also.Only the Profit Center Balance Sheet reports are accurate because you can filter based on Profit Center. The client is on Classic GL & there is no way to filter F.01 based on Profit Center.

After a lot of consideration, the best cost effective approach that the client agreed on is to be able to post a Journal in GL that would reverse all the GL Account balance issues that exist & post to a Dummy Profit & Cost Center that will never be referred to in the future.

The issue is an unconventional one & hence would involve unconventional solutions. If you know any method to post to AP & AR Reconciliation Accounts in GL, please let me know so that we can test this in our QA systems.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 14, 2017 at 09:40 PM

    Hi - you can try using transaction FS02 on the general ledger recon account, go to the accounting information, and blank out the recon account type for group as shown:

    Save, post your journal entry and then go to FS02 and switch back on the recon account for account type

    Word of caution - your outside auditors may question this activity, so be sure you have accounting/management approval to do this; so many companies get into trouble on this.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Tammy Powlas

      You are correct. I could make this message into a Warning, convert to non Recon & try to post a JV.

      I just wanted to make sure there is no standard solution available for this. Like I said, I found one solution for Asset Accounting, but couldn't find anything for AP & AR.