2 Replies Latest reply on Nov 6, 2012 11:03 AM by Anna

    How to query ICP result in [Elimination] value ?

    Anna
      Dear experts,

      I want to create a form which can show an ICP transaction as below:

      ____________________________________SalesIC______CostIC_______PlugPL
      Entity A____Partner B___<Entity Currency>__500
      Entity B____Partner A___<Entity Currency>_____________600

      Now, after consolidation, i want to see [Elimination] value in form. I did create a form like this in v11.1.1.3 before and it worked. However in v11.1.2.2.300, it keeps sending me invalid cell. Below is the additional information I want to see in form:

      ____________________________________SalesIC______CostIC_______PlugPL
      Entity A____Partner B___<Entity Currency>__500
      Entity B____Partner A___<Entity Currency>_____________600
      Parent A___Partner A____[Elimination]______-500___________________500
      Parent A___Partner B____[Elimination]_________________-600________-600
      Parent A___[ICP Top]___<Entity Currency>________________________-100

      When I build this form, [Elimination] row always invalid (red/orange color). I wondering how can I show the elimination process ?
      I know that we can create intercompany report for summary, but still I need to show this elimination as a report formal.

      Thanks for your help.
      Anna