We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Data Source - Input Currency Journals reverse translation

Question
13
Views
0
Comments

Content

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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