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.
Creating a Formula in Price Update Saved Search
Hello,
I am trying to create a formula in my NetSuite saved search but I am not too comfortable with creating formulas, can anyone assist?
Scenario: Price Update Search
I would like to have the lines highlighted for this scenario,
If customer has multiple end date for the same Item highlight the row(s)/line(s)
Customer field - custrecord_edp_update_customer
End Date field - custrecord_edp_update_end_date
In the picture above I show that there is a Item setup for a price update and although the start dates are not the same the end dates are which is causing an issue. I do not believe the system should have allowed the price update in December to be created as the one that started in September is still active but nonetheless I would like to see if I can get a formula to highlight these rows when this issue occurrs.