In a Cognos Controller (10.1.0) application it's necessary to eliminate inter-company balances, but only partially. After eliminations, it should be a remaining balance in the account, which is not eliminated. The total account balance before eliminations is reported in the general ledger. The general ledger does not contain the details of transactions between companies. The eliminations details for the same account are fed separately from a text file. So, the account's final balance must be the general ledger amount minus the amount of transactions with other companies.
Any idea how to solve it?
Thanks in advance.
Pinned topic Eliminate intercompany balances partially.
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-07-02T17:42:30Z at 2012-07-02T17:42:30Z by Paul_Allen
Paul_Allen 2700025GB913 Posts
Re: Eliminate intercompany balances partially.2012-07-02T17:42:30ZThis is the accepted answer. This is the accepted answer.Load the ic detail into a statistical account and use that to drive the IC elimination against the main account, it's pretty straight forward.