CO-FI Reconciliation
Purpose
This content was created to clarify the system logic of the CO-FI reconciliation.
Overview
This function reconciles the internal posts from CO to FI. You can use the Real-Time integration to transfer cross-company code or cross-functional area postings made in CO that are relevant to FI and to automatically create reconciliation postings in FI.
CO-FI Reconciliation Customizing
The customizing of the Real Time Integration will determine when the FI document will be created from CO lines.
You can check the customizing on transaction FAGLCOFIIMG.
• Real-Time Integration with CO Active: The CO documents selected are to be transferred in real time to Financial Accounting.
• Key Date from which Real-Time Integration Is Active: Key date from which CO documents are transferred from CO-internal allocations into Financial Accounting.
• Perform Acct Determination for Real-Time Integration with CO: Account determination (OK17) to be performed when CO documents are transferred into Financial Accounting.
• Document type: The document type classifies the accounting documents
• Ledger Group: Identify the ledger group
Then you need to choose the selection of document lines for Real-Time Integration CO->FI:
• Use Check boxes
The CO line items that correspond to the selected criteria to be transferred to Financial Accounting .
In your system the real time integration is active. The fields to be checked are
• Company code
• Fund
• Functional area
• Profit Center
If there is a change during a CO posting (Credit vs. Debit) in any of the selected fields the FI document will be created. If there is no change no FI document will be created.
The CO line items will be selected using a customer-defined implementation for the Business Add-In (BAdI) FAGL_COFI_LNITEM_SEL.
• Use Rule
The CO line items will be selected using a Boolean rule to be transferred to Financial Accounting.
• Update All CO LIs
All the CO line items that are generated with CO internal allocations (KO88, CJ88, KSU5, KEU5) will be transferred to Financial Accounting.
After you customize the variant you will need to assign it to a company code
Account Determination Of The FI Document
You customize the account determination on transaction OK17.
You cannot transfer any secondary cost elements from Controlling into an FI document, so you need to maintain an account in transaction OK17.
Primary cost elements are transferred from the CO document to post the FI document, but you can use the option "Account determination for primary cost elements" to use
the account from the account determination.
Useful CO-FI Reconciliation Transactions
FAGLCOFIFLUP Repost CO->FI from Worklist
FAGLCOFIIMG Customizing for CO->FI Update
FAGLCOFILOGDISP Display Application Log
FAGLCOFITRACEADMIN Administr. of Trace for OnlineUpdate
FAGLCOFITRACEDEL Deletion of Trace Data for Update
FAGLCOFITRACEOFF Deactivate Trace for Online Update
FAGLCOFITRACEON Activate Trace for Online Update
FAGLCOFITRACESHOW Display Trace for Online Update
FAGLCOFITRNSFRCODOCS Transfer CO Doc. into Ext.Accounting
FAGLCOFIWRKLSTDISP Display Worklist
FAGLCOFIWRKLSTEDIT Edit Worklist
FAGLCOFIWRKLSTTRACE Display Worklist and Trace Data
FAGLCORC CO - FI Reconciliation