Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
NSC | Show Aging Estimates in a Saved Search
The user wants to create an Estimate saved search that is aged from the estimate's entry date in the following number of days:
- 1-30 days from entry date
- 31-60 days from entry date
- 61-90 days from entry date
- 90+ days from entry date
To create the search, see the steps below.
- Navigate to List > Search > Saved Searches > New
- Select Transactions
- In Criteria tab > Standard subtab
- Filter:
- Main Line: is True
- Type = Estimate
- Main Line: is True
- Filter:
- In Results tab > Add Formula (Numeric) fields for the following:
- Number of Days Open
- ROUND({today} - {datecreated},0)
- 0-30 days
- CASE WHEN (ROUND({today} - {datecreated})) >= 0 AND (ROUND({today} - {datecreated})) <= 30 THEN 1 ELSE 0 END
- Number of Days Open
🌟Q1 2026 Community Choice Nominations: Recognize a member who made a difference in our community!
🏆️ Earn Community badges for Refer a Member | Answer Accepter | Content Creator
_______________________________________________________________________________
Michelle Jabanes | NetSuite Support Community Administrator
Tagged:
0