05-17-2021 04:35 AM
Hello All,
Currently Our Default Currency in the system is 'USD". The system is rolling up the value correctly for the all the flow member formulas for USD. We also defined additional currencies in the system and for that the base value is not rolling up to the parent.
Is there is any formula available for us to use for the Parent to do the aggregation instead of Translation?
Thanks & Regards,
Ram
10-18-2021 05:46 AM - edited 10-18-2021 05:53 AM
Hi Ram
If you use foreign currency flow members, they are only valid intersections at base level and you can't consolidate them.
In case you are not using foreign currency flow members, or as a work around (you need to change the flow back to standard) you can use a member formula or a custom currency conversion to force a translation with an exchange rate of 1.
I hope this helps and regards
Christian