Here is a description of the fields that make up a project record. Some of these fields may not be visible or editable at all times, or in all package combinations.
Key: R – Read-only
| Field | Description | |
|---|---|---|
| Account | Lookup to the related account for the project. Enter the customer account for the Project, unless you are using it to track items other than revenue such as vacations or internal non-billable Projects. | |
| Billing Type | Type of billing, such as Fixed Price or Time and Materials. A Time and Materials project tracks hours entered by resources with assignment and schedules as the main method of billing. | |
| Currency | When working with multiple currencies, allows you to choose a currency to report the project figures in when different from the default currency for your Salesforce org. | |
| End Date | Date this project ends. | |
| Exclude from Backlog | Indicates whether the project is to be excluded from backlog calculations. | |
| Group | Lookup to the related group to which the project actuals roll up to. |
|
| Include in Forecasting | Indicates whether the project is to be included in forecasting. | |
| Location | The project's location. | |
| Notes | A field where you can enter project staffing notes. | |
| Opportunity | Lookup to the related opportunity. Enter the opportunity for the project unless you are using it to track items other than revenue such as vacations or internal non-billable projects. | |
| Opportunity Owner | Contact who owns the related opportunity. | |
| Practice | Lookup to the related practice to which the project actuals roll up to. |
|
| Pre-Bill Type | R | The type of pre-billing selected for the project. This indicates whether the customer has been pre-billed for a part of the budget or all of it. |
| Project ID | R | Unique project identifier assigned by the system. |
| Project Manager | Lookup to the related contact. Used on the resource planner. | |
| Project Name | Name of the project. Should relate to the account and opportunity. | |
| Project Phase | Current phase of the project. | |
| Project Type | Classification of the project. | |
| Region | Lookup to the related region to which the project actuals roll up to. |
|
| Share with Project Manager | Indicates whether project related business records such as milestones are shared with the project manager. | |
| Share with Project Resources | Indicates whether project related business records such as milestones are shared with resources assigned to the project. | |
| Stage | Current stage of the project. | |
| Start Date | Date this project starts. | |
| Template | Indicates that this project is a template and appears in the list of projects when you select Create Project From Template. |
| Field | Description | |
|---|---|---|
| Planned Hours | The number of planned hours for the project. This field exists on projects, assignments and milestones and is for simple planning purposes. When a project is created from a template, the number of hours from the template is copied to this field. | |
| Project Status | Status of the project. The defaults are Red, Yellow and Green, but you can customize this picklist. | |
| Project Status Notes | Notes on the project status. |
Key: G – Used in global projects.
| Field | Description | |
|---|---|---|
| Active | Indicates whether this project is active. When deselected, this project's Scheduled Backlog will not be calculated or reflected in roll-ups . Also when deselected, you cannot enter, delete or materially update further business records on this project. |
|
| Billable | G | Indicates that this project is billable. When deselected this project's numbers will not be reflected in any billing information. |
| Exclude From Billing | Indicates that this project should be excluded from billing events. | |
| Closed for Time Entry | Indicates that this project is closed for timecard entry. | |
| Closed for Expense Entry | Indicates that this project is closed for expense entry. | |
| Exclude from Project Planner | Indicates that this project is hidden from view in the Project Planner. | |
| Allow Self Staffing | Indicates whether resources have permission to create their own assignments for the project. This overrides the staffing permission controls for the project or resource. | |
| Allow Timecards Without Assignment | G | Enables the entry of timecards without the resource requiring an assignment. |
| Allow Expenses Without Assignment | G | Enables the entry of timecards and expenses without the resource requiring an assignment. |
| Time Credited | Indicates that non-billable time should be credited for utilization. For instance, you may want time spent on consulting to count towards utilization. | |
| Time Excluded | Indicates that non-billable time should neither count for nor against utilization. | |
| Daily Timecard Notes Required | Makes the entry of timecard notes mandatory. | |
| Billable Expense Fee Percentage | Fee percentage by which to increase the billable amount of any Expense logged for the Project. Set to 0% for no increase (default). Set to 100% to double the amount. The calculation applies the percentage expense fee before any flat expense fee. | |
| Billable Expense Fee Flat | The flat fee in project currency by which to increase the billable amount of an expense logged to the project. The increase is applied after any percentage fee increase. The default value is taken from the Billable Expense Fee Flat field on the project. | |
| Expense Notes | Makes the entry of expense notes mandatory. | |
| Share with Project Manager | Enables the sharing of project information with the user designated as project manager. | |
| Share with Project Resources | Enables the sharing of information such as milestones with resources assigned to the project. |
| Field | Description | |
|---|---|---|
| Tasks Total Points | Total of points on all project tasks. | |
| Tasks Total Points Complete | Total of points on completed project tasks. | |
| Tasks Total Percent Complete (Points) | R | Percentage of project tasks that are complete based on task points. |
| Total Number of Tasks | Total number of project tasks. |
Key: R – Read-only
| Field | Description | |
|---|---|---|
| Planned Hours | Number of hours planned for the project. | |
| Total Assigned Hours | R | Total number of hours from project assignments. |
| Total Projected Revenue From Assignments | R | Total projected revenue from all project assignments |
Key: R – Read-only
| Field | Description | |
|---|---|---|
| Action: Update Current Time Period | Indicates whether project numbers within the current time period are to be updated when you next save the project. Use this checkbox to update project numbers after changing the Project Time Period field. | |
| Current Time Period | R | Name of the current time period. |
| Current Time Period End Date | R | Last day of current time period. |
Actual values, for the project, at a given point in time, based on selected time period. All read-only.
| Field | Description | |
|---|---|---|
| Billed | Sum of billed amounts. Expenses, timecard splits and miscellaneous adjustments that are billable contribute to billed revenue after they are billed/invoiced. Milestones contribute to billed and invoiced revenue after they are billed/invoiced. | |
| Billings | Sum of Ready-to-Bill Revenue from Timecards and Milestones. | |
| Bookings | Booked revenue for this project. Budgets of type Customer PO and Customer PO Change Order contribute to bookings. | |
| Expense Budget | Sum of expense budgets for the project. The Expense Amount field of a budget contributes to this field if the budget is of type: Customer PO, Customer PO Change Order, Internal Budget or Internal Budget Change Request. | |
| Internal Budget | Sum of internal budgets for the project. The Amount field of a budget contributes to this field if the budget is of type: Internal Budget or Internal Budget Change Request. | |
| Invoiced | Sum of invoiced amounts. Expenses, timecard splits and miscellaneous adjustments that are billable contribute to invoiced revenue after they are billed/invoiced. Milestones contribute to invoiced revenue after they are billed/invoiced. | |
| Pass-Through Billing | Sum of pass-through billings, including expenses. | |
| Pre-Billed | Amount already billed for the project. | |
| Revenue | Revenue is not calculated or rolled up. Enter a miscellaneous adjustment to show revenue on the project actuals. | |
| Margin | Billings minus Total Costs. |
| Field | Description | |
|---|---|---|
| Internal Costs | Sum of internal costs, whether billable or not. Internal Costs are only for resources that are not marked External. This is calculated using this formula: approved timecard hours * cost rate + expense costs in approved expense reports. Expense costs include both billable and non-billable costs. |
|
| External Costs | Sum of external costs, whether billable or not. Milestones may contribute to flat External Cost if the External Cost field is completed, and the Log Cost as External checkbox is selected. For example, when you count subcontractor fees as a flat cost amount that helped you reach the milestone and achieve the billings. |
|
| Expense Costs | Sum of approved expenses in expense reports, whether billable or not. | |
| Other Costs | Any other project costs. Other costs might include things like material or capital costs incurred on the project.These are only generated through miscellaneous adjustments which can also generate any other category of revenue or cost. The Amount field of a budget also contributes to this field if the budget is of type Work Order or Work Order Change Request. | |
| Total Costs | Total costs from all projects in the project hierarchy. |
| Field | Description | |
|---|---|---|
| Billable Hours (External) | Not included in utilization calculation. | |
| Billable Hours (Internal) | Included in utilization calculation. | |
| Credited Hours | Hours taken from timecards where the project has Time Credited checkbox selected. | |
| Excluded Hours | Hours taken from timecards where the project has Time Excluded checkbox selected. | |
| Non-Billable Hours (External) | Not included in utilization calculation. | |
| Non-Billable Hours (Internal) | Not included in utilization calculation. |
When you run a backlog calculation the details are copied from the backlog detail object to the project.
| Field | Description | |
|---|---|---|
| Scheduled Backlog Amount | Value of scheduled hours backlog. | |
| Scheduled Backlog Calculation Date | Start date of scheduled backlog calculation (usually today). | |
| Scheduled Backlog End Date | End date of scheduled backlog calculation | |
| Scheduled Milestone | Value of scheduled milestone backlog.This value depends on the time period. For instance if the backlog is calculated for all time periods, the value includes all time periods up to the end of the last future milestone. | |
| Scheduled Time | Value of scheduled time backlog. This value depends on the time period. For instance if the backlog is calculated for all time periods, the value includes all time periods up to the end of the last assignment. | |
| Unscheduled Backlog | Value of unscheduled revenue. |
| Field | Description |
|---|---|
| Billing Eligible Last Updated | Displays the date on which the Billing Eligible fields were last updated on the project. |
| Action: Count Billing Eligible Records | Indicates whether the fields above are updated when you save the project. When you save the project, the checkbox is automatically deselected. |
| Billing Eligible Budgets | The number of budgets that are eligible for billing event generation and creation. |
| Billing Eligible Expenses | The number of expenses that are eligible for billing event generation and creation. |
| Billing Eligible Milestones | The number of milestones that are eligible for billing event generation and creation. |
| Billing Eligible Misc Adjustments | The number of miscellaneous adjustments that are eligible for billing event generation and creation. |
| Billing Eligible Timecard Splits | The number of timecard splits that are eligible for billing event generation and creation. |
In addition, for an item to be eligible for billing, the following applies:
| Field | Description | |
|---|---|---|
| Parent Project | Next level up in the project hierarchy. | |
| Master Project | Highest project in the hierarchy. | |
| Hierarchy Depth | Level within the project hierarchy. | |
| Project Name Chain | Name of system-generated chain for linking to the project. | |
| Project ID Chain | ID for system-generated chain for linking to the project. |
| Button | Description |
|---|---|
| Edit | Allows you to edit the project. |
| Delete | Allows you to delete the project. |
| Clone | Allows you to clone the project. |
| Create Change Request | Displays the Create Change Request page where you can create a new change request opportunity from the project. |
| Project Planner | Displays the Project Planner. |
| Share Project | Displays the Share Project page where you can share related objects such as milestones with resources assigned to the project. |
| Manage Project Tasks | Displays the PSA Task Management page where you can manage project tasks. |