Thursday, July 11, 2019

Multiple Languages Formula

NetSuite is multi-lingual ready. When the Language is changed, user can still use the standard Saved Searches and Custom Saved Searches without Formulas. Once the Formulas are used, there is a limitation that needs to be kept in mind.

Example:
When user builds a Saved Search in English and uses the Formula:
case when {status} = 'Open' then 1 else 0 end 

User gets the expected results when using NetSuite in English. However, user gets no data when using the Saved Search in French.

Indeed, user gets expected results when using NetSuite in French while using the Formula with French strings:
case when {status} = 'Ouvrir' then 1 else 0 end

To avoid creating of Saved Search for each language used, the Formula can include both languages:
case when {status} = 'Open' then 1 when {status} = 'Ouvrir' then 1 else 0 end

No comments:

Post a Comment