Now we have 2 primary ledgers, ledger 1 with ledger currency as HKD, Ledger 2 with ledger currency as SGD.
Now we have setup 2 reporting currency in USD for the 2 ledgers respectively.
We are trying to create an OTBI with subject area using general ledger - transactional balances real time, but we cannot find the reporting currency in the report.
Is there any way we can extract the balance in the reporting currency?
Hi User_X2EYT ,
Login to reports and analytics and go to My Account>Preferences
change currency to 'Ledger Currency' or 'Entered Currency' and test it
Regards,
Ravi
Hi,
Please find the uses of different options is BI :
The analytics currency settings determine the currency type that's displayed in all your analytics. It also determines how and when your currency conversion rates are calculated.
This shows the currency display options for users:
Currency Display Type
Description
Entered Currency
Currency used on a transaction.
<Application> Currency
Currency set up in each respective Cloud application as the common Corporate currency used company-wide.
User Preferred Currency using Simple Currency Management
Conversion to User Preferred Currency is performed at the time your run the report, and is calculated from the Corporate currency based on the last time the record was updated and saved or closed.
User Preferred Currency using Advanced Currency Management
Conversion to User Preferred Currency happens on the date your run the report, and uses the currency indicated on the record.
Hope this helps.
Thanks,
Dimple N
Thanks for the solution. However, I doubt it will be a little bit different from the expected result from user.
As we have already setup the reporting currency, such reporting currency is already using a specific currency rate for the balance translation. Is there any way I can extract the result from that translated table? Or which subject area I should look for?
