Currencies and Currency Types for Balances Cubes

A currency type is a GL balances cube dimension that you can use in reports and analyses, such as Financial Reports, Smart View queries, and also in Account Inspector, and on the Inquire on Detail Balances page.

The Currency Type dimension has these members:

Total

Select the Total currency type to view cumulative ledger currency balances.

To view summarized balances entered in the ledger currency, along with any balances entered in a foreign currency that were converted to that ledger currency for a primary ledger, secondary ledger, journal-level reporting currency, or subledger-level reporting currency, set the following dimensions:

• Ledger: Select either the primary or secondary ledger, or the journal-level or subledger-level reporting currency.

• Currency: Select the ledger currency.

• Currency Type: Select Total.

To view translated balances for a primary or secondary ledger in a balance-level reporting currency, set the following dimensions:

• Ledger: Because balance-level reporting currencies aren't ledgers themselves, select the primary or secondary ledger for the reporting currency.

• Currency: Select the translation currency, which is the same as the currency of the balance-level reporting currency.

• Currency Type: Select Total.

Entered

Select the Entered currency type to view balances that were entered in a specific currency. You can select this currency type for any primary or secondary ledger, or any journal-level or subledger-level reporting currency.

For example, the Vision Corporation ledger has a ledger currency of USD. To view balances that were entered in JPY, set the following dimensions:

• Ledger: Vision Corporation

• Currency: JPY

• Currency Type: Entered

Converted From

To view balances that were converted from an entered currency to the ledger currency, select the currency type that begins with From followed by the currency with the balances you want to view.

For example, the Vision Corporation ledger has a ledger currency of USD. To view balances that were entered in JPY and converted to USD, set the following dimensions:

• Ledger: Vision Corporation

• Currency: USD

• Currency Type: From JPY

Converted All

Use the Converted All currency type along with the Entered currency type in your reports to view entered balances and their equivalent converted balances side by side.

Here's an example of a Smart View analysis with a side by side comparison. The ledger currency is USD. Each row shows a currency followed by its entered and converted balances for the March 2020 accounting period. The third column uses the Total currency type and shows the cumulative balance in USD.

You can use this currency type for any primary or secondary ledger or any journal-level or subledger-level reporting currency. You can also select this currency type for a ledger set, provided the ledgers in the set have the same ledger currency.