Translation to Local Currency from USD data

Content

Hi, We have a requirement to translate data from USD Data load to the local currency of Intercompany entities. I know one of the solution could be leveraging reporting currency to translate data into the local currencies of intercompany partner. Just wanted to know if there is any other better solution to cater to below requirement.

Original Data:

Total $100 USD

Corp $100-> No Intercompany-$45,    ICP SPV 1 - $25,      ICP SPV 2-$30

After:

Total $100 USD

Corp $45 USD

SPV 1 $25 USD translated back to local currency

SPV 2 $30 USD translated back to local currency

Thanks in advance.

Version

21.03.60