Project Management Records

With Project Management, you can use project records to track everything about your projects from start to finish.

By setting up data for each project in an organized manner, you can maintain and access information when you need it, as well as use the data to update schedules and generate transactions or reports that help you track your project's progress.

When you maintain accurate information for each project record, you are better able to accomplish goals not only for the one project, but for all company projects. Since you often have to split limited resources across projects, having up-to-date information makes it easier to balance margins and risks.

Important:

You should break up long, multi-year projects into smaller parts to improve performance when working with project records.

Project Scheduling Methods

When you first create a project record, even if you don’t have all the details yet, you can enter the project name, status, and perhaps the start and end dates. As the project moves forward, the record becomes your workspace where you can manage details.

As you begin planning your project, you must decide the best method to create your project schedule. NetSuite offers two methods for project scheduling, forward and backward.

Important:

The Planned Work feature is required for backward project scheduling. For more information, see Planned Work.

Forward scheduling lets you define a start date for your project and schedule tasks from there. NetSuite uses the start date, task order, durations, and lag time to calculate an estimated end date for your project. Forward planning works best when you know exactly when your project needs to start.

Backward scheduling lets you define an end date for your project and schedule tasks backward based on the end date. NetSuite uses the end date, task order, durations, and lag time to calculate an estimated start date for your project. Backward planning works best when you have a hard deadline for finishing your project.

As data is available, you can also do the following on the project record to define and refine the project:

Schedule subtab

On the schedule subtab of project records, you can identify and schedule necessary work tasks. After tasks are created, you can see various basic or customizable views of the tasks, also known as a project plan. A Gantt Chart view is also available. The project plan helps you plan, manage, and run your project schedule. For more information, see Working with the Project Schedule.

Note:

The Schedule subtab only appears after you save a project record. It lists project tasks in the same order as the project plan, and you can’t sort or reorder tasks from the Schedule subtab.

Resources subtab

On the Resources subtab, you can assign the resources needed to complete project tasks and designate their role on the project. You can select multiple roles for a single resource. To price and schedule resources, you need to select resources on specific task records. Read Assigning Project Resources.

If you use Resource Allocations, you must first allocate resources to your project before they can be assigned to tasks. For more information, see Resource Allocations.

Financial subtab

On the Financial subtab, you can define the project billing behavior by selecting a billing type and billing schedule, if you use Advanced Billing. The Financial subtab provides labor data for estimated, actual, and remaining work, as well as the percent of the project completed based on labor hours. You’ll also see estimated costs, revenue, and profits.

Preferences subtab

On the Preferences subtab, choose settings for time and expense preferences related to the project. You can let anyone enter time or limit time entry to assigned resources only. Classify project time entries as utilized, productive or exempt to customize utilization calculations. You can also choose to allow expense entries and to create planned time entries. If you use NetSuite OneWorld, you can select a subsidiary for the project. For more information, see Working with Project Management in OneWorld.

Related Records subtab

The Related Records subtab contains most of the same basic information found on Related Records subtabs on records throughout NetSuite, such as information about contacts and partners.

Communication subtab

The Communication subtab is where you can attach and send messages and schedule phone calls. You can also link projects with opportunities so that project items can be included in estimates and sales orders and billed along with other sales items.

The following workflow is the best practice for incorporating projects into the sales process.

Note:

This specific workflow is possible only if you don't enable the Consolidate Projects on Sales Transactions preference. For more information, read Using the Project Consolidation Preference.

Best Practice: Incorporate the Project Record into your Sales Process

  1. Create an opportunity for a prospect.

    On the Items subtab of the opportunity form, add all non-project items. This is any items except service items. Project items, or service items, are derived from the project record.

    If you’d rather, you can wait to add non-project items on the estimate.

    For more information, see Opportunity Records.

  2. Set up the project by creating a project record.

    From within the project record, add and manage service items related to the opportunity, create project tasks, and define the billing type.

    For more information, read Creating a Project Record.

  3. Link the project to the opportunity.

    After you create a project record, you can link the opportunity record to the project by selecting the project on the opportunity.

    When you connect a project to an opportunity, the project items automatically source into the transaction rows of the opportunity record. These rows can't be edited on the opportunity but you can remove them. To make changes, update the project record first, then reopen the opportunity to refresh the items. Read Refreshing Project Items on Transactions.

    For information, read Linking a Project to an Opportunity.

  4. Generate one or more estimates from the opportunity.

    An estimate created from a linked opportunity merges the non-inventory and other items with the service items for the project.

    Note:

    If you create an estimate from the project record, it only includes service items from the project.

    For more information, read Generating an Estimate from a Project.

  5. Create a sales order from a project estimate.

Related Topics:

General Notices