| Name | Type | Cardinality | Label | Required | Help |
|---|
| accountNumber |
string |
0..1 |
Account |
F |
If you assign account numbers for projects, enter the account number here. |
| actualTime |
Duration |
0..1 |
Actual Time |
F |
Indicates the actual time entered for the project, including open, pending approval, approved, unapproved, and rejected time transactions. This total includes time transactions entered against project tasks and the project as a whole without a specified task.
If this project is set to include CRM tasks in project totals, then Actual Work also includes time entered for CRM tasks associated with this project. |
| addressbookList |
JobAddressbookList |
0..1 |
|
|
|
| allocatePayrollExpenses |
boolean |
0..1 |
Allocate Payroll Expenses |
F |
|
| allowAllResourcesForTasks |
boolean |
0..1 |
Display All Resources for Project Task Assignment |
F |
Check this box to allow any employee or vendor designated as a project resource on the entity record or any employee or vendor that has previously been assigned to a project to be assigned to a project task.
When you enable this preference, any resource that has been previously assigned to a project appears in the list of available resources. This allows for the possibility that an employee or vendor no longer designated as a project resource can still be assigned to a new project task.
Clear the box if you want to restrict project task assignment to resources you add to the Resources subtab.
If you use Resource Allocations, enabling this preference overrides the need to allocate resources prior to making task assignments. Disabling this preference requires you to allocate defined resources prior to making task assignments. Generic resources are available for task assignments regardless of project allocation. |
| allowExpenses |
boolean |
0..1 |
Allow Expenses |
F |
Check this box to allow expenses to be entered for this project.
If the Limit Time Entry to Assignees field is also checked, then only resources listed on the Resource subtab will be able to see this project in the Customer/Project select list for Expense Reporting. |
| allowTime |
boolean |
0..1 |
Allow Time Entry |
F |
Check this box to enable time to be entered for this project.
If the Limit Time Entry to Assignees field is checked, the project appears only in the Customer/Project dropdown for resources listed on the Resource tab of the project. |
| altName |
string |
0..1 |
|
|
When using Auto-Generated Numbers for projects, the project number assigned to this project is displayed in this field. |
| altPhone |
string |
0..1 |
Alt. Phone |
F |
|
| applyProjectExpenseTypeToAll |
boolean |
0..1 |
Apply to all time entries |
F |
Check this box to apply the selected project expense type to all time entries for this project. This preference overrides any other project expense type for time transactions recorded for this project. |
| billingSchedule |
RecordRef |
0..1 |
Billing Schedule |
F |
A billing schedule determines when and how to bill a customer over the duration of the project.
Billing schedules for Fixed Bid, Interval and Time and Materials projects are public schedules and can be shared across projects. A Fixed Bid, Milestone billing schedule is private and used only for the project it is created for. |
| billPay |
boolean |
0..1 |
Enable Online Bill Pay |
F |
|
| calculatedEndDate |
dateTime |
0..1 |
Estimated End Date |
F |
NetSuite calculates the end date for the project as the date that all project tasks will be complete according to the current project schedule.
Calculated End Date changes as the project schedule changes. |
| calculatedEndDateBaseline |
dateTime |
0..1 |
Estimated End Date Baseline 1 |
F |
The Calculated End Date when the baseline was set. |
| category |
RecordRef |
0..1 |
Category |
F |
Select the category that applies to this customer.
To add choices to this list, go to <_TABNAME=EDIT_ACCOUNTINGOTHERLIST_> > <_TASKCATEGORY= ACCOUNTINGOTHERLIST _> > New > Customer Category.
For example, you might create categories of wholesale, retail, and online. |
| comments |
string |
0..1 |
Comments |
F |
Enter other information about this project. |
| companyName |
string |
0..1 |
Job Name |
F |
Enter a unique project name.
If you use Auto-Generated Numbering, it is important to enter the project name here because the Project ID does not include the project name. |
| creditCardsList |
JobCreditCardsList |
0..1 |
|
|
|
| currency |
RecordRef |
0..1 |
Currency |
F |
The customer's currency is shown here. This is the currency used for all transactions and records created for this project.
If you use the Multi-Currency Customers feature, select the customer's transaction currency you want to use for this project and its associated records and transactions. |
| customFieldList |
CustomFieldList |
0..1 |
|
|
|
| customForm |
RecordRef |
0..1 |
Custom Form |
F |
Select the form you want to use to enter this record.
Select Standard Project Form to continue using this form, select a custom project form you have already created, or select New to create a custom project form. |
| dateCreated |
dateTime |
0..1 |
Date Created |
F |
Indicates the date the project was created. |
| defaultAddress |
string |
0..1 |
Address |
F |
|
| email |
string |
0..1 |
|
|
|
| emailPreference |
EmailPreference |
0..1 |
Type |
F |
|
| endDate |
dateTime |
0..1 |
End Date |
F |
Enter the date the project is finished. |
| entityId |
string |
0..1 |
|
|
NetSuite copies the Project Name as the Project ID.
If you want to manually enter a Project ID, clear the Auto check box next to the field and enter the ID.
If you use Auto-Generated Numbering, then NetSuite creates this ID automatically based on your settings at <_TABNAME=ADMI_NUMBERING_> > <_TASKCATEGORY=ADMI_NUMBERING_> Set Up Auto-Generated Numbers. |
| entityStatus |
RecordRef |
0..1 |
Status |
F |
Indicates the progress of the project.
When creating a new project, select the status that best indicates the progress of the project.
You can create new statuses at Setup > Accounting > Accounting Lists > New, and click Project Status. |
| estimatedCost |
double |
0..1 |
Estimated Cost |
F |
Enter the projected cost to complete this project. |
| estimatedGrossProfit |
double |
0..1 |
Estimated Gross Profit |
F |
Estimated Gross Profit is calculated as follows:
For Time and Materials projects:
[Estimated Labor Revenue - Estimated Labor Cost]
For Fixed Bid projects:
[Project Price - Estimated Labor cost] |
| estimatedGrossProfitPercent |
double |
0..1 |
Estimated Gross Profit Percent |
F |
Shows the expected profit percentage, calculated as:
For Time and Materials projects:
[Estimated Gross Profit / Estimated Labor Revenue
For Fixed Bid projects:
[Estimated Gross Profit / Project Price] |
| estimatedLaborCost |
double |
0..1 |
Estimated Labor Cost |
F |
Estimated Labor Cost is the total amount expected to be spent on labor for the project. |
| estimatedLaborCostBaseline |
double |
0..1 |
Estimated Labor Cost Baseline 1 |
F |
The value of Estimated Labor Cost when the baseline was set. |
| estimatedLaborRevenue |
double |
0..1 |
Estimated Labor Revenue |
F |
Indicates the projected revenue to be billed for work performed on this project. |
| estimatedRevenue |
double |
0..1 |
Estimated Revenue |
F |
Enter the projected revenue to be billed for work performed on this project. |
| estimatedTime |
Duration |
0..1 |
Initial Time Budget |
F |
Indicates the sum of the initial time budgeted for the CRM Tasks that are included in this project. |
| estimatedTimeOverride |
Duration |
0..1 |
Current Time Budget |
F |
Estimated Work is the sum of the estimated work for all project tasks.
Estimated Work also includes the Current Time Budget amounts for all CRM tasks if the Include CRM Tasks in Project Totals check box is selected for this project. |
| estimateRevRecTemplate |
RecordRef |
0..1 |
Rev Rec Forecast Template |
F |
Select a revenue recognition template created for the project. The template generates a schedule forecasting expected revenue to be recognized for the project. |
| fax |
string |
0..1 |
Fax |
F |
|
| fxRate |
double |
0..1 |
Exchange Rate |
F |
Shows the currency's exchange rate when you create the project.
You can edit the rate for this project if you want to use a different rate for cost and labor estimates. |
| globalSubscriptionStatus |
GlobalSubscriptionStatus |
0..1 |
|
|
|
| includeCrmTasksInTotals |
boolean |
0..1 |
|
|
Check this box to allow CRM tasks to be included in costs, planned time, and actual time for this project. |
| isExemptTime |
boolean |
0..1 |
Exempt Time |
F |
Exempt time is excluded when calculating utilization. It is not included in the numerator or denominator of the utilization formula. |
| isInactive |
boolean |
0..1 |
|
|
If you check this box, then the project no longer appears on the list of projects.
You cannot edit or make any changes to a project marked inactive.
Check the Show Inactives box at the bottom of the List page to view inactive projects. |
| isProductiveTime |
boolean |
0..1 |
Productive Time |
F |
Productive time is time worked on a project but not included when calculating revenue for the project.
Productive time is not billed to the customer.
Training and pre-sales support are examples of productive time. |
| isUtilizedTime |
boolean |
0..1 |
Utilized Time |
F |
Utilized time directly contributes to the revenue for a project. |
| jobBillingType |
JobBillingType |
0..1 |
Billing Type |
F |
Select a method to bill project costs to the customer.
Charge-Based: billable amounts are represented by charges. Charges are generated based on charge rules based on fixed dates, milestones, project progress, or time entries. This option requires that you have enabled the Charge-Based Billing feature.
Fixed Bid, Interval: bill customers at predefined intervals for a portion of the fixed amount based on project percent complete.
Fixed Bid Milestone: bill customers as milestones are completed for the percentage of the total project amount specified for the milestone.
Time and Materials: bill customers for time and expenses entered against the project. |
| jobItem |
RecordRef |
0..1 |
|
|
Enter the service item to appear on transactions billed to the customer. |
| jobPrice |
double |
0..1 |
Default Rate |
F |
Enter the price billed to the customer on transactions.
Project Price is also used to calculate the gross profit margin for the project. |
| jobResourcesList |
JobResourcesList |
0..1 |
|
|
|
| jobType |
RecordRef |
0..1 |
Job Type |
F |
Select the project type. Project types are user-defined values to classify projects in a way meaningful to your company. |
| language |
RecordRef |
0..1 |
Language |
F |
Select the language to use to display all project records and invoices. |
| lastBaselineDate |
dateTime |
0..1 |
Last Date |
F |
The date when the last project baseline was set. |
| lastModifiedDate |
dateTime |
0..1 |
Last Modified Date |
F |
|
| limitTimeToAssignees |
boolean |
0..1 |
Limit Time and Expenses To Resources |
F |
Check this box to allow only resources listed on the Resources subtab for the project to enter time and expenses.
Clearing this box allows any project resource to track time against this project and its project tasks.
Only resources listed on the Resource tab will be able to see the project in Project select lists for time and expenses.
Note: Regardless of whether this box is marked, in the Vendor Center, this project will only show if the vendor is listed as a resource of the project. |
| materializeTime |
boolean |
0..1 |
Create Planned Time Entries |
F |
Check this box to generate time entries for planned work on project tasks.
Resources assigned to this project will be able to see their planned time in Time Tracking or Timesheets.
If you use Project Budgets, planned time entries are required to generate calculated costs. |
| milestonesList |
JobMilestonesList |
0..1 |
|
|
|
| openingBalance |
double |
0..1 |
Opening Balance |
F |
|
| openingBalanceAccount |
RecordRef |
0..1 |
{1} Account |
F |
|
| openingBalanceDate |
dateTime |
0..1 |
{1} Date |
F |
|
| parent |
RecordRef |
0..1 |
Child Of |
F |
Enter the name of the customer for this project. If you are creating a subproject, then enter a customer and project in this field. |
| percentComplete |
double |
0..1 |
% Complete |
F |
Enter an estimate of how much of the total project work is complete.
This percentage is not calculated or updated by NetSuite. |
| percentCompleteOverrideList |
JobPercentCompleteOverrideList |
0..1 |
|
|
|
| percentTimeComplete |
double |
0..1 |
Percent Complete (Time) |
F |
Shows the percent of the total planned project time that has been completed.
Percent Work Complete is calculated by dividing the total number of actual hours worked and reported in Time Tracking by the number of hours entered in the Estimated Work field for each project task.
The percentage is 100% when the status of all project tasks is Completed. |
| phone |
string |
0..1 |
Phone |
F |
|
| phoneticName |
string |
0..1 |
|
|
|
| plStatementList |
JobPlStatementList |
0..1 |
|
|
|
| projectedEndDate |
dateTime |
0..1 |
Estimated End Date |
F |
Enter the date you plan to complete all project tasks by. You can update this date at any time.
If you use Advanced Projects, NetSuite calculates an end date based on the project schedule and displays it in Calculated End Date. |
| projectedEndDateBaseline |
dateTime |
0..1 |
Estimated End Date Baseline 1 |
F |
The Estimated End Date when the baseline was set.
Baseline information is available only if you use Advanced Projects. |
| projectExpenseType |
RecordRef |
0..1 |
Project Expense Type |
F |
Select a project expense type for this project.
The project expense type determines which account is debited when posting time transactions recorded for this project. |
| revRecForecastRule |
RecordRef |
0..1 |
Revenue Recognition Rule |
F |
Select a revenue recognition rule to create a forecast revenue recognition plan for the project. The project must have both a Start Date and an End Date or Projected End Date.
For more information, see the help topic Linking a Forecast Revenue Recognition Rule to a Project. |
| startDate |
dateTime |
0..1 |
Start Date |
F |
Enter the estimated date work will start on the project. You can change this date at any time during the life of the project.
NetSuite schedules all project tasks without predecessors to start on this date. |
| startDateBaseline |
dateTime |
0..1 |
Start Date Baseline 1 |
F |
The Start Date when the baseline was set.
Baseline information is available only if you use Advanced Projects. |
| subsidiary |
RecordRef |
0..1 |
|
|
The subsidiary for this project is displayed here. |
| timeRemaining |
Duration |
0..1 |
Time Remaining |
F |
Indicates the time for work yet to be done on all project tasks, calculated as:
[Estimated Work(all tasks) - Actual Work (all tasks)] |
| usePercentCompleteOverride |
boolean |
0..1 |
Use Percent Complete Override for Revenue Forecasting |
F |
Check this box to generate forecast revenue plans based on the latest status of the Rev Rec Percent Complete Override subtab. Any planned time entries in the project record are ignored for revenue recognition and forecasting purposes. The Cumulative Percent Complete on the subtab must equal 100.
For more information, see the help topic Using the Rev Rec Percent Complete Override Subtab. |
| workplace |
RecordRef |
0..1 |
Workplace |
F |
|