Reconciliation Key

[Former Member]

Can anyone tell me how to open an already closed Reconciliation Key. The situation is that somebody closed a reconciliation key for the month of october with the posting date of september and now when the transfer to g/l is done for the month of october, that recon key shopws up in the list with the posting date of september. the need to open this recon key is to change the posting date of september to october.

Opening of the posting periods in OB52 is not a solution because it is not safe. Suppose we open the posting period and some one else again uses the posting date of september for recon key then we face the same problem.

what is the way to open the closed recon key.

will appreciate greatly if i can get the answer as it is very urgent.

thanks

Lakshmi

[Former Member]

Hello Lakshmi Reddy,

try to use transaction FPG0, it enables you to define an alternative posting date for G/l transfert. maintain this table by defining 31.09.2007 in "the to poste date" field, 01.10.2007 in the alternative posting date. So all the FICA documents with a posting date of september will be posted for the month of october in GL.

Hope this help you,

Emmanuel

[Former Member]

Hi Lakshmi

I do not know if this info will help.

Reconciliation key

Well let me start by giving a definition of a reconciliation key. A reconciliation key is a key in which the summary records from contract accounts receivable and payable are recorded for later transference to downstream accounting systems such as the general ledger.

Summary record

Total of all line items posted to a reconciliation key that could be grouped together by general ledger accounting and other downstream accounting systems. Line items can be grouped together if they match in any of the following cases: company code, business area, posting date, credit/debit indicator, G/L account number, currency and value date for general ledger accounting and cost center, profit center, order number and project as well as fields related specifically to downstream applications.

General Ledger and Controlling

The FI-CA documents provide for the current account assignments from the following application components:

· The general ledger. Here it is the company code, business area, G/L account.
· The overhead costs Controlling and the Profitability Analysis (CO-PA). Here it is cost center, order, project, Profit Center, profitability segment.

The documents update FI-CA posting totals which are subdivided according to the account assignments named above. However, because the FI-CA documents often only differ from each other with regard to amount, business partner and contract account, a large summarization effect arises in the FI-CA posting totals. So experience from IS-U shows that several hundred thousand FI-CA document items meet on a few hundred totals records.
The FI-CA posting totals form the basis for generating G/L documents, via which not only the general ledger, but also, by transferring the corresponding Controlling account assignments, the different areas of Controlling are updated.
In addition to the account assignment characteristics of G/L accounting and Controlling, the FI-CA posting totals can be grouped according to a freely definable reconciliation key.
This reconciliation key is stored:

· in the FI-CA document header
· in the FI-CA posting totals
· in the document header of the general ledger document as external reference

This makes it possible to understand from which FI-CA documents a general ledger transfer document has been formed. This is a way in which, for instance, a reconciliation between contract accounts receivable and payable and the general ledger for a complete payment run, billing run or a given pile of FI-CA documents can be executed.

To Answer Your Question

So to answer your question it is not possible to change the posting date of a reconciliation key as a reconciliation key does not have a posting date but dates on which it was created(entry date) and closed. Actually the posting date is derived from the line items hence it is these line items that require adjustment thus if your system authorisation allows you so to changed the posting date. In your case, the only possible and recommended way to correct these entries is to reverse these line items and create new ones. Make sure this time around you have punched in a correct required posting date. A posting date determines the period in which it is posted to. These are changes that you must make on the FICA side. Or else those responsible on the FIGL side have to make some adjustments.

Note

Once a reconciliation key contains summary records, it can not be deleted. Once it has been closed and transferred you can not reopen. The only way is to reverse and post appropriated period

Posting Date in the Document

Date on which the document is posted in contract accounts receivable and payable (FI-CA).

Use

The system uses the posting date to:

· Determine the fiscal year and posting period when transferring summary records to the SAP R/3 General Ledger. This information is required for period-based updates of the G/L account, or cost center specified in the document.

· Select open items at a key date or within a particular period.

The posting date does not have to be the same as the entry date (date on which the entry was made in system) or document date (date on which the original document was created).

Regards

Hugo