Discussions
SuiteWorld is the largest annual gathering of the NetSuite community! It will be held in Las Vegas on October 6-9, 2025. Our customers and partners look forward to SuiteWorld every year as a place to hear the latest from NetSuite, get hands-on learning, and connect with each other. Register now!
NSC | How to create a Saved Search for Project Tasks with higher Actual hours than Planned
Scenario:
User wants to create a Saved Search for Project Tasks with higher actual hours than planned in which helps them identify potential project budget overheads. This will allow them to make timely adjustments to resource allocation and timelines, ensuring such tasks to stay on track and within budget.
Solution
Note: User is using Planned Work, this field is not adjusted when work is tracked outside the original fixed plan.
1.) Navigate to Reports>List > Search > Saved Searches > New
2.) Select Project Task
3.) Under Criteria, select Formula (Numeric) and add the formula:
Formula: {actualwork}-{plannedwork}
Formula (Numeric): greater than
Value: 0
4.) In the Results tab, in addition to the existing and desired fields, user can add the following field which represents the difference between the Actual work (hours) and Planned Time: