ANS-0090 · SAVED SEARCHES & FORMULAS
How to View and Export Account Currency in NetSuite’s Chart of Accounts
While direct sourcing of account currency in NetSuite saved searches is not supported, this information can be accessed and exported from the Chart of Accounts list view.
Short answer
The currency column for accounts is accessible within the Chart of Accounts list view (Setup > Accounting > Chart of Accounts). Although this list view cannot be customized, exporting it will include the currency column, providing the necessary data for analysis outside of saved searches.
Scenario
Users often seek to include the currency associated with an account in NetSuite saved searches. However, the currency column is not directly available for sourcing within an "account" saved search, leading to challenges in reporting and data extraction.
Solution
To access the currency information for accounts, navigate to the Chart of Accounts list view by following the path: "Setup > Accounting > Chart of Accounts". The currency column is readily available in this view. Although the Chart of Accounts list view cannot be customized, exporting this list will include the "currency" column, allowing users to obtain the required data.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support