Hello Gurus,
Need some help. I want to produce a consolidating trial balance. A wrench is thrown into my report when an entity is inactive in the middle of the year using a periodic consolidated scenario because you can only see the amount contributed to parent at [Proportion] but FR does not recognize invalid entities, i.e., any amount at [Parent] or later.
I cannot use PCON to 0 because ICP eliminations do not work appropriately as parent entities will move.
I believe the only workable solution to this issue is to hard code the report by month but this seems painfully manual and subject to error. Another alternative, in SmartView, you can display invalid data but would prefer not to encourage financial reporting in excel.
Any ideas?