We are facing an issue with Currency conversion while implementing Consolidation for one of our clients. The requirement is to perform conversion using different exchange rates per account for an entity.
For example, considering the entity structure given below:
For each of the group in the legal entity structure, there is an elimination entity where all the permanent elimination entries for that group are passed. These permanent elimination entries are not calculated in BPC using IC elimination business rule, but are directly passed into the system by client through a flat file upload.
For Group_A, permanent entries for entities Entity_A, Entity_B & Entity_C are passed and stored in elimination entity Elim_A. For Grp_D, these are
stored in Elim_D.
Taking a scenario wherein, Entity_A acquired Entity_B in 2000 when INR to USD exchange rate was say 45 and it acquired Entity_C in 2005 when the exchange rate of INR to USD was 50.
Now, let’s consider the entries for elimination of Reserves in acquiring entity with Investment in acquired entity. While performing consolidation at Group_D in the month of June 2014, the LC (INR) data in these accounts for entity Elim_A is required to be converted to USD using more than one rate, each corresponding to the acquisition of Entity_B & Entity_C by Entity_A. For Entity_A & Entity_B conversion would happen at the rate of 45 but that for
Entity_A & Entity_C it would happen at the rate of 50
Hence, summarizing the issue, for the same account within an entity, different exchange rates need to be stored for performing conversion from LC to Group Currency.
As far as we know, in BPC we can store single exchange rate at entity – account combination. For a legal entity, each account can have one exchange rate for every currency. I am not sure on how to implement this requirement of storing multiple exchange rates for one single account of an entity.
We would really appreciate your inputs/help on the same.