Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Data Source - Input Currency Journals reverse translation — 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

Data Source - Input Currency Journals reverse translation

Question
8
Views
0
Comments
edited May 20, 2021 10:14AM in Financial Consolidation and Close

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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