Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
NSC | Resolve Error when using NS_CONCAT within CASE Formula
Scenario:
A user is attempting to utilize the NS_CONCAT function within a CASE statement to retrieve and concatenate all Sales Orders associated per Project. The formula used is CASE WHEN {transaction.type} = 'Sales Order' THEN NS_CONCAT({transaction.number}) END
and this results to an error when the search is ran.
The Issue:
The problem lies in the placement of the NS_CONCAT function within the CASE statement. This arrangement is syntactically incorrect and leads to the encountered error.
Solution:
To resolve this issue, the formula requires a slight adjustment. Instead of nesting NS_CONCAT within the CASE statement, the
Learn how to Refer A Member | Earn the Answer Accepter Badge | Be the Content Creator of the Quarter | Vote for the content you want to see!