ANS-0082 · SAVED SEARCHES & FORMULAS
How to Display Item Prices in Non-Base Currencies in NetSuite Saved Searches?
Understand why NetSuite transactions default to base currency and how to adjust Saved Search results for accurate foreign currency display.
Short answer
To display item prices in a currency other than the base currency in a NetSuite Saved Search, modify the search to calculate the item rate divided by the transaction's exchange rate. NetSuite posts all transactions in the base currency, so this calculation ensures correct foreign currency representation.
Scenario
Users may observe that transactions originally recorded in a foreign currency, such as USD, appear in the NetSuite base currency (e.g., JPY) within a Saved Search. This occurs because NetSuite processes and stores all transaction amounts in the system's designated base currency.
Solution
To ensure a NetSuite Saved Search displays transaction results in the original foreign currency rather than the base currency, the Saved Search must be modified. This involves performing a calculation within the search criteria. The correct approach is to divide the item rate by the transaction's exchange rate. The exchange rate is automatically stored with each transaction, making it accessible for accurate calculations within Saved Searches. The formula to use is: item rate / exchange rate.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support