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.
How to write a Formula for a Saved Search Column that returns value only on certain conditions?
Hi Guys,
I have created a saved search for transaction type: PO.
Below in the screenshots you will find the criteria's, results and the report output.
Since creating searches based on system notes is a tricky business, I am curious as to if it would be possible to a separate column date for each of the fields I am trying to track. I have tried doing this with a case formula for date, but no luck, any other ideas or maybe something in the formula I a missing that this could be done? Thank you.
BTW, the results are working as expected but all the dates are funneled into one column, I would like to have one column for, each of the fields: PO Sent for Approval, Sent to Vendor, Document Status