Good morning!
We've been using ASSIGNMENTS for the past couple years on projects. The benefit being that Assigned Hours on a Project Task appear to be the only way to let NetSuite derive estimated/calculated End Dates.
Ex: Resource with a 40hr/wk work calendar, assigned 80 hours of work on a task, at 50%. NetSuite will calculate 4-weeks to do that work. Assuming a Start Date of 2/1/2021, NetSuite would project the end date at 2/26/2021. Importantly, the Project Task dates get updated with this information, as does the overall Project end date.
The two big drawbacks we have with ASSIGNMENTS are:
- If a user starts the work for 2 weeks, gets pulled onto another priority for 2 weeks, then comes back to finish the work: Planned time ended on the 26th, but there's really 2 weeks of hours left to be completed. Planned Utilization reports and Project Charges Forecasts are off with regard to the dates.
- Some Resources are assigned a small number of oversight hours to a task, over a long period of time. Assigned resources can't be assigned at less than 5%. So if there are 10 PM hours over a 10 week task, an Assigned resource can be assigned no less than 2 hrs per week (5% of 40 hrs), and will appear to have no utilization (and no time-based charges forecast) in the second 5 week period).
ALLOCATIONS seem to be a solution to this --
- A resource can be allocated multiple times to a Project Task, allowing for "start / stop" work to accurately flow through to Forecasted Charges and Allocated Utilization Reports, and
- A resource can be allocated at less than 5% of their time, allowing for the small/even spread described above.
HOWEVER, if we use Resource Allocations at the Project and Project Task level, there doesn't seem to be any way to have the Dates work for the Project Plans. We could Allocate to the project, and then Assign to the Project Task, but that would put us back in the same position /have the same big drawbacks as discussed above.
Are we just missing something really obvious here? Or is there really no way to have Resource Allocation dates drive Project Plan dates?
Thanks!