ANS-0008 · SAVED SEARCHES & FORMULAS
How to Ensure Consistent NetSuite Saved Search Results Across Languages
NetSuite saved searches using CASE WHEN formulas can produce varying results when executed by users with different language preferences.
Short answer
NetSuite saved searches using CASE WHEN statements with language-specific criteria will yield different results based on the user's language setting. To resolve this, modify the formula to include all relevant translated values for list-type fields using an OR condition, ensuring consistent results across all supported languages.
Scenario
Users running NetSuite saved searches or viewing sublists may observe different results when their language setting is changed, for example, between English and French. This discrepancy occurs because criteria within CASE WHEN statements in formulas are language-specific. Consequently, a search condition looking for a value like 'Income' will fail to find its French equivalent, 'Bénéfice', leading to incomplete or missing data.
Solution
To avoid discrepancies caused by language-specific criteria in NetSuite saved searches, modify the CASE WHEN formula to include all relevant translated values for list-type fields. This ensures the search correctly identifies values regardless of the user's language setting. For instance, consider the following examples: An English-only formula might appear as:
CASE WHEN {accounttype} = 'Cost of Goods Sold' THEN {amount} ELSE 0 ENDTo support both English and French, the formula should be updated to include the translated term using an OR condition:
CASE WHEN {accounttype} = 'Cost of Goods Sold' OR {accounttype} = 'Coût des marchandises vendues' THEN {amount} ELSE 0 ENDExpert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support