Currency in Datasets and Workbooks
If you're in a NetSuite account with transactions in different currencies, or a NetSuite OneWorld account with multiple subsidiaries, amount fields in your datasets and workbooks might show data in multiple currencies. To do math or see totals for these fields, you'll need to consolidate or convert the values to a single currency. This is especially important if you're working with transaction, transaction line, or transaction accounting line record types.
-
In transaction accounting lines, amount fields store monetary values in the base currency of the subsidiary assigned to the transaction. The amount fields in this record type can only be consolidated, and are usually for accounting purposes, like tracking financial results for your whole company and all subsidiaries. In Workbook, currency consolidation converts a field’s values to the currency of the lowest-level subsidiary that's a common parent to all subsidiaries you have access to. This works the same way as currency consolidation in NetSuite saved searches and reports. By default, if you use amount fields from the transaction accounting line record type in workbook table views, pivot tables, or charts, currency consolidation is enabled.
-
In transaction and transaction line records, amount fields store monetary values in the transaction currency. These values can only be converted, and they're usually for operational purposes, like analyzing total sales for a specific item. Currency conversion is another Workbook tool that lets you translate a field's values from one currency to another in your account.
You can apply currency consolidation or conversion to applicable fields right from the user interface in any workbook visualization. To consolidate or convert field values in a dataset, you'll need to 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: