Translation Overrides for Balance Sheet Accounts Not Working
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.