Data Source - Input Currency Journals reverse translation
Hi, We have captured some adjustments using Journal Input-USD member of Data source dimension specifically created to capture Journals in USD currency and back translate them to entity currency after executing consolidation process.
It seems system is using Ending Rate only irrespective of type of account e.g. Balance Sheet or Income Statement to reverse translate in Entity Currency. For Example,
Cost of Materials Debit. $100
Accounts Payable Credit. $100
( Exchange Rate to USD are Ending Rate = 0.75, Average Rate = 0.80)
Once we run consolidation and see translated number in Entity currency, we can see both accounts are translated using Ending Rate 0.75 only. Should this be translated using Average Rate for income/expense account? Any additional configuration required to enable it?