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

Translation Overrides for Balance Sheet Accounts Not Working

Received Response
edited Jul 23, 2021 7:59PM in Financial Consolidation and Close 2 comments


We have a requirement to translate Intercompany Accounts (historical periods) at either a Mid-month Spot Rate (Assets & Liabilities) or a Mid-month Average Rate (Revenue & Expenses). 

We created the two Global Rate accounts, ICSPTRATE & ICAVGRATE (Intercompany Spot Rate & Intercompany Average Rate), and rates are populated in all the relevant currencies for the period.  We then created two 'Translation Override' rules and fix on just the appropriate accounts (one for Balance Sheet and one for Income Statement accounts). 

When we Consolidate and Translate the data something really strange is happening.  The Income Statement related Translation Override rule works as expected.  Those accounts defined in the rule use the ICAVGRATE instead of the default AVGRATE, which is correct.

Howdy, Stranger!

Log In

To view full details, sign in.


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