This discussion is archived
2 Replies Latest reply: Nov 6, 2012 3:03 AM by Anna RSS

How to query ICP result in [Elimination] value ?

Anna Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points