Hello gurus,
Is there a common method to create intercompany reconciliation reports without using the intercompany module in HFM?
For the sake of simplicity, lets say I have a flat hierarchy with entities using different reporting currencies and the group currency is USD. Users load their intercompany balances into HFM in their reporting own currencies. After all users load their balances, each user should be able to see the amount they entered and the amount their partner company entered and the difference in Group Currency. So, similar to intercompany module report without the transaction amount detail.
I thought I would create two members; "Entity Amount" and "Partner Amount" in a custom dimension, and write a custom rule to map intercompany transactions for the users to compare. But ofcourse the users would have to first perform translation and the calculate in parent currency. Would that be a bad approach performance wise or can you suggest any other methods?
Thank you.