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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
how to create a Project profitability saved search
l projects that have a Scheduled End Date > 7 days ago
AND the (parent) Project (and any of its sub projects ) have aggregate costs >£0
AND the (parent) Project has no Revenue
AND the (parent) Project status is "in progress"
Output to list:
Job ID
Job Name
Customer
Department
Location
Schedule end date
Actual work (hours)
Cost (from Subtab P&L, cost being the total of all item groups)
*only include projects where the PROJECT EXPENSE TYPE = “Chargeable Project”, all other projects are expensed so will never have any revenue
* exclude sub-projects (all revenue is at the parent project level so by definition these will never have revenue against them)
0