The Opal Creek team had a wonderful time at SuiteWorld this year. One of the good sessions I attended was entitled “Improve Capacity Planning with SuiteProjects Resource Management.” I picked it because I wanted to understand the difference and the relationship between Planned Time and Allocated Time in NetSuite. Turns out I wasn’t the only one – multiple audience members had the same question, and even after the presenters tag teamed the answer, there was still a lot of doubt in the room. I came away feeling like I needed to understand the two time types, how they work together, or don’t, and when to use which one. My findings are below.
Definitions
In the records browser, Time is Time. Actual Time, Planned Time, Allocated Time…it’s all just Time. There are differences in behavior, and in how the different time types show up in native Reports, but under the covers, it’s all Time records with different Type values. Actual Time is self-explanatory, so I’ll focus on the other two types here.
Planned Time is created using Project Task Assignments. It’s created whenever the “Create Planned Time Entries” preference is set for a Project and a project manager enters Planned Work on the assignment. This was explained in the session as the place where the Project Manager builds up a project time budget. Since Project Task Assignments can use Employee/Vendor Resources, Resource Groups, or Generic Resources, the task-level Planned Work (and therefore the related Planned Time entries) can be person-specific or not. NetSuite uses the Task Start Date and the Resource’s Work Calendar to create the time entries. When I enter an assignment for myself (default work calendar, 40 hours per week) on a test task, and the task has the same start and end date, NetSuite uses 8 hours a day and extends the task end date to account for the planned entries.
Allocated Time entries, by contrast, are created when Resource Allocations are entered. A resource manager allocates resources to projects. An allocation has a resource, a project, a start date, end date, and a number of hours or a percentage. For example, if I’m 50% allocated to a project over two weeks (and have the same default work calendar as above), the allocation will create ten 4-hour entries spanning those two weeks. The Oracle documentation indicates that allocations are for utilization and planning from a resource perspective.
So Why Both?
Allocated Time and Planned Time capture similar information. A Resource assigned a certain amount of time to a Project over a period. You need both if your organization has one group looking at resource booking – is everyone on the team the right amount of busy? – and another group managing projects – do I have enough people of the right types on the team to deliver this project on time and on budget?
Allocated Time is for resourcing managers to plan team utilization. It feeds the Resource Allocation Chart/Grid, a SuiteApp deployed in most agency NetSuite instances that lets you see who is booked to what, who is under- and over-booked, etc. Planned Time is for project managers to build up a project time budget for a given scope of work.
You can compare allocated to planned to actual time for a project, or you can compare it for an individual or team across all their projects. In my experience there’s a lot of push and pull on teams, and while these numbers should broadly track each other over time, you should not expect them to tie out.
How They Interact
Part of the reason I found it so hard to understand the difference is that NetSuite has the two features closely intertwined. Once Resource Allocations is turned on, you have to allocate a person to a Project before you can assign them to one of its Tasks. Unless you have the “Display All Resources for Project Task Assignment” preference on the Project, in which case it’s pretty much wide open. Going the other direction, the “Allow Allocated Resources to Enter Time to All Tasks” preference lets anyone allocated to the Project book time to any Task, assignment or not. NetSuite will add that not-planned time to the Task’s estimated work. When you enable Resource Allocations, NetSuite creates an allocation for every Task Assignment you already have.
The two types also compete to drive your numbers. On a Charge-Based Project, forecast Charges come from Planned Time unless you check “Use Allocated Time for Forecast,” in which case allocations drive the forecast instead. If you use the Planned Work feature, the Percent Complete Denominator accounting preference asks you to choose between Planned Time and Allocated Time, each with or without Actual Time added. Task-level labor budgets calculate from Planned Time. Project-level labor budgets can calculate from allocations, but they land in a “Labor: Other” bucket because an allocation doesn’t have a Service Item.
And they show up in different places. Only Planned Time can be imported to your weekly timesheet, but the timesheet can show Planned Hours and Allocated Hours. Reports are split too. Planned Utilization and Allocated Utilization are separate reports. The Project 360 Dashboard only uses Planned Time.
One, the Other, or Both?
If your project managers staff their own projects, you may not need Resource Allocations at all. Assign people to Tasks, leave “Create Planned Time Entries” checked, and let Planned Time drive the schedule, the forecast, and the budget. The risk is that nothing stops you from overbooking. NetSuite will let you assign 50 hours of Tasks to someone who works 20 hours a week without so much as a warning.
If you run on bookings and keep your task plans thin, go the other way. You can allocate a person straight to a Task, which skips the assignment step and still lets them enter time there. Point the forecast and the percent complete denominator at Allocated Time. What you give up is everything around Planned Time: Project 360, the timesheet import, and the ability to calculate Task-level budgets.
If resourcing and project management are separate jobs done by separate people, use both. Allocate at the Project level and assign at the Task level. Oracle warns not to mix Task-level allocations and Task Assignments on the same Project, because of a risk of unspecified (but dreaded) data inconsistency.
Making It Easier to Live With
Start with your Project Templates. The template has the “Create Planned Time Entries” and “Use Allocated Time for Forecast” boxes. More on Project Templates here. Add the Planned Hours and Allocated Hours fields to your timesheet form. And choose your percent complete denominator carefully; changing it later recalculates every open project plan.
Next, build one view that shows all three types. Because it’s all Time, a saved search or a customized Time by Employee report can put Planned, Allocated, and Actual hours side by side, by person and by week. For the resourcing view, the native Allocated vs. Actual Hours by Resource report is a good start.
If that still isn’t enough, script it. The Resource Allocation record is scriptable, so you can enforce your own rules, like blocking a save that puts someone over 100% for a day.
Final Thought
Planned Time and Allocated Time are intended to answer two different questions. Planned Time describes the effort to do the work. Allocated Time says who’s reserved to do it. Let the way you staff decide which you use. If one person does both jobs, pick one type and ignore the other. If two groups do, use both, agree on which one drives the forecast, and put that choice in your templates.
Sources
01. Oracle, Time record (SuiteScript Records Browser) — https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_1/script/record/timebill.html
02. Oracle, Planned Utilization by Resource — https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_3748784072.html
03. Oracle, Planned Work — https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_1530301667.html
04. Oracle, Scheduling Project Tasks — https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N1199494.html
05. Oracle, Assigning Project Resources — https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N1189140.html
06. Oracle, Assigning Resources to Project Tasks — https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N1200642.html
07. Oracle, Creating Resource Groups — https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_1547067026.html
08. Oracle, Generic Resources — https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_3897338492.html
09. Oracle, Resource Allocations — https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/chapter_3746701142.html
10. Oracle, Creating a Resource Allocation Record — https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_3746899469.html
11. Oracle, Setting Up and Navigating the Resource Allocation Grid — https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4168477255.html
12. Oracle, Allocated vs. Actual Hours by Resource Report — https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4225707452.html
13. Oracle, Setting Up Project Record Preferences — https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4585905289.html
14. Oracle, Understanding Charge Rules — https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_3752833778.html
15. Oracle, Project Budgeting — https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_3751156348.html
16. Oracle, Weekly Timesheets — https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4671374137.html
17. Oracle, Weekly Timesheet record — https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/article_6102743586.html
18. Sikich, 2019.1 weekly timesheet fields — https://www.sikich.com/?p=87128
19. Oracle, Project 360 Dashboard Limitations and Best Practices — https://docs.cloud.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_164252378090.html
20. Oracle, Creating Project Templates — https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_3897375531.html
21. Oracle, Resource Allocation record (SuiteScript) — https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_3733846138.html
22. Oracle NetSuite Community, Projects – Employee center, Planned time and Allocated time — https://community.oracle.com/netsuite/english/discussion/4473974/projects-employee-center-planned-time-and-allocated-time
23. Oracle NetSuite Community, comments by Pixel_NS — https://community.oracle.com/Netsuite/english/profile/comments/Pixel_NS?page=p2
24. Oracle NetSuite Community, comments by jjns — https://community.oracle.com/netsuite/english/profile/comments/jjns?page=p8

