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!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
MIN(A,B) instead of CASE WHEN in saved search formula?
We keep hitting the character limit for SQL formulas in saved searches. It seems that the issue is often inefficiency of the formula, and often this is due to us wanting the keep only the minimum value from two or three separate expressions...
For example I want to simply write
MINIMUM(A,B)
Instead I end up writing
(CASE WHEN A<B THEN A ELSE B END)
Which is fine, except that A and B are not simply a single character variable, in one of the formulas I use the part that constitutes the above is shown below....
CASE WHEN (to_char({custbody_associatedcontract.custrecord_rencbd}, 'YYYYMM')*1)>(to_char({custbody_associatedcontract.custrecord_end}, 'YYYYMM')*1))) THEN (to_char({custbody_associatedcontract.custrecord_end}, 'YYYYMM')*1) ELSE ((to_char({custbody_associatedcontract.custrecord_smallerrendate}, 'YYYYMM'))