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.
Formula for 'within' quarter for condition to be set
I would like to be able to set a condition to make a field mandatory (or not) by using a combination of two field values. I want to set a specific field to be mandatory if the status of the opportunity is A-C AND if the expected close date is within this quarter.
Condition used:
{opportunitystatus.id} in (1,2,3) and to_char({expectedclosedate}, 'Q')=to_char({today}, 'Q')
After field sourcing triggering client fields:
opportunity status and expected close date
Result:
Nothing happened except the system locked me out of editing my opportunities. I could click the edit button, but my drop down of statuses would not open up and if i set a new expected close date it would let me set it but not let me move off of it. Also, I couldn't navigate to the proper subtab where the field i was trying to set as mandatory was located.