2 Replies Latest reply: Nov 6, 2012 5:03 AM by Anna RSS

    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
        • 1. Re: How to query ICP result in [Elimination] value ?
          user10767728
          Hi Anna,

          Since [Elimination] is dependent on the consolidation hierarchy, you need to have the entity in parent.entity format on your form/grid/report in order to get the [Elimination] to show. If you only refer to the entity dimension only with the entity (without the parent) the cell will show orange/invalid.

          Hope this helps!
          • 2. Re: How to query ICP result in [Elimination] value ?
            Anna
            Hi,

            Yes, actually in form, i create exactly as you told. It's automatically created by system when i select entity. HFM is automatically added Parent.Entity. That's in form script. But when viewing the form, the entity display only Entity, not with its parent.

            Did I create something wrong with this ?

            Appreciate your help. Thanks,
            Anna