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!
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