What's new in Customer Journeys?

Connect and learn more!
Translate Closing Balance at avg current rate where no movement — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Translate Closing Balance at avg current rate where no movement

Received Response
43
Views
1
Comments
edited Mar 31, 2023 3:46AM in Financial Consolidation and Close 1 comment

Summary:

Is it possible to translate the closing balance of an account at the current FX average rate when there is no movement

Content (required):

Hello brains trust, I have a historical equity account that is carried forward each year but l want to translate the entity currency value to AUD for the current period at the current period average rate. I have tried a translation override but it seems to just carry the balance forward and doesn't "re-translate". I do not want to use the historical amount override because we have so many periods we are loading (I know that's not ideal but client insists). Is there something else l can do to make it work like the following please?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!