Topic
  • 1 reply
  • Latest Post - ‏2012-07-02T17:42:30Z by Paul_Allen
SystemAdmin
SystemAdmin
41 Posts

Pinned topic Eliminate intercompany balances partially.

‏2012-06-04T17:28:13Z |
Hi!
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.
Updated on 2012-07-02T17:42:30Z at 2012-07-02T17:42:30Z by Paul_Allen
  • Paul_Allen
    Paul_Allen
    13 Posts

    Re: Eliminate intercompany balances partially.

    ‏2012-07-02T17:42:30Z  
    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.