To apply consolidation or conversion from the SuiteAnalytics Workbook user interface, click the Field Menu icon next to an applicable field in the Data Grid or Layout Panel, then select Currency.
Depending on the field, you are presented with up to four options:
-
Display Original: displays each amount in the original currency used for the transaction.
-
Apply Consolidation: consolidates each amount to the currency of the lowest level subsidiary that is a common parent to all the subsidiaries that you have access to in your account. In SuiteAnalytics Workbook, the rate type used for the consolidation is based on the general rate type set up for each account in your chart of accounts: either Historical, Average, or Current.
Note:
You cannot apply currency consolidation to Total Amount (Transaction Currency)
values from the Data Grid, Pivot, or Chart tabs. To convert these values for
use in data aggregations, use the currency conversion options or define a
custom formula field. -
Apply Conversion: converts each amount using the currency and date selected on the Convert To window. By default, the Convert To window is set to the current date and the currency of the lowest level subsidiary that is a common parent to all the subsidiaries that you have access to in your account.
-
Conversion Options...: opens the Convert To window. In the Convert To window, you select the currency and date to use when the Apply Conversion option is selected. The rates used in the conversion are drawn from the table of currency exchange rates set up in your account.
Note:
If you check the Anchor Relative to Today box, the current date will be used
for the conversion each time the workbook is opened.
If you are in a NetSuite account with multiple currencies and your workbook contains fields with values in multiple currencies, you can apply currency consolidation or currency conversion to those fields. This is required for accurate data aggregations and other types of numeric manipulation for fields with values in multiple currencies. In SuiteAnalytics Workbook, currency consolidation enables you to convert the values of a field to the currency of the lowest level subsidiary that is a common parent to all the subsidiaries that you have access to in your account. Conversely, currency conversion enables you to convert the values of a field to any currency you have set up in your account.
To apply currency conversion to your workbooks, you must have the Multiple Currencies feature enabled in your account. To apply currency consolidation to your workbooks, you must be in a NetSuite OneWorld account. Additionally, you should make sure that your currency records, chart of accounts, currency exchange rates, and currency conversion rates are all set up correctly to ensure that the correct rates and accounting periods are used during conversion.
In SuiteAnalytics Workbook, you can apply consolidation or conversion to an applicable field directly from the user interface on the Data Grid, Pivot or Chart tabs. You can also create custom formula fields to apply consolidation to a specific field using the SuiteAnalytics Workbook formula builder. Additionally, you can apply consolidation when you create workbook filter conditions based on a field that contains values with multiple currencies