This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hey all, can anyone lead me in the right direction to build a saved search to show items that haven't had their pricing changed in the last 30 days? I have an item search set up, but within the description fields of the filters, I am not sure how/where to show the 'today-30'.  ChatGPT is letting me down :rolling_on_the_floor_laughing:

maybe a system notes join. then specify the field and date range.

Thanks Nathan! I've never used System Notes! I'm going to give this a shot and report back. Looks relatively straightforward

Here's where I"m stumbling. When I get into the dates 'description", I can choose 'Not on or after', but can't seem to type anywhere 30 days ago or today-30. There's three cells. One allows me to choose the 'not on or after, the next one has "All' defaulting as an option, and the third has the little calendar next to it. I wish there was an uber-beginners thread. I apologize!

No worries! Here's what i did step by step:
System Notes Fields...
Date
Not on or after
(relative)
30 days ago

Yes this works! I now have a better understand of System Notes - this is super helpful. Thank you again!