Currency in Datasets and Workbooks

If you are in a NetSuite account with transactions in multiple currencies, or a NetSuite Oneworld account with multiple subsidiaries, amount fields in your datasets and workbooks might display data in multiple currencies. To perform arithmetic operations and view totals for these fields, you must consolidate or convert the field values to a single currency. This is particularly important if you are working with the transaction, transaction line, or transaction accounting line record types.

• In transaction accounting line, monetary values in amount fields are stored in the base currency of the subsidiary assigned to the transaction. The amount fields in this record type can only be consolidated and are typically used for accounting purposes, such as calculating financial results for your entire company, including all subsidiaries. In Workbook, currency consolidation consolidates 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. This is identical to how currency consolidation behaves in NetSuite saved searches and reports. By default, when you include amount fields from the transaction accounting line record type in workbook table views, pivot tables, and charts, currency consolidation is enabled.

• In transaction and transaction line, monetary values in amount fields are stored in the currency of the transaction. These values can only be converted and are typically used for operational use cases, such as analyzing total sales of a specific item. Currency conversion is an additional tool available in Workbook, which enables you to translate the values of a field from one currency to another currency that you have set up in your account.

You can apply currency consolidation or conversion to applicable fields directly from the user interface in any workbook visualization. To consolidate or convert field values in a dataset, you must use a custom formula field.

For more information about amount fields in each transaction record type, see the video Transaction Data Model in 2020.1.

For more information about currency consolidation and conversion in Workbook, see the following topics:

• Currency Consolidation in Workbook

• Currency Conversion in Workbook

Related Topics

• Custom Workbooks and Datasets
• Defining a Dataset
• Linking Datasets
• Dataset Criteria Filters
• Creating a Workbook

General Notices