Now, after consolidation, i want to see [Elimination] value in form. I did create a form like this in v184.108.40.206 before and it worked. However in v220.127.116.11.300, it keeps sending me invalid cell. Below is the additional information I want to see in form:
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.
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.
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.