Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
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.