Project

Use the project record to manage company initiatives.

To use the project record, you must have the Projects feature enabled at Setup > Company > Enable Features, on the Company tab. If you plan to do advanced project tracking, you must also enable Project Management. If you do not see the Project Management box, your company must first purchase the Project Management add-on from NetSuite.

To access the project record in the UI, choose Lists > Relationships > Projects(or Jobs).

For help working with this record in the user interface, see Projects.

The internal ID for this record is job.

See the SuiteScript Records Browser for all internal IDs associated with this record.

Note:

For information about using the SuiteScript Records Browser, see Working with the SuiteScript Records Browser in the NetSuite Help Center.

For information about scripting with this record in SuiteScript, see the following:

Supported Script Types

The project record is scriptable in both client and server SuiteScript.

Supported Functions

The project record is fully scriptable — it can be created, updated, copied, deleted, and searched using SuiteScript. It can also be transformed.

Field Definitions

Note that the datecreated body field is a system-generated field that marks the date the record was created in NetSuite. You cannot change or override this field. If you need to capture “date created” information that is not related to the date the record was created in NetSuite, create a custom field and set it to auto-default to today's date.

For more details on available fields, see the SuiteScript Records Browser, which lists all internal IDs associated with this record. For information about using the SuiteScript Records Browser, see Working with the SuiteScript Records Browser in the NetSuite Help Center.

Usage Notes

The Time Tracking sublist is included with the project (job) record. It is an inline editor sublist.

Important:

If any case, task, or event record has more than 9500 time entries in the Time Tracking sublist, all cases include a static list of time entries. These static lists are not accessible to scripting. Attempts to script on Time Tracking sublists that are static lists of time entries will not return accurate results.

Adding a Resource With Multiple Roles

When using SuiteScript, the behavior of the Resources sublist differs slightly from the behavior in the UI. Specifically, in the UI, each line must have a unique value in the Name field. Further, in the UI, you can specify more than one role for each resource.

The Resource Details tab showing three roles.

With SuiteScript, if you want to add a resource that has two different roles, you set up your code as if you are adding two sublist records for that resource -- one for each role. The jobresource values are not required to be unique. The following example illustrates this technique. In this example, only two unique resources are being added, but because one resource has two roles, that resource is represented twice.

          proj = record.create({
    type: record.Type.JOB
});
proj.setValue({
    fieldId: 'companyname',
    value: 'Launch'
}); 
proj.setValue({
    fieldId: 'subsidiary',
    value: '1'
}); 
proj.selectNewLine({
    sublistId: 'jobresources'
}); 
proj.setCurrentSublistText({
    sublistId: 'jobresources',
    fieldId: 'jobresource',
    text: 'Employee Resource 1'
}); 
proj.setCurrentSublistText({
    sublistId: 'jobresources',
    fieldId: 'role',
    text: 'Staff'
}); 
proj.commitLine({
    sublistId: 'jobresources'
}); 

proj.selectNewLine({
    sublistId: 'jobresources'
}); 
proj.setCurrentSublistText({
    sublistId: 'jobresources',
    fieldId: 'jobresource',
    text: 'Employee Resource 1'
}); 
proj.setCurrentSublistText({
    sublistId: 'jobresources',
    fieldId: 'role',
    text: 'Project Manager'
}); 
proj.commitLine({
    sublistId: 'jobresources'
}); 

var id = proj.save(); 
var savedProj = recordload ({
    type: record.Type.JOB,
    id: id
});
savedProj.selectLine({
    sublistId: 'jobresources',
    line: '1'
}); 
savedProj.setCurrentSublistText({
    sublistId: 'jobresources',
    fieldId: 'jobresource',
    text: 'Employee Resource 2'
}); 
savedProj.commitLine({
    sublistId: 'jobresources'
}); 
savedProj.save();

Note that after you complete the add operation, the Resources sublist in the UI looks the same as it would if you had manually added one line for the resource, with multiple roles specified on that line, as shown in the illustration above.

Scripting Projects with Advanced Revenue Management

The following table lists the scriptable fields associated with the Project record and advanced revenue management.

Field

Type

Internal ID

Accounting Period

List/Record

accountingperiod

Comments

Text Area

comments

Percentage Complete

Percent

percent

Before you begin working with advanced revenue management programmatically, see Setup for Advanced Revenue Management (Essentials).

For help working with this record in the user interface, see Advanced Revenue Management (Essentials) for Projects.

Supported Script Types

Supported Functions

Field Definitions

Usage Notes

Adding a Resource With Multiple Roles

Scripting Projects with Advanced Revenue Management

Related Topics